Nextcloud circles Database error

Apps & App Center
1

Hello, unfortunately we have a database error since the last update when we add people to circles in the nextcloud.

Das Mitglied ‘Tester’ konnte nicht zum Kreis eingeladen werden: An exception occurred while executing ‘SELECT “m”.“user_id”, “m”.“user_type”, “m”.“circle_id”, “m”.“level”, “m”.“status”, “m”.“note”, “m”.“joined” FROM “oc_circles_members” “m” WHERE ((“m”.“status” = ?) OR (“m”.“status” = ?) OR (“m”.“status” = ?)) AND (“m”.“level” >= ?) AND (“m”.“circle_id” = ?) ORDER BY “m”.“joined” ASC’ with params [“Member”, “Invited”, “Requesting”, “Member”, “121dd980e112c4”]: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ungültige Eingabesyntax für ganze Zahl: »Member«

The other connection to LDAP runs wonderfully.

Kind regards from Niebüll
Holger Jessen-Thiesen

2

Hi,

as this looks rather an generic Nextcloud issue than something related to be specific on UCS I had a quick look at the usual Nextcloud places and found adding user to circle causes sql error · Issue #227 · nextcloud/circles · GitHub

The following appears to be the case in your case as well:

As you can see, it is using the string “Member” instead of a integer level.

You may want to try the mentioned fix or talk to Nextcloud directly.

hth,
Dirk Ahrnke

1 Like
3

Hi,
thanks for the reply, the Link and the solution.

Holger