SQL Error (1054): Unknown column struct.date_end in field list
SELECT sections.title, struct.struct_id, struct.copy_id, struct.on_page2, struct.name as struct_name, struct.dir, struct.num, struct.parent_id, struct.parents, struct.smark, struct.date_end, UNIX_TIMESTAMP(struct.date) as date_format, UNIX_TIMESTAMP(struct.date_change) as date_change_format, UNIX_TIMESTAMP(struct.date_start) as date_start_format FROM struct LEFTJOIN sections USING (struct_id) WHERE sections.lang = 'ukr' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND parent_id='0' && (smark='mainmenu' || smark='topmenu' || smark='bottommenu') AND struct.location='sections' ORDERBY num, date_start desc, date desc LIMIT 0,20 line: | file:
SQL Error (1054): Unknown column struct.date_end in field list
SELECT combo.name, struct.struct_id, struct.copy_id, struct.on_page2, struct.name as struct_name, struct.dir, struct.num, struct.parent_id, struct.parents, struct.smark, struct.date_end, UNIX_TIMESTAMP(struct.date) as date_format, UNIX_TIMESTAMP(struct.date_change) as date_change_format, UNIX_TIMESTAMP(struct.date_start) as date_start_format FROM struct LEFTJOIN combo USING (struct_id) WHERE combo.lang = 'ukr' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND combo.name!='' AND struct.location='combo' AND struct.parent_id = '419' ORDERBY num, struct.name LIMIT 5000 line: | file:
SQL Error (1054): Unknown column struct.date_end in field list
SELECT combo.name, struct.struct_id, struct.copy_id, struct.on_page2, struct.name as struct_name, struct.dir, struct.num, struct.parent_id, struct.parents, struct.smark, struct.date_end, UNIX_TIMESTAMP(struct.date) as date_format, UNIX_TIMESTAMP(struct.date_change) as date_change_format, UNIX_TIMESTAMP(struct.date_start) as date_start_format FROM struct LEFTJOIN combo USING (struct_id) WHERE combo.lang = 'ukr' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND city_id='' AND struct.location='combo' AND struct.parent_id = '418' ORDERBY num, struct.name LIMIT 5000 line: | file:
SQL Error (1054): Unknown column struct.date_end in field list
SELECT combo.name, struct.struct_id, struct.copy_id, struct.on_page2, struct.name as struct_name, struct.dir, struct.num, struct.parent_id, struct.parents, struct.smark, struct.date_end, UNIX_TIMESTAMP(struct.date) as date_format, UNIX_TIMESTAMP(struct.date_change) as date_change_format, UNIX_TIMESTAMP(struct.date_start) as date_start_format FROM struct LEFTJOIN combo USING (struct_id) WHERE combo.lang = 'ukr' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND struct_id IN ('13385','431','431','431','431','431','431','431','431','431','878','431','431','431','431','431','431','431','431','431') && combo.name!='' AND struct.location='combo' AND struct.parent_id = '416' ORDERBY num, struct.name LIMIT 5000 line: | file: