Hello
When i am trying to install globaladdressbook 1.10-git on Roundcube 1.2.0
in globaladdressbook.php
if (!($user = rcube_user::query($this->user_name, $this->host))) {
allways return null $user
DB Error: [7] ERROR: duplicate key value violates unique constraint "users_username_key"
DETAIL: Key (username, mail_host)=(liste_globale, localhost) already exists. (SQL Query: INSERT INTO "users" ("created", "last_login", "username", "mail_host", "language") VALUES (now(), now(), 'liste_globale', 'localhost', 'fr_FR')) in /volume1/@appstore/MailStation/mail/program/lib/Roundcube/rcube_db.php on line 539 (GET /mail/?_task=settings&_action=plugin.syno_admin)
[08-Nov-2016 22:15:12 +0100]: <m03ipoci> DB Error: [7] ERROR: insert or update on table "identities" violates foreign key constraint "identities_user_id_fkey"
DETAIL: Key (user_id)=(61) is not present in table "users". (SQL Query: INSERT INTO "identities" ("changed", "email", "name", "standard", "user_id") VALUES (now(), '
[email protected]', 'liste_globale', '1', '61')) in /volume1/@appstore/MailStation/mail/program/lib/Roundcube/rcube_db.php on line 539 (GET /mail/?_task=settings&_action=plugin.syno_admin)
[08-Nov-2016 22:15:12 +0100]: <m03ipoci> DB Error: [7] ERROR: insert or update on table "identities" violates foreign key constraint "identities_user_id_fkey"
DETAIL: Key (user_id)=(61) is not present in table "users". (GET /mail/?_task=settings&_action=plugin.syno_admin)
i am looking for the records in pgsql (tables users and identities) and the records was well created.
Is there a solution to that? What am I doing wrong?
Thanks
You're getting a duplicate key error. Did you already create the global addressbook user in the database?
Does the Global Addressbook show up when you login to Roundcube?