hypery2k/owncloud — pull request #37 by djboris9 (2012-08-26 17:55:42+00:00)
Title: Roundcube: Added doublequotes to SQL statements

Hi there

If Owncloud is configured to use a PostgreSQL DB and the "Roundcube" app is installed, it will show a blank-site on "Personal" and "Webmail". This is the result of an SQL Exception like this:
Undefined column: 7 ERROR: column "ocuser" does not exist\nLINE 1: SELECT id FROM oc_roundcube WHER
E ocUser = 'djboris'\n ^' in /var/www/owncloud/lib/db.php:600\nStack trace:\n#0 /var/www/owncloud/lib/db.php(600): PDOStatement->execute()\n#1 /var/www/owncloud/apps/roundcube/lib/mail.php(39): PD
OStatementWrapper->execute()\n#2 /var/www/owncloud/apps/roundcube/lib/mail.php(69): OC_RoundCube_App::existLoginData('djboris')
...........

The solution is: Add doublequotes to columnnames in SQL statements, which I've done.

Please commit this patch.

Thanks
DjBoris