Author Topic: Help! Bad SQL Query - record changes  (Read 3658 times)

0 Members and 1 Guest are viewing this topic.

Offline blitzy

  • Newbie
  • *
  • Posts: 32
    • View Profile
    • http://www.cs-media.org
Help! Bad SQL Query - record changes
« on: April 08, 2005, 12:50:39 AM »
I just installed a fresh 1.7.1 gallery on my site and a few simple mods ([Mod] More Statistics for your visitors, [MOD] Ban v1.6, and [MOD] Batch Copy/Move/Edit Images v3.7.1) but everything's been working fine. That is...until today. When I accessed the page, this error message showed at the top of the page:

Quote
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 >= 1112913548 ORDER BY u.user_id ASC, s.session_ip ASC
Record has changed since last read in table 's'

I haven't altered any coding since I did the mods about two weeks ago! I also noticed that the 'Currently active users' statistics are not accurate. It doesn't show my online status nor that of guests. What's wrong? Please help!

Gallery: http://www.cs-media.org

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: Help! Bad SQL Query - record changes
« Reply #1 on: April 08, 2005, 12:55:05 AM »
If your mysql is version 4.1.7 or older then its a bug:
http://bugs.mysql.com/bug.php?id=6748
contact your hoster and ask them to upgrade their version to v4.1.8 or newer.
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 blitzy

  • Newbie
  • *
  • Posts: 32
    • View Profile
    • http://www.cs-media.org
Re: Help! Bad SQL Query - record changes
« Reply #2 on: April 08, 2005, 01:16:16 AM »
If your mysql is version 4.1.7 or older then its a bug:
http://bugs.mysql.com/bug.php?id=6748
contact your hoster and ask them to upgrade their version to v4.1.8 or newer.
Grrr...I just checked and my host (Globat) is using 4.1.7.  :x Stupid Globat! They've got the worst tech support; worthless jerks. Never get hosted with them!  :? If I'm correct, they won't upgrade to v4.1.8 or newer for me. Is there any way around this?  :cry: