:(

1064: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 'order by RAND() LIMIT 4' at line 1 [ SQL语句 ] : SELECT * FROM `watch_product` WHERE FIND_IN_SET(216,`product_classify_2`) AND product_state=1 AND product_id order by RAND() LIMIT 4

错误位置

FILE: /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 350

TRACE

#0 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/Db/Driver.class.php(350): E('1064:You have a...')
#1 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/Db/Driver.class.php(180): Think\Db\Driver->error()
#2 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/Model.class.php(1382): Think\Db\Driver->query('SELECT * FROM `...')
#3 /www/wwwroot/www.vhlondon.cn/Application/Home/Controller/BaseController.class.php(262): Think\Model->query('SELECT * FROM `...')
#4 /www/wwwroot/www.vhlondon.cn/Application/Home/Controller/ShopController.class.php(399): Home\Controller\BaseController->detailRecom('216', NULL, NULL)
#5 [internal function]: Home\Controller\ShopController->productDetail()
#6 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/App.class.php(173): ReflectionMethod->invoke(Object(Home\Controller\ShopController))
#7 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Home\Controller\ShopController), 'productDetail')
#8 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/App.class.php(204): Think\App::exec()
#9 /www/wwwroot/www.vhlondon.cn/ThinkPHP/Library/Think/Think.class.php(120): Think\App::run()
#10 /www/wwwroot/www.vhlondon.cn/ThinkPHP/ThinkPHP.php(97): Think\Think::start()
#11 /www/wwwroot/www.vhlondon.cn/index.php(22): require('/www/wwwroot/ww...')
#12 {main}