phpBB Suomi

Koodi: Valitse kaikki

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

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

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

Line : 89
File : sessions.php

Koodi: Valitse kaikki

CREATE TABLE `phpbb_sessions_keys` (
`key_id` varchar(32) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`last_ip` varchar(8) NOT NULL default '0',
`last_login` int(11) NOT NULL default '0',
PRIMARY KEY (`key_id`,`user_id`),
KEY `last_login` (`last_login`)
) TYPE=MyISAM;
UPDATE phpbb_users SET user_active = 0 WHERE user_id = -1;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');

Koodi: Valitse kaikki

Error

SQL query:

CREATE TABLE `phpbb_sessions_keys` (
`key_id` varchar( 32 ) NOT NULL default '0',
`user_id` mediumint( 8 ) NOT NULL default '0',
`last_ip` varchar( 8 ) NOT NULL default '0',
`last_login` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `key_id` , `user_id` ) ,
KEY `last_login` ( `last_login` )
) TYPE = MYISAM ;

MySQL said: Documentation
#1050 - Table 'phpbb_sessions_keys' already exists 

Koodi: Valitse kaikki

$table_prefix = 'phpbb_';