首页 >> 会员相册 >> 网友贴图

SQL:
SELECT COUNT(*) AS total FROM `album` WHERE 1 ishidden<1 AND review=1 AND cid IN (118) AND pictures_cnt>0 AND (allowgroup<=0 OR uid=0) ORDER BY aid DESC LIMIT 0, 1

Error:
SQLSTATE[42000]: Syntax error or access violation: 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 'ishidden<1 AND review=1 AND cid IN (118) AND pictures_cnt>0 AND (allowgroup<=0 O' at line 1


Fatal error: Uncaught Error: Call to a member function fetchAll() on bool in /var/www/html/park/include/drivers/pdo.class.php:72 Stack trace: #0 /var/www/html/park/include/page.class.php(44): mdb->get_one('SELECT COUNT(*)...', Array) #1 /var/www/html/park/modules/album/album.class.php(80): Page->pageList() #2 /var/www/html/park/include/archive.common.php(196): Album->selectList(Array) #3 /var/www/html/park/cache/templates/park/list_album.tpl.php(27): pagelist('row=30,desclen=...') #4 /var/www/html/park/index.php(105): include('/var/www/html/p...') #5 {main} thrown in /var/www/html/park/include/drivers/pdo.class.php on line 72