error

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
ndonezn
Registered User
Posts: 118
Joined: Fri Nov 11, 2005 10:05 pm
Location: pasadena
Contact:

error

Post by ndonezn » Mon Jun 19, 2006 8:11 pm

phpBB : Critical Error

Error updating session key

DEBUG MODE

SQL Error : 1146 Table 'icwsorga_p_bb1.phpbb_pulsesessions_keys' doesn't exist

INSERT INTO phpbb_pulsesessions_keys(key_id, user_id, last_ip, last_login) VALUES ('8e0f9e44abe4f1d321dba5fa7a02edb2', 60, '447bfeaf', 1150744141)

Line : 229
File : sessions.php


how can i fix this?

User avatar
jwunderly
Registered User
Posts: 5740
Joined: Sun Mar 30, 2003 2:18 pm
Location: Easton, PA (in the groove)

Re: error

Post by jwunderly » Mon Jun 19, 2006 8:13 pm

ndonezn wrote: SQL Error : 1146 Table 'icwsorga_p_bb1.phpbb_pulsesessions_keys' doesn't exist


This error is due to the restore replacing a later version of the database structure with an earlier one and is missing addtional tables or fields.

The current version of your files is expecting this table/field.

0. If you don't have the full install file set for the version of your forum, download it again

1. upload the install directory from it to your forum.
2. Point your browser to http://{YOUR_FORUM}/{FORUM_ROOT}/install/update_to_latest.php. Change the labels inside the { and } markers to your values.
3. remove the install directory.
John (A cranky old man. "Looking for an echo ...")
using any control-panel install/update is like shooting yourself in the foot. It won't kill you, but you're really going to hobble around until it heals.
Using the wrong tools (Front Page, DreamWeaver) gives the same results
Do not PM me for Support!

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom » Mon Jun 19, 2006 8:14 pm

Did this just start happening, or has it been happening since you updated?

You'll need to creat the table phpbb_pulsesessions_keys. It should have been created during the running of the update_to_latest.php script at version 2.0.18.

Code: Select all

CREATE TABLE phpbb_pulsesessions_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));
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

Locked

Return to “2.0.x Support Forum”