Author Topic: Error in Admin Control Panel  (Read 3884 times)

0 Members and 1 Guest are viewing this topic.

Offline sigma.

  • Full Member
  • ***
  • Posts: 148
  • cydonian.com/potd
    • View Profile
    • sigma's gallery
Error in Admin Control Panel
« on: January 07, 2011, 05:28:53 AM »
Just got this error in my Admin control panel while trying to change a value for a catergories. Changeing who can post comments to 'Registered User' and after i click save I get the following.

Code: [Select]
DB Error: Bad SQL Query: UPDATE 4images_categories SET cat_name = 'Toronto', cat_description = 'hometown.<!--// <img src=\"http://cydonian.com/photos/templates/catimages/toronto.jpg\" width=\"590\" height=\"300\"><iframe src=\"http://cydonian.com/add.htm\" width=\"600\" height=\"70\" scrolling=\"no\" frameborder=\"0\"></iframe> //-->', cat_parent_id = 23, cat_order = 5, cat_hits = 3092, auth_viewcat = 0, auth_viewimage = 0, auth_download = 2, auth_upload = 9, auth_directupload = 9, auth_vote = 0, auth_sendpostcard = 0, auth_readcomment = 0, auth_postcomment = 2, cat_image = WHERE cat_id = 24
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 = 24' at line 3

Anyone know where that call would of came from? what php file?
or is it something else

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 Admin Control Panel
« Reply #1 on: January 07, 2011, 09:55:31 PM »
issue with category image mod, check all it's steps.
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 sigma.

  • Full Member
  • ***
  • Posts: 148
  • cydonian.com/potd
    • View Profile
    • sigma's gallery
Re: Error in Admin Control Panel
« Reply #2 on: January 08, 2011, 04:49:18 PM »
Thanks V@no, Im taking a look but I haven't edited anything with those php files in ages. Im also seeing a couple other problems. The News Archive Mod, the link to the archive doesnt work anymore and i just noticed that if i delete a comment from an image the comment count stays. Doesn't reset back to zero. This along with my JPG downloads come up as 0kb but the download zip works fine.

I only installed the following mod's recently.

[MOD] See new pictures of a specified category
[MOD] Paypal Mod (Shop Mod Lite)

UPDATE: Looks like I was missing one of the steps in admin/categories.php

somehow it wasn't giving me errors for months but all of a sudden it decided to stop working.
weird!

Thanks V@no. 1 error fixed!
« Last Edit: January 09, 2011, 04:43:43 PM by sigma. »