Error: the following database error occured:Close
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
The query that caused the error is:
SELECT GROUP_CONCAT(parent_key ORDER BY IF(NOT ISNULL(publicatiedatum),publicatiedatum,'1970-01-01') DESC, title ASC) AS p FROM t_bestelitems_cache WHERE version='published' AND site='nt2' AND parent_key IN ( SELECT CONCAT('p',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id) INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id) INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id) INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id) INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id) INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id) INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id) WHERE c1.page_element='product' AND c1.value = 696 AND c1.version='published' AND c2.value = 719 AND c2.version='published' AND c3.value = 669 AND c3.version='published' AND c4.value = 734 AND c4.version='published' AND c5.value = 717 AND c5.version='published' AND c6.value = 702 AND c6.version='published' AND c7.value = 716 AND c7.version='published' AND c8.value = 680 AND c8.version='published' UNION SELECT CONCAT('g',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id) INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id) INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id) INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id) INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id) INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id) INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id) WHERE c1.page_element='productgroep' AND c1.value = 696 AND c1.version='published' AND c2.value = 719 AND c2.version='published' AND c3.value = 669 AND c3.version='published' AND c4.value = 734 AND c4.version='published' AND c5.value = 717 AND c5.version='published' AND c6.value = 702 AND c6.version='published' AND c7.value = 716 AND c7.version='published' AND c8.value = 680 AND c8.version='published' UNION SELECT CONCAT('x',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id) INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id) INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id) INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id) INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id) INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id) INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id) WHERE c1.page_element='promoitem' AND c1.value = 696 AND c1.version='published' AND c2.value = 719 AND c2.version='published' AND c3.value = 669 AND c3.version='published' AND c4.value = 734 AND c4.version='published' AND c5.value = 717 AND c5.version='published' AND c6.value = 702 AND c6.version='published' AND c7.value = 716 AND c7.version='published' AND c8.value = 680 AND c8.version='published' UNION SELECT CONCAT('s',c1.datasource_id) FROM u_facet_cache c1 INNER JOIN u_facet_cache c2 ON (c1.page_element=c2.page_element AND c1.datasource_id = c2.datasource_id) INNER JOIN u_facet_cache c3 ON (c1.page_element=c3.page_element AND c1.datasource_id = c3.datasource_id) INNER JOIN u_facet_cache c4 ON (c1.page_element=c4.page_element AND c1.datasource_id = c4.datasource_id) INNER JOIN u_facet_cache c5 ON (c1.page_element=c5.page_element AND c1.datasource_id = c5.datasource_id) INNER JOIN u_facet_cache c6 ON (c1.page_element=c6.page_element AND c1.datasource_id = c6.datasource_id) INNER JOIN u_facet_cache c7 ON (c1.page_element=c7.page_element AND c1.datasource_id = c7.datasource_id) INNER JOIN u_facet_cache c8 ON (c1.page_element=c8.page_element AND c1.datasource_id = c8.datasource_id) WHERE c1.page_element='product_set' AND c1.value = 696 AND c1.version='published' AND c2.value = 719 AND c2.version='published' AND c3.value = 669 AND c3.version='published' AND c4.value = 734 AND c4.version='published' AND c5.value = 717 AND c5.version='published' AND c6.value = 702 AND c6.version='published' AND c7.value = 716 AND c7.version='published' AND c8.value = 680 AND c8.version='published' )
Technical info:
[1] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_DB.php, line: 97, function: C_DB::reportQueryError
[2] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_DB.php, line: 146, function: C_DB::executeQuery
[3] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_DB.php, line: 246, function: C_DB::fetchSingleRow
[4] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/page_elements/product_overzicht/class_product_overzicht.php, line: 353, function: C_DB::getFieldValue
[5] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/page_elements/product_overzicht/class_product_overzicht.php, line: 211, function: C_ProductOverzicht->initResults
[6] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_Node.php, line: 59, function: C_ProductOverzicht->__construct
[7] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_Node.php, line: 17, function: C_Node->readBlockData
[8] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_Page.php, line: 312, function: C_Node->__construct
[9] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_Page.php, line: 185, function: C_Page->readChildnodes
[10] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/xsite/classes/C_Page.php, line: 196, function: C_Page->prepare
[11] /home/stag/domains/webshop40.staging-freshbits.nl/public_html/index.php, line: 140, function: C_Page->renderPage