Database query error. The error was: errno : 1021 Disk full (/tmp/#sql-temptable-26da5a-9786-10c2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SQL query/queries : select distinct ads.*, ads.id as adid, date_format(ads.`date_added`,'%b %d, %Y') as date_nice, date_format(ads.`date_updated`,'%b %d, %Y') as date_updated_nice, date_format(ads.`date_expires`,'%b %d, %Y') as date_expires_nice, UNIX_TIMESTAMP(ads.`date_added`) as `time_added`, UNIX_TIMESTAMP(ads.`date_updated`) as `time_updated`, (ads.date_expires < '2024-04-27 00:20:08' and ads.date_expires!='0000-00-00 00:00:00' and ads.active=0) as expired , slugs.slug from ads use index (active_2) inner join slugs on ads.id=slugs.object_id where ads.active=1 and ads.category_id in (16,18,19,21,23,2) and ( (ads.structura_constructie like 'Beton') ) and slugs.`type`='listing' order by `priority` desc, date_updated desc limit 4524, 12
Error path: www.realestate.ro/search/vanzari/?structura_constructie=beton&page=378
SQL query/queries : select distinct ads.*, ads.id as adid, date_format(ads.`date_added`,'%b %d, %Y') as date_nice, date_format(ads.`date_updated`,'%b %d, %Y') as date_updated_nice, date_format(ads.`date_expires`,'%b %d, %Y') as date_expires_nice, UNIX_TIMESTAMP(ads.`date_added`) as `time_added`, UNIX_TIMESTAMP(ads.`date_updated`) as `time_updated`, (ads.date_expires < '2024-04-27 00:20:08' and ads.date_expires!='0000-00-00 00:00:00' and ads.active=0) as expired , slugs.slug from ads use index (active_2) inner join slugs on ads.id=slugs.object_id where ads.active=1 and ads.category_id in (16,18,19,21,23,2) and ( (ads.structura_constructie like 'Beton') ) and slugs.`type`='listing' order by `priority` desc, date_updated desc limit 4524, 12
Error path: www.realestate.ro/search/vanzari/?structura_constructie=beton&page=378