LamozSt3D Posted January 30, 2015 Share Posted January 30, 2015 Hello !! I would like to know how to fix this error [PrestaShopDatabaseException] Column 'id' in field list is ambiguous SELECT COUNT(`id`) FROM `ps_simpleauction_auction_winner` w LEFT JOIN `ps_simpleauction_auction` a ON (a.`id` = w.`id_auction`) WHERE `id_customer`='3' AND a.`id_shop` = '1' LIMIT 1 at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$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 547 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 572 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 191 - modules/auction/models/bidder.php] - [1 Arguments] SimpleAuctionBidder->getWonAuctionsCount - [line 75 - cache/smarty/compile/57/02/5d/57025df9af64b669bb4b714a66768777a1dd18a4.file.account.tpl.php] content_54ca5a76608347_14102004 - [line 180 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments] Smarty_Internal_TemplateBase->fetch - [line 553 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->display - [line 198 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
Recommended Posts