SQL: 1021 Disk full (/tmp/#sql_841_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Ostatnie zapytanie: (
SELECT
sp.*,
sc.`name` as cname,
sp.`stock` as stock_available,
IFNULL(SUM(o2.`amount`), 0) as bought
FROM `cms_shopPositions` sp
JOIN `cms_shopCategory` sc ON sp.`categoryId` = sc.`id`
LEFT JOIN `cms_orders` o2 ON (o2.`productId` = sp.`id` AND o2.`status` NOT IN (2, 3, 22) AND o2.`date` > 1767913200)
WHERE 1
AND sp.`activity` = 1
AND sc.`activity` = 1
AND sp.`price_brutto` > 0
AND (sp.`categoryId` IN (0,11,7,8,9,12,14,15,16,17,13,25,23,36,35,26,27,28,29,30,31,37,38,39))
GROUP BY sp.`id`
HAVING 1
AND (bought > 0 || sp.`top10` = 1)
AND stock_available > 0
ORDER BY
sp.`top10` DESC,
bought DESC,
sp.`id` DESC
LIMIT 16)
Ilość wykonanych zapytań: 27
Całkowity czas wykonywania zapytań: 0.026133298873901
Plik: /var/www/clients/1/web48/web/lib/Db.class.php
Linia: 133
Trace: #0 /var/www/clients/1/web48/web/lib/Shop.class.php(1252): db->query('\n SE...')
#1 /var/www/clients/1/web48/web/tpl/modern/modules/shop/bestseller-section.php(5): Shop->getBestsellers(16)
#2 /var/www/clients/1/web48/web/tpl/modern/start.php(28): include('/var/www/client...')
#3 /var/www/clients/1/web48/web/lib/Template.class.php(125): require('/var/www/client...')
#4 /var/www/clients/1/web48/web/index.php(122): Template->showPage()
#5 {main}
Kod: 0
Zaloguj