coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: tothecore on August 15, 2006, 03:23:24 PM

Title: Fatal Error: with no explaination?
Post by: tothecore on August 15, 2006, 03:23:24 PM
Hello,
I recently went to my gallery page and all of a sudden it gives a "Fatal Error:" message; but with no explanation. Since I didn't modify anything in weeks, I'm assuming maybe someone hacked it, but did not see anything in the logs. The index.php file says I am using version 1.4.3.  Should I try to run the reinstall?
Right now the admin.php, index.php give the blank fatal error, and probably more.

Any help or info would be appreciated.
Thanks!
-tothecore
Title: Re: Fatal Error: with no explaination?
Post by: Nibbler on August 15, 2006, 03:32:59 PM
http://coppermine-gallery.net/tutorial/debug_mode.php

Update your gallery.
Title: Re: Fatal Error: with no explaination?
Post by: tothecore on August 15, 2006, 04:04:36 PM
Thanks Nibbler!

Its now giving me the error message :
While executing query "delete from `weraceha_photo`.cpg143_sessions where time<1155646717 and remember=0;" on Resource id #6

mySQL error: Table './weraceha_photo/cpg143_sessions' is marked as crashed and should be repaired

So I can see its an error on the sql table. I tried a repair but it did not fix it. Any tips on what to do? I assume its possible to browse and delete the offending entry?

Thanks again!
-Tothecore
Title: Re: Fatal Error: with no explaination?
Post by: Nibbler on August 15, 2006, 04:10:50 PM
If you can't repair it then you can try to DROP it and recreate it.

DROP TABLE cpg143_sessions;
CREATE TABLE IF NOT EXISTS cpg143_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: with no explaination?
Post by: tothecore on August 15, 2006, 04:20:43 PM
Wow your amazing!
Thanks that fixed it.
I looked into it some more and it seems that the session table was gone. I have no clue how a table can disappear on its own :P
Thanks for the code to recreate it, everything seems to be fine now. I'm gonna go make a backup right now :P
Thanks so much!
-Tothecore