Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 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 5680 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

  • Guest
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

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: 15289
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

wurfgang

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Re: Fatal Error - Table sessions doesn't exist.
« Reply #5 on: March 18, 2015, 04: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: 4384
    • Windsurf.me
Re: Fatal Error - Table sessions doesn't exist.
« Reply #6 on: March 18, 2015, 04: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.069 seconds with 20 queries.