|
|
Error in include template "/var/lib/aolserver/larion-tours/packages/accommodation/lib/directory-type-tree-view": Database operation "0or1row" failed
(exception ERROR, "ERROR: column srlm.region_id does not exist
")
pqerror was: "ERROR: column srlm.region_id does not exist
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL: Select Coalesce(co.default_name, colm.name) as country_name, Coalesce(s.default_name, slm,name) as sate_name , Coalesce(r.default_name, rlm,name) as region_name, Coalesce(srlm.name, sr.default_name) as sub_region_name
From ac_sub_regions sr Left Outer Join ac_sub_region_language_map srlm
On (sr.region_id = srlm.region_id And srlm.language = 'de_DE'),
ac_regions r Left Outer Join ac_region_language_map rlm
On (r.region_id = rlm.region_id And rlm.language = 'de_DE'),
ac_states s Left Outer Join ac_state_language_map slm
On (s.state_id = slm.state_id And slm.language = 'de_DE'),
ac_countries co Left Outer Join ac_country_language_map colm
On (co.country_id = colm.country_id And colm.language = 'de_DE')
Where co.country_id = s.country_id
And s.state_id = r.state_id
And r.region_id = sr.region_id
And sr.sub_region_id = '6083'
|
Afrika