SQL: 1021 Disk full (/tmp/#sql_21ab_3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Ostatnie zapytanie: (
SELECT
p.`id`,
p.`categoryId`,
p.`lead`,
p.`name`,
p.`price_brutto`,
p.`price_netto`,
p.`price_promo_netto`,
p.`price_promo_brutto`,
p.`product_code`,
p.`id` as thisId,
p.`categoryId` as thisCategoryId,
( SELECT `seoname` FROM `cms_seo` WHERE `target_id`=thisCategoryId AND `target_table`='shopCategory' ) as categorySeo,
( SELECT `seoname` FROM `cms_seo` WHERE `target_id`= ( SELECT `parentId` FROM `cms_shopCategory` WHERE `id`=thisCategoryId ) AND `target_table`='shopCategory' ) as parentCategorySeo
FROM `cms_shopPositions` p
WHERE 1
AND p.`activity`='1'
AND p.`price_brutto` > 0
AND p.`id`!='29442'
AND p.`categoryId`='129'
AND p.`id` NOT IN ( 0 )
AND p.`stock` > 0
ORDER BY RAND()
LIMIT 8 )
Ilość wykonanych zapytań: 34
Całkowity czas wykonywania zapytań: 0.0025138854980469
Plik: /var/www/clients/1/web97/web/lib/Db.class.php
Linia: 135
Trace: #0 /var/www/clients/1/web97/web/lib/Shop.class.php(985): db->query('\n SE...')
#1 /var/www/clients/1/web97/web/tpl/new/modules/shop/product-related.php(5): Shop->getOtherCategoryPositions(29442, 129, 8)
#2 /var/www/clients/1/web97/web/tpl/new/modules/shop/shop-details.php(220): require('/var/www/client...')
#3 /var/www/clients/1/web97/web/tpl/new/shop.php(51): include_once('/var/www/client...')
#4 /var/www/clients/1/web97/web/lib/Template.class.php(126): require('/var/www/client...')
#5 /var/www/clients/1/web97/web/index.php(131): Template->showPage()
#6 {main}
Kod: 0
