string(404) "SELECT  COUNT(*) FROM `publication`
  
 WHERE (`publication`.`lang` = :lang1) AND (id IN (SELECT pub FROM publication_link_topic WHERE topic IN (2))) AND (`publication`.`date_add` <= :date_add3) AND ((date_end >= '2024-11-22 02:54:41' OR date_end IS NULL)) AND (`publication`.`enable` = :enable5) AND (id IN (SELECT publication_id FROM publication_link_publication_region WHERE publication_region_id =))
"
object(PDOException)#122 (8) {
  ["message":protected]=>
  string(206) "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 '))' at line 3"
  ["string":"Exception":private]=>
  string(0) ""
  ["code":protected]=>
  string(5) "42000"
  ["file":protected]=>
  string(80) "/var/www/sj.finarty.ru/public_html/laPuzzle/system/Som/Model/Mapper/Abstract.php"
  ["line":protected]=>
  int(307)
  ["trace":"Exception":private]=>
  array(9) {
    [0]=>
    array(6) {
      ["file"]=>
      string(80) "/var/www/sj.finarty.ru/public_html/laPuzzle/system/Som/Model/Mapper/Abstract.php"
      ["line"]=>
      int(307)
      ["function"]=>
      string(7) "execute"
      ["class"]=>
      string(12) "PDOStatement"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(80) "/var/www/sj.finarty.ru/public_html/laPuzzle/system/Som/Model/Mapper/Abstract.php"
      ["line"]=>
      int(563)
      ["function"]=>
      string(5) "query"
      ["class"]=>
      string(25) "Som_Model_Mapper_Abstract"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        &string(404) "SELECT  COUNT(*) FROM `publication`
  
 WHERE (`publication`.`lang` = :lang1) AND (id IN (SELECT pub FROM publication_link_topic WHERE topic IN (2))) AND (`publication`.`date_add` <= :date_add3) AND ((date_end >= '2024-11-22 02:54:41' OR date_end IS NULL)) AND (`publication`.`enable` = :enable5) AND (id IN (SELECT publication_id FROM publication_link_publication_region WHERE publication_region_id =))
"
        [1]=>
        &array(3) {
          ["lang1"]=>
          string(2) "ru"
          ["date_add3"]=>
          string(19) "2024-11-22 02:54:41"
          ["enable5"]=>
          int(1)
        }
      }
    }
    [2]=>
    array(6) {
      ["file"]=>
      string(73) "/var/www/sj.finarty.ru/public_html/laPuzzle/system/Som/Model/Abstract.php"
      ["line"]=>
      int(953)
      ["function"]=>
      string(8) "getCount"
      ["class"]=>
      string(25) "Som_Model_Mapper_Abstract"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        object(Publication_Model_Article)#79 (13) {
          ["_topics":"Publication_Model_Article":private]=>
          bool(false)
          ["_errors"]=>
          array(0) {
          }
          ["_data":protected]=>
          array(19) {
            ["id"]=>
            NULL
            ["title"]=>
            NULL
            ["descr"]=>
            NULL
            ["message"]=>
            NULL
            ["date_add"]=>
            NULL
            ["date_update"]=>
            NULL
            ["date_end"]=>
            NULL
            ["custom_url"]=>
            NULL
            ["seo_description"]=>
            NULL
            ["seo_keywords"]=>
            NULL
            ["lang"]=>
            NULL
            ["id_channel"]=>
            int(0)
            ["tomain"]=>
            NULL
            ["enable"]=>
            int(1)
            ["user"]=>
            NULL
            ["pub_source"]=>
            NULL
            ["uni_key"]=>
            NULL
            ["show_on"]=>
            NULL
            ["pub_source_link"]=>
            NULL
          }
          ["_linkData":protected]=>
          array(0) {
          }
          ["_extraData":protected]=>
          array(0) {
          }
          ["_oldData":protected]=>
          array(0) {
          }
          ["_e":protected]=>
          NULL
          ["showValidateErrors"]=>
          bool(true)
          ["validators":protected]=>
          array(0) {
          }
          ["ignoreValidateFields":protected]=>
          array(0) {
          }
          ["_requiredFields":"Som_Model_Abstract":private]=>
          array(0) {
          }
          ["_m":"Component":private]=>
          NULL
          ["_e":"Component":private]=>
          NULL
        }
        [1]=>
        &array(6) {
          [0]=>
          array(2) {
            [0]=>
            string(4) "lang"
            [1]=>
            string(2) "ru"
          }
          [1]=>
          string(65) "id IN (SELECT pub FROM publication_link_topic WHERE topic IN (2))"
          [2]=>
          array(3) {
            [0]=>
            string(8) "date_add"
            [1]=>
            string(19) "2024-11-22 02:54:41"
            [2]=>
            string(2) "<="
          }
          [3]=>
          array(2) {
            [0]=>
            string(3) "SQL"
            [1]=>
            string(55) "(date_end >= '2024-11-22 02:54:41' OR date_end IS NULL)"
          }
          [4]=>
          array(2) {
            [0]=>
            string(6) "enable"
            [1]=>
            int(1)
          }
          [5]=>
          array(2) {
            [0]=>
            string(7) "regions"
            [1]=>
            string(3) "42 "
          }
        }
      }
    }
    [3]=>
    array(6) {
      ["file"]=>
      string(81) "/var/www/sj.finarty.ru/public_html/site/modules/Publication/DefaultController.php"
      ["line"]=>
      int(508)
      ["function"]=>
      string(5) "count"
      ["class"]=>
      string(18) "Som_Model_Abstract"
      ["type"]=>
      string(2) "::"
      ["args"]=>
      array(1) {
        [0]=>
        &array(6) {
          [0]=>
          array(2) {
            [0]=>
            string(4) "lang"
            [1]=>
            string(2) "ru"
          }
          [1]=>
          string(65) "id IN (SELECT pub FROM publication_link_topic WHERE topic IN (2))"
          [2]=>
          array(3) {
            [0]=>
            string(8) "date_add"
            [1]=>
            string(19) "2024-11-22 02:54:41"
            [2]=>
            string(2) "<="
          }
          [3]=>
          array(2) {
            [0]=>
            string(3) "SQL"
            [1]=>
            string(55) "(date_end >= '2024-11-22 02:54:41' OR date_end IS NULL)"
          }
          [4]=>
          array(2) {
            [0]=>
            string(6) "enable"
            [1]=>
            int(1)
          }
          [5]=>
          array(2) {
            [0]=>
            string(7) "regions"
            [1]=>
            string(3) "42 "
          }
        }
      }
    }
    [4]=>
    array(4) {
      ["function"]=>
      string(14) "actionShowList"
      ["class"]=>
      string(29) "Publication_DefaultController"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [5]=>
    array(4) {
      ["file"]=>
      string(76) "/var/www/sj.finarty.ru/public_html/laPuzzle/modules/Pages/PageController.php"
      ["line"]=>
      int(157)
      ["function"]=>
      string(14) "call_user_func"
      ["args"]=>
      array(1) {
        [0]=>
        &array(2) {
          [0]=>
          object(Publication_DefaultController)#91 (12) {
            ["_bootstrap":protected]=>
            NULL
            ["_module":protected]=>
            NULL
            ["blocks"]=>
            object(LaContainer)#87 (2) {
              ["_data":protected]=>
              array(2) {
                ["title"]=>
                string(44) "Новости региональных СЖ"
                ["metaTitle"]=>
                string(91) "Новости региональных СЖ - Союз журналистов России"
              }
              ["_index":protected]=>
              int(0)
            }
            ["layout"]=>
            string(13) "content.phtml"
            ["_cnf":protected]=>
            array(26) {
              ["charset"]=>
              string(5) "utf-8"
              ["siteTitle"]=>
              string(44) "Союз журналистов России"
              ["slow_log"]=>
              bool(true)
              ["route"]=>
              array(2) {
                ["page"]=>
                string(34) "%page%/:module/:controller/:action"
                ["default"]=>
                string(12) "%page%/:args"
              }
              ["site_id"]=>
              string(18) "sdfgkjhsiduskjfgbk"
              ["new_install"]=>
              int(0)
              ["db"]=>
              array(2) {
                ["adapter"]=>
                string(5) "mysql"
                ["params"]=>
                array(8) {
                  ["host"]=>
                  string(9) "127.0.0.1"
                  ["port"]=>
                  string(4) "3306"
                  ["username"]=>
                  string(2) "sj"
                  ["password"]=>
                  string(2) "sj"
                  ["dbname"]=>
                  string(2) "sj"
                  ["charset"]=>
                  string(4) "utf8"
                  ["collate"]=>
                  string(15) "utf8_unicode_ci"
                  ["profiler"]=>
                  bool(false)
                }
              }
              ["path"]=>
              array(10) {
                ["root"]=>
                string(35) "/var/www/sj.finarty.ru/public_html/"
                ["application"]=>
                string(44) "/var/www/sj.finarty.ru/public_html/laPuzzle/"
                ["libs"]=>
                string(49) "/var/www/sj.finarty.ru/public_html/laPuzzle/libs/"
                ["modules"]=>
                string(52) "/var/www/sj.finarty.ru/public_html/laPuzzle/modules/"
                ["models"]=>
                string(51) "/var/www/sj.finarty.ru/public_html/laPuzzle/models/"
                ["system"]=>
                string(51) "/var/www/sj.finarty.ru/public_html/laPuzzle/system/"
                ["themes"]=>
                string(51) "/var/www/sj.finarty.ru/public_html/laPuzzle/themes/"
                ["sitethemes"]=>
                string(47) "/var/www/sj.finarty.ru/public_html/site/themes/"
                ["files"]=>
                string(53) "/var/www/sj.finarty.ru/public_html/site/public/files/"
                ["tmp_img"]=>
                string(55) "/var/www/sj.finarty.ru/public_html/site/public/tmp/img/"
              }
              ["url"]=>
              array(4) {
                ["base"]=>
                string(14) "https://ruj.ru"
                ["public"]=>
                string(27) "https://ruj.ru/site/public/"
                ["files"]=>
                string(33) "https://ruj.ru/site/public/files/"
                ["tmp_img"]=>
                string(35) "https://ruj.ru/site/public/tmp/img/"
              }
              ["cache"]=>
              array(2) {
                ["on"]=>
                bool(false)
                ["memcache"]=>
                array(3) {
                  ["on"]=>
                  bool(true)
                  ["host"]=>
                  string(0) ""
                  ["port"]=>
                  string(0) ""
                }
              }
              ["multihost"]=>
              bool(false)
              ["cpanel"]=>
              string(24) "Cpanel_DefaultController"
              ["mod_list"]=>
              array(37) {
                [0]=>
                string(3) "Acl"
                [1]=>
                string(7) "Sitemap"
                [2]=>
                string(6) "Socket"
                [3]=>
                string(4) "File"
                [4]=>
                string(11) "CKTemplates"
                [5]=>
                string(5) "Pages"
                [6]=>
                string(4) "Test"
                [7]=>
                string(9) "Installer"
                [8]=>
                string(4) "Main"
                [9]=>
                string(6) "Cpanel"
                [10]=>
                string(4) "Lang"
                [11]=>
                string(7) "Captcha"
                [12]=>
                string(10) "ExtraField"
                [13]=>
                string(13) "CodeGenerator"
                [14]=>
                string(3) "GEO"
                [15]=>
                string(4) "Draw"
                [16]=>
                string(4) "User"
                [17]=>
                string(11) "FormCreator"
                [18]=>
                string(7) "Banners"
                [19]=>
                string(8) "Carousel"
                [20]=>
                string(8) "Feedback"
                [21]=>
                string(7) "CEvents"
                [22]=>
                string(5) "Event"
                [23]=>
                string(7) "Gallery"
                [24]=>
                string(9) "Employees"
                [25]=>
                string(7) "Mistake"
                [26]=>
                string(4) "Blog"
                [27]=>
                string(7) "SiteMap"
                [28]=>
                string(15) "UnionJournalist"
                [29]=>
                string(4) "Form"
                [30]=>
                string(8) "Document"
                [31]=>
                string(11) "Publication"
                [32]=>
                string(8) "Partners"
                [33]=>
                string(5) "Video"
                [34]=>
                string(9) "Accordion"
                [35]=>
                string(4) "Menu"
                [36]=>
                string(4) "Poll"
              }
              ["page_mod"]=>
              string(20) "Pages_PageController"
              ["hashsalt"]=>
              string(0) ""
              ["secret_key"]=>
              string(12) "%secret_key%"
              ["cookiepath"]=>
              string(1) "/"
              ["cookiedomain"]=>
              string(6) "ruj.ru"
              ["theme"]=>
              string(8) "lapuzzle"
              ["headrc_consolidate"]=>
              bool(false)
              ["headrc_minify"]=>
              bool(false)
              ["adminemail"]=>
              string(10) "ruj@ruj.ru"
              ["defaulttimezone"]=>
              string(13) "Europe/Moscow"
              ["pdf_service_url"]=>
              string(27) "https://ruj.ru/pdfconverter"
              ["debug"]=>
              array(1) {
                ["on"]=>
                bool(false)
              }
              ["save_log"]=>
              bool(false)
            }
            ["_db":protected]=>
            object(Som_Model_Mapper_Mysql)#2 (5) {
              ["tableQuote"]=>
              string(1) "`"
              ["typesMap":protected]=>
              array(4) {
                ["link"]=>
                array(1) {
                  ["convertor"]=>
                  object(Closure)#4 (2) {
                    ["this"]=>
                    *RECURSION*
                    ["parameter"]=>
                    array(2) {
                      ["$field"]=>
                      string(10) ""
                      ["$value"]=>
                      string(10) ""
                    }
                  }
                }
                ["timestamp without time zone"]=>
                array(1) {
                  ["convertor"]=>
                  object(Closure)#5 (2) {
                    ["this"]=>
                    *RECURSION*
                    ["parameter"]=>
                    array(2) {
                      ["$field"]=>
                      string(10) ""
                      ["$value"]=>
                      string(10) ""
                    }
                  }
                }
                ["bigint"]=>
                array(1) {
                  ["convertor"]=>
                  object(Closure)#6 (2) {
                    ["this"]=>
                    *RECURSION*
                    ["parameter"]=>
                    array(2) {
                      ["$field"]=>
                      string(10) ""
                      ["$value"]=>
                      string(10) ""
                    }
                  }
                }
                ["int"]=>
                array(1) {
                  ["convertor"]=>
                  object(Closure)#7 (2) {
                    ["this"]=>
                    *RECURSION*
                    ["parameter"]=>
                    array(2) {
                      ["$field"]=>
                      string(10) ""
                      ["$value"]=>
                      string(10) ""
                    }
                  }
                }
              }
              ["_dbinfo":protected]=>
              array(0) {
              }
              ["_affected_rows":protected]=>
              int(1)
              ["_adapter":protected]=>
              object(PDO)#3 (0) {
              }
            }
            ["_user":protected]=>
            object(User_Model_User)#43 (13) {
              ["_changedPass":"User_Model_User":private]=>
              bool(false)
              ["_errors"]=>
              array(0) {
              }
              ["_data":protected]=>
              array(22) {
                ["user_id"]=>
                NULL
                ["login"]=>
                NULL
                ["email"]=>
                NULL
                ["name"]=>
                NULL
                ["lastname"]=>
                NULL
                ["middlename"]=>
                NULL
                ["password"]=>
                NULL
                ["passfunc"]=>
                NULL
                ["passsalt"]=>
                NULL
                ["lostpass"]=>
                NULL
                ["ip"]=>
                string(13) "18.217.98.175"
                ["regdate"]=>
                NULL
                ["birthdate"]=>
                NULL
                ["logcount"]=>
                int(0)
                ["lastlog"]=>
                int(0)
                ["lastvisit"]=>
                int(0)
                ["sid"]=>
                string(0) ""
                ["sidtime"]=>
                int(0)
                ["token"]=>
                string(0) ""
                ["banexpire"]=>
                int(0)
                ["timezone"]=>
                string(13) "Europe/Moscow"
                ["gender"]=>
                int(0)
              }
              ["_linkData":protected]=>
              array(0) {
              }
              ["_extraData":protected]=>
              array(0) {
              }
              ["_oldData":protected]=>
              array(1) {
                ["ip"]=>
                NULL
              }
              ["_e":protected]=>
              NULL
              ["showValidateErrors"]=>
              bool(true)
              ["validators":protected]=>
              array(0) {
              }
              ["ignoreValidateFields":protected]=>
              array(0) {
              }
              ["_requiredFields":"Som_Model_Abstract":private]=>
              array(0) {
              }
              ["_m":"Component":private]=>
              NULL
              ["_e":"Component":private]=>
              NULL
            }
            ["_acl":protected]=>
            object(Acl)#86 (12) {
              ["_errors"]=>
              array(0) {
              }
              ["_data":protected]=>
              array(9) {
                ["id"]=>
                NULL
                ["user_group_id"]=>
                int(0)
                ["user_id"]=>
                NULL
                ["aco"]=>
                NULL
                ["description"]=>
                string(0) ""
                ["allow"]=>
                int(0)
                ["created_by"]=>
                NULL
                ["created"]=>
                NULL
                ["module_name"]=>
                string(0) ""
              }
              ["_linkData":protected]=>
              array(0) {
              }
              ["_extraData":protected]=>
              array(0) {
              }
              ["_oldData":protected]=>
              array(0) {
              }
              ["_e":protected]=>
              NULL
              ["showValidateErrors"]=>
              bool(true)
              ["validators":protected]=>
              array(0) {
              }
              ["ignoreValidateFields":protected]=>
              array(0) {
              }
              ["_requiredFields":"Som_Model_Abstract":private]=>
              array(0) {
              }
              ["_m":"Component":private]=>
              NULL
              ["_e":"Component":private]=>
              NULL
            }
            ["_params":protected]=>
            array(5) {
              ["TITLE"]=>
              string(44) "Новости региональных СЖ"
              ["t_2"]=>
              string(1) "1"
              ["template"]=>
              string(15) "listArticle.php"
              ["show_template"]=>
              string(15) "showArticle.php"
              ["items_limit"]=>
              string(0) ""
            }
            ["redirectBack"]=>
            bool(true)
            ["_e":"Component":private]=>
            NULL
            ["_m":"Component":private]=>
            NULL
          }
          [1]=>
          string(14) "actionShowList"
        }
      }
    }
    [6]=>
    array(6) {
      ["file"]=>
      string(76) "/var/www/sj.finarty.ru/public_html/laPuzzle/modules/Pages/PageController.php"
      ["line"]=>
      int(69)
      ["function"]=>
      string(19) "runControllerAction"
      ["class"]=>
      string(20) "Pages_PageController"
      ["type"]=>
      string(2) "::"
      ["args"]=>
      array(1) {
        [0]=>
        &array(8) {
          ["action"]=>
          string(8) "showList"
          ["module"]=>
          string(11) "Publication"
          ["controller"]=>
          string(29) "Publication_DefaultController"
          ["uri"]=>
          string(6) "%page%"
          ["actionParams"]=>
          array(0) {
          }
          ["layout"]=>
          string(13) "content.phtml"
          ["modulesParams"]=>
          array(5) {
            ["TITLE"]=>
            string(44) "Новости региональных СЖ"
            ["t_2"]=>
            string(1) "1"
            ["template"]=>
            string(15) "listArticle.php"
            ["show_template"]=>
            string(15) "showArticle.php"
            ["items_limit"]=>
            string(0) ""
          }
          ["blocks"]=>
          array(2) {
            ["title"]=>
            string(44) "Новости региональных СЖ"
            ["metaTitle"]=>
            string(91) "Новости региональных СЖ - Союз журналистов России"
          }
        }
      }
    }
    [7]=>
    array(6) {
      ["file"]=>
      string(61) "/var/www/sj.finarty.ru/public_html/laPuzzle/system/Kernel.php"
      ["line"]=>
      int(730)
      ["function"]=>
      string(6) "render"
      ["class"]=>
      string(20) "Pages_PageController"
      ["type"]=>
      string(2) "::"
      ["args"]=>
      array(1) {
        [0]=>
        object(Pages_Model_Page)#24 (13) {
          ["_translatedData":"Lang_Decorator_Model":private]=>
          array(2) {
            ["name"]=>
            string(44) "Новости региональных СЖ"
            ["enable"]=>
            string(1) "1"
          }
          ["_errors"]=>
          array(0) {
          }
          ["_data":protected]=>
          array(10) {
            ["id"]=>
            string(3) "277"
            ["name"]=>
            string(44) "Новости региональных СЖ"
            ["url"]=>
            string(12) "regions-news"
            ["sort"]=>
            string(1) "1"
            ["template"]=>
            string(13) "content.phtml"
            ["enable"]=>
            string(1) "1"
            ["parent"]=>
            string(2) "98"
            ["param"]=>
            string(0) ""
            ["show_menu"]=>
            string(1) "1"
            ["date_update"]=>
            string(19) "2018-12-21 16:16:16"
          }
          ["_linkData":protected]=>
          array(0) {
          }
          ["_extraData":protected]=>
          array(1) {
            ["action"]=>
            array(5) {
              ["action"]=>
              string(8) "showList"
              ["module"]=>
              string(11) "Publication"
              ["controller"]=>
              string(29) "Publication_DefaultController"
              ["uri"]=>
              string(6) "%page%"
              ["actionParams"]=>
              array(0) {
              }
            }
          }
          ["_oldData":protected]=>
          array(0) {
          }
          ["_e":protected]=>
          NULL
          ["showValidateErrors"]=>
          bool(true)
          ["validators":protected]=>
          array(0) {
          }
          ["ignoreValidateFields":protected]=>
          array(0) {
          }
          ["_requiredFields":"Som_Model_Abstract":private]=>
          array(0) {
          }
          ["_m":"Component":private]=>
          NULL
          ["_e":"Component":private]=>
          NULL
        }
      }
    }
    [8]=>
    array(6) {
      ["file"]=>
      string(44) "/var/www/sj.finarty.ru/public_html/index.php"
      ["line"]=>
      int(102)
      ["function"]=>
      string(3) "run"
      ["class"]=>
      string(6) "Kernel"
      ["type"]=>
      string(2) "::"
      ["args"]=>
      array(0) {
      }
    }
  }
  ["previous":"Exception":private]=>
  NULL
  ["errorInfo"]=>
  array(3) {
    [0]=>
    string(5) "42000"
    [1]=>
    int(1064)
    [2]=>
    string(150) "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 '))' at line 3"
  }
}