MYSQL CLIENT ERROR : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'position' in 'order clause' // SELECT id,rank,parentId,name_fr,name_de,name_en,name_es,name_it,name_nl,name_hu,name_pl,name_pt,name_ro,name_cz,name_sk,status,tags,dateInsert,dateUpdate,author,lastAuthor,authorId,lastAuthorId,serial,data,urlKey_fr,urlKey_de,urlKey_en,urlKey_es,urlKey_it,urlKey_nl,urlKey_hu,urlKey_pl,urlKey_pt,urlKey_ro,urlKey_cz,urlKey_sk,link,isToRegister,metaTitle_fr,metaTitle_de,metaTitle_en,metaTitle_es,metaTitle_it,metaTitle_nl,metaTitle_hu,metaTitle_pl,metaTitle_pt,metaTitle_ro,metaTitle_cz,metaTitle_sk,metaDesc_fr,metaDesc_de,metaDesc_en,metaDesc_es,metaDesc_it,metaDesc_nl,metaDesc_hu,metaDesc_pl,metaDesc_pt,metaDesc_ro,metaDesc_cz,metaDesc_sk,(SELECT image FROM productImageGalleries WHERE ref=saleProducts.refImages) AS image,description_fr,description_de,description_en,description_es,description_it,description_nl,description_hu,description_pl,description_pt,description_ro,description_cz,description_sk,shortDescription_fr,shortDescription_de,shortDescription_en,shortDescription_es,shortDescription_it,shortDescription_nl,shortDescription_hu,shortDescription_pl,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) AS averageRating,(SELECT COUNT(*) FROM customerReviews WHERE ref=saleProducts.refData) 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,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,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,stockUK,sport,size,type,hasOptions FROM saleProducts WHERE (CONCAT('/saleProduct/',id) IN (SELECT saleProduct FROM productCatAttachments WHERE saleCategory='/saleCategory/105') AND (3 IN (SELECT DISTINCT(orderChannel) FROM saleProductOffers WHERE saleProduct=saleProducts.id))) AND (status=1) ORDER BY position 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 55

Fatal error: Uncaught Error: Call to a member function html() on null in /application/specific/blocks/productsBlock.php:90 Stack trace: #0 /application/specific/classes/hook.php(217): 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(104): section::show() #4 /application/core/php/sz-body.php(5): template->show() #5 /application/specific/classes/app.php(527): include_once('/application/co...') #6 /application/core/classes/page.php(202): app::obload() #7 /application/specific/classes/app.php(477): page->showContent() #8 /application/index.php(10): app->content() #9 {main} thrown in /application/specific/blocks/productsBlock.php on line 90