Jump to content

neocreations

Members
  • Posts

    4
  • Joined

  • Last visited

Profile Information

  • Location
    Italy
  • Activity
    Freelancer

neocreations's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Buongiorno a tutti, vi siete mai imbattuti su questo genere di problema: Ho già recuperato due backup, ma dopo un aggiornamento di un modulo oppure ho pulito la cache, ritorna questo problema. Grazie.
  2. Hi everybody I have an e-commerce website with PS 1.6.0.8. The web space and the database have been upgraded. Now you no longer see the Front Office and the "products" page of the Back Office. This error appears: -------- [PrestaShopDatabaseException] Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamercer94089.pd.nb_downloadable' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT SQL_CALC_FOUND_ROWS a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active , shop.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` as sav_quantity, sa.`active`, IF(sav.`quantity`<=0, 1, 0) badge_danger FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product`) LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default) LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default) LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default) LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`) WHERE 1 GROUP BY sa.id_product ORDER BY a.`id_product` ASC LIMIT 0,50 at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 630. } 631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 632. { 633. if ($sql) 634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); 636. } 637. } 638. 639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 2791 - classes/controller/AdminController.php] - [3 Arguments] AdminControllerCore->getList - [line 358 - controllers/admin/AdminProductsController.php] - [6 Arguments] AdminProductsControllerCore->getList - [line 1992 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->renderList - [line 2431 - controllers/admin/AdminProductsController.php] AdminProductsControllerCore->renderList - [line 1768 - classes/controller/AdminController.php] AdminControllerCore->initContent - [line 2362 - controllers/admin/AdminProductsController.php] AdminProductsControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php] ------ The technical service of the hosting writes me that the problem is the query not compatible with the "strict mode" of MySQL 5.7. How do I solve? Thank you Sorry for my bad english.
  3. Buongiorno a tutti, ho un problema occorso dopo la migrazione da parte del provider dello spazio web e del database. Per aumentare le performance e la velocità di un e-commerce PS 1.6.0.8 , il provider dell'hosting ha effettuato un upgrade verso una nuova piattaforma. Successivamente a questo non si visualizzano più alcune pagine, tra cui tutto il FO e le pagine dei prodotti e delle statistiche nel BO. L'errore restituito è questo (in particolare questo riguarda le statistiche): " [PrestaShopDatabaseException] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lamercer94089.h.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT h.`name` AS hook, m.`name` FROM `ps_module` m LEFT JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` LEFT JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE h.`name` LIKE 'displayAdminStatsModules' AND m.`active` = 1 GROUP BY hm.id_module ORDER BY hm.`position` at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 630. } 631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 632. { 633. if ($sql) 634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); 636. } 637. } 638. 639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 193 - controllers/admin/AdminStatsTabController.php] - [1 Arguments] AdminStatsTabControllerCore->getModules - [line 152 - controllers/admin/AdminStatsTabController.php] AdminStatsTabControllerCore->displayMenu - [line 54 - controllers/admin/AdminStatsTabController.php] AdminStatsTabControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php] "" Il supporto dell'hosting mi ha scritto che la query non è compatibile con lo strict mode di MySQL 5.7. Avete qualche idea da darmi per venirne fuori. Grazie in anticipo.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More