Co w tym zapytaniu jest źle?

[Zbyszekk]

$this->DB->build(array(

'select' => '*',

'from' => array( 'LSPD_culprit' => 'c' ),

'where' => 'uid = "'.$this->request['uid'].'"',

'add_join' => array( 0 => array(

'select' => 'o.nick',

'from' => array( 'LSPD_officers' => 'o' ),

'where' => 'o.uid = c.officer ',

'type' => 'inner' ) )

));

[DawPi]

Jaki jest zgłaszany błąd?

[Zbyszekk]

Wyskakuje błąd bazy danych. Mam dwie tabele. IPB_LSPD_culprit i IPB_LSPD_officers

[DawPi]

Jaki błąd?

[Zbyszekk]

No bazy danych. Nie pisze co dokładnie. 

[DawPi]

To sprawdź, nie mamy szklanej kuli.

 

http://forum.invisionize.pl/tutorials/article/11-blad-na-forum-ips-driver-error/

[Zbyszekk]

Nie wiedziałem nawet o tym ;p 

 Date: Sat, 02 Nov 2013 12:03:33 +0000
 Error: 1052 - Column 'uid' in where clause is ambiguous
 IP Address: 93.179.213.202 - /index.php?app=lspd&module=database&section=seeculprit&uid=1
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT *,o.nick FROM IPB_LSPD_culprit c,IPB_LSPD_officers o WHERE uid = "1" AND o.uid = c.officer 
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsController.php                                       | [public_lspd_database_seeculprit].doExecute                                   | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

[DawPi]

Zmień:

'where'  => 'uid = "'.$this->request['uid'].'"',

Na:

'where'  => 'c.uid = "'.$this->request['uid'].'"',

[Zbyszekk]

Wiem, zdążyłem w logach dostrzec. 

[DawPi]

Nie ma za co.