Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Fatal Error - Table sessions doesn't exist.  (Read 8100 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, 08: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

  • Guest
Re: Fatal Error - Table sessions doesn't exist.
« Reply #1 on: November 30, 2010, 09: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

ToddW

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Fatal Error - Table sessions doesn't exist.
« Reply #2 on: November 30, 2010, 09: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: 15686
Re: Fatal Error - Table sessions doesn't exist.
« Reply #3 on: November 30, 2010, 03: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, 06: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

wurfgang

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Fatal Error - Table sessions doesn't exist.
« Reply #5 on: March 18, 2015, 03:04:47 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';

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

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

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4633
    • Windsurf.me
Re: Fatal Error - Table sessions doesn't exist.
« Reply #6 on: March 18, 2015, 03:45:47 pm »

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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.