exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.hot_id' in 'where clause'' in /www/hory.cz/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /www/hory.cz/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /www/hory.cz/lib/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /www/hory.cz/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT h.`pre_i...', Array) #4 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query('SELECT h.`pre_i...', Array) #5 /www/hory.cz/app/models/BaseModel.php(85): Zend_Db_Adapter_Abstract->fetchAll('SELECT h.`pre_i...', Array) #6 /www/hory.cz/app/models/Abstract/Getter.php(475): BaseModel->fetchAllCached('SELECT h.`pre_i...', Array, '78c0aa7c53aaafd...', Array) #7 /www/hory.cz/app/controllers/horycz/AccommodationController.php(178): Abstract_Getter->getData() #8 /www/hory.cz/lib/Zend/Controller/Action.php(516): Horycz_AccommodationController->resortAction() #9 /www/hory.cz/lib/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('resortAction') #10 /www/hory.cz/lib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #11 /www/hory.cz/lib/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch() #12 /www/hory.cz/lib/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #13 /www/hory.cz/www/index.php(45): Zend_Application->run() #14 {main} Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.hot_id' in 'where clause', query was: SELECT h.`pre_id`, h.`hot_id`, h.`hot_name`, h.`hot_street`, h.`hot_gpsLatitude`, h.`hot_gpsLongitude`, h.`hot_class`, h.`hot_classConfirmed`, h.`hot_hotelCzTip`, h.`hot_customerTip`, h.`hoy_id`, h.`hot_clientPayment`, h.`hot_onlyWeeks`, h.`hot_partnerCatalog`, h.`hot_importedPartner`, h.`cur_id_default`, h.`cot_id`, h.`reg_id`, h.`hot_arrival`, h.`hot_departure`, h.`hot_email`, h.`hot_phone`, h.`hot_seoName`, h.`hot_onlineReservation`, h.`hot_deactivate`, h.`hot_url`, h.`hot_commission`, h.`hot_adminDescription`, h.`hot_ownerEmail`, h.`hot_capacity`, h.`hot_lastChangeOther`, ROUND(h.`hot_cityCenterDistance`, 1) as hot_cityCenterDistance, ROUND(h.`hot_skiDistance`, 1) as hot_skiDistance, ROUND(h.`hot_swimDistance`, 1) as hot_swimDistance, ROUND(h.`hot_airDistance`, 1) as hot_airDistance, hp.`hpr_recommended` as projectRecommended, mresort.rst_id, mresort.name as rst_name, mresort.seo_name as rst_seoname, gcache.gps_distance, m.seo_name as mnt_seoname, m.name as mnt_name, IF(translationa6.`tra_translation` IS NULL, translationa6En.`tra_translation`, translationa6.`tra_translation`) AS shortDescription, IF(translationa6.`tra_translation` IS NULL, 0, 1) AS shortDescriptionTranslated, IF(translationa7.`tra_translation` IS NULL, translationa7En.`tra_translation`, translationa7.`tra_translation`) AS longDescription, IF(translationa7.`tra_translation` IS NULL, 0, 1) AS longDescriptionTranslated, (SELECT (SUM(acp.`acc_price` * DATEDIFF(LEAST(s.sea_to, :departure), GREATEST(s.sea_from, :arrival))) * IF(rates.rat_rate IS NULL, 1, rates.rat_rate)) AS sum FROM `Season` s LEFT JOIN `Hotel` hot ON s.pre_id = hot.pre_id AND s.hot_id = hot.hot_id LEFT JOIN `Rates` rates ON rates.cur_id = hot.`cur_id_default` LEFT JOIN `AccommodationPrice` acp ON s.`pri_id` = acp.`pri_id` AND acp.`obk_id` = (SELECT o.`obk_id` FROM `ObjectKind` o LEFT JOIN `Hotel` hotel ON o.`pre_id` = hotel.`pre_id` AND o.`hot_id` = hotel.`hot_id` LEFT JOIN `Season` season ON season.`pre_id` = hotel.`pre_id` AND season.`hot_id` = hotel.`hot_id` AND CURDATE() BETWEEN season.`sea_from` AND season.`sea_to` LEFT JOIN `AccommodationPrice` ap ON season.`pri_id` = ap.`pri_id` AND ap.`cur_id` = hotel.`cur_id_default` AND IF(1 = hotel.`prm_id`, ap.`acc_occupancy` = o.`obk_numOfBeds`, ap.`acc_occupancy` = 1) AND ap.obk_id = o.obk_id WHERE o.`hot_id` = h.`hot_id` AND o.`pre_id` = h.`pre_id` AND o.`obk_numOfBeds` > 1 AND IF(1 = hotel.`prm_id`, ap.`acc_occupancy` = o.obk_numOfBeds, ap.`acc_occupancy` = 1) -- AND ap.`acc_price` <> 0 ORDER BY o.obk_numOfBeds ASC, ap.`acc_price` ASC LIMIT 0,1) AND IF(1 = hot.`prm_id`, acp.`acc_occupancy` = 2, acp.`acc_occupancy` = 1) WHERE s.`hot_id` = h.`hot_id` AND s.pre_id = h.`pre_id` AND acp.`cur_id` = h.`cur_id_default` AND ((:arrival BETWEEN s.sea_from AND s.sea_to) OR (:departure BETWEEN s.sea_from AND s.sea_to) OR ((s.sea_from BETWEEN :arrival AND :departure) AND (s.sea_to BETWEEN :arrival AND :departure))) AND IF (s.sea_from < :arrival, s.sea_to > :arrival, TRUE) AND s.sea_from < :departure GROUP BY acp.pri_id LIMIT 0,1) as basePrice, t.`tow_id`, t.`tow_seo`, county.`cot_name`, county.`cot_seo`, locality.`lct_name`, locality.`lct_seo`, locality.`lct_id`, IF(tr.`tra_translation` IS NULL, reg.`reg_name`, tr.`tra_translation`) AS reg_name, IF(trtown.`tra_translation` IS NULL, t.`tow_name`, trtown.`tra_translation`) AS tow_name, IF(tr.`tra_seo` IS NULL, reg.`reg_seo`, tr.`tra_seo`) AS reg_seo, z.`zip_office` AS hot_city, z.`zip_zip` AS hot_zip, zig.`zig_name` FROM `Hotel` h INNER JOIN Hotel_Project hp ON hp.pre_id = h.pre_id AND hp.hot_id = h.hot_id AND hp.pro_id = :proId JOIN GpsCache gcache ON gcache.pre_id = h.pre_id AND gcache.hot_id = h.hot_id AND gcache.gps_distance <= :mountainDistance AND gcache.gct_id = 4 AND gcache.gps_objectId = :rst_id JOIN MountainHotelPair p ON gcache.pre_id = p.pre_id AND gcache.hot_id = p.hot_id JOIN MountainResort mresort ON p.pre_id = mresort.pre_id AND p.rst_id = mresort.rst_id JOIN Mountain m ON m.pre_id = mresort.pre_id AND m.mnt_id = mresort.mnt_id LEFT JOIN TranslationApproval translationa6 ON h.`hot_id` = translationa6.`tra_rowid` AND translationa6.pre_id = h.pre_id AND translationa6.`tco_id` = 6 AND translationa6.`lan_id` = :lanId AND translationa6.`pro_id` = 1 LEFT JOIN TranslationApproval translationa6En ON h.`hot_id` = translationa6En.`tra_rowid` AND translationa6En.pre_id = h.pre_id AND translationa6En.`tco_id` = 6 AND translationa6En.`lan_id` = 2 AND translationa6En.`pro_id` = 1 LEFT JOIN TranslationApproval translationa7 ON h.`hot_id` = translationa7.`tra_rowid` AND translationa7.pre_id = h.pre_id AND translationa7.`tco_id` = 7 AND translationa7.`lan_id` = :lanId AND translationa7.`pro_id` = 1 LEFT JOIN TranslationApproval translationa7En ON h.`hot_id` = translationa7En.`tra_rowid` AND translationa7En.pre_id = h.pre_id AND translationa7En.`tco_id` = 7 AND translationa7En.`lan_id` = 2 AND translationa7En.`pro_id` = 1 LEFT JOIN Town t ON h.pre_id = t.pre_id AND h.tow_id = t.tow_id LEFT JOIN County county ON h.cot_id = county.cot_id AND h.pre_id = county.pre_id LEFT JOIN Locality locality ON h.lct_id = locality.lct_id AND h.pre_id = locality.pre_id LEFT JOIN Region reg ON h.pre_id = reg.pre_id AND h.reg_id = reg.reg_id LEFT JOIN Zip z ON h.pre_id = z.pre_id AND h.zip_id = z.zip_id LEFT JOIN ZipGroup_Zip zgz ON z.pre_id = zgz.pre_id AND h.zip_id = zgz.zip_id LEFT JOIN ZipGroup zig ON zgz.pre_id = zig.pre_id AND zgz.zig_id = zig.zig_id LEFT JOIN Translation tr ON tr.`tra_rowid` = h.`reg_id` AND tr.pre_id = h.pre_id AND tr.`tco_id` = '1' AND tr.`lan_id` = :lanId AND tr.`pro_id` = 1 LEFT JOIN Translation trtown ON trtown.`tra_rowid` = h.`tow_id` AND trtown.pre_id = h.pre_id AND trtown.`tco_id` = '23' AND trtown.`lan_id` = :lanId AND trtown.`pro_id` = 1 WHERE h.`pre_id` = :preId AND h.`hot_seoName` <> '' AND h.`hot_seoName` <> 'test' AND h.`zip_id` > 0 AND h.`hot_active` = 1 GROUP BY h.pre_id, h.hot_id ORDER BY gcache.gps_distance ASC ' in /www/hory.cz/lib/Zend/Db/Statement/Pdo.php:235 Stack trace: #0 /www/hory.cz/lib/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /www/hory.cz/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT h.`pre_i...', Array) #3 /www/hory.cz/lib/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query('SELECT h.`pre_i...', Array) #4 /www/hory.cz/app/models/BaseModel.php(85): Zend_Db_Adapter_Abstract->fetchAll('SELECT h.`pre_i...', Array) #5 /www/hory.cz/app/models/Abstract/Getter.php(475): BaseModel->fetchAllCached('SELECT h.`pre_i...', Array, '78c0aa7c53aaafd...', Array) #6 /www/hory.cz/app/controllers/horycz/AccommodationController.php(178): Abstract_Getter->getData() #7 /www/hory.cz/lib/Zend/Controller/Action.php(516): Horycz_AccommodationController->resortAction() #8 /www/hory.cz/lib/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('resortAction') #9 /www/hory.cz/lib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #10 /www/hory.cz/lib/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch() #11 /www/hory.cz/lib/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #12 /www/hory.cz/www/index.php(45): Zend_Application->run() #13 {main} link: http://hory.cz/ubytovani/jeseniky/ostruzna/ ip: 34.238.189.240