Error doing DB query userdata row fetch

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
User avatar
JooK
Registered User
Posts: 28
Joined: Sun Oct 05, 2003 4:55 pm
Location: LA, CA, USA
Contact:

Error doing DB query userdata row fetch

Post by JooK »

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'sporkaco_forum.phpbb_sessions_keys' doesn't exist

SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = 'cdf3aead074cf574c5ce6c9ce76c2e41'

Line : 89
File : sessions.php


I tried to upgrade from 2.0.17 to 2.0.18

I just simply replaced all of the files with the new files, and put the old config back in.
As soon as I logged out of my account, I couldnt re-access the forum, not even the main page.

Any suggestions?
.: TheJooK :.
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Post by karlsemple »

have you recenly upgraded? if you did it looks like you forgot to run the /install/update_to_latest.php yo complete the upgrade, your missing the table needed for the new versions new sessions system.
Image
User avatar
JooK
Registered User
Posts: 28
Joined: Sun Oct 05, 2003 4:55 pm
Location: LA, CA, USA
Contact:

Post by JooK »

karlsemple wrote: have you recenly upgraded? if you did it looks like you forgot to run the /install/update_to_latest.php yo complete the upgrade, your missing the table needed for the new versions new sessions system.


That did it.
Forgot to RTFM.

Sorry.
.: TheJooK :.
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Post by karlsemple »

no probs, its easily done!
Image
k4x
Registered User
Posts: 3
Joined: Sat Dec 03, 2005 12:21 am

Post by k4x »

I get a similar message, but I haven't done anything to my forums lately to have caused it. Well, its not really similar, but it has the DB query userdata row fetch thing...

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1030 Got error 134 from table handler

SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'a92a9945cac7fd416874edb459301e9b' AND u.user_id = s.session_user_id

Line : 247
File : sessions.php


:?
Locked

Return to “2.0.x Support Forum”