Recently upgraded one of my sites to 2.0.16 and now I can't get into the administrative module. I'm also having (unrelated) issues getting into phpmyadmin so I can't use that to fix the problem.

What's the quickest way to take care of this from the linux command prompt?

You upgraded from which version? How?

What exactly happens when you login? Cant login at all or only admin is refused? (any error message?)

Tried cleaning out templates_c folder?

I posted a response to this on Friday but it doesn't appear here. Weird.

Quote:

From 2.0.15 by following the directions in the upgrade readme.

Quote:

I get logged in as a normal user, but I am denied access to the admin.php which of course makes the site a bit too static.

Quote:

Tried that. No change.

If you can't use phpmyadmin, do you know how to use MySQL from the command line?

Check that there's a row in the groups_users_link table with groupid = 1 (XOOPS_GROUP_ADMIN) and uid = (your user ID). If not, try inserting that row.

Quote:

Does this look right to you? IT seems to me to be showing UID as an INT, not a string:

mysql> describe dmembr_groups_users_link;
+---------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------------------+------+-----+---------+----------------+
| linkid | mediumint(8) unsigned | | PRI | NULL | auto_increment |
| groupid | smallint(5) unsigned | | MUL | 0 | |
| uid | mediumint(8) unsigned | | | 0 | |
+---------+-----------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> select groupid, uid from dmembr_groups_users_link;
+---------+-----+
| groupid | uid |
+---------+-----+
| 1 | 1 |
| 2 | 1 |
+---------+-----+
2 rows in set (0.01 sec)

That looks correct, assuming that your user ID is 1. That shows that user 1 is in groups 1 (admins) and 2 (registered users). The IDs for those groups are defined in mainfile.php as XOOPS_GROUP_ADMIN and XOOPS_GROUP_USERS.

You might try emptying the sessions and online tables:

mysql> delete from dmembr_session;
mysql> delete from dmembr_online;

And delete any cookies for that domain.