Page 1 of 1

Error doing DB query userdata row fetch

Posted: Wed Dec 21, 2005 7:45 am
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?

Posted: Wed Dec 21, 2005 7:47 am
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.

Posted: Wed Dec 21, 2005 7:50 am
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.

Posted: Wed Dec 21, 2005 7:50 am
by karlsemple
no probs, its easily done!

Posted: Wed Dec 21, 2005 8:27 pm
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


:?