Query Error 1114: The table '/tmp/#sql46a_9fdf6_57' is full
Query: SELECT p.*,p.id,p.sku_id,p.image_id,p.image_filename,p.ext,(p.count > 0 || p.count IS NULL) AS in_stock
FROM shop_product p
JOIN shop_category_products cp1
ON p.id = cp1.product_id
WHERE p.status = 1
AND cp1.category_id IN(37)
GROUP BY cp1.sort, p.id
ORDER BY in_stock DESC,RAND()
LIMIT 4 code 1114

## wa-system/database/waModel.class.php(283)
#0 wa-system/database/waModel.class.php(384): waModel->run('SELECT p.*,p.id...')
#1 wa-apps/shop/lib/classes/shopProductsCollection.class.php(2627): waModel->query('SELECT p.*,p.id...')
#2 wa-apps/shop/lib/classes/shopProduct.class.php(1207): shopProductsCollection->getProducts('*,skus_filtered', 0)
#3 wa-cache/4b8cc5/apps/shop/templates/compiled/shop_ru_RU/06/fb/14/06fb14cb199d6b15d4c48b4b203bd1c50af200c0.file.index.html.php(626): shopProduct->crossSelling(4)
#4 wa-cache/4b8cc5/apps/shop/templates/compiled/shop_ru_RU/06/fb/14/06fb14cb199d6b15d4c48b4b203bd1c50af200c0.file.index.html.php(182): content_6969e0f97b3414_49060880(Object(Smarty_Internal_Template))
#5 wa-system/vendors/smarty3/sysplugins/smarty_internal_templatebase.php(186): content_694b8ccc4bc588_39143374(Object(Smarty_Internal_Template))
#6 wa-system/view/waSmarty3View.class.php(144): Smarty_Internal_TemplateBase->fetch('file:index.html', NULL)
#7 wa-system/layout/waLayout.class.php(162): waSmarty3View->fetch('file:index.html')
#8 wa-system/controller/waViewController.class.php(104): waLayout->display()
#9 wa-system/controller/waViewController.class.php(47): waViewController->display()
#10 wa-system/controller/waFrontController.class.php(299): waViewController->run(NULL)
#11 wa-apps/shop/lib/classes/shopFrontController.class.php(22): waFrontController->runController(Object(shopFrontendProductController), NULL)
#12 wa-system/controller/waFrontController.class.php(197): shopFrontController->runController(Object(shopFrontendProductController), NULL)
#13 wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'frontend', 'product')
#14 wa-system/controller/waDispatch.class.php(385): waFrontController->dispatch()
#15 wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('catalog/diski/g...')
#16 wa-system/waSystem.class.php(614): waDispatch->dispatch()
#17 index.php(8): waSystem->dispatch()
#18 {main}

GET

[]

Params

[
  'app' => 'shop',
  '_name' => 'Магазин',
  'theme' => 'amuravtotorg',
  'theme_mobile' => 'amuravtotorg',
  'checkout_version' => '2',
  'locale' => 'ru_RU',
  'title' => 'Продажа шин, масел и аккумуляторов в Хабаровске',
  'meta_keywords' => 'грузовые шины, легковые шины, масла, аккумуляторы',
  'meta_description' => '',
  'og_title' => '',
  'og_image' => '',
  'og_video' => '',
  'og_description' => '',
  'og_type' => '',
  'og_url' => '',
  'url_type' => '2',
  'type_id' => '0',
  'currency' => 'RUB',
  'public_stocks' => '0',
  'drop_out_of_stock' => '1',
  'payment_id' => '0',
  'shipping_id' => '0',
  'checkout_storefront_id' => 'efeec6fc55ae2b95d8ea436e96fc208a',
  'category_url' => 'catalog/diski/gruzovye-diski',
  'product_url' => '101252-lemmerz-b19ds444-525x175-5208-et106-dia150',
  'module' => 'frontend',
  'action' => 'product',
]