1
MorelyDotes
Upgraded my site and now I can't get into admin area

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?

2
Bender
Re: Upgraded my site and now I cant get into admin area
  • 2006/12/30 22:02

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


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?
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

3
MorelyDotes
Re: Upgraded my site and now I cant get into admin area

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

Quote:

Bender wrote:
You upgraded from which version? How?


From 2.0.15 by following the directions in the upgrade readme.

Quote:

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


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 cleaning out templates_c folder?


Tried that. No change.

4
Dave_L
Re: Upgraded my site and now I cant get into admin area
  • 2006/12/31 21:50

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


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.

5
MorelyDotes
Re: Upgraded my site and now I cant get into admin area

Quote:

Dave_L wrote:
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.


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)

6
Dave_L
Re: Upgraded my site and now I cant get into admin area
  • 2007/1/1 1:35

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


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.

Login

Who's Online

352 user(s) are online (318 user(s) are browsing Support Forums)


Members: 0


Guests: 352


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits