SQL Error (3): Error writing file /tmp/MY7OdTLV (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 '%AgroGear,%' OR items.tags LIKE '%AgroGear ,%' OR items.tags LIKE '%, AgroGear%' OR items.tags LIKE '%,AgroGear%' OR items.tags = 'AgroGear') ANDUNIX_TIMESTAMP(struct.date_start) <= 1585543206 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 5000 line: | file:
SQL Error (3): Error writing file /tmp/MY7NJwEl (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 '%AgroGear,%' OR items.tags LIKE '%AgroGear ,%' OR items.tags LIKE '%, AgroGear%' OR items.tags LIKE '%,AgroGear%' OR items.tags = 'AgroGear') ANDUNIX_TIMESTAMP(struct.date_start) <= 1585543206 AND struct.location='items' ORDERBY num, date_start desc, date desc LIMIT 10,10 line: | file:
