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/GetHotel.php(2448): BaseModel->fetchAllCached('SELECT h.`pre_i...', Array, 'Model_GetHotel_...', Array) #7 /www/hory.cz/app/controllers/horycz/HotelController.php(50): Model_GetHotel->getData() #8 /www/hory.cz/lib/Zend/Controller/Action.php(133): Horycz_HotelController->init() #9 /www/hory.cz/lib/Zend/Controller/Dispatcher/Standard.php(281): Zend_Controller_Action->__construct(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http), Array) #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`, hp.`hpr_recommended` as projectRecommended, (SELECT SUM(acp.`acc_price` * DATEDIFF(LEAST(s.sea_to, :departure), GREATEST(s.sea_from, :arrival))) AS sum FROM `Season` s 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` = 2 AND ap.`acc_price` <> 0 ORDER BY ap.`acc_price` ASC LIMIT 0,1) AND acp.`acc_occupancy` = 2 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) as baseDoubleRoom, 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`, 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, h.`hot_city`, z.`zip_zip` AS hot_zip, short.`tra_translation` AS hot_shortDescription, short.`tra_protected` AS hot_shortDescription_protected, longd.`tra_translation` AS hot_longDescription, short.`tra_protected` AS hot_longDescription_protected, cond.`tra_translation` AS hot_conditions, previoshort.`tra_translation` AS previo_hot_shortDescription, previolongd.`tra_translation` AS previo_hot_longDescription, projectshort.`tra_translation` AS project_hot_shortDescription, projectlongd.`tra_translation` AS project_hot_longDescription, transport.`tra_translation` AS hot_transportAccessibility, surroundings.`tra_translation` AS hot_surroundings, roomsDescription.`tra_translation` AS hot_roomsDescription, gastronomy.`tra_translation` AS hot_gastronomy, additionalInfo.`tra_translation` AS hot_additionalInfo, transport_project.`tra_translation` AS project_hot_transportAccessibility, surroundings_project.`tra_translation` AS project_hot_surroundings, roomsDescription_project.`tra_translation` AS project_hot_roomsDescription, gastronomy_project.`tra_translation` AS project_hot_gastronomy, additionalInfo_project.`tra_translation` AS project_hot_additionalInfo, transport_previo.`tra_translation` AS previo_hot_transportAccessibility, surroundings_previo.`tra_translation` AS previo_hot_surroundings, roomsDescription_previo.`tra_translation` AS previo_hot_roomsDescription, gastronomy_previo.`tra_translation` AS previo_hot_gastronomy, additionalInfo_previo.`tra_translation` AS previo_hot_additionalInfo, paf.`pfm_id` as hasFirstMinute, paf.`pfm_distance`, paf.`pfm_discountRate`, pal.`plm_id` as hasLastMinute, pal.`plm_distance`, pal.`plm_discountRate`, pat.`pal_id` as hasLongTerm, pat.`pal_count`, pat.`pal_discountRate`, r.`rat_guestReviews`, ROUND( ((SUM(reviewCount.`rev_staffReview`) + SUM(reviewCount.`rev_servicesReview`) + SUM(reviewCount.`rev_cleanReview`) + SUM(reviewCount.`rev_comfortReview`) + SUM(reviewCount.`rev_valueReview`)) / 5) / count(reviewCount.`rev_id`), 1) as hot_score, COUNT(DISTINCT(reviewCount.`rev_id`)) as hot_reviewCount, photo.`pho_id` AS photoId, photo.`pho_name` AS photoName, photo.`pho_hdd` AS photoHdd 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 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 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 LEFT JOIN `Translation` short ON short.`tra_rowid` = h.`hot_id` AND short.`pre_id` = h.`pre_id` AND short.`tco_id` = '6' AND short.`lan_id` = :lanId AND short.`pro_id` = 1 LEFT JOIN `Translation` longd ON longd.`tra_rowid` = h.`hot_id` AND longd.`pre_id` = h.`pre_id` AND longd.`tco_id` = '7' AND longd.`lan_id` = :lanId AND longd.`pro_id` = 1 LEFT JOIN `Translation` cond ON cond.`tra_rowid` = h.`hot_id` AND cond.`pre_id` = h.`pre_id` AND cond.`tco_id` = '21' AND cond.`lan_id` = :lanId AND cond.`pro_id` = 1 LEFT JOIN `TranslationApproval` previoshort ON previoshort.`tra_rowid` = h.`hot_id` AND previoshort.`pre_id` = h.`pre_id` AND previoshort.`tco_id` = '6' AND previoshort.`lan_id` = :lanId AND previoshort.`pro_id` = 1 LEFT JOIN `TranslationApproval` previolongd ON previolongd.`tra_rowid` = h.`hot_id` AND previolongd.`pre_id` = h.`pre_id` AND previolongd.`tco_id` = '7' AND previolongd.`lan_id` = :lanId AND previolongd.`pro_id` = 1 LEFT JOIN `Translation` projectshort ON projectshort.`tra_rowid` = h.`hot_id` AND projectshort.`pre_id` = h.`pre_id` AND projectshort.`tco_id` = '6' AND projectshort.`lan_id` = :lanId AND projectshort.`pro_id` = :proId LEFT JOIN `Translation` projectlongd ON projectlongd.`tra_rowid` = h.`hot_id` AND projectlongd.`pre_id` = h.`pre_id` AND projectlongd.`tco_id` = '7' AND projectlongd.`lan_id` = :lanId AND projectlongd.`pro_id` = :proId LEFT JOIN `Translation` transport ON transport.`tra_rowid` = h.`hot_id` AND transport.`pre_id` = h.`pre_id` AND transport.`tco_id` = '11' AND transport.`lan_id` = :lanId AND transport.`pro_id` = 1 LEFT JOIN `Translation` surroundings ON surroundings.`tra_rowid` = h.`hot_id` AND surroundings.`pre_id` = h.`pre_id` AND surroundings.`tco_id` = '13' AND surroundings.`lan_id` = :lanId AND surroundings.`pro_id` = 1 LEFT JOIN `Translation` roomsDescription ON roomsDescription.`tra_rowid` = h.`hot_id` AND roomsDescription.`pre_id` = h.`pre_id` AND roomsDescription.`tco_id` = '15' AND roomsDescription.`lan_id` = :lanId AND roomsDescription.`pro_id` = 1 LEFT JOIN `Translation` gastronomy ON gastronomy.`tra_rowid` = h.`hot_id` AND gastronomy.`pre_id` = h.`pre_id` AND gastronomy.`tco_id` = '14' AND gastronomy.`lan_id` = :lanId AND gastronomy.`pro_id` = 1 LEFT JOIN `Translation` additionalInfo ON additionalInfo.`tra_rowid` = h.`hot_id` AND additionalInfo.`pre_id` = h.`pre_id` AND additionalInfo.`tco_id` = '12' AND additionalInfo.`lan_id` = :lanId AND additionalInfo.`pro_id` = 1 LEFT JOIN `Translation` transport_project ON transport_project.`tra_rowid` = h.`hot_id` AND transport_project.`pre_id` = h.`pre_id` AND transport_project.`tco_id` = '11' AND transport_project.`lan_id` = :lanId AND transport_project.`pro_id` = :proId LEFT JOIN `Translation` surroundings_project ON surroundings_project.`tra_rowid` = h.`hot_id` AND surroundings_project.`pre_id` = h.`pre_id` AND surroundings_project.`tco_id` = '13' AND surroundings_project.`lan_id` = :lanId AND surroundings_project.`pro_id` = :proId LEFT JOIN `Translation` roomsDescription_project ON roomsDescription_project.`tra_rowid` = h.`hot_id` AND roomsDescription_project.`pre_id` = h.`pre_id` AND roomsDescription_project.`tco_id` = '15' AND roomsDescription_project.`lan_id` = :lanId AND roomsDescription_project.`pro_id` = :proId LEFT JOIN `Translation` gastronomy_project ON gastronomy_project.`tra_rowid` = h.`hot_id` AND gastronomy_project.`pre_id` = h.`pre_id` AND gastronomy_project.`tco_id` = '14' AND gastronomy_project.`lan_id` = :lanId AND gastronomy_project.`pro_id` = :proId LEFT JOIN `Translation` additionalInfo_project ON additionalInfo_project.`tra_rowid` = h.`hot_id` AND additionalInfo_project.`pre_id` = h.`pre_id` AND additionalInfo_project.`tco_id` = '12' AND additionalInfo_project.`lan_id` = :lanId AND additionalInfo_project.`pro_id` = :proId LEFT JOIN `TranslationApproval` transport_previo ON transport_previo.`tra_rowid` = h.`hot_id` AND transport_previo.`pre_id` = h.`pre_id` AND transport_previo.`tco_id` = '11' AND transport_previo.`lan_id` = :lanId AND transport_previo.`pro_id` = 1 LEFT JOIN `TranslationApproval` surroundings_previo ON surroundings_previo.`tra_rowid` = h.`hot_id` AND surroundings_previo.`pre_id` = h.`pre_id` AND surroundings_previo.`tco_id` = '13' AND surroundings_previo.`lan_id` = :lanId AND surroundings_previo.`pro_id` = 1 LEFT JOIN `TranslationApproval` roomsDescription_previo ON roomsDescription_previo.`tra_rowid` = h.`hot_id` AND roomsDescription_previo.`pre_id` = h.`pre_id` AND roomsDescription_previo.`tco_id` = '15' AND roomsDescription_previo.`lan_id` = :lanId AND roomsDescription_previo.`pro_id` = 1 LEFT JOIN `TranslationApproval` gastronomy_previo ON gastronomy_previo.`tra_rowid` = h.`hot_id` AND gastronomy_previo.`pre_id` = h.`pre_id` AND gastronomy_previo.`tco_id` = '14' AND gastronomy_previo.`lan_id` = :lanId AND gastronomy_previo.`pro_id` = 1 LEFT JOIN `TranslationApproval` additionalInfo_previo ON additionalInfo_previo.`tra_rowid` = h.`hot_id` AND additionalInfo_previo.`pre_id` = h.`pre_id` AND additionalInfo_previo.`tco_id` = '12' AND additionalInfo_previo.`lan_id` = :lanId AND additionalInfo_previo.`pro_id` = 1 LEFT JOIN `PriceActionFirstMinute` paf ON paf.`hot_id` = h.`hot_id` AND paf.`pre_id` = h.`pre_id` AND paf.`pfm_distance` > 0 AND paf.`pfm_discountRate` > 0 LEFT JOIN `PriceActionLastMinute` pal ON pal.`hot_id` = h.`hot_id` AND pal.`pre_id` = h.`pre_id` AND pal.`plm_distance` > 0 AND pal.`plm_discountRate` > 0 LEFT JOIN `PriceActionLongTerm` pat ON pat.`hot_id` = h.`hot_id` AND pat.`pre_id` = h.`pre_id` AND pat.`pal_count` > 0 AND pat.`pal_discountRate` > 0 LEFT JOIN Rating r ON h.hot_id = r.hot_id AND h.pre_id = r.pre_id LEFT JOIN `Reviews` reviewCount ON reviewCount.`hot_id` = h.`hot_id` AND reviewCount.`pre_id` = h.`pre_id` AND reviewCount.`rev_textOnly` <> '1' AND reviewCount.`rev_disabled` <> '1' LEFT JOIN `Photos` photo ON photo.`pho_pairId` = h.`hot_id` AND photo.`pre_id` = h.`pre_id` AND photo.`php_id` = '1' AND photo.`obk_id` = '0' LEFT JOIN `Photos` x ON x.`pho_pairId` = h.`hot_id` AND x.`pre_id` = h.`pre_id` AND x.`php_id` = '1' AND x.`obk_id` = '0' AND x.`pho_syncUpdate` = '2' WHERE h.`hot_seoName` = :seoName GROUP BY h.pre_id, h.`hot_id`' 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/GetHotel.php(2448): BaseModel->fetchAllCached('SELECT h.`pre_i...', Array, 'Model_GetHotel_...', Array) #6 /www/hory.cz/app/controllers/horycz/HotelController.php(50): Model_GetHotel->getData() #7 /www/hory.cz/lib/Zend/Controller/Action.php(133): Horycz_HotelController->init() #8 /www/hory.cz/lib/Zend/Controller/Dispatcher/Standard.php(281): Zend_Controller_Action->__construct(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http), Array) #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/miroslav/helios/ ip: 34.239.154.240