Welcome to Geeklog, Anonymous Monday, December 30 2024 @ 11:34 am EST

Geeklog Forums

An SQL error has occurred. Please see error.log for details.


Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
Suddenly today my site crashed, I did not touch anything it jst happened

Can you tell me why

Here is one line from eror log in geklog folder

DELETE FROM gl2_sessions WHERE remote_ip = '67.186.65.213' AND uid = 1
Wed Jul 11 15:16:37 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Wed Jul 11 15:16:42 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '38.99.44.102' AND uid = 1
Wed Jul 11 15:17:46 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '70.43.166.6' AND uid = 1
Wed Jul 11 15:18:20 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '70.43.166.6' AND uid = 1


ANd if I try to open the site I get this error

An SQL error has occurred. Please see error.log for details.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
As the error message says: Try to repair the sessions table - phpMyAdmin has an option for that. If that doesn't work out, you can empty (not delete) the table - the worst that will happen is that some people may have to log in again.

bye, Dirk
 Quote

Status: offline

garfy

Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
thank you again DIrk

But it happened again today, yesterday the host did not know how to fix this so they did a backup

and today it happened again so I repaired the table

But why is it happening 2 days in a row - is it because of host or hackers

I also disabled pingback just in case and it still happened

hereis the erro.log



Text Formatted Code

Thu 12 Jul 2007 13:31:35 MDT - Error, invalid username: 'HellisDS'
Thu 12 Jul 2007 14:23:19 MDT - Error, invalid username: 'sexxysexy'
Thu 12 Jul 2007 14:24:11 MDT - Error, invalid username: 'sexxysexy'
Thu 12 Jul 2007 14:26:28 MDT - Error, invalid username: 'sexxysexy'
Thu Jul 12 16:02:30 2007 - 1030: Got error 127 from storage engine. SQL in question: INSERT INTO gl2_sessions (sess_id, uid, start_time, remote_ip) VALUES (1466761770, 411, 1184277750, '24.30.149.142')
Thu Jul 12 16:02:45 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:03:53 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:06:33 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:10:26 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:26:59 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:27:00 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:34:02 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:37:01 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu Jul 12 16:40:33 2007 - 1030: Got error 124 from storage engine. SQL in question: DELETE FROM gl2_sessions WHERE uid = 1 AND remote_ip = '24.30.149.142'
Thu 12 Jul 2007 17:10:01 MDT - Error, invalid username: 'Variamoizix'
Thu 12 Jul 2007 17:11:21 MDT - Error, invalid username: 'Variamoizix'
Thu 12 Jul 2007 17:12:04 MDT - Error, invalid username: 'Variamoizix'
Thu Jul 12 18:12:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '70.121.8.97' AND uid = 1
Thu Jul 12 18:12:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '69.216.113.129' AND uid = 1
Thu Jul 12 18:12:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.57.163.205' AND uid = 1
Thu Jul 12 18:12:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '69.123.1.63' AND uid = 1
Thu Jul 12 18:12:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '71.96.78.6' AND uid = 1
Thu Jul 12 18:12:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '80.216.76.83' AND uid = 1
Thu Jul 12 18:12:23 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.6.26.28' AND uid = 1
Thu Jul 12 18:12:23 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:12:23 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: SELECT uid FROM gl2_sessions WHERE (sess_id = '1419297722') AND (start_time > 1184278343) AND (remote_ip = '89.142.144.104')
Thu Jul 12 18:12:30 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: SELECT uid FROM gl2_sessions WHERE (sess_id = '1419297722') AND (start_time > 1184278350) AND (remote_ip = '89.142.144.104')
Thu Jul 12 18:12:34 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: SELECT uid FROM gl2_sessions WHERE (sess_id = '1419297722') AND (start_time > 1184278354) AND (remote_ip = '89.142.144.104')
Thu Jul 12 18:13:08 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:13:15 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: SELECT uid FROM gl2_sessions WHERE (sess_id = '1419297722') AND (start_time > 1184278395) AND (remote_ip = '89.142.144.104')
Thu Jul 12 18:13:17 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.6.26.36' AND uid = 1
Thu Jul 12 18:13:19 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '71.234.67.209' AND uid = 1
Thu Jul 12 18:13:24 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '71.234.67.209' AND uid = 1
Thu Jul 12 18:14:03 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:14:58 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:15:45 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:16:34 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:16:57 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '85.195.123.24' AND uid = 1
Thu Jul 12 18:17:24 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:18:21 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:19:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '75.3.183.25' AND uid = 1
Thu Jul 12 18:19:10 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '97.99.32.59' AND uid = 1
Thu Jul 12 18:19:11 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:19:14 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '172.203.74.102' AND uid = 1
Thu Jul 12 18:20:04 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '128.194.135.94' AND uid = 1
Thu Jul 12 18:20:49 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '24.149.233.170' AND uid = 1
Thu Jul 12 18:20:50 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '70.253.202.250' AND uid = 1
Thu Jul 12 18:20:51 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '68.252.46.160' AND uid = 1
Thu Jul 12 18:20:51 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '190.49.155.132' AND uid = 1
Thu Jul 12 18:20:53 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '219.136.239.51' AND uid = 1
Thu Jul 12 18:20:54 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '64.178.176.238' AND uid = 1
Thu Jul 12 18:21:07 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.220.195.115' AND uid = 1
Thu Jul 12 18:21:39 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '67.186.65.213' AND uid = 1
Thu Jul 12 18:22:15 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.6.17.20' AND uid = 1
Thu Jul 12 18:23:44 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '69.120.201.47' AND uid = 1
Thu Jul 12 18:23:44 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '68.78.5.246' AND uid = 1
Thu Jul 12 18:23:44 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '67.82.126.18' AND uid = 1
Thu Jul 12 18:25:14 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '66.249.70.35' AND uid = 1
Thu Jul 12 18:25:16 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '76.186.164.27' AND uid = 1
Thu Jul 12 18:26:40 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '66.231.188.167' AND uid = 1
Thu Jul 12 18:26:44 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.220.195.115' AND uid = 1
Thu Jul 12 18:26:44 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.220.195.115' AND uid = 1
Thu Jul 12 18:26:44 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.220.195.115' AND uid = 1
Thu Jul 12 18:26:45 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '74.220.195.115' AND uid = 1
Thu Jul 12 18:27:22 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '66.231.188.167' AND uid = 1
Thu Jul 12 18:27:54 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '68.40.49.12' AND uid = 1
Thu Jul 12 18:28:45 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: SELECT uid FROM gl2_sessions WHERE (sess_id = '1974455874') AND (start_time > 1184279325) AND (remote_ip = '62.1.60.60')
Thu Jul 12 18:28:47 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: SELECT uid FROM gl2_sessions WHERE (sess_id = '1974455874') AND (start_time > 1184279327) AND (remote_ip = '62.1.60.60')
Thu Jul 12 18:29:02 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '66.231.188.167' AND uid = 1
Thu Jul 12 18:29:35 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '24.201.233.26' AND uid = 1
Thu Jul 12 18:30:20 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '24.201.233.26' AND uid = 1
Thu Jul 12 18:30:41 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '68.93.42.65' AND uid = 1
Thu Jul 12 18:30:42 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '201.53.130.224' AND uid = 1
Thu Jul 12 18:30:42 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '99.245.255.212' AND uid = 1
Thu Jul 12 18:30:42 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '123.213.218.204' AND uid = 1
Thu Jul 12 18:33:19 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '67.186.65.213' AND uid = 1
Thu Jul 12 18:33:27 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '24.44.136.10' AND uid = 1
Thu Jul 12 18:33:27 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '69.86.24.88' AND uid = 1
Thu Jul 12 18:33:29 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '76.181.22.19' AND uid = 1
Thu Jul 12 18:33:34 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '24.89.233.130' AND uid = 1
Thu Jul 12 18:33:45 2007 - 1194: Table 'gl2_sessions' is marked as crashed and should be repaired. SQL in question: DELETE FROM gl2_sessions WHERE remote_ip = '66.231.188.167' AND uid = 1
 
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Talk to your hosting service. Corruption of tables often happens when MySQL crashes. They should have a better idea what's going on.

bye, Dirk
 Quote

All times are EST. The time is now 11:34 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