Fatal Error - Table sessions doesn't exist.

[ToddW]

Just upgraded to 1.5, and get "FATAL ERROR".
I enabled debug, and I see this:

While executing query 'DELETE FROM `ruff_copp1`.cpg_sessions WHERE time < 1291097513 AND remember = 0' in bridge/coppermine.inc.php on line 248

mySQL error: Table 'ruff_copp1.cpg_sessions' doesn't exist

What to do?

[Nibbler]

Did you try to update directly from 1.3 to 1.5? That's not supported. You have to update to 1.4 first then 1.5.

http://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_10

[ToddW]

Pretty sure I had 1.4 then wen to 1.5 though.

[Αndré]

You can manually add that table with the following query:

Code Select Expand

CREATE TABLE CPG_sessions (
  session_id char(32) NOT NULL default '',
  user_id int(11) default '0',
  time int(11) default NULL,
  remember int(1) default '0',
  PRIMARY KEY (session_id)
) COMMENT='Used to store sessions';

[ToddW]

Thanks, I did that, and also added a couple other missing columns in 2 other tables, and it seems to be working again on the front end.

I have yet to check the user/admin area but it's actually displaying something now

[wurfgang]

You can manually add that table with the following query:

Code Select Expand

CREATE TABLE CPG_sessions (
  session_id char(32) NOT NULL default '',
  user_id int(11) default '0',
  time int(11) default NULL,
  remember int(1) default '0',
  PRIMARY KEY (session_id)
) COMMENT='Used to store sessions';

solved my problem, thanks. but: case sensitive! it's "cpg" (not CPG):

Code Select Expand

CREATE TABLE cpg_sessions (
  session_id char(32) NOT NULL default '',
  user_id int(11) default '0',
  time int(11) default NULL,
  remember int(1) default '0',
  PRIMARY KEY (session_id)
) COMMENT='Used to store sessions';

[phill104]

It is capitalised as the prefix could be a number of things. On one of my galleries for instance it is cpg133, on another it is cpg154. We simply use the capitalisation to highlight that area.