When assigning a category to an article as database error is produced
The article ID is not found/used by the category assignment query with the following error reported.
Inserting the category with the category bbCode works fine but the tool below the edit window fails.
Code:
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT categoryitemid FROM `vw_categoryitem` WHERE pageid = AND itemcategoryid = 4277;
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 'AND itemcategoryid = 4277' at line 1
Error Number : 1064
Request Date : Thursday, January 1st 2015 @ 12:16:52 AM
Error Date : Thursday, January 1st 2015 @ 12:16:53 AM
Script : [url]http://mb.nawcc.org/showwiki.php?title=Elgin_Watch_Co&do=save[/url]
Referrer : [url]http://mb.nawcc.org/showwiki.php?title=Elgin_Watch_Co&do=edit[/url]
IP Address : 68.189.242.96
Username : Tom McIntyre
Classname : vB_Database
MySQL Version : 5.6.16
The category BB-Code doesn't actually add a page to the category. If you have a category BB-Code, it just makes a link, same as the regular Wiki BB-Code.
I get this error if I try to use the category too below the edit windowl to add a category to any article, not just a new one. I carn put in the fix you describe in the other threqd, but if the 4.0.0 release is available today, I will just use that.
This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.