Advanced search  

News:

cpg1.5.24 maintenance release - upgrade recommended
The Coppermine development team is releasing an update for Coppermine in order to fix several minor issues. All fixes are not security critical, so if your gallery is running fine with cpg1.5.20 or cpg1.5.22 you don't need to upgrade. If you are running an older version than cpg1.5.20, you must update to this latest version as soon as possible because of the security impact!
[more]

Pages: [1]   Go Down

Author Topic: Fatal Error - Table sessions doesn't exist.  (Read 1781 times)

0 Members and 1 Guest are viewing this topic.

ToddW

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Fatal Error - Table sessions doesn't exist.
« on: November 30, 2010, 09:21:57 am »

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?
Logged

Nibbler

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 19981
Re: Fatal Error - Table sessions doesn't exist.
« Reply #1 on: November 30, 2010, 10:09:25 am »

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
Logged
I don't care about what they say, I won't live or die that way.

ToddW

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Fatal Error - Table sessions doesn't exist.
« Reply #2 on: November 30, 2010, 10:11:10 am »

Pretty sure I had 1.4 then wen to 1.5 though.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 11835
Re: Fatal Error - Table sessions doesn't exist.
« Reply #3 on: November 30, 2010, 04:02:04 pm »

You can manually add that table with the following query:
Code: [Select]
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';
Logged

ToddW

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Fatal Error - Table sessions doesn't exist.
« Reply #4 on: November 30, 2010, 07:21:21 pm »

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 :)
Logged
Pages: [1]   Go Up
 

Page created in 0.172 seconds with 20 queries.