SQL Error (3): Error writing file /tmp/MYJo7LZO (Errcode: 28) SELECT items.*, 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.alias, 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 items USING (struct_id) WHERE items.lang = 'ru' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND (alias='pubs' OR alias='news' OR alias='multimedias' OR alias='blogs' OR alias='authors' OR alias='opinions') AND struct.location='items' ORDERBY date_start asc LIMIT 0,1 line: | file:
SQL Error (3): Error writing file /tmp/MYHYFUSY (Errcode: 28) SELECT items.*, 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.alias, 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 items USING (struct_id) WHERE items.lang = 'ru' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND (alias='pubs' OR alias='news' OR alias='multimedias' OR alias='blogs' OR alias='authors' OR alias='opinions') AND date_start >= '1970-01-01 03:00:00'AND date_start <= '2020-02-27 23:59:59'AND ( items.tags LIKE '%Nestle,%' OR items.tags LIKE '%Nestle ,%' OR items.tags LIKE '%, Nestle%' OR items.tags LIKE '%,Nestle%' OR items.tags = 'Nestle') ANDUNIX_TIMESTAMP(struct.date_start) <= 1582764462 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 5000 line: | file:
SQL Error (3): Error writing file /tmp/MY0ThvO8 (Errcode: 28) SELECT items.*, 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.alias, 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 items USING (struct_id) WHERE items.lang = 'ru' AND (struct.showmode='show' || struct.showmode='show!tree') && struct.type!='separator' AND (alias='pubs' OR alias='news' OR alias='multimedias' OR alias='blogs' OR alias='authors' OR alias='opinions') AND date_start >= '1970-01-01 03:00:00'AND date_start <= '2020-02-27 23:59:59'AND ( items.tags LIKE '%Nestle,%' OR items.tags LIKE '%Nestle ,%' OR items.tags LIKE '%, Nestle%' OR items.tags LIKE '%,Nestle%' OR items.tags = 'Nestle') ANDUNIX_TIMESTAMP(struct.date_start) <= 1582764462 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 0,10 line: | file:
