[Obm] accès base mysql

[Marc BEY]

Bonsoir,

Sur une install d'OBM 2.1.8 petit problème lorsque je me connecte avec nom
de suser crée via l'admin0:

J'ai cela:



Database error: Invalid SQL: SELECT e.userobm_id as id,
concat(userobm_lastname , ' ' , userobm_firstname) as label, 'calendar' as
entityright_entity FROM EntityRight LEFT JOIN UserObm as e ON
entityright_entity_id = e.userobm_id WHERE entityright_entity = 'calendar'
AND ( (entityright_consumer = 'user' AND (entityright_consumer_id = '9' OR
entityright_consumer_id = 0)) OR (entityright_consumer = 'group' AND
(entityright_consumer_id IN (SELECT of_usergroup_group_id FROM
of_usergroup WHERE of_usergroup_user_id = '9') OR entityright_consumer_id
= 0))) AND entityright_write = 1 GROUP BY id, label, entityright_entity
UNION SELECT '9' as id, 'BEY Marc' as label, 'calendar' as
entityright_entity ORDER BY entityright_entity, label
MySQL Error: 1064 (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 'ORDER BY entityright_entity, label' at line 14)
Session halted.

Env:

RHEL 4
Php5
Mysql-4.1.7-4.RHEL4.1

Je pense que c'est de la syntaxe mysql...

Des idées?


Très cordialement


Marc BEY
http://www.bashprofile.eu
BASHPROFILE Informatique & Open Source
--------------------------------------
Vice-président-TPE
Fédération Nationale de l'Industrie du Logiciel Libre
http://www.fnill.org
--------------------------------------
Tel: 04.91.78.69.22
Mob: 06.11.75.49.12