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 :)

[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.