Geeklog Forums

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?

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

Muchas gracias Dirk.

:shakehands: