SQL 错误消息: "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 '' at line 3" SQL 语句: "SELECT COUNT(`shop_comments`.`comment_id`) FROM `shop_comments` WHERE shop_id = " SQL 错误代码: "7335941".

错误原因:

您看到这个错误页面是因为应用程序抛出了没有捕获的异常。

异常的详细内容: exception 'flea_db_exception_sqlquery' with message 'SQL 错误消息: "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 '' at line 3"
SQL 语句: "SELECT COUNT(`shop_comments`.`comment_id`)
FROM `shop_comments`
WHERE shop_id = "
SQL 错误代码: "7335941".' in /var/www/html/hsj/home/FLEA/FLEA/Db/Exception/SqlQuery.php:55

#0 /var/www/html/hsj/home/FLEA/FLEA/Db/Driver/Mysql.php(230): flea_db_exception_sqlquery('SELECT COUNT(`shop_comments ...', 'You have an error in your S ...', 1064)
#1 /var/www/html/hsj/home/FLEA/FLEA/Db/Driver/Mysql.php(614): execute('SELECT COUNT(`shop_comments ...')
#2 /var/www/html/hsj/home/FLEA/FLEA/Db/TableDataGateway.php(553): getone('SELECT COUNT(`shop_comments ...')
#3 /var/www/html/hsj/home/FLEA/FLEA/Helper/Pager.php(200): findcount('shop_id = ')
#4 /var/www/html/hsj/home/APP/Controller/shop.php(119): flea_helper_pager(model_shopcomments, 0, 20, 'shop_id = ', 'created desc')
#5 /var/www/html/hsj/home/FLEA/FLEA/Dispatcher/Simple.php(127): actioncomments()
#6 /var/www/html/hsj/home/FLEA/FLEA/Dispatcher/Simple.php(77): _executeaction('shop', 'comments', 'Controller_shop')
#7 /var/www/html/hsj/home/FLEA/FLEA.php(621): dispatching()
#8 /var/www/html/hsj/home/home.php(42): runmvc()
#9 {main}

Exception: flea_db_exception_sqlquery
Message: SQL 错误消息: "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 '' at line 3" SQL 语句: "SELECT COUNT(`shop_comments`.`comment_id`) FROM `shop_comments` WHERE shop_id = " SQL 错误代码: "7335941".


Filename: /var/www/html/hsj/home/FLEA/FLEA/Db/Driver/Mysql.php
#9 flea_db_exception_sqlquery::flea_db_exception_sqlquery('SELECT COUNT(`shop_comments ...', 'You have an error in your S ...', 1064)

Filename: /var/www/html/hsj/home/FLEA/FLEA/Db/Driver/Mysql.php
#8 flea_db_driver_mysql::execute('SELECT COUNT(`shop_comments ...')

Filename: /var/www/html/hsj/home/FLEA/FLEA/Db/TableDataGateway.php
#7 flea_db_driver_mysql::getone('SELECT COUNT(`shop_comments ...')

Filename: /var/www/html/hsj/home/FLEA/FLEA/Helper/Pager.php
#6 model_shopcomments::findcount('shop_id = ')

Filename: /var/www/html/hsj/home/APP/Controller/shop.php
#5 flea_helper_pager::flea_helper_pager(model_shopcomments, 0, 20, 'shop_id = ', 'created desc')

Filename: /var/www/html/hsj/home/FLEA/FLEA/Dispatcher/Simple.php
#4 controller_shop::actioncomments()

Filename: /var/www/html/hsj/home/FLEA/FLEA/Dispatcher/Simple.php
#3 flea_dispatcher_simple::_executeaction('shop', 'comments', 'Controller_shop')

Filename: /var/www/html/hsj/home/FLEA/FLEA.php
#2 flea_dispatcher_simple::dispatching()

Filename: /var/www/html/hsj/home/home.php
#1 flea::runmvc()