Error 500 on opening a folder (synced with clientsync's)

[julienfastre]

Hi,

I get a "error 500" when opening a folder which is synced between different computer with an owncloud's client.

This is the error in the error log :

[Tue Nov 20 16:19:34 2012] [error] [client xx.xx.xx.xx] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42703]: Undefined column: 7 ERROR: column "/Shared" does not exist\nLINE 1: DELETE FROM "oc_properties" WHERE "propertypath" = "/Shared"\n ^' in /srv/www/cloud/owncloud-4.5.2/owncloud/lib/db.php:738\nStack trace:\n#0 /srv/www/cloud/owncloud-4.5.2/owncloud/lib/db.php(738): PDOStatement->execute()\n#1 /srv/www/cloud/owncloud-4.5.2/owncloud/lib/connector/sabre/node.php(283): PDOStatementWrapper->execute(Array)\n#2 /srv/www/cloud/owncloud-4.5.2/owncloud/lib/filesystem.php(569): OC_Connector_Sabre_Node::removeETagPropertyForPath('/julien/files_v...')\n#3 /srv/www/cloud/owncloud-4.5.2/owncloud/lib/filesystemview.php(456): OC_Filesystem::removeETagHook(Array, '/julien')\n#4 /srv/www/cloud/owncloud-4.5.2/owncloud/apps/files_versions/lib/versions.php(116): OC_FilesystemView->copy('files/clientsyn...', 'files_versions/...')\n#5 /srv/www/cloud/owncloud-4.5.2/owncloud/apps/files_versions/lib/hooks.php(28): OCA_Versi in /srv/www/cloud/owncloud-4.5.2/owncloud/lib/db.php on line 738

I use owncloud 4.5.2 with php 5.3 and postgresql 9.1.

I checked in the table "oc_properties" and there isn't any row where propertypath is like /Shared.

But I think there is an error in the sql syntax: it should be

DELETE FROM "oc_properties" WHERE "propertypath" = '/Shared'; #use of single quotes around the property 

instead of ...

-- wrong
DELETE FROM "oc_properties" WHERE "propertypath" ="/Shared"; #use of double quotes

But it is strange to see that I can still open other folders, which were not synced. But I cannot sync my folder between computers.

[eMerzh]

Thanks for your report ;)

it has already been fixed ... in #430 :).... but not yet released i think :/

sorry for the inconvenience

[julienfastre]

@eMerzh : I applied the patch you proposed in issue #430 and it seems to work now.

Thanks a lot !