After I upgrade to 5.0.1 in Smileys Manager there is an error like this :
Database error in vBulletin 5.0.1: Invalid SQL: SELECT imagecategory.*, COUNT(smilie.0) AS items FROM vbstc_imagecategory AS imagecategory LEFT JOIN vbstc_smilie AS smilie USING(imagecategoryid) WHERE imagetype = 3 GROUP BY imagecategoryid ORDER BY displayorder; MySQL Error : Unknown column 'smilie.0' in 'field list' Error Number : 1054 Request Date : Wednesday, April 24th 2013 @ 12:49:34 AM Error Date : Wednesday, April 24th 2013 @ 12:49:35 AM Script : http:///core/admincp/image.php?do=modify&table=smilie Referrer : http://community.siutao.com/core/adm...0a6a9af&do=nav IP Address : 111.67.94.227 Username : ST_TERABYTE Classname : vB_Database_MySQL MySQL Version : 5.1.68-cll
Database error in vBulletin 5.0.1: Invalid SQL: SELECT imagecategory.*, COUNT(smilie.0) AS items FROM vbstc_imagecategory AS imagecategory LEFT JOIN vbstc_smilie AS smilie USING(imagecategoryid) WHERE imagetype = 3 GROUP BY imagecategoryid ORDER BY displayorder; MySQL Error : Unknown column 'smilie.0' in 'field list' Error Number : 1054 Request Date : Wednesday, April 24th 2013 @ 12:49:34 AM Error Date : Wednesday, April 24th 2013 @ 12:49:35 AM Script : http:///core/admincp/image.php?do=modify&table=smilie Referrer : http://community.siutao.com/core/adm...0a6a9af&do=nav IP Address : 111.67.94.227 Username : ST_TERABYTE Classname : vB_Database_MySQL MySQL Version : 5.1.68-cll
Comment