16. Zend_Db_Statement_Exception
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Db/­Statement/­Pdo.php235
15. PDOException
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Db/­Statement/­Pdo.php228
14. PDOStatement execute
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Db/­Statement/­Pdo.php228
13. Zend_Db_Statement_Pdo _execute
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Db/­Statement.php303
12. Zend_Db_Statement execute
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Db/­Adapter/­Abstract.php480
11. Zend_Db_Adapter_Abstract query
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Db/­Adapter/­Pdo/­Abstract.php238
10. Zend_Db_Adapter_Pdo_Abstract query
…/­library/­Dnk/­Db/­Table.php706
9. Dnk_Db_Table cacheFetchAll
…/­library/­Dnk/­Db/­Table.php797
8. Dnk_Db_Table getAll
…/­library/­Dnk/­Db/­Table.php811
7. Dnk_Db_Table getSingle
…/­application/­modules/­products/­models/­ProductModel.php259
6. ProductModel getItem
…/­application/­modules/­products/­controllers/­IndexController.php16
5. Products_IndexController itemAction
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Controller/­Action.php516
4. Zend_Controller_Action dispatch
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Controller/­Dispatcher/­Standard.php308
3. Zend_Controller_Dispatcher_Standard dispatch
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Controller/­Front.php954
2. Zend_Controller_Front dispatch
…/­vendor/­bombayworks/­zendframework1/­library/­Zend/­Controller/­Front.php212
1. Zend_Controller_Front run
…/­application/­kernel.php222
0. include_once
…/­public/­index.php25

Zend_Db_Statement_Exception (42000)

Callstack information; navigate with mouse or keyboard using Ctrl+↑ or Ctrl+↓
Copy-to-clipboard button
Exception message and its type
Code snippet where the error was thrown
Server state information
Application provided context information
Zend_Db_Statement_Exception thrown with message "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 ')' at line 1, query was: SELECT `products`.`id`, `products`.`name_ru` AS `name`, `products`.`annotation_ru` AS `annotation`, `products`.`text_ru` AS `text`, `products`.`lead_ru` AS `lead`, `products`.`brand`, `products`.`more_link`, `products`.`c2a_type`, `products`.`file_path`, `products`.`price`, `products`.`price_from`, `products`.`eshop_link_ru` AS `eshop_link` FROM `products` WHERE (id=)" Stacktrace: #16 Zend_Db_Statement_Exception in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement/Pdo.php:235 #15 PDOException in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement/Pdo.php:228 #14 PDOStatement:execute in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement/Pdo.php:228 #13 Zend_Db_Statement_Pdo:_execute in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement.php:303 #12 Zend_Db_Statement:execute in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Adapter/Abstract.php:480 #11 Zend_Db_Adapter_Abstract:query in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238 #10 Zend_Db_Adapter_Pdo_Abstract:query in /var/www/clients/client13/web77/web/library/Dnk/Db/Table.php:706 #9 Dnk_Db_Table:cacheFetchAll in /var/www/clients/client13/web77/web/library/Dnk/Db/Table.php:797 #8 Dnk_Db_Table:getAll in /var/www/clients/client13/web77/web/library/Dnk/Db/Table.php:811 #7 Dnk_Db_Table:getSingle in /var/www/clients/client13/web77/web/application/modules/products/models/ProductModel.php:259 #6 ProductModel:getItem in /var/www/clients/client13/web77/web/application/modules/products/controllers/IndexController.php:16 #5 Products_IndexController:itemAction in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Action.php:516 #4 Zend_Controller_Action:dispatch in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Dispatcher/Standard.php:308 #3 Zend_Controller_Dispatcher_Standard:dispatch in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Front.php:954 #2 Zend_Controller_Front:dispatch in /var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Front.php:212 #1 Zend_Controller_Front:run in /var/www/clients/client13/web77/web/application/kernel.php:222 #0 include_once in /var/www/clients/client13/web77/web/public/index.php:25

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 ')' at line 1, query was: SELECT `products`.`id`, `products`.`name_ru` AS `name`, `products`.`annotation_ru` AS `annotation`, `products`.`text_ru` AS `text`, `products`.`lead_ru` AS `lead`, `products`.`brand`, `products`.`more_link`, `products`.`c2a_type`, `products`.`file_path`, `products`.`price`, `products`.`price_from`, `products`.`eshop_link_ru` AS `eshop_link` FROM `products` WHERE (id=)

/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement/Pdo.php
                return $this->_stmt->execute($params);
            } else {
                return $this->_stmt->execute();
            }
        } catch (PDOException $e) {
            // require_once 'Zend/Db/Statement/Exception.php';
            $message = sprintf('%s, query was: %s', $e->getMessage(), $this->_stmt->queryString);
            throw new Zend_Db_Statement_Exception($message, (int) $e->getCode(), $e);
        }
    }
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement/Pdo.php
     * @return bool
     * @throws Zend_Db_Statement_Exception
     */
    public function _execute(array $params = null)
    {
        try {
            if ($params !== null) {
                return $this->_stmt->execute($params);
            } else {
                return $this->_stmt->execute();
Exception message: 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 ')' at line 1
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement/Pdo.php
     * @return bool
     * @throws Zend_Db_Statement_Exception
     */
    public function _execute(array $params = null)
    {
        try {
            if ($params !== null) {
                return $this->_stmt->execute($params);
            } else {
                return $this->_stmt->execute();
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Statement.php
     */
    public function execute(array $params = null)
    {
        /*
         * Simple case - no query profiler to manage.
         */
        if ($this->_queryId === null) {
            return $this->_execute($params);
        }
 
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Adapter/Abstract.php
        // because $bind may be a Zend_Db_Expr object
        if (!is_array($bind)) {
            $bind = array($bind);
        }
 
        // prepare and execute the statement with profiling
        $stmt = $this->prepare($sql);
        $stmt->execute($bind);
 
        // return the results embedded in the prepared statement object
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php
                    unset($bind[$name]);
                    $bind[$newName] = $value;
                }
            }
        }
 
        try {
            return parent::query($sql, $bind);
        } catch (PDOException $e) {
            /**
/var/www/clients/client13/web77/web/library/Dnk/Db/Table.php
 
 
 
   public function cacheFetchAll($select = "", $type = "FETCHALL")
   {
      $prepare = $select->__toString();
      //self::$_logger->warn($select);
      $stmt = $this->getAdapter()->query($select);
 
      $useCache = Zend_Registry::get('cnf')->use_cache;
/var/www/clients/client13/web77/web/library/Dnk/Db/Table.php
               }
            }
         }
// if($this->_name=="nw_product_foodtypes"){
// Zend_Debug::dump($joinTable);die();
// self::$_FBlogger->debug($select.'');
// }
         $retv = $this->cacheFetchAll($select);
      }
      else{
/var/www/clients/client13/web77/web/library/Dnk/Db/Table.php
   }
 
   public function getSingle($fields = array(), $where = "", $joinTable = "", $joinCond = "", $joinFields = array(), $joinType="")
   {
 
      if(count($fields) > 0){
         //self::$_logger->warn(serialize($fields)." where ".$where);
         $retv = $this->getAll($fields, $where, "", "", "", "", $joinTable, $joinCond, $joinFields, $joinType);
         if(is_array($retv) && count($retv) > 0) $retv = $retv[0];
      }
/var/www/clients/client13/web77/web/application/modules/products/models/ProductModel.php
        $id = $this->getIdByUrl($id, $lang);
        $data = $this->getSingle(array( 'id',
            'name_'.$lang.' as name',
            'annotation_'.$lang.' as annotation',
            'text_'.$lang.' as text', 'lead_'.$lang.' as lead',
            'brand', 'more_link', 'c2a_type', 'file_path', 'price', 'price_from',
            'eshop_link_'.$lang.' as eshop_link',
        ), 'id='.$id);
        if(!empty($data)){
            $data['url'] = $this->getUrl($id, $lang);
/var/www/clients/client13/web77/web/application/modules/products/controllers/IndexController.php
class Products_IndexController extends Dnk_Common_Controller
{
    function itemAction()
    {
        $lang =$this->view->currentLang();
 
        $model = new ProductModel();
        $this->view->item = $model->getItem($this->getParam('id'), $lang);
 
        $brand_model = new BrandsModel();
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Action.php
            // @see ZF-7496
            if (!($this->getResponse()->isRedirect())) {
                // preDispatch() didn't change the action, so we can continue
                if ($this->getInvokeArg('useCaseSensitiveActions') || in_array($action, $this->_classMethods)) {
                    if ($this->getInvokeArg('useCaseSensitiveActions')) {
                        trigger_error('Using case sensitive actions without word separators is deprecated; please do not rely on this "feature"');
                    }
                    $this->$action();
                } else {
                    $this->__call($action, array());
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Dispatcher/Standard.php
        $disableOb = $this->getParam('disableOutputBuffering');
        $obLevel   = ob_get_level();
        if (empty($disableOb)) {
            ob_start();
        }
 
        try {
            $controller->dispatch($action);
        } catch (Exception $e) {
            // Clean output buffer on error
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Front.php
                    continue;
                }
 
                /**
                 * Dispatch request
                 */
                try {
                    $dispatcher->dispatch($this->_request, $this->_response);
                } catch (Exception $e) {
                    if ($this->throwExceptions()) {
/var/www/clients/client13/web77/web/vendor/bombayworks/zendframework1/library/Zend/Controller/Front.php
     * @return void
     * @throws Zend_Controller_Exception if called from an object instance
     */
    public static function run($controllerDirectory)
    {
        self::getInstance()
            ->setControllerDirectory($controllerDirectory)
            ->dispatch();
    }
 
/var/www/clients/client13/web77/web/application/kernel.php
$viewRenderer->setView($view);
Zend_Controller_Action_HelperBroker::addHelper($viewRenderer);
 
//добавление пути для своих помощников
$view->addHelperPath('/admin/views/helpers', 'Admin_View_Helper');
// Запуск приложения
 
Zend_Controller_Front::run($config["path"]["controllers"]);
/var/www/clients/client13/web77/web/public/index.php
 
 
// Enable Composer autoloader
require_once BASE_PATH.'/vendor/autoload.php';
 
// Bootstrap default resources & run app
//$application->bootstrap(['frontController','request','routing','dicontainer','view'])->run();
include_once BASE_PATH.'/application/kernel.php';
empty
empty
empty
empty
Key Value
DNKNS Array ( [inlineEdit] => )
Key Value
PHPRC /etc/php5/cgi/
PHP_DOCUMENT_ROOT /var/www/clients/client13/web77
PATH /usr/local/bin:/usr/bin:/bin
PWD /var/www/php-fcgi-scripts/web77
SHLVL 0
PHP_FCGI_MAX_REQUESTS 5000
FCGI_ROLE RESPONDER
REDIRECT_STATUS 200
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST www.mobius.lv
SERVER_SIGNATURE
SERVER_SOFTWARE Apache/2.2.16 (Debian)
SERVER_NAME www.mobius.lv
SERVER_ADDR 87.110.179.123
SERVER_PORT 80
REMOTE_ADDR 3.236.145.110
DOCUMENT_ROOT /var/www/mobius.lv/web/public
SERVER_ADMIN webmaster@mobius.lv
SCRIPT_FILENAME /var/www/mobius.lv/web/public/index.php
REMOTE_PORT 42646
REDIRECT_URL /ru/products/sumka-dlya-dokumentov-meisterst%C3%BCck
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /ru/products/sumka-dlya-dokumentov-meisterst%25C3%25BCck
SCRIPT_NAME /index.php
HTTP_CONNECTION close
PHP_SELF /index.php
REQUEST_TIME 1711663813
empty
0. Whoops\Handler\PrettyPageHandler