系统发生错误

您可以选择 [ 重试 ] [ 返回 ] 或者 [ 回到首页 ]

错误位置: FILE: /mnt/wwwroot/obl/ephp/dbdrivers/db_mysqli.class.php LINE: 45 ErrorCode: 2045

[ 错误信息 ]

执行mysqli::query()出现错误: 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 'GROUP BY a.id ORDER BY count desc LIMIT 0,10' at line 1
原SQL: SELECT SQL_CALC_FOUND_ROWS a .* , c.username AS username, c.image AS userImg, count( b.userID )AS count FROM t_gallery AS a LEFT JOIN t_zan AS b ON b.galleryID = a.id LEFT JOIN p_user AS c ON a.user_id = c.id WHERE a.gameID= GROUP BY a.id ORDER BY count desc LIMIT 0,10

[ TRACE ]

#0 /mnt/wwwroot/obl/ephp/dbdrivers/db_mysqli.class.php(68): db_mysqli->query('SELECT SQL_CALC...')
#1 /mnt/wwwroot/obl/ephp/libraries/model.class.php(336): db_mysqli->fetch_arrays('SELECT SQL_CALC...')
#2 /mnt/wwwroot/obl/ephp/libraries/model.class.php(397): model->findAll()
#3 /mnt/wwwroot/obl/_web/models/installModel.php(461): model->findPage()
#4 /mnt/wwwroot/obl/_web/controllers/competitionController.php(156): installModel->getSqlAllPage('a .* , c.userna...', 't_gallery AS a ...', 'a.gameID= GROUP...', 1, 10, 'count desc')
#5 /mnt/wwwroot/obl/ephp/ePHP.php(420): competitionController->readAction()
#6 /mnt/wwwroot/obl/index.php(34): app->run()
#7 {main}

ePHP { Fast & Simple PHP Framework } -- [ WE CAN DO IT JUST LIKE IT ]