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!
Unfortunately there is no support for MySQL issues on this forum.
QuoteThis 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).
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.
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';
Quote from: 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.
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!