Whoops, looks like something went wrong.

1/1 Doctrine_Connection_Mysql_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '-3' at line 1

  1. in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Connection.php line 1082
  2. at Doctrine_Connection->rethrowException(object(PDOException), object(Doctrine_Connection_Statement)) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Connection/Statement.php line 269
  3. at Doctrine_Connection_Statement->execute(array('LT', 'A', '1', '1708', '0', '1', '1')) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Connection.php line 1006
  4. at Doctrine_Connection->execute('SELECT DISTINCT g5.id FROM goods g5 LEFT JOIN goods_sitemap g6 ON (g5.id = g6.good_id) LEFT JOIN sitemap s2 ON s2.id = g6.sitemap_id LEFT JOIN goods_translation g7 ON g5.id = g7.id AND (g7.lang = ?) LEFT JOIN router r2 ON g5.id = r2.item_id AND ((r2.canonical = 1 AND r2.lng = g7.lang)) AND r2.type = 'good' LEFT JOIN price_lists p2 ON g5.id = p2.object_id AND (p2.name = ?) AND p2.object_type = 'good' LEFT JOIN goods_sitemap g8 ON g5.id = g8.good_id WHERE g8.sitemap_id = s2.id AND g5.top = ? AND s2.id = ? AND p2.final_price_no_vat * 1 > ? AND g5.main_category > ? AND g7.visible = ? GROUP BY g5.id ORDER BY g8.order_nr ASC LIMIT 3 OFFSET -3', array('LT', 'A', '1', '1708', '0', '1', '1')) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Query.php line 1274
  5. at Doctrine_Query->buildSqlQuery(true) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Query.php line 1133
  6. at Doctrine_Query->getSqlQuery(array()) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Query/Abstract.php line 945
  7. at Doctrine_Query_Abstract->_execute(array()) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/libraries/Doctrine/Query/Abstract.php line 1026
  8. at Doctrine_Query_Abstract->execute(array(), '2') in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/models/lgoods.php line 892
  9. at Lgoods->_get_goods(array('offset' => '-3', 'limit' => '3', 'top' => '1', 'group_by' => 'g.id', 'sort_order' => 'order_nr')) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/models/lgoods.php line 1239
  10. at Lgoods->get_top_goods(array('offset' => '-3', 'limit' => '3')) in /home/mv067051/domains/kovinissportas.lt/public_html/CodeIgniter/application/controllers/goods.php line 527
  11. at Goods->top_goods_main()
  12. at call_user_func_array(array(object(Goods), 'top_goods_main'), array()) in /home/mv067051/domains/kovinissportas.lt/public_html/vendor/nercury/code-igniter-bundle/Nercury/CodeIgniterBundle/ci_bootstrap.php line 404
  13. at ci_bootstrap(object(AppKernel)) in /home/mv067051/domains/kovinissportas.lt/public_html/vendor/nercury/code-igniter-bundle/Nercury/CodeIgniterBundle/CiHelperService.php line 259
  14. at CiHelperService->getResponse(object(Request)) in /home/mv067051/domains/kovinissportas.lt/public_html/src/Legacy/CodeIgniterBundle/Controller/DefaultRouteController.php line 47
  15. at DefaultRouteController->indexAction('goods/top_goods_main')
  16. at call_user_func_array(array(object(DefaultRouteController), 'indexAction'), array('goods/top_goods_main')) in /home/mv067051/domains/kovinissportas.lt/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 129
  17. at HttpKernel->handleRaw(object(Request), '1') in /home/mv067051/domains/kovinissportas.lt/public_html/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php line 73
  18. at HttpKernel->handle(object(Request), '1', true) in /home/mv067051/domains/kovinissportas.lt/public_html/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/HttpKernel.php line 50
  19. at HttpKernel->handle(object(Request), '1', true) in /home/mv067051/domains/kovinissportas.lt/public_html/app/bootstrap.php.cache line 619
  20. at Kernel->handle(object(Request)) in /home/mv067051/domains/kovinissportas.lt/public_html/index.php line 80