[Bug 2703] New: SQL errors

Wine Bugs wine-bugs at winehq.org
Sun Feb 6 13:52:55 CST 2005


           Summary: SQL errors
           Product: WineHQ Apps Database
           Version: unspecified
          Platform: Other
               URL: http://appdb.winehq.org/
        OS/Version: other
            Status: NEW
          Severity: normal
          Priority: P2
         Component: website-bugs
        AssignedTo: wine-bugs at winehq.org
        ReportedBy: jargonautti at hotmail.com

the address "http://appdb.winehq.org/" gives alternatively lots of red-colored
SQL error messages, or a weird-looking page (all columns blank except the last,
which says either application name or something like "screenshot").

Based on error message I'd say that it's in the "AND id = AND" part - you might
want to specify the ID :).

Example of SQL error (there's lots of these in red boxes, one under another):

Database Error!
Query: SELECT appData.*, appVersion.appId AS appId FROM appData, appVersion
WHERE appData.versionId = appVersion.versionId AND id = AND type = 'image'
You have an error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND type = 'image'' at line 5

Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

More information about the wine-bugs mailing list