Display Order: Database Error

[LOTR]

I have add categories on the aticlesm however when i try to display the order of categories and error occured.

Invalid SQL:
UPDATE articles_category
SET categoryorder=
WHERE articles_categoryid=16

mysql 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 'WHERE articles_categoryid=16' at line 3

mysql error number: 1064

Date: Sunday 20th of February 2005 05:06:02 PM
Script: http://mydomain.com/forum/admincp/vbarticles.php
Referer: http://mydomain.com/forum/admincp/vbarticles.php?do=modifycat
Username: Admin
IP Address: xxx.xxx.xx.xxx



Any ideas to fix it cing? :)
Thanks

[LOTR]

Cing,

These error still occured when ever i tried to save display order on category articles.

Database error in vBulletin 3.0.7:

Invalid SQL:
UPDATE articles_category
SET categoryorder=
WHERE articles_categoryid=16

mysql 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 'WHERE articles_categoryid=16' at line 3

mysql error number: 1064

Date: Tuesday 22nd of February 2005 07:08:43 PM
Script: http://mysite.com/forum/admincp/vbarticles.php
Referer: http://mysite.com/forum/admincp/vbarticles.php?do=modifycat

Please take a look at it.

[cinq]

Sorry to dig this up, am going through all the threads in this subforum to make sure I don't miss anything out.

I cannot replicate this, can you ?

[jlaine]

Sorry to dig this up, am going through all the threads in this subforum to make sure I don't miss anything out.

I cannot replicate this, can you ?

I can cinq - every time I try to update a category order in the system it repeats that error.

[jlaine]

Just for further review -

I found if you delete the category from the admin panel, it doesn't apparently remove the reference to it from articles_category table - that seems to be causing articles_categoryid to reference the wrong catid when you go to update.

Mine was showing

Invalid SQL:
UPDATE articles_category
SET categoryorder=
WHERE articles_categoryid=5

But the actual category I was trying to update was 8..

Upon removing the categories that were deleted prior via sqladmin and attempting to update the categories again, script worked fine.