Session Crash in Database

Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Thu Dec 26, 2013 6:08 pm
Reply with quote
Report this post
So today when I go to the site I see an error relating to the database...

"Table '/forum/usmhtv11_newnews/u1hp4_session' is marked as crashed and should be repaired SQL=INSERT INTO `u1hp4_session` (`session_id`, `client_id`, `time`) VALUES ('50f1424fcbe95384d2a432232110563a', 0, '1388077608')"

I attempt to repair this in phpmyadmin by clicking SQL and running....

use usmhtv11_newnews; INSERT INTO `u1hp4_session` (`session_id`, `client_id`, `time`) VALUES ('50f1424fcbe95384d2a432232110563a', 0, '1388076930')


But the result I am returned is...

Error

SQL query:

INSERT INTO `u1hp4_session` ( `session_id` , `client_id` , `time` )
VALUES (
'50f1424fcbe95384d2a432232110563a', 0, '1388076930'
)

MySQL said: Documentation
#145 - Table '/forum/usmhtv11_newnews/u1hp4_session' is marked as crashed and should be repaired



Could someone please point me in the right direction for some information on how to correct this problem?
User avatar
Senior Boarder

GK User
Thu Dec 26, 2013 6:11 pm
Reply with quote
Report this post
I'm not sure why I have so many %20 junking up the text of that message. Could someone please point me in the direction of some information on how to fix this crashed session?
User avatar
Senior Boarder

GK User
Thu Dec 26, 2013 11:05 pm
Reply with quote
Report this post
Please disregard. I backed up the database (because the repair feature sometimes causes more problems than it solves) and then ran the repair database feature and it corrected everything.
User avatar
Senior Boarder

teitbite
Tue Dec 31, 2013 4:26 am
Reply with quote
Report this post
Hi

Yes the error mentioned looks like overinterpretation of the code from sql injection. I'm affraid using a backup was the only solution since a place where it got broke was almost impossible to found.
User avatar
Moderator


cron