TDbCommand failed to execute the query SQL "SELECT id, title FROM bfb_champions t LEFT JOIN bfb_champions_success ts ON (t.id = ts.champion_id) LEFT JOIN bfb_champions_en tl ON (t.id = tl.champion_id) WHERE t.flag&3=2 GROUP BY t.id ORDER BY position ASC ": SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous
/home/bulwrest/public_html/framework/Data/TDbCommand.php (230)
0219: try
0220: {
0221: // Prado::trace('Query: '.$this->getDebugStatementText(), 'System.Data');
0222: if($this->_statement instanceof PDOStatement)
0223: $this->_statement->execute();
0224: else
0225: $this->_statement=$this->getConnection()->getPdoInstance()->query($this->getText());
0226: return new TDbDataReader($this);
0227: }
0228: catch(Exception $e)
0229: {
0230: throw new TDbException('dbcommand_query_failed',$e->getMessage(),$this->getDebugStatementText());
0231: }
0232: }
0233:
0234: /**
0235: * Executes the SQL statement and returns the first row of the result.
0236: * This is a convenient method of {@link query} when only the first row of data is needed.
0237: * @param boolean whether the row should be returned as an associated array with
0238: * column names as the keys or the array keys are column indexes (0-based).
0239: * @return array the first row of the query result, false if no result.
0240: * @throws TDbException execution failed
0241: */
0242: public function queryRow($fetchAssociative=true)
#0 /home/bulwrest/public_html/engine/Plugins/Custom/Champions/ChampionsModel.php(202): TDbCommand->query()
#1 /home/bulwrest/public_html/engine/Plugins/Core/Item/ItemController.php(588): ChampionsModel->getHomeItems(Array)
#2 /home/bulwrest/public_html/protected/Pages/Sitemap.php(45): ItemController->getItemsForMenu(Array)
#3 /home/bulwrest/public_html/protected/Pages/Sitemap.php(22): Sitemap->setData()
#4 /home/bulwrest/public_html/framework/pradolite.php(4187): Sitemap->onInit(NULL)
#5 /home/bulwrest/public_html/framework/pradolite.php(5558): TControl->initRecursive(NULL)
#6 /home/bulwrest/public_html/framework/pradolite.php(5674): TCompositeControl->initRecursive(NULL)
#7 /home/bulwrest/public_html/framework/pradolite.php(6208): TTemplateControl->initRecursive()
#8 /home/bulwrest/public_html/framework/pradolite.php(6203): TPage->processNormalRequest(Object(THtmlWriter))
#9 /home/bulwrest/public_html/framework/pradolite.php(8323): TPage->run(Object(THtmlWriter))
#10 /home/bulwrest/public_html/framework/pradolite.php(8289): TPageService->runPage(Object(Sitemap), Array)
#11 /home/bulwrest/public_html/framework/pradolite.php(9269): TPageService->run()
#12 /home/bulwrest/public_html/framework/pradolite.php(8871): TApplication->runService()
#13 /home/bulwrest/public_html/index.php(28): TApplication->run()
#14 {main}