Warning: mysqli_query(): (HY001/1038): Out of sort memory, consider increasing server sort buffer size in /home/binnova/public_html/include/db/db.php on line 267
db.class.php Error:
Out of sort memory, consider increasing server sort buffer size
Last SQL Query :
SELECT ci.*
, cp.catalogue_price_price, cp.catalogue_price_price_disc1, cp.catalogue_price_price_disc2, '' as cp2ai1title , cg.catalogue_group_alias, cg.catalogue_group_title, cg.catalogue_group_id FROM binnova_catalogue_item ci INNER JOIN binnova_catalogue_price cp ON cp.catalogue_item_id = ci.catalogue_item_id LEFT JOIN binnova_catalogue_group2item as cg2i ON ci.catalogue_item_id = cg2i.catalogue_item_id LEFT JOIN binnova_catalogue_group as cg ON cg.catalogue_group_id = cg2i.catalogue_group_id WHERE 1 = 1
AND cg2i.catalogue_group2item_primary = 1 AND EXISTS( SELECT *
FROM binnova_catalogue_group2item as cg2i
WHERE ci.catalogue_item_id = cg2i.catalogue_item_id
AND cg2i.catalogue_group_id IN ( 1,353,356,371,376,377,379,383,354,355,357,358,364,363,384,368,369,370,378,372,373,374,375,382,385,386,387) ) AND ci.catalogue_item_visible = 1 ORDER BY ci.catalogue_item_title ASC, ci.catalogue_item_id ASC LIMIT 0, 10
Trace:
#0  db->print_last_error() called at [/home/binnova/public_html/include/db/db.php:117]
#1  db->last_error(Out of sort memory, consider increasing server sort buffer size) called at [/home/binnova/public_html/include/db/db.php:278]
#2  db->select(SELECT ci.* 
, cp.catalogue_price_price, cp.catalogue_price_price_disc1, cp.catalogue_price_price_disc2, '' as cp2ai1title , cg.catalogue_group_alias, cg.catalogue_group_title, cg.catalogue_group_id  FROM binnova_catalogue_item ci  INNER JOIN  binnova_catalogue_price cp ON cp.catalogue_item_id = ci.catalogue_item_id LEFT JOIN binnova_catalogue_group2item as cg2i ON ci.catalogue_item_id  = cg2i.catalogue_item_id LEFT JOIN binnova_catalogue_group as cg   ON cg.catalogue_group_id = cg2i.catalogue_group_id   WHERE 1 = 1 
 AND cg2i.catalogue_group2item_primary = 1  AND EXISTS( SELECT *
										 FROM  binnova_catalogue_group2item as cg2i 
										 WHERE ci.catalogue_item_id = cg2i.catalogue_item_id 
						    AND cg2i.catalogue_group_id IN ( 1,353,356,371,376,377,379,383,354,355,357,358,364,363,384,368,369,370,378,372,373,374,375,382,385,386,387) )  AND ci.catalogue_item_visible = 1 ORDER BY ci.catalogue_item_title ASC, ci.catalogue_item_id ASC LIMIT 0, 10) called at [/home/binnova/public_html/include/db/table.catalogue_item.php:283]
#3  db_catalogue_item_adapter->GetList(, ci.catalogue_item_title ASC, ci.catalogue_item_id ASC, Array ([start] => 0,[records] => 10), Array ([0] => 1,[1] => 353,[2] => 356,[3] => 371,[4] => 376,[5] => 377,[6] => 379,[7] => 383,[8] => 354,[9] => 355,[10] => 357,[11] => 358,[12] => 364,[13] => 363,[14] => 384,[15] => 368,[16] => 369,[17] => 370,[18] => 378,[19] => 372,[20] => 373,[21] => 374,[22] => 375,[23] => 382,[24] => 385,[25] => 386,[26] => 387), , 1, -1, , Array (), , -1, -1, , Array (), Array ()) called at [/home/binnova/public_html/include/db/table.catalogue_item.php:1138]
#4  db_catalogue_item_list->GenerateList(ci.catalogue_item_title ASC, ci.catalogue_item_id ASC, Array ([start] => 0,[records] => 10), Array ([0] => 1,[1] => 353,[2] => 356,[3] => 371,[4] => 376,[5] => 377,[6] => 379,[7] => 383,[8] => 354,[9] => 355,[10] => 357,[11] => 358,[12] => 364,[13] => 363,[14] => 384,[15] => 368,[16] => 369,[17] => 370,[18] => 378,[19] => 372,[20] => 373,[21] => 374,[22] => 375,[23] => 382,[24] => 385,[25] => 386,[26] => 387), , 1, -1, , Array ()) called at [/home/binnova/public_html/include/modules/catalogue/controller/catalogue.php:938]
#5  Page_Catalogue->view_item_list(Array ([0] => 1,[1] => 353,[2] => 356,[3] => 371,[4] => 376,[5] => 377,[6] => 379,[7] => 383,[8] => 354,[9] => 355,[10] => 357,[11] => 358,[12] => 364,[13] => 363,[14] => 384,[15] => 368,[16] => 369,[17] => 370,[18] => 378,[19] => 372,[20] => 373,[21] => 374,[22] => 375,[23] => 382,[24] => 385,[25] => 386,[26] => 387)) called at [/home/binnova/public_html/include/modules/catalogue/controller/catalogue.php:614]
#6  Page_Catalogue->view_list_bygroup(Array ([options] => Array ([0] => Array ([name] => type,[value] => 0),[1] => Array ([name] => groupid,[value] => 1)))) called at [/home/binnova/public_html/include/modules/pagemanager/controller/pagemanager.php:850]
#7  PageManager->module_load(catalogue, view_list_bygroup, Array ([options] => Array ([0] => Array ([name] => type,[value] => 0),[1] => Array ([name] => groupid,[value] => 1)))) called at [/home/binnova/public_html/include/modules/pagemanager/controller/pagemanager.php:671]
#8  PageManager->load() called at [/home/binnova/public_html/index.php:44]
db.class.php Error:
Invalid resource identifier passed to get_row() function.
Last SQL Query :
SELECT ci.*
, cp.catalogue_price_price, cp.catalogue_price_price_disc1, cp.catalogue_price_price_disc2, '' as cp2ai1title , cg.catalogue_group_alias, cg.catalogue_group_title, cg.catalogue_group_id FROM binnova_catalogue_item ci INNER JOIN binnova_catalogue_price cp ON cp.catalogue_item_id = ci.catalogue_item_id LEFT JOIN binnova_catalogue_group2item as cg2i ON ci.catalogue_item_id = cg2i.catalogue_item_id LEFT JOIN binnova_catalogue_group as cg ON cg.catalogue_group_id = cg2i.catalogue_group_id WHERE 1 = 1
AND cg2i.catalogue_group2item_primary = 1 AND EXISTS( SELECT *
FROM binnova_catalogue_group2item as cg2i
WHERE ci.catalogue_item_id = cg2i.catalogue_item_id
AND cg2i.catalogue_group_id IN ( 1,353,356,371,376,377,379,383,354,355,357,358,364,363,384,368,369,370,378,372,373,374,375,382,385,386,387) ) AND ci.catalogue_item_visible = 1 ORDER BY ci.catalogue_item_title ASC, ci.catalogue_item_id ASC LIMIT 0, 10
Trace:
#0  db->print_last_error() called at [/home/binnova/public_html/include/db/db.php:117]
#1  db->last_error(Invalid resource identifier passed to get_row() function.) called at [/home/binnova/public_html/include/db/db.php:330]
#2  db->get_row(, MYSQL_ASSOC) called at [/home/binnova/public_html/include/db/table.catalogue_item.php:1156]
#3  db_catalogue_item_list->GenerateList(ci.catalogue_item_title ASC, ci.catalogue_item_id ASC, Array ([start] => 0,[records] => 10), Array ([0] => 1,[1] => 353,[2] => 356,[3] => 371,[4] => 376,[5] => 377,[6] => 379,[7] => 383,[8] => 354,[9] => 355,[10] => 357,[11] => 358,[12] => 364,[13] => 363,[14] => 384,[15] => 368,[16] => 369,[17] => 370,[18] => 378,[19] => 372,[20] => 373,[21] => 374,[22] => 375,[23] => 382,[24] => 385,[25] => 386,[26] => 387), , 1, -1, , Array ()) called at [/home/binnova/public_html/include/modules/catalogue/controller/catalogue.php:938]
#4  Page_Catalogue->view_item_list(Array ([0] => 1,[1] => 353,[2] => 356,[3] => 371,[4] => 376,[5] => 377,[6] => 379,[7] => 383,[8] => 354,[9] => 355,[10] => 357,[11] => 358,[12] => 364,[13] => 363,[14] => 384,[15] => 368,[16] => 369,[17] => 370,[18] => 378,[19] => 372,[20] => 373,[21] => 374,[22] => 375,[23] => 382,[24] => 385,[25] => 386,[26] => 387)) called at [/home/binnova/public_html/include/modules/catalogue/controller/catalogue.php:614]
#5  Page_Catalogue->view_list_bygroup(Array ([options] => Array ([0] => Array ([name] => type,[value] => 0),[1] => Array ([name] => groupid,[value] => 1)))) called at [/home/binnova/public_html/include/modules/pagemanager/controller/pagemanager.php:850]
#6  PageManager->module_load(catalogue, view_list_bygroup, Array ([options] => Array ([0] => Array ([name] => type,[value] => 0),[1] => Array ([name] => groupid,[value] => 1)))) called at [/home/binnova/public_html/include/modules/pagemanager/controller/pagemanager.php:671]
#7  PageManager->load() called at [/home/binnova/public_html/index.php:44]
Ponudba | B-innova
Ponudba