Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: fatal error: cpg_sessions is crashed  (Read 3630 times)

0 Members and 1 Guest are viewing this topic.

lotoazul

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
fatal error: cpg_sessions is crashed
« on: July 11, 2010, 12:24:42 am »

hello! i'm hoping someone can help me.

a few weeks ago, out of the blue one of my galleries (URL here) began throwing out a fatal error and wouldn't even let me view the main page, let alone log into the admin panel. i haven't touched that gallery in months, so i'm pretty sure it wasn't something i did. i'm running CPG 1.4.25, i actually tried to upgrade to 1.4.26 to see if that fixed things, but the upgrade failed-- i'm guessing because of the error.

i looked the error up, and found the tutorial for the debug mode. after i turned that on, the script gave me the standard "table cpg_sessions is marked as crashed" explanation that i know many previous posters have gotten. so i looked up the docs and learned that i had to repair the table. i went back to phpMyAdmin and ran the REPAIR TABLE sql query; you can see the result in the attachment to this post.

i figured that "table is up to date" meant something good, so i went back to my gallery and tried again-- nothing, i still get the error. cpg_sessions still seems to be marked as crashed when i look it up in phpMyAdmin.

is there anything else i could try? any help is appreciated.
Logged

Nibbler

  • Guest
Re: fatal error: cpg_sessions is crashed
« Reply #1 on: July 11, 2010, 01:55:13 am »

Drop and re-create the table in phpMyAdmin.

Code: [Select]
DROP TABLE cpg_sessions;
CREATE TABLE IF NOT EXISTS cpg_sessions (
  session_id varchar(40) NOT NULL default '',
  user_id int(11) default '0',
  time int(11) default NULL,
  remember int(1) default '0',
  PRIMARY KEY (session_id)
) TYPE=MyISAM COMMENT='Used to store sessions';
Logged

lotoazul

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: fatal error: cpg_sessions is crashed
« Reply #2 on: July 11, 2010, 02:39:18 am »

that worked! thank you very much, nibbler.  :)
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: fatal error: cpg_sessions is crashed
« Reply #3 on: July 11, 2010, 04:26:12 am »

Thanks for coming back and resilving your thread.

I am sure you know you are a couple of versions behind (we are currently on 1.4.27) so please try and upgrade asap as you are at risk if you don't. This might be a good time to make the jump to the new 1.5.x line. ;)
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.045 seconds with 20 queries.