object(Zend_Db_Statement_Mysqli_Exception)#483 (7) { ["message":protected]=> string(67) "Mysqli prepare error: Unknown column 'e.products' in 'where clause'" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1054) ["file":protected]=> string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php" ["line":protected]=> int(77) ["trace":"Exception":private]=> array(19) { [0]=> array(6) { ["file"]=> string(36) "/usr/share/php/Zend/Db/Statement.php" ["line"]=> int(115) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(472) "SELECT c.*,count(DISTINCT ec.escort_id) as count, c.title_it as current_lang_title FROM cities c inner join escorts_in_cities ec ON ec.city_id = c.id INNER JOIN escorts as e On e.id = ec.escort_id WHERE FIND_IN_SET(21, e.products) > 0 AND e.gender = 1 AND c.id IN(393,1223) AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 GROUP BY ec.city_id ORDER BY count desc " } } [1]=> array(6) { ["file"]=> string(41) "/usr/share/php/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(381) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Cubix_Db_Adapter_Mysqli)#246 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#484 (12) { ["_keys":protected]=> array(1) { [0]=> string(8) "COUNT(*)" } ["_values":protected]=> array(1) { [0]=> int(166) } ["_meta":protected]=> object(mysqli_result)#485 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(1) } ["_stmt":protected]=> NULL ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(30) "SELECT COUNT(*) FROM countries" } ["_sqlParam":protected]=> array(1) { [0]=> string(30) "SELECT COUNT(*) FROM countries" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(9) { ["charset"]=> string(4) "utf8" ["host"]=> string(6) "galera" ["port"]=> string(5) "13306" ["password"]=> string(6) "654321" ["username"]=> string(14) "ed_cubix_front" ["dbname"]=> string(23) "escortdirectory_com_www" ["persistent"]=> bool(false) ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#247 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#249 (19) { ["affected_rows"]=> int(-1) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(1054) ["error"]=> string(45) "Unknown column 'e.products' in 'where clause'" ["error_list"]=> array(1) { [0]=> array(3) { ["errno"]=> int(1054) ["sqlstate"]=> string(5) "42S22" ["error"]=> string(45) "Unknown column 'e.products' in 'where clause'" } } ["field_count"]=> int(1) ["host_info"]=> string(17) "galera via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(21) "5.5.5-10.3.39-MariaDB" ["server_version"]=> int(100339) ["stat"]=> string(156) "Uptime: 17611887 Threads: 54 Questions: 14564402944 Slow queries: 780 Opens: 436516 Flush tables: 1 Open tables: 1087 Queries per second avg: 826.964" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(40503109) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } [1]=> string(472) "SELECT c.*,count(DISTINCT ec.escort_id) as count, c.title_it as current_lang_title FROM cities c inner join escorts_in_cities ec ON ec.city_id = c.id INNER JOIN escorts as e On e.id = ec.escort_id WHERE FIND_IN_SET(21, e.products) > 0 AND e.gender = 1 AND c.id IN(393,1223) AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 GROUP BY ec.city_id ORDER BY count desc " } } [2]=> array(6) { ["file"]=> string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php" ["line"]=> int(38) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(472) "SELECT c.*,count(DISTINCT ec.escort_id) as count, c.title_it as current_lang_title FROM cities c inner join escorts_in_cities ec ON ec.city_id = c.id INNER JOIN escorts as e On e.id = ec.escort_id WHERE FIND_IN_SET(21, e.products) > 0 AND e.gender = 1 AND c.id IN(393,1223) AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 GROUP BY ec.city_id ORDER BY count desc " } } [3]=> array(6) { ["file"]=> string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php" ["line"]=> int(706) ["function"]=> string(5) "query" ["class"]=> string(23) "Cubix_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(472) "SELECT c.*,count(DISTINCT ec.escort_id) as count, c.title_it as current_lang_title FROM cities c inner join escorts_in_cities ec ON ec.city_id = c.id INNER JOIN escorts as e On e.id = ec.escort_id WHERE FIND_IN_SET(21, e.products) > 0 AND e.gender = 1 AND c.id IN(393,1223) AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 GROUP BY ec.city_id ORDER BY count desc " [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(66) "/var/www/www.escortdirectory.com/application/models/Statistics.php" ["line"]=> int(1007) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(472) "SELECT c.*,count(DISTINCT ec.escort_id) as count, c.title_it as current_lang_title FROM cities c inner join escorts_in_cities ec ON ec.city_id = c.id INNER JOIN escorts as e On e.id = ec.escort_id WHERE FIND_IN_SET(21, e.products) > 0 AND e.gender = 1 AND c.id IN(393,1223) AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 GROUP BY ec.city_id ORDER BY count desc " } } [5]=> array(6) { ["file"]=> string(76) "/var/www/www.escortdirectory.com/application/views/scripts/error/error.phtml" ["line"]=> int(91) ["function"]=> string(14) "getCitiesbyIds" ["class"]=> string(16) "Model_Statistics" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(8) "393,1223" } } [6]=> array(4) { ["file"]=> string(28) "/usr/share/php/Zend/View.php" ["line"]=> int(108) ["args"]=> array(1) { [0]=> string(76) "/var/www/www.escortdirectory.com/application/views/scripts/error/error.phtml" } ["function"]=> string(7) "include" } [7]=> array(6) { ["file"]=> string(37) "/usr/share/php/Zend/View/Abstract.php" ["line"]=> int(880) ["function"]=> string(4) "_run" ["class"]=> string(9) "Zend_View" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(76) "/var/www/www.escortdirectory.com/application/views/scripts/error/error.phtml" } } [8]=> array(6) { ["file"]=> string(61) "/usr/share/php/Zend/Controller/Action/Helper/ViewRenderer.php" ["line"]=> int(897) ["function"]=> string(6) "render" ["class"]=> string(18) "Zend_View_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> NULL } } [9]=> array(6) { ["file"]=> string(61) "/usr/share/php/Zend/Controller/Action/Helper/ViewRenderer.php" ["line"]=> int(918) ["function"]=> string(12) "renderScript" ["class"]=> string(42) "Zend_Controller_Action_Helper_ViewRenderer" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(17) "error/error.phtml" [1]=> NULL } } [10]=> array(6) { ["file"]=> string(61) "/usr/share/php/Zend/Controller/Action/Helper/ViewRenderer.php" ["line"]=> int(957) ["function"]=> string(6) "render" ["class"]=> string(42) "Zend_Controller_Action_Helper_ViewRenderer" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [11]=> array(6) { ["file"]=> string(54) "/usr/share/php/Zend/Controller/Action/HelperBroker.php" ["line"]=> int(277) ["function"]=> string(12) "postDispatch" ["class"]=> string(42) "Zend_Controller_Action_Helper_ViewRenderer" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [12]=> array(6) { ["file"]=> string(41) "/usr/share/php/Zend/Controller/Action.php" ["line"]=> int(523) ["function"]=> string(18) "notifyPostDispatch" ["class"]=> string(35) "Zend_Controller_Action_HelperBroker" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [13]=> array(6) { ["file"]=> string(54) "/usr/share/php/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(289) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(11) "errorAction" } } [14]=> array(6) { ["file"]=> string(40) "/usr/share/php/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#317 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(162) "/escorts-dubai-145?tag=11%2Fde%2F%2F%2Fes%2F%2Fit%2F%2Fit%2F%2Fit%2F%2F%2Fes%2F%2F%2Ffr%2F%2Ffr%2F%2F%2Fes%2F%2F%2Fde%2F%2Ffr%2F%2F%2F%2Fde%2F%2F%2Ffr%2F%2Fde%2F/" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(17) "escorts-dubai-145" ["_params":protected]=> array(10) { ["p_top_category"]=> string(7) "escorts" [2]=> string(10) "-dubai-145" ["p_city_slug"]=> string(5) "dubai" ["p_city_id"]=> string(3) "145" ["module"]=> string(7) "default" ["controller"]=> string(7) "escorts" ["action"]=> string(5) "index" ["lang_id"]=> string(2) "it" ["chatVersion"]=> int(2) ["error_handler"]=> object(ArrayObject)#473 (1) { ["storage":"ArrayObject":private]=> array(3) { ["exception"]=> object(Zend_Db_Statement_Mysqli_Exception)#500 (7) { ["message":protected]=> string(69) "Mysqli prepare error: Unknown column 'e.package_id' in 'where clause'" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1054) ["file":protected]=> string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php" ["line":protected]=> int(77) ["trace":"Exception":private]=> array(13) { [0]=> array(6) { ["file"]=> string(36) "/usr/share/php/Zend/Db/Statement.php" ["line"]=> int(115) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [1]=> array(6) { ["file"]=> string(41) "/usr/share/php/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(381) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Cubix_Db_Adapter_Mysqli)#246 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#484 (12) { ["_keys":protected]=> array(1) { [0]=> string(8) "COUNT(*)" } ["_values":protected]=> array(1) { [0]=> int(166) } ["_meta":protected]=> object(mysqli_result)#485 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(1) } ["_stmt":protected]=> NULL ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(30) "SELECT COUNT(*) FROM countries" } ["_sqlParam":protected]=> array(1) { [0]=> string(30) "SELECT COUNT(*) FROM countries" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(9) { ["charset"]=> string(4) "utf8" ["host"]=> string(6) "galera" ["port"]=> string(5) "13306" ["password"]=> string(6) "654321" ["username"]=> string(14) "ed_cubix_front" ["dbname"]=> string(23) "escortdirectory_com_www" ["persistent"]=> bool(false) ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#247 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#249 (19) { ["affected_rows"]=> int(-1) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(1) ["host_info"]=> string(17) "galera via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(21) "5.5.5-10.3.39-MariaDB" ["server_version"]=> int(100339) ["stat"]=> string(156) "Uptime: 17611887 Threads: 54 Questions: 14564402944 Slow queries: 780 Opens: 436516 Flush tables: 1 Open tables: 1087 Queries per second avg: 826.964" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(40503109) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } [1]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [2]=> array(6) { ["file"]=> string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php" ["line"]=> int(38) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [3]=> array(6) { ["file"]=> string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php" ["line"]=> int(706) ["function"]=> string(5) "query" ["class"]=> string(23) "Cubix_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(67) "/var/www/www.escortdirectory.com/application/models/Escort/List.php" ["line"]=> int(3059) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [5]=> array(6) { ["file"]=> string(78) "/var/www/www.escortdirectory.com/application/controllers/EscortsController.php" ["line"]=> int(604) ["function"]=> string(26) "getEscortsByCountryAndCity" ["class"]=> string(17) "Model_Escort_List" ["type"]=> string(2) "::" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(41) "/usr/share/php/Zend/Controller/Action.php" ["line"]=> int(513) ["function"]=> string(11) "indexAction" ["class"]=> string(17) "EscortsController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(54) "/usr/share/php/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(289) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(11) "indexAction" } } [8]=> array(6) { ["file"]=> string(40) "/usr/share/php/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> *RECURSION* [1]=> object(Zend_Controller_Response_Http)#318 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(2) { [0]=> *RECURSION* [1]=> *RECURSION* } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [9]=> array(6) { ["file"]=> string(55) "/usr/share/php/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [10]=> array(6) { ["file"]=> string(58) "/var/www/www.escortdirectory.com/application/Bootstrap.php" ["line"]=> int(30) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [11]=> array(6) { ["file"]=> string(35) "/usr/share/php/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(9) "Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [12]=> array(6) { ["file"]=> string(49) "/var/www/www.escortdirectory.com/public/index.php" ["line"]=> int(393) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL } ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#320 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(162) "/escorts-dubai-145?tag=11%2Fde%2F%2F%2Fes%2F%2Fit%2F%2Fit%2F%2Fit%2F%2F%2Fes%2F%2F%2Ffr%2F%2Ffr%2F%2F%2Fes%2F%2F%2Fde%2F%2Ffr%2F%2F%2F%2Fde%2F%2F%2Ffr%2F%2Fde%2F/" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(17) "escorts-dubai-145" ["_params":protected]=> array(9) { ["p_top_category"]=> string(7) "escorts" [2]=> string(10) "-dubai-145" ["p_city_slug"]=> string(5) "dubai" ["p_city_id"]=> string(3) "145" ["module"]=> string(7) "default" ["controller"]=> string(7) "escorts" ["action"]=> string(5) "index" ["lang_id"]=> string(2) "it" ["chatVersion"]=> int(2) } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(7) "escorts" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "index" ["_actionKey":protected]=> string(6) "action" } } } } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "error" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "error" ["_actionKey":protected]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#318 (8) { ["_body":protected]=> array(0) { } ["_exceptions":protected]=> array(2) { [0]=> object(Zend_Db_Statement_Mysqli_Exception)#500 (7) { ["message":protected]=> string(69) "Mysqli prepare error: Unknown column 'e.package_id' in 'where clause'" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1054) ["file":protected]=> string(43) "/usr/share/php/Zend/Db/Statement/Mysqli.php" ["line":protected]=> int(77) ["trace":"Exception":private]=> array(13) { [0]=> array(6) { ["file"]=> string(36) "/usr/share/php/Zend/Db/Statement.php" ["line"]=> int(115) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [1]=> array(6) { ["file"]=> string(41) "/usr/share/php/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(381) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Cubix_Db_Adapter_Mysqli)#246 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#484 (12) { ["_keys":protected]=> array(1) { [0]=> string(8) "COUNT(*)" } ["_values":protected]=> array(1) { [0]=> int(166) } ["_meta":protected]=> object(mysqli_result)#485 (5) { ["current_field"]=> int(0) ["field_count"]=> int(1) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(1) } ["_stmt":protected]=> NULL ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(30) "SELECT COUNT(*) FROM countries" } ["_sqlParam":protected]=> array(1) { [0]=> string(30) "SELECT COUNT(*) FROM countries" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(9) { ["charset"]=> string(4) "utf8" ["host"]=> string(6) "galera" ["port"]=> string(5) "13306" ["password"]=> string(6) "654321" ["username"]=> string(14) "ed_cubix_front" ["dbname"]=> string(23) "escortdirectory_com_www" ["persistent"]=> bool(false) ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#247 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#249 (19) { ["affected_rows"]=> int(-1) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(1) ["host_info"]=> string(17) "galera via TCP/IP" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(21) "5.5.5-10.3.39-MariaDB" ["server_version"]=> int(100339) ["stat"]=> string(156) "Uptime: 17611887 Threads: 54 Questions: 14564402944 Slow queries: 780 Opens: 436516 Flush tables: 1 Open tables: 1085 Queries per second avg: 826.964" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(40503109) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } [1]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [2]=> array(6) { ["file"]=> string(44) "/var/www/library/Cubix/Db/Adapter/Mysqli.php" ["line"]=> int(38) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [3]=> array(6) { ["file"]=> string(43) "/usr/share/php/Zend/Db/Adapter/Abstract.php" ["line"]=> int(706) ["function"]=> string(5) "query" ["class"]=> string(23) "Cubix_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(67) "/var/www/www.escortdirectory.com/application/models/Escort/List.php" ["line"]=> int(3059) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(1265) "SELECT SQL_CALC_FOUND_ROWS eic.country_id AS id, co.title_en as title, count( eic.escort_id ) as `count` FROM escorts_in_cities eic FORCE INDEX ( for_selbyids_query ) INNER JOIN escorts e ON e.id = eic.escort_id INNER JOIN countries co On co.id = eic.country_id INNER JOIN cities c ON c.id = eic.city_id WHERE eic.gender = 1 AND eic.participate_in_listing = 1 AND eic.is_base = 1 AND FIND_IN_SET(68, e.blacklisted_countries_1) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_2) = 0 AND FIND_IN_SET(68, e.blacklisted_countries_3) = 0 AND ( ( e.agency_id IS NOT NULL AND e.package_id NOT IN ( 102, 125 ) ) OR e.agency_id IS NULL ) GROUP BY eic.country_id ORDER BY title ASC" } } [5]=> array(6) { ["file"]=> string(78) "/var/www/www.escortdirectory.com/application/controllers/EscortsController.php" ["line"]=> int(604) ["function"]=> string(26) "getEscortsByCountryAndCity" ["class"]=> string(17) "Model_Escort_List" ["type"]=> string(2) "::" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(41) "/usr/share/php/Zend/Controller/Action.php" ["line"]=> int(513) ["function"]=> string(11) "indexAction" ["class"]=> string(17) "EscortsController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(54) "/usr/share/php/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(289) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(11) "indexAction" } } [8]=> array(6) { ["file"]=> string(40) "/usr/share/php/Zend/Controller/Front.php" ["line"]=> int(954) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#317 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(162) "/escorts-dubai-145?tag=11%2Fde%2F%2F%2Fes%2F%2Fit%2F%2Fit%2F%2Fit%2F%2F%2Fes%2F%2F%2Ffr%2F%2Ffr%2F%2F%2Fes%2F%2F%2Fde%2F%2Ffr%2F%2F%2F%2Fde%2F%2F%2Ffr%2F%2Fde%2F/" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(17) "escorts-dubai-145" ["_params":protected]=> array(10) { ["p_top_category"]=> string(7) "escorts" [2]=> string(10) "-dubai-145" ["p_city_slug"]=> string(5) "dubai" ["p_city_id"]=> string(3) "145" ["module"]=> string(7) "default" ["controller"]=> string(7) "escorts" ["action"]=> string(5) "index" ["lang_id"]=> string(2) "it" ["chatVersion"]=> int(2) ["error_handler"]=> object(ArrayObject)#473 (1) { ["storage":"ArrayObject":private]=> array(3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#320 (15) { ["_paramSources":protected]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri":protected]=> string(162) "/escorts-dubai-145?tag=11%2Fde%2F%2F%2Fes%2F%2Fit%2F%2Fit%2F%2Fit%2F%2F%2Fes%2F%2F%2Ffr%2F%2Ffr%2F%2F%2Fes%2F%2F%2Fde%2F%2Ffr%2F%2F%2F%2Fde%2F%2F%2Ffr%2F%2Fde%2F/" ["_baseUrl":protected]=> string(0) "" ["_basePath":protected]=> NULL ["_pathInfo":protected]=> string(17) "escorts-dubai-145" ["_params":protected]=> array(9) { ["p_top_category"]=> string(7) "escorts" [2]=> string(10) "-dubai-145" ["p_city_slug"]=> string(5) "dubai" ["p_city_id"]=> string(3) "145" ["module"]=> string(7) "default" ["controller"]=> string(7) "escorts" ["action"]=> string(5) "index" ["lang_id"]=> string(2) "it" ["chatVersion"]=> int(2) } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(7) "escorts" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "index" ["_actionKey":protected]=> string(6) "action" } } } } ["_rawBody":protected]=> NULL ["_aliases":protected]=> array(0) { } ["_dispatched":protected]=> bool(true) ["_module":protected]=> string(7) "default" ["_moduleKey":protected]=> string(6) "module" ["_controller":protected]=> string(5) "error" ["_controllerKey":protected]=> string(10) "controller" ["_action":protected]=> string(5) "error" ["_actionKey":protected]=> string(6) "action" } [1]=> *RECURSION* } } [9]=> array(6) { ["file"]=> string(55) "/usr/share/php/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [10]=> array(6) { ["file"]=> string(58) "/var/www/www.escortdirectory.com/application/Bootstrap.php" ["line"]=> int(30) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [11]=> array(6) { ["file"]=> string(35) "/usr/share/php/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(9) "Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [12]=> array(6) { ["file"]=> string(49) "/var/www/www.escortdirectory.com/public/index.php" ["line"]=> int(393) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL } [1]=> *RECURSION* } ["_headers":protected]=> array(0) { } ["_headersRaw":protected]=> array(0) { } ["_httpResponseCode":protected]=> int(200) ["_isRedirect":protected]=> bool(false) ["_renderExceptions":protected]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [15]=> array(6) { ["file"]=> string(55) "/usr/share/php/Zend/Application/Bootstrap/Bootstrap.php" ["line"]=> int(97) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [16]=> array(6) { ["file"]=> string(58) "/var/www/www.escortdirectory.com/application/Bootstrap.php" ["line"]=> int(30) ["function"]=> string(3) "run" ["class"]=> string(36) "Zend_Application_Bootstrap_Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [17]=> array(6) { ["file"]=> string(35) "/usr/share/php/Zend/Application.php" ["line"]=> int(366) ["function"]=> string(3) "run" ["class"]=> string(9) "Bootstrap" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [18]=> array(6) { ["file"]=> string(49) "/var/www/www.escortdirectory.com/public/index.php" ["line"]=> int(393) ["function"]=> string(3) "run" ["class"]=> string(16) "Zend_Application" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL } Unexpected error!