forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: jenzbie on October 24, 2010, 01:23:54 am

Title: Fatal Error :
Post by: jenzbie on October 24, 2010, 01:23:54 am
I noticed yesterday that my gallery at http://jonasphotos.net came up with 'Fatal Error :'. Thinking and knowing that the gallery version was out-of-date, I upgraded my gallery to 1.4.27, but the same message is still up. I checked the tables in phpmyadmin and repaired them, but the sessions table isn't repairing. I've tried repairing it multiple times using http://documentation.coppermine-gallery.net/en/errors.htm#errors_messages_database but it still hasn't worked.

I've attached a screen cap of what the SQL query states after I've tried repairing the table.

HELP!
Title: Re: Fatal Error :
Post by: papukaija on October 24, 2010, 02:43:46 pm
Unfortunately there is no support for MySQL issues on this forum.
Quote
This is not a coppermine issue, but a mySQL issue. It just may affect a database table used by Coppermine. Use your website's Control Panel to repair the table [...] If you don't understand the solution, ask your webhost to make the above changes.  If this happens frequently, there is something fishy with your webserver - ask your webhost for support
(from the docs (http://documentation.coppermine-gallery.net/en/errors.htm#errors_messages_database)).

More information to fix your issue is available here (http://www.google.com/search?btnG=1&pws=0&q=repairing+crashed+mysql+tables).
Title: Re: Fatal Error :
Post by: Nibbler on October 25, 2010, 10:25:20 am
There's no point in attempting to repair the table. Just drop (delete) the table and re-create it. It only holds temporary session information.

Code: [Select]
DROP TABLE cpg14x_sessions;
CREATE TABLE IF NOT EXISTS cpg14x_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';
Title: Re: Fatal Error :
Post by: jenzbie on October 26, 2010, 03:04:20 am
There's no point in attempting to repair the table. Just drop (delete) the table and re-create it. It only holds temporary session information.

Code: [Select]
DROP TABLE cpg14x_sessions;
CREATE TABLE IF NOT EXISTS cpg14x_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';

Thank you!