owncloud 5 RC1 pgsql Export User Account

[hellweiss]

Hi,

exporting a User Account hangs with pgsql Database:

{"app":"PHP","message":"SQLSTATE[42883]: Undefined function: 7 FEHLER: Operator existiert nicht: integer ~~ unknown\nLINE 1: ...LECT * FROM "oc_calendar_objects" WHERE "calendarid" LIKE $1\n ^\nHINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen \u00fcberein. Sie m\u00fcssen m\u00f6glicherweise ausdr\u00fcckliche Typumwandlungen hinzuf\u00fcgen. at /var/www/owncloud/lib/db.php#963","level":4,"time":1362398005}

Looks like the same error we had with user_ldap app not sure.

[karlitschek]

@eMerzh Do you have an idea? :-)

[eMerzh]

i look a this tonight when i'm back home ... but yeah it looks like the same kind of problem...
(btw @hellweiss ... it's easier if errors are in english :p fortunately i have google translate :p )

[hellweiss]

Sorry, that's what I got in the logs, how do I switch ?!?
I guess, the Import Account needs some love too. Will test, when the Export works.

[BernhardPosselt]

Quick grep: calendar/appinfo/migrate.php:

$query = $this->content->prepare( 'SELECT * FROM `calendar_objects` WHERE `calendarid` LIKE ?' );

Very likely missing a wildcard % in the argument.

SELECT * FROM Persons
WHERE City LIKE '%s'

I dont think LIKE is the sql that you want to use here, id use =

Also you cant use LIKE with integers since it doesnt make sense. Thats the error OP is getting

[BernhardPosselt]

cc @georgehrke

[eMerzh]

@DeepDiver1975 can we close this?