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
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.
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 ?
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.
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.