Print

[jenzbie]

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!

[papukaija]

Unfortunately there is no support for MySQL issues on this forum.

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).

More information to fix your issue is available here.

[Nibbler]

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';


[jenzbie]

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!