Exception - FineCMS

Exception

Description

[content][list] SQL execute failed :SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id` WHERE `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100 and (Bycapacity= or Bycapacity=1) LIMIT 1
Error Message:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'or Bycapacity=1) LIMIT 1' at line 1
Error Code:1064
Error SQL:SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id` WHERE `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100 and (Bycapacity= or Bycapacity=1) LIMIT 1

Source File

/var/www/vhosts/millerhaus.de/wellberghome.com/core/lib/mysql.class.php(55)

Stack Trace

#0 /var/www/vhosts/millerhaus.de/wellberghome.com/core/lib/mysql.class.php(55)Controller::halt([content][list] SQL execute failed :SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id`  WHERE  `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100  and (Bycapacity= or Bycapacity=1) LIMIT 1
Error Message:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'or Bycapacity=1) LIMIT 1' at line 1
Error Code:1064
Error SQL:SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id` WHERE `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100 and (Bycapacity= or Bycapacity=1) LIMIT 1)
#1 /var/www/vhosts/millerhaus.de/wellberghome.com/core/lib/mysql.class.php(87)mysql->query(SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id` WHERE `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100 and (Bycapacity= or Bycapacity=1) LIMIT 1)
#2 /var/www/vhosts/millerhaus.de/wellberghome.com/core/Model.php(804)mysql->fetch_row(SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id` WHERE `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100 and (Bycapacity= or Bycapacity=1))
#3 /var/www/vhosts/millerhaus.de/wellberghome.com/core/View.php(527)Model->execute(SELECT count(*) AS total FROM wb_content_1 LEFT JOIN wb_content_1_bakcarbonsteel ON `wb_content_1`.`id`=`wb_content_1_bakcarbonsteel`.`id` WHERE `wb_content_1`.`status`=1 AND `wb_content_1`.`catid`=100 and (Bycapacity= or Bycapacity=1)..36000)
#4 /var/www/vhosts/millerhaus.de/wellberghome.com/cache/views/b60de7b40ae7713ae5094701c51da711.cache.php(169)View->_listdata(catid=100 more=1 extend=WHERE.-and-(Bycapacity=-or-Bycapacity=1) page=1 urlrule=/index.php?c=content&a=list&catid=100&Bycapacity=1&page=[page] pagesize=16 order=listorder_ASC,id_DESC cache=36000)
#5 /var/www/vhosts/millerhaus.de/wellberghome.com/core/View.php(614)include(/var/www/vhosts/millerhaus.de/wellberghome.com/cache/views/b60de7b40ae7713ae5094701c51da711.cache.php)
#6 /var/www/vhosts/millerhaus.de/wellberghome.com/controllers/ContentController.php(31)View->display(list)
#7 /var/www/vhosts/millerhaus.de/wellberghome.com/core/App.php(148)ContentController->listAction()
#8 /var/www/vhosts/millerhaus.de/wellberghome.com/index.php(19)App::run(Array)