appdb : database error for screenshots

[T'aZ]

hi

in the The top-10 Gold List from http://appdb.winehq.org/
all links to the screenshots returns with an error : 
Database Error!
Query: SELECT appData.*, appVersion.appId as appId FROM appData,
appVersion WHERE appVersion.versionId = appData.versionId AND type =
'image' AND appId = 1533
Column: 'appId' in where clause is ambiguous

easy to spot and easy to fix i hope :)

-- 
T'aZ |Jabber:taz-007(a)jabber.org|GPG keyID:E051925D|http://taz.prout.be
*They that can give up essential liberty to obtain a little temporary
 safety deserve neither liberty nor safety.*  Benjamin Franklin 1759
*Beaucoup,vite,loin,mal.*  http://www.cl.cam.ac.uk/~rja14/tcpa-faq.html

[Jonathan Ernst]

Le lundi 07 février 2005 à 01:57 +0100, T'aZ a écrit :
> hi
>
> in the The top-10 Gold List from http://appdb.winehq.org/
> all links to the screenshots returns with an error : 
> Database Error!
> Query: SELECT appData.*, appVersion.appId as appId FROM appData,
> appVersion WHERE appVersion.versionId = appData.versionId AND type =
> 'image' AND appId = 1533
> Column: 'appId' in where clause is ambiguous
>
> easy to spot and easy to fix i hope :)

Thanks it was caused by the re-adding of the appid column in appdata.

=> I sent a patch.