Display Order: Database Error

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

PHP Code:

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.

PHP Code:

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]

Originally Posted by 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 ?

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.