Author Topic: Error in syntax problem  (Read 2737 times)

0 Members and 1 Guest are viewing this topic.

Offline velcro

  • Pre-Newbie
  • Posts: 9
    • View Profile
Error in syntax problem
« on: May 16, 2006, 06:32:00 AM »
all of sudden i am getting this error
(using using MySQL 4.1.14 4images 1.7.2)

DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.user_id = AND l.user_id = u.user_id
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND l.user_id = u.user_id' at line 3

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id =
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

nothing has changed that Im aware of..so Im stumped and of course mysql challenged
thanks for any help you can offer
LB

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: Error in syntax problem
« Reply #1 on: May 16, 2006, 08:58:04 AM »
hmmm...wierd...
what if you replace in includes/sessions.php
Code: [Select]
      $user_id = ($this->read_cookie_data("userid")) ? intval($this->read_cookie_data("userid")) : GUEST;
With this:
Code: [Select]
      $user_id = intval($this->read_cookie_data("userid")) ? intval($this->read_cookie_data("userid")) : GUEST;
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)