MPeiro Posted November 17, 2015 Share Posted November 17, 2015 Desde hace dos dias la importacion de productos desde un CSV me da este error [PrestaShopDatabaseException]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `ps_feature` SET `position` = @i:=@i+1 ORDER BY `position` ASC' at line 1 SET @i = -1; UPDATE `ps_feature` SET `position` = @i:=@i+1 ORDER BY `position` ASCat line 765 in file classes/db/Db.php 760. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);761. }762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))763. {764. if ($sql)765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');766.767. throw new PrestaShopDatabaseException($this->getMsgError());768. }769. }770. DbCore->displayError - [line 418 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 578 - classes/db/Db.php] - [1 Arguments] DbCore->execute - [line 318 - classes/Feature.php] - [1 Arguments] FeatureCore::cleanPositions - [line 1831 - controllers/admin/AdminImportController.php] AdminImportControllerCore->productImport - [line 3461 - controllers/admin/AdminImportController.php] AdminImportControllerCore->postProcess - [line 171 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php] Alguien me puede ayudar? Link to comment Share on other sites More sharing options...
lbviaevista Posted November 24, 2015 Share Posted November 24, 2015 I have the same problem. Please Help Link to comment Share on other sites More sharing options...
lbviaevista Posted November 25, 2015 Share Posted November 25, 2015 Hi, I have resolve the problem. I have update my prestashop version and no problem after. My actual version is 1.6.1.2. Good luck Link to comment Share on other sites More sharing options...
Recommended Posts