Author Topic: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars  (Read 5811 times)

0 Members and 1 Guest are viewing this topic.

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars
« on: June 07, 2005, 12:45:45 AM »
hello evrybody here  :D

this the first post for me ..

i have probleme with 4images .. be4 it's work good but last night i have this error :

DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN

you can see the error here url :  http://gallery.7oob.net

i have repait table (4images_sessionvars )  but it's not work

i hope anybody here help me :)

Warm Regards,

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars
« Reply #1 on: June 07, 2005, 01:44:14 AM »
_ts h_ rd t_ he_p u wi_h_ut s_ei_g fu_l  _rr_ r me_s_g_

huh? dont understand?
Insert the following letters to the blank spaces:
I a o l t o e n l e o s a e

:lol:
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars
« Reply #2 on: June 07, 2005, 02:05:49 AM »
looooooooooooolz V@no  :lol:

k6_ dk _ dk55ty _

i think you understand me now  :roll:

now i have fixed some error but i stille see some error like this :
DB Error: Bad SQL Query: DELETE FROM 4images_sessions WHERE session_lastaction < -6E+25
Got error 127 from table handler

Warning: Cannot modify header information - headers already sent by (output started at /home/gallery/public_html/0123gallery/includes/db_mysql.php:188) in /home/gallery/public_html/0123gallery/includes/sessions.php on line 85

Warning: Cannot modify header information - headers already sent by (output started at /home/gallery/public_html/0123gallery/includes/db_mysql.php:188) in /home/gallery/public_html/0123gallery/includes/sessions.php on line 85

Warning: Cannot modify header information - headers already sent by (output started at /home/gallery/public_html/0123gallery/includes/db_mysql.php:188) in /home/gallery/public_html/0123gallery/includes/sessions.php on line 85

DB Error: Bad SQL Query: SELECT s.session_user_id, s.session_lastaction, s.session_ip, u.user_id, u.user_level, u.user_name, u.user_invisible FROM 4images_sessions s LEFT JOIN 4images_users u ON (u.user_id = s.session_user_id) WHERE s.session_lastaction >= 1118101711 ORDER BY u.user_id ASC, s.session_ip ASC
Got error 127 from table handler


what this error mean ? and how can i fixed it

Regards,

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars
« Reply #3 on: June 07, 2005, 02:20:45 AM »
hmmm...error 127 is something new on this forum...
if this page is a correct match with the error, then I belive u should contact your hoster...
http://dev.mysql.com/doc/maxdb/en/87/0c7ff172ff11d2a9aa00a0c9430730/content.htm

but before u go ahead and contact them, try to clear (empty up) the 4images_sessions table (dont delete it!) nothing going to get lost, only sessions, which are not critical important ;)
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline RED_LINE

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars
« Reply #4 on: June 07, 2005, 02:30:25 AM »
thankyou man  :lol:

i have empty the table but no new ... i will go ahead and contact my host now

much thanx for help

Regards,