dbException /home/www/nanoclegi.pl/app/sys/classes/shared/db.class.php(169) QUERY - ERROR: relation "payments.view_aktywne_produkty" does not exist LINE 103: left join payments.view_aktywne_produkty p_vap on p_vap.... ^ select p_uo.o_id is not null as o_is_online, p_uo.chmgr_id is not null as o_is_chmgr, p_uo.chmgr_id, b_chmgr.chmgr_sys_name, p_uo.typ as p_uo_typ, p_uo.prowizja as p_uo_prowizja, coalesce(array_upper(oext.og_ids,1),0)>0 as o_have_offer, oext.o_is_partner as is_partner, oext.o_is_checked, oext.p_pz_tekst as pay_desc, (p_vap.o_id is null) as show_promo, o.o_status, o.o_book_link_nr, o.o_status_fin, o.o_id, curr.cu_symbol, o.o_photo_cnt, array_to_json(o.o_video) as o_video, o.o_super_id, md5(o.o_super_id||'eholiday_hash_solt') as o_super_id_hash, o.o_photo_pri, o.o_breakfast_price, case when o.o_status_fin then address_format(o.o_street, c.c_name::text, o.o_post, o.o_postcode) else address_format(null, c.c_name::text, o.o_post, o.o_postcode) end as o_address, row_to_json(o.o_logo) as o_logo, o.oo_score_avg::numeric(4,2), o.oo_score_cnt, o.o_name, o.c_id, o.o_rates_status, array_to_json(o.o_type) as o_type, row_to_json(o.o_street) as o_street, o.o_postcode, o.o_post, array_to_json(o.o_phones) as o_phones, array_to_json(1 -> o.o_phones) as o_phones_normal, array_to_json(2 -> o.o_phones) as o_phones_mobile, array_to_json(3 -> o.o_phones) as o_phones_infoline, array_to_json(null -> o.o_phones) as o_phones_other, o.o_fax, array_to_json(o.o_emails) as o_emails, array_to_json(o.o_www) as o_www, array_to_json(o.o_attr_ids) as o_attr_ids, array_upper(o.o_attr_ids-=null,1) as o_attr_cnt, o.o_standard, o.o_room_cnt, o.o_place_cnt, o.currs_id, o.o_price_kind, row_to_json(o.o_room_price1) as o_room_price1, row_to_json(o.o_room_price2) as o_room_price2, row_to_json(o.o_room_price3) as o_room_price3, row_to_json(o.o_room_price4) as o_room_price4, row_to_json(o.o_apartament_price) as o_apartament_price, array_to_json(o.o_room_others) as o_room_others, row_to_json(o.o_person_price_range) as o_person_price_range, row_to_json(o.o_room_price_range) as o_room_price_range, o.o_animals, row_to_json(o.o_animal_price) as o_animal_price, col_not_null_first(o.o_description) as o_desc, o.o_rep_person_name, o.o_rep_person_position, o.o_rep_person_email, o.o_rep_person_phone, o.o_modify_obj, row_to_json(o.o_coordinate) as o_coordinate, c.c_name::text, prov.prov_name, c.distr_name, c.gmina_name, ot.ot_name::text as ot_name_pri, ot.ot_name_plural::text as ot_name_plural_pri, prep_for_link(ot.ot_name::text) as ot_name_pri_lnk, prep_for_link(ot.ot_name_plural::text) as ot_name_plural_pri_lnk, prep_for_link(c.c_name::text) as c_name_lnk, coalesce(o.o_create_date, o.o_a_data_przejecia)::date as o_create_date, (o.o_type[1]!=6) as show_cite, o.o_gg, o.o_skype, o.o_poi_disable, array_upper(o.o_video,1) as o_video_cnt, row_to_json(coordniate_obj_to_gps(c.c_coordinate)) as o_coordinate_gps, (o.o_room_price1 is not null or o.o_room_price2 is not null or o.o_room_price3 is not null or o.o_room_price4 is not null or o.o_apartament_price is not null or (array_upper(o.o_room_others, 1) is not null and array_upper(o.o_room_others, 1) >0) ) as o_any_room, p_vdom.domena as o_domain, o.o_is_structure, o.o_facebook_url, p_uo.platnosci_maska as p_uo_platnosci_maska, oattr_agg.o_attr_available, oext.occ_cnt is not null as o_have_occ, oext.occ_cnt, ocq_agg.cq_available from ( objects o left join payments.view_aktywne_produkty p_vap on p_vap.o_id=o.o_id left join payments.view_domeny p_vdom on p_vdom.o_id=o.o_id ) inner join objects_ext oext on oext.o_id=o.o_id inner join o_types ot on ot.ot_id=o.o_type[1] inner join cities c on o.c_id=c.c_id inner join provinces prov on prov.prov_id = c.prov_id inner join currs curr on o.currs_id=curr.currs_id::text left join payments.umowy_online p_uo on p_uo.o_id = o.o_id and p_uo.aktywna left join bookings.channel_managers b_chmgr on b_chmgr.chmgr_id = p_uo.chmgr_id left join ( select oattrv_agg.o_id, array_to_json(array_agg(oattr.oattr_name::text)) as o_attr_available from o_attributes2 oattr inner join ( select otoattrv.o_id, oattrv.oattr_id from o_attributes_values oattrv inner join o_to_attributes_values otoattrv on otoattrv.oattrv_id = oattrv.oattrv_id and otoattrv.otoattrv_status inner join objects o on otoattrv.o_id = o.o_id where o.o_super_id = 'vo5537' and oattrv.oattrv_status and oattrv.oattrv_is_positive group by otoattrv.o_id, oattrv.oattr_id ) oattrv_agg on oattrv_agg.oattr_id=oattr.oattr_id group by oattrv_agg.o_id ) oattr_agg on oattr_agg.o_id = o.o_id left join ( select ocq.o_id, array_to_json(array_agg(row_to_json(ocq.*) order by cq_area desc)) as cq_available from ( select o.o_id, cq.cq_id, cq.cq_name::text, cq.cq_name_loc::text, cq.cq_name_prefix::text, cq.cq_area, prep_for_link(cq.cq_name::text) as cq_name_lnk from cities_quarter cq inner join objects o on array[cq.cq_id] && o.cq_ids where o.o_super_id = 'vo5537' and cq.cq_status ) ocq group by ocq.o_id ) ocq_agg on ocq_agg.o_id = o.o_id where o.o_super_id='vo5537' and (o.o_status_fin OR NOT o.o_status) and (NOT o.o_a_bad_record) #0 /home/www/nanoclegi.pl/app/sys/classes/shared/db.class.php(275): db->_query('?select? p_uo....') #1 /home/www/nanoclegi.pl/app/sys/classes/shared/db.class.php(199): db->query('?select? p_uo....') #2 /home/www/nanoclegi.pl/app/sys/classes/shared/db.class.php(292): db->_run_query('?select? p_uo....') #3 /home/www/nanoclegi.pl/app/sys/classes/app_parent.class.php(283): db->q2a('?select? p_uo....', true) #4 /home/www/nanoclegi.pl/app/sys/classes/app.class.php(2440): app_parent::cache_query_result('get_object_one_...', '?select? p_uo....', true, 10) #5 /home/www/nanoclegi.pl/app/sys/classes/app.class.php(2452): app->get_object_one(Array) #6 /home/www/nanoclegi.pl/app/sys/classes/control_client.class.php(194): app->get_object_detail(Array, Array) #7 /home/www/nanoclegi.pl/app/sys/classes/control.class.php(131): control_client->action() #8 /home/www/nanoclegi.pl/www/index.php(3): control->__construct() #9 {main}