Tygh\Exceptions\AException

Message

Error writing file '/tmp/MY1Z6vhm' (Errcode: 28 - No space left on device) (3)

SELECT b.row_position FROM (SELECT product_id, @r := @r + 1 as row_position FROM(SELECT products.product_id FROM ssl_myproducts as products LEFT JOIN ssl_myproduct_options_inventory as inventory ON inventory.product_id = products.product_id LEFT JOIN ssl_myproduct_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ssl_myproduct_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ssl_myproducts_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ssl_mycategories ON ssl_mycategories.category_id = products_categories.category_id AND (ssl_mycategories.usergroup_ids = '' OR FIND_IN_SET(0, ssl_mycategories.usergroup_ids) OR FIND_IN_SET(1, ssl_mycategories.usergroup_ids)) AND ssl_mycategories.status IN ('A', 'H') LEFT JOIN ssl_myult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' LEFT JOIN ssl_myproduct_popularity as popularity ON popularity.product_id = products.product_id WHERE 1 AND ssl_mycategories.category_id IN (3594) AND ssl_mycategories.company_id = 1 AND (CASE products.tracking WHEN 'O' THEN inventory.amount > 0 WHEN 'B' THEN products.amount > 0 ELSE 1 END) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product asc) AS a) AS b WHERE b.product_id = 43949

Error at

app/Tygh/Database/Connection.php, line: 1133

Backtrace

File:app/Tygh/Database/Connection.php
Line:499
Function:throwError
File:app/Tygh/Database/Connection.php
Line:307
Function:query
File:app/functions/fn.database.php
Line:79
Function:getField
File:app/schemas/last_view/frontend.functions.php
Line:69
Function:db_get_field
File:app/Tygh/Navigation/LastView/Frontend.php
Line:149
Function:fn_lv_get_product_default_navigation
File:app/Tygh/Navigation/LastView/ACommon.php
Line:109
Function:_initDefaultViewTools
File:app/functions/fn.control.php
Line:491
Function:init
File:index.php
Line:35
Function:fn_dispatch