Author Topic: Bad SQL Query?  (Read 4732 times)

0 Members and 1 Guest are viewing this topic.

Offline RamEEz

  • Newbie
  • *
  • Posts: 25
    • View Profile
Bad SQL Query?
« on: August 07, 2006, 05:00:32 PM »
When i tried to edit a category i got this error

Quote
DB Error: Bad SQL Query: UPDATE 4images_categories SET cat_name = 'Guitar Workshop By Faraz Anwar', cat_description = 'Karachi, July 2006. Thanks to Zeeshan Anwar Ali', cat_parent_id = 0, cat_hits = 285, auth_viewcat = 0, auth_viewimage = 0, auth_download = 2, auth_upload = 2, auth_directupload = 9, auth_vote = 0, auth_sendpostcard = 0, auth_readcomment = 0, auth_postcomment = 2, cat_image = WHERE cat_id = 32
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 'WHERE cat_id = 32' at line 3
« Last Edit: August 07, 2006, 05:23:48 PM by RamEEz »

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: Bad SQL Query?
« Reply #1 on: August 07, 2006, 05:20:47 PM »
Please read forum rules, your topic has no useful information.
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 RamEEz

  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: Bad SQL Query?
« Reply #2 on: August 07, 2006, 05:24:12 PM »
I think the error itself is enough information.

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: Bad SQL Query?
« Reply #3 on: August 07, 2006, 05:30:51 PM »
The problem is "Category image" mod. And if I'm not misstaken this already been covered under the mod's topic.

Since this is not related to 4images itself, no point discuss it here. Any further questions, please reply to the appropriate topic.
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)