SQL Error 1146 line 514??

New Member Joined: Dec 11, 2006 Posts: 2

phpBB : Critical Error

Error removing auto-login keys

DEBUG MODE

SQL Error : 1146 Table 'xxx.SESSIONS_KEYS_TABLE' doesn't exist

DELETE FROM SESSIONS_KEYS_TABLE WHERE user_id = 31

Line : 514
File : sessions.php

This is the Error I'm getting..I have been all over this forum and tried everything I could possibly find to try

This is as of LAST NIGHT this forum was working to perfection...We have not installed one mod on this forum. No Hacks or anything. I haven't even attempted to ever add one as this forum doesn't need any.
I up graded to phpnuke 8 a month ago and this is the first error...

Like I said.Last night it was perfect...tonight it is not

oh and I'm running phpnuke 8 with phpBB 2.0.20

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Welcome. First, be careful about posting public messages that contain root paths or, in this case, database names, as that could be used in attacks against your site.

Errors like this indicate a problem with the database. If it can't delete from a table, it could be that it had a problem creating it in the first place. Since it was working yesterday, I'd recommend using phpMyAdmin to analyze and repair the database.

Posted: Tue Dec 12, 2006 4:08 pm

Okies....I've been looking in phpadmin all day....and well I'm not sure what or where I need to look to fix anything

registered · Posted: Tue Dec 12, 2006 4:39 pm

One - SESSIONS_KEYS_TABLE needs to be defined in includes/constants.php

Code:




define('SESSIONS_KEYS_TABLE', $prefix.'_bbsessions_keys');

Two - the sessions_keys table needs to be created using the following

Code:




CREATE TABLE nuke_bbsessions_keys (key_id varchar(32) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, last_ip varchar(8) DEFAULT '0' NOT NULL, last_login int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (key_id, user_id), KEY last_login (last_login))

Sounds like another bug from FB on 8.0

Posted: Tue Dec 12, 2006 5:02 pm

Not bad, thats only 300 bugs so far

New Member Joined: Jan 07, 2008 Posts: 11

evaders99 wrote:

One - SESSIONS_KEYS_TABLE needs to be defined in includes/constants.php

Code:




define('SESSIONS_KEYS_TABLE', $prefix.'_bbsessions_keys');

Two - the sessions_keys table needs to be created using the following

Code:




CREATE TABLE nuke_bbsessions_keys (key_id varchar(32) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, last_ip varchar(8) DEFAULT '0' NOT NULL, last_login int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (key_id, user_id), KEY last_login (last_login))

Sounds like another bug from FB on 8.0

Could someone pls point out where the constants.php file is in 8.0 or 8.1? Because I don't have one in either version in the includes directory.
=(

Seems like one headache after another. I'm a new user to phpnuke, not knowing sql or phpnuke and I must say...this is not a database for non-coders!

Posted: Tue Jan 08, 2008 1:02 am

Why not switch to RavenNuke then?
At least it has an official support team unlike phpNuke Smile

Sorry I cannot help with the nuke 8.0 question. Like many, I won't touch it because it is so bug ridden.

Posted: Tue Jan 08, 2008 2:02 pm

They were moved into modules/Forums/includes (which probably screws up some more things with more code changes in 8.0)

Posted: Fri Jan 11, 2008 12:47 pm

Guardian2003 wrote:

Why not switch to RavenNuke then?
At least it has an official support team unlike phpNuke Smile

Sorry I cannot help with the nuke 8.0 question. Like many, I won't touch it because it is so bug ridden.

I'm sorry, I don't know anything about RavenNuke. Could somone point me to some info on it and give me some idea of how it runs and what the difference is in using phpnuke and RavenNuke?

Thanks so much...
A|ice

Posted: Fri Jan 11, 2008 1:01 pm

Did you install a new bb2nuke (phpbb) update (2.0.20)?

According to a few sites you need to install those bb2nuke sequentually.
f.e.; from 2.0.17, first to 2.0.18 then 2.0.19 and finally 2.0.20

http://www.karakas-online.de/forum/viewtopic.php?t=6074

Posted: Fri Jan 11, 2008 1:16 pm

After I changed the above mentioned in the constants.php file, I now get this when I try to log into Forums from the Administration Menu panel:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1054 Unknown column 's.session_id' in 'where clause'

SELECT u.*, s.* FROM nuke_bbsessions_keys s, nuke_users u WHERE s.session_id = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' AND u.user_id = s.session_user_id

Line : 317
File : sessions.php

Line 317 is:
message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);

From this section:
//
// Does a session exist?
//
if ( !empty($session_id) )
{
//
// session_id exists so go ahead and attempt to grab all
// data in preparation
//
$sql = "SELECT u.*, s.*
FROM " . SESSIONS_TABLE . " s, " . USERS_TABLE . " u
WHERE s.session_id = '$session_id'
AND u.user_id = s.session_user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql);
}

$userdata = $db->sql_fetchrow($result);

Posted: Fri Jan 11, 2008 3:18 pm

If this is a new site, I would still recommend ripping it all out in favour of installing RavenNuke.
More details about RavenNuke appear on the front page of this site

Posted: Sun Jan 13, 2008 5:38 pm

By "ripping it out", do I just delete all of the PhPNuke folders?

thanks

Posted: Mon Jan 14, 2008 3:46 am

Yes, remove all the phpnuke files and upload the RavenNuke one.
The RavenNuke installer will automatically re-create the database tables (but you will lose any exiting user data etc).