tawnygirl |
03-13-2007 07:52 AM |
I just updated to vB3.6.5, and then updated the Fav Smilies to the current version using the Update instructions and then the 3.1+ instructions.
Everything "looks" fine when we go to reply, but when we click to edit fav smilies:
Database error in vBulletin 3.6.5:
HTML Code:
/misc.php?do=editfavsmilies
we get this error, which I don't know how to fix...
Quote:
Invalid SQL:
SELECT smilieid, smilietext, smiliepath, smilie.title,
imagecategory.title AS category
FROM smilie AS smilie
LEFT JOIN imagecategory AS imagecategory USING(imagecategoryid)
WHERE smilie.imagecategoryid NOT IN (Admin, Use)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder;
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 'Use)
ORDER BY imagecategory.displayorder, imagecategory.title, smilie.display' at line 5
Error Number : 1064
Date : Tuesday, March 13th 2007 @ 01:43:02 AM
Classname : vb_database
|
Does anyone know how I would go about fixing this? :o
|