I am new to Bolibarr and extremely impressed by it’s extensive feature list. I have isntalled the package. As admin, I have opened a project and added two tasks. As admin, I can display the task list without problems. When logging in as a contact, I get the follwing error message when clciking the task list in the left menu (own tasks and/or all tasks, both produce an error):
Das System hat einen technischen Fehler festgestellt.
Diese Informationen könnten bei der Diagnose des Fehlers behilflich sein:
Datum: 20160801155103
Dolibarr: 3.9.3
Funktionslevel: 0
PHP: 5.6.23-nmm1
Server: Apache
OS: Linux dd6312 3.13.0-92-generic #139-Ubuntu SMP Tue Jun 28 20:42:26 UTC 2016 x86_64
UserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36
Angeforderte URL: /htdocs/projet/tasks/list.php?mode=mine
Referer: http://dolibarr.formatprojekt.at/htdocs/projet/tasks/list.php
Menüverwaltung: eldy_menu.php
Datenbank Type Manager: mysqli
Anfrage des letzten fehlerhaften Datenbankzugriffs: SELECT DISTINCT p.rowid as projectid, p.ref as projectref, p.title as projecttitle, p.fk_statut as projectstatus, p.fk_opp_status, p.public, p.fk_user_creat as projectusercreate, s.nom as name, s.rowid as socid, t.datec as date_creation, t.dateo as date_start, t.datee as date_end, t.tms as date_update, t.rowid as id, t.ref, t.label, t.planned_workload, t.duration_effective, t.progress, t.fk_statut FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid, llx_projet_task as t, llx_element_contact as ect WHERE t.fk_projet = p.rowid AND p.entity IN (1) p.rowid IN () AND p.fk_statut = 1 AND ect.fk_c_type_contact IN (181,180) AND ect.element_id = t.rowid AND ect.fk_socpeople = 2 ORDER BY p.ref DESC LIMIT 26
Return-Code des letzten fehlerhaften Datenbankzugriffs: DB_ERROR_SYNTAX
Inhalt des letzten Datenbankzugriffs mit Fehler: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘p.rowid IN () AND p.fk_statut = 1 AND ect.fk_c_type_contact IN (181,180) AND ect’ at line 1
Could somebody please look at the message and perhaps come up with an explaination / workaround? Have I made some mistake or is this a bug? Thank you for your help.
Best regards,
Pepe
