SQL Error (3): Error writing file /tmp/MY58sfXq (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 >= '2015-07-25 16:45:37'AND date_start <= '2019-10-23 23:59:59'AND ( items.tags LIKE '%скотоводство,%' OR items.tags LIKE '%скотоводство ,%' OR items.tags LIKE '%, скотоводство%' OR items.tags LIKE '%,скотоводство%' OR items.tags = 'скотоводство') ANDUNIX_TIMESTAMP(struct.date_start) <= 1571788271 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 5000 line: | file:
SQL Error (3): Error writing file /tmp/MYDA8FUg (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 >= '2015-07-25 16:45:37'AND date_start <= '2019-10-23 23:59:59'AND ( items.tags LIKE '%скотоводство,%' OR items.tags LIKE '%скотоводство ,%' OR items.tags LIKE '%, скотоводство%' OR items.tags LIKE '%,скотоводство%' OR items.tags = 'скотоводство') ANDUNIX_TIMESTAMP(struct.date_start) <= 1571788271 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 0,10 line: | file:
