Error when updating slots

Please report bugs here, please be very detailed in your bug reports. If you've come up with some code to fix the bug, please post it here.
Post Reply
AndyM
Developer
Posts: 213
Joined: Thu Jul 16, 2009 21:44

Error when updating slots

Post by AndyM » Sat Sep 24, 2011 20:24

Command Processors are appearing as High slot items on my board. So I logged in as admin and attempted to use the "Fix Slots" link. This error came up.

Database error: 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 itd_itl_id = 1' at line 1
SQL: UPDATE kb3_items_dropped SET itd_itl_id ='2' WHERE itd_itm_id=11014 AND itd_kll_id = AND itd_itl_id = 1
ERROR [256] SQL error (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 itd_itl_id = 1' at line 1
Error on line 397 in file /kbpath/common/includes/class.dbcachedquery.php
PHP 5.3.6 (Linux), EDK 3.2.3 (Incursion)

The query seems to have an extra AND itd_kll_id = in it.
You backed up your database, right ???

Kovell
Veteran
Posts: 1036
Joined: Wed Nov 26, 2008 13:35

Re: Error when updating slots

Post by Kovell » Sun Sep 25, 2011 07:58

What is the url for your board?
Are you using a custom theme?

Post Reply

Return to “Bug Reporting”

Who is online

Users browsing this forum: No registered users and 6 guests