MYSQL CLIENT ERROR : SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress // SELECT id,rank,parentId,name_en,name_fr,name_de,name_nl,name_hu,name_it,name_pl,name_es,name_pt,name_ro,name_cz,name_sk,status,tags,dateInsert,dateUpdate,author,lastAuthor,authorId,lastAuthorId,serial,data,urlKey_en,urlKey_fr,urlKey_de,urlKey_nl,urlKey_hu,urlKey_it,urlKey_pl,urlKey_es,urlKey_pt,urlKey_ro,urlKey_cz,urlKey_sk,link,isToRegister,metaTitle_en,metaTitle_fr,metaTitle_de,metaTitle_nl,metaTitle_hu,metaTitle_it,metaTitle_pl,metaTitle_es,metaTitle_pt,metaTitle_ro,metaTitle_cz,metaTitle_sk,metaDesc_en,metaDesc_fr,metaDesc_de,metaDesc_nl,metaDesc_hu,metaDesc_it,metaDesc_pl,metaDesc_es,metaDesc_pt,metaDesc_ro,metaDesc_cz,metaDesc_sk,(SELECT image FROM productImageGalleries WHERE ref=saleProducts.refImages) AS image,description_en,description_fr,description_de,description_nl,description_hu,description_it,description_pl,description_es,description_pt,description_ro,description_cz,description_sk,shortDescription_en,shortDescription_fr,shortDescription_de,shortDescription_nl,shortDescription_hu,shortDescription_it,shortDescription_pl,shortDescription_es,shortDescription_pt,shortDescription_ro,shortDescription_cz,shortDescription_sk,categoryId,(saleProducts.ref) AS sku,purchasePrice,price,discount,productType,weight,stock,canBeOrderedOutOfStock,shippingDelayOutOfStock,shippingDelayInStock,ean,ref,refImages,refData,refTechnicalSheet,refInstructionSheet,(SELECT id FROM saleProductDatas WHERE ref=saleProducts.refData) AS saleProductData,(SELECT ROUND(SUM(rating)/COUNT(*),1) FROM customerReviews WHERE ref=saleProducts.refData AND customerReviews.dateInsert < CURDATE()) AS averageRating,(SELECT COUNT(*) FROM customerReviews WHERE ref=saleProducts.refData AND customerReviews.dateInsert < CURDATE()) AS numberRatings,(SELECT id FROM technicalSheets WHERE ref=saleProducts.refTechnicalSheet) AS technicalSheet,(SELECT id FROM instructionSheets WHERE ref=saleProducts.refInstructionSheet) AS instructionSheet,bestSeller,saleCategory,composition,optionProducts,substitutionProducts,brand,(SELECT secondaryImages FROM productImageGalleries WHERE ref=saleProducts.refImages) AS otherImages,(SELECT videos FROM productImageGalleries WHERE ref=saleProducts.refImages) AS videos,(SELECT videoFiles FROM productImageGalleries WHERE ref=saleProducts.refImages) AS videoFiles,grossWeight,netWeight,width,length,height,color_en,color_fr,color_de,color_nl,color_hu,color_it,color_pl,color_es,color_pt,color_ro,color_cz,color_sk,shippingTime,(SELECT GROUP_CONCAT(DISTINCT(SELECT name_en FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) AS orderChannels,(SELECT GROUP_CONCAT(DISTINCT(SELECT image FROM orderChannels WHERE id=saleProductOffers.orderChannel)) FROM saleProductOffers WHERE saleProduct=saleProducts.id) AS orderChannelsLogos,stockEU,normalPrice,discountPrice,netPrice,publicPrice,hasOptions,features FROM saleProducts WHERE (CONCAT('/saleProduct/',id) IN (
SELECT saleProduct
FROM productCatAttachments
WHERE saleCategory='/saleCategory/90'
)
AND status!=0
AND (
SELECT COUNT(*)
FROM saleProductOffers
WHERE saleProduct=saleProducts.id
AND orderChannel=3
AND marketplace IN ('eu', 'it')
) > 0) AND (status=1) ORDER BY ref ASC LIMIT 16 OFFSET 0
[{Classement::fr}] :
[{Référence::fr}]
[{Nouveautés::fr}]
Notice: Trying to get property 'totalPages' of non-object in
/application/specific/blocks/productsBlock.php on line
78
Fatal error: Uncaught Error: Call to a member function html() on null in /application/specific/blocks/productsBlock.php:125
Stack trace:
#0 /application/specific/classes/hook.php(235): productsBlock::show()
#1 /application/core/classes/section.php(53): hook->show()
#2 /application/core/classes/section.php(25): section::getInbound()
#3 /application/core/classes/template.php(110): section::show()
#4 /application/specific/php/sz-body.php(11): template->show()
#5 /application/specific/classes/app.php(620): include_once('/application/sp...')
#6 /application/core/classes/page.php(203): app::obload()
#7 /application/specific/classes/app.php(572): page->showContent()
#8 /application/index.php(10): app->content()
#9 {main}
thrown in /application/specific/blocks/productsBlock.php on line 125