Forum Subject: Insert failed in new_session()
Posted on: 10/05/09 09:50am
By: manowar
An SQL error has occurred. Please see error.log for details.: An SQL error has occurred. Please see error.log for details.
Insert failed in new_session()
In log file :
Mon Oct 5 09:49:18 2009 - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE remote_ip = '200.75.21.139' AND uid = '1'
Mon Oct 5 09:49:18 2009 - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE start_time < 1254750258
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE uid = '2'
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE uid = '1' AND remote_ip = '200.75.21.139'
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: INSERT INTO hn_sessions (sess_id, uid, start_time, remote_ip) VALUES (1326975321, 2, 1254750558, '200.75.21.139'
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question:
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question:
What should I do to fix this? :doh:
Why is it?
Insert failed in new_session()
In log file :
Mon Oct 5 09:49:18 2009 - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE remote_ip = '200.75.21.139' AND uid = '1'
Mon Oct 5 09:49:18 2009 - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE start_time < 1254750258
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE uid = '2'
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM hn_sessions WHERE uid = '1' AND remote_ip = '200.75.21.139'
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question: INSERT INTO hn_sessions (sess_id, uid, start_time, remote_ip) VALUES (1326975321, 2, 1254750558, '200.75.21.139'
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question:
lun 05 oct 2009 09:49:18 CLT - 145: Table './zorreros09/hn_sessions' is marked as crashed and should be repaired. SQL in question:
What should I do to fix this? :doh:
Why is it?
Re: Insert failed in new_session()
Posted on: 10/05/09 10:38am
By: Dirk
As the error message says: The sessions table has to be repaired. phpMyAdmin (if you have that) has an option for that. Or in plain SQL:
REPAIR TABLE hn_sessions;
bye, Dirk
REPAIR TABLE hn_sessions;
bye, Dirk
Re: Insert failed in new_session()
Posted on: 10/05/09 11:52am
By: manowar
Muchas gracias Dirk.
:shakehands:
:shakehands: