Array ( [corePath] => Array ( [0] => shop [1] => default [2] => 3m [3] => 2 ) [attribute] => Array ( ) [page] => 2 [categoryID] => 378 [brandID] => 47 [joinBrand] => 1 ) 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 'LIMIT 20,20' at line 1
MYSQL QUERY ERROR: «SELECT SQL_CALC_FOUND_ROWS p.id,p.url link,p.title,p.img mainImage, p.quantity, p.page_active, p.availability, p.short_descr text1,p.price,p.oldPrice,p.flags isNew,b.id brandID,b.url1 brandLink,b.title brandTitle,b.img brandImage FROM goods p LEFT JOIN firms b ON b.id=p.firm LEFT JOIN goods_sort ps ON ps.page_id=p.page AND ps.producer_id=p.firm WHERE p.active=1 AND (p.page IN (378) OR p.pages LIKE '%|378,%') AND p.firm=47 ORDER BY IFNULL(ps.ord,999999), p.ord, b.ord LIMIT 14 OFFSET 1 LIMIT 20,20»
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /var/www/protehnology/data/www/protehnology.ru/core/Mysql.php:62 Stack trace: #0 /var/www/protehnology/data/www/protehnology.ru/model/Product.php(212): core\Mysql->fetchAssoc() #1 /var/www/protehnology/data/www/protehnology.ru/tpl/index.tpl(1710): model\Product::getListByFilter(Array, 'goods_sort', 20) #2 /var/www/protehnology/data/www/protehnology.ru/controller/ShopController.php(291): tpl_print_main_page(Array, '3M') #3 /var/www/protehnology/data/www/protehnology.ru/core/core.php(623): controller\ShopController->actionCategory() #4 /var/www/protehnology/data/www/protehnology.ru/index.php(215): core\runApplication(Array) #5 {main} thrown in /var/www/protehnology/data/www/protehnology.ru/core/Mysql.php on line 62