exception 'exception_db' in /home/www/db2/db.class.php:924
Stack trace:
#0 /home/www/db2/db.class.php(593): db->halt(Invalid SQL:
select H.SID, H.title,H.eng_title, H.CREATE_USER, H.CREATE_PROGRAM, H.CREATE_TIME, H.UPDATE_USER, H.UPDATE_PROGRAM, H.UPDATE_TIME, H.t_num, H.checkin_title, H.checkin,
H.checkout_title, H.checkout, H.room_title, H.room, H.floors_title, H.floors, H.checkage_title, H.checkage, H.checkin_f_title, H.checkin_f, H.tower_title, H.tower,
H.year_title, H.year_val, H.import_title, H.import, H.price_title, H.price, H.go_import_title, H.go_import, H.where_title, H.where_val, H.groom_title, H.groom, H.facilities_title, H.facilities,
H.food_title, H.food, H.business_title, H.business, H.disabled_title, H.disabled, H.status, H.hotel_grade, H.field, H.field1, H.field2, H.field3, H.price_val ,H.hanwha_loc_cd
,( select hotel_img from hotel_img hi
where H.SID = hi.hotel_SID
limit 1) hotel_img
,hb.block_wdate,hb.block_hold
,hbl_price.normal_price
,hbl_price.sgl_price
,hbl_price.dbl_price
,hbl_price.twn_price
,hbl_price.trp_price
,hbl_price.oht1_price
,hbl_price.oht2_price
,hbl_price.oht3_price
from hotel_list as H
left join
hotel_guest_list as hgl
on H.SID = hgl.HOTEL_SID
left join
hotel_block as hb
on hgl.SID = hb.SID
left
join (select hb2.SID
,hgl2.HOTEL_SID
,MIN(CASE WHEN hb2.block_price_price > 0 THEN hb2.block_price_price END) normal_price
,MIN(CASE WHEN hb2.block_sgl_price_price > 0 THEN hb2.block_sgl_price_price END) sgl_price
,MIN(CASE WHEN hb2.block_dbl_price_price > 0 THEN hb2.block_dbl_price_price END) dbl_price
,MIN(CASE WHEN hb2.block_twn_price_price > 0 THEN hb2.block_twn_price_price END) twn_price
,MIN(CASE WHEN hb2.block_trp_price_price > 0 THEN hb2.block_trp_price_price END) trp_price
,MIN(CASE WHEN hb2.block_oht1_price_price > 0 THEN hb2.block_oht1_price_price END) oht1_price
,MIN(CASE WHEN hb2.block_oht2_price_price > 0 THEN hb2.block_oht2_price_price END) oht2_price
,MIN(CASE WHEN hb2.block_oht3_price_price > 0 THEN hb2.block_oht3_price_price END) oht3_price
from hotel_block as hb2
left
join hotel_guest_list as hgl2
on hb2.SID = hgl2.SID
where date_format(hb2.block_wdate,'%Y.%m.%d') >= CURRENT_DATE()
group
by hgl2.HOTEL_SID) hbl_price
on H.SID = hbl_price.HOTEL_SID
where
H.status = 'Y' AND H.t_num = '1160'
AND H.field = '1160_4_8' AND H.field1 = '1160_4'
group
by H.SID
ORDER BY UPDATE_TIME desc
, , /home/www/lib2/display_manager/display_manager.class.php)
#1 /home/www/db2/db.class.php(612): db->query(
select H.SID, H.title,H.eng_title, H.CREATE_USER, H.CREATE_PROGRAM, H.CREATE_TIME, H.UPDATE_USER, H.UPDATE_PROGRAM, H.UPDATE_TIME, H.t_num, H.checkin_title, H.checkin,
H.checkout_title, H.checkout, H.room_title, H.room, H.floors_title, H.floors, H.checkage_title, H.checkage, H.checkin_f_title, H.checkin_f, H.tower_title, H.tower,
H.year_title, H.year_val, H.import_title, H.import, H.price_title, H.price, H.go_import_title, H.go_import, H.where_title, H.where_val, H.groom_title, H.groom, H.facilities_title, H.facilities,
H.food_title, H.food, H.business_title, H.business, H.disabled_title, H.disabled, H.status, H.hotel_grade, H.field, H.field1, H.field2, H.field3, H.price_val ,H.hanwha_loc_cd
,( select hotel_img from hotel_img hi
where H.SID = hi.hotel_SID
limit 1) hotel_img
,hb.block_wdate,hb.block_hold
,hbl_price.normal_price
,hbl_price.sgl_price
,hbl_price.dbl_price
,hbl_price.twn_price
,hbl_price.trp_price
,hbl_price.oht1_price
,hbl_price.oht2_price
,hbl_price.oht3_price
from hotel_list as H
left join
hotel_guest_list as hgl
on H.SID = hgl.HOTEL_SID
left join
hotel_block as hb
on hgl.SID = hb.SID
left
join (select hb2.SID
,hgl2.HOTEL_SID
,MIN(CASE WHEN hb2.block_price_price > 0 THEN hb2.block_price_price END) normal_price
,MIN(CASE WHEN hb2.block_sgl_price_price > 0 THEN hb2.block_sgl_price_price END) sgl_price
,MIN(CASE WHEN hb2.block_dbl_price_price > 0 THEN hb2.block_dbl_price_price END) dbl_price
,MIN(CASE WHEN hb2.block_twn_price_price > 0 THEN hb2.block_twn_price_price END) twn_price
,MIN(CASE WHEN hb2.block_trp_price_price > 0 THEN hb2.block_trp_price_price END) trp_price
,MIN(CASE WHEN hb2.block_oht1_price_price > 0 THEN hb2.block_oht1_price_price END) oht1_price
,MIN(CASE WHEN hb2.block_oht2_price_price > 0 THEN hb2.block_oht2_price_price END) oht2_price
,MIN(CASE WHEN hb2.block_oht3_price_price > 0 THEN hb2.block_oht3_price_price END) oht3_price
from hotel_block as hb2
left
join hotel_guest_list as hgl2
on hb2.SID = hgl2.SID
where date_format(hb2.block_wdate,'%Y.%m.%d') >= CURRENT_DATE()
group
by hgl2.HOTEL_SID) hbl_price
on H.SID = hbl_price.HOTEL_SID
where
H.status = 'Y' AND H.t_num = '1160'
AND H.field = '1160_4_8' AND H.field1 = '1160_4'
group
by H.SID
ORDER BY UPDATE_TIME desc
, , /home/www/lib2/display_manager/display_manager.class.php, , , )
#2 /home/www/lib2/display_manager/display_manager.class.php(1264): db->limit_query(
select H.SID, H.title,H.eng_title, H.CREATE_USER, H.CREATE_PROGRAM, H.CREATE_TIME, H.UPDATE_USER, H.UPDATE_PROGRAM, H.UPDATE_TIME, H.t_num, H.checkin_title, H.checkin,
H.checkout_title, H.checkout, H.room_title, H.room, H.floors_title, H.floors, H.checkage_title, H.checkage, H.checkin_f_title, H.checkin_f, H.tower_title, H.tower,
H.year_title, H.year_val, H.import_title, H.import, H.price_title, H.price, H.go_import_title, H.go_import, H.where_title, H.where_val, H.groom_title, H.groom, H.facilities_title, H.facilities,
H.food_title, H.food, H.business_title, H.business, H.disabled_title, H.disabled, H.status, H.hotel_grade, H.field, H.field1, H.field2, H.field3, H.price_val ,H.hanwha_loc_cd
,( select hotel_img from hotel_img hi
where H.SID = hi.hotel_SID
limit 1) hotel_img
,hb.block_wdate,hb.block_hold
,hbl_price.normal_price
,hbl_price.sgl_price
,hbl_price.dbl_price
,hbl_price.twn_price
,hbl_price.trp_price
,hbl_price.oht1_price
,hbl_price.oht2_price
,hbl_price.oht3_price
from hotel_list as H
left join
hotel_guest_list as hgl
on H.SID = hgl.HOTEL_SID
left join
hotel_block as hb
on hgl.SID = hb.SID
left
join (select hb2.SID
,hgl2.HOTEL_SID
,MIN(CASE WHEN hb2.block_price_price > 0 THEN hb2.block_price_price END) normal_price
,MIN(CASE WHEN hb2.block_sgl_price_price > 0 THEN hb2.block_sgl_price_price END) sgl_price
,MIN(CASE WHEN hb2.block_dbl_price_price > 0 THEN hb2.block_dbl_price_price END) dbl_price
,MIN(CASE WHEN hb2.block_twn_price_price > 0 THEN hb2.block_twn_price_price END) twn_price
,MIN(CASE WHEN hb2.block_trp_price_price > 0 THEN hb2.block_trp_price_price END) trp_price
,MIN(CASE WHEN hb2.block_oht1_price_price > 0 THEN hb2.block_oht1_price_price END) oht1_price
,MIN(CASE WHEN hb2.block_oht2_price_price > 0 THEN hb2.block_oht2_price_price END) oht2_price
,MIN(CASE WHEN hb2.block_oht3_price_price > 0 THEN hb2.block_oht3_price_price END) oht3_price
from hotel_block as hb2
left
join hotel_guest_list as hgl2
on hb2.SID = hgl2.SID
where date_format(hb2.block_wdate,'%Y.%m.%d') >= CURRENT_DATE()
group
by hgl2.HOTEL_SID) hbl_price
on H.SID = hbl_price.HOTEL_SID
where
H.status = 'Y' AND H.t_num = '1160'
AND H.field = '1160_4_8' AND H.field1 = '1160_4'
group
by H.SID
ORDER BY UPDATE_TIME desc
, , , /home/www/lib2/display_manager/display_manager.class.php, )
#3 /home/www/new/rsp_new_list.php(262): display_manager->getProductList_dongbang(1160_4, 1160_4_8, , , , , , , , , , )
#4 /home/www/new/index.php(27): include(/home/www/new/rsp_new_list.php)Database error: Invalid SQL:
select H.SID, H.title,H.eng_title, H.CREATE_USER, H.CREATE_PROGRAM, H.CREATE_TIME, H.UPDATE_USER, H.UPDATE_PROGRAM, H.UPDATE_TIME, H.t_num, H.checkin_title, H.checkin,
H.checkout_title, H.checkout, H.room_title, H.room, H.floors_title, H.floors, H.checkage_title, H.checkage, H.checkin_f_title, H.checkin_f, H.tower_title, H.tower,
H.year_title, H.year_val, H.import_title, H.import, H.price_title, H.price, H.go_import_title, H.go_import, H.where_title, H.where_val, H.groom_title, H.groom, H.facilities_title, H.facilities,
H.food_title, H.food, H.business_title, H.business, H.disabled_title, H.disabled, H.status, H.hotel_grade, H.field, H.field1, H.field2, H.field3, H.price_val ,H.hanwha_loc_cd
,( select hotel_img from hotel_img hi
where H.SID = hi.hotel_SID
limit 1) hotel_img
,hb.block_wdate,hb.block_hold
,hbl_price.normal_price
,hbl_price.sgl_price
,hbl_price.dbl_price
,hbl_price.twn_price
,hbl_price.trp_price
,hbl_price.oht1_price
,hbl_price.oht2_price
,hbl_price.oht3_price
from hotel_list as H
left join
hotel_guest_list as hgl
on H.SID = hgl.HOTEL_SID
left join
hotel_block as hb
on hgl.SID = hb.SID
left
join (select hb2.SID
,hgl2.HOTEL_SID
,MIN(CASE WHEN hb2.block_price_price > 0 THEN hb2.block_price_price END) normal_price
,MIN(CASE WHEN hb2.block_sgl_price_price > 0 THEN hb2.block_sgl_price_price END) sgl_price
,MIN(CASE WHEN hb2.block_dbl_price_price > 0 THEN hb2.block_dbl_price_price END) dbl_price
,MIN(CASE WHEN hb2.block_twn_price_price > 0 THEN hb2.block_twn_price_price END) twn_price
,MIN(CASE WHEN hb2.block_trp_price_price > 0 THEN hb2.block_trp_price_price END) trp_price
,MIN(CASE WHEN hb2.block_oht1_price_price > 0 THEN hb2.block_oht1_price_price END) oht1_price
,MIN(CASE WHEN hb2.block_oht2_price_price > 0 THEN hb2.block_oht2_price_price END) oht2_price
,MIN(CASE WHEN hb2.block_oht3_price_price > 0 THEN hb2.block_oht3_price_price END) oht3_price
from hotel_block as hb2
left
join hotel_guest_list as hgl2
on hb2.SID = hgl2.SID
where date_format(hb2.block_wdate,'%Y.%m.%d') >= CURRENT_DATE()
group
by hgl2.HOTEL_SID) hbl_price
on H.SID = hbl_price.HOTEL_SID
where
H.status = 'Y' AND H.t_num = '1160'
AND H.field = '1160_4_8' AND H.field1 = '1160_4'
group
by H.SID
ORDER BY UPDATE_TIME desc
mysqli Error: 1054 (Unknown column 'H.hanwha_loc_cd' in 'field list')
File: /home/www/lib2/display_manager/display_manager.class.php
Line: 1263
Function: db::limit_query / display_manager::getProductList_dongbang / include(/new/rsp_new_list.php)
Session halted.