SQL Error (3): Error writing file /tmp/MYov6Aq5 (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 <= '2020-03-30 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) <= 1585530357 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 5000 line: | file:
SQL Error (3): Error writing file /tmp/MYO4yXAm (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 <= '2020-03-30 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) <= 1585530357 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 0,10 line: | file:
