The secure CMS.

Welcome to Geeklog, Anonymous Wednesday, April 24 2024 @ 07:23 am EDT

Geeklog Forums

Insert failed in new_session()

 New Topic  Post Reply
 11/06/09 05:47am (Read 1,449 times)  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Hello,

Some of my geeklog sites show this message today
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()


and the log file
Fri Nov 6 10:41:22 2009 - 1194: Table 'gl_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '203.131.251.138' AND uid = '1'
Fri Nov 6 10:41:22 2009 - 1194: Table 'gl_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl_sessions WHERE start_time < 1257496582
ven 06 nov 2009 10:41:23 GMT-2 - 1194: Table 'gl_sessions' is marked as crashed and should be repaired. SQL in question: SELECT DISTINCT gl_sessions.uid,username,remoteusername,remoteservice,photo,showonline FROM gl_sessions,gl_users,gl_userprefs WHERE gl_users.uid = gl_sessions.uid AND gl_users.uid = gl_userprefs.uid AND start_time >= 1257496583 AND gl_sessions.uid <> 1 ORDER BY username,remoteusername,remoteservice
ven 06 nov 2009 10:41:23 GMT-2 - 1194: Table 'gl_sessions' is marked as crashed and should be repaired. SQL in question: SELECT COUNT(*) FROM gl_sessions WHERE uid = '1'


Reparing the Db solve the issue
geeklog.gl_sessions
warning : Number of rows changed from 4 to 5
status : OK


::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 07:23 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content