Bonjour,
je viens d'installer obm 2.4 sur une Debian via les paquets daily, lorsque je vais dans l'outils de
Mise à jour j'ai ces messages d'erreurs :
----
*Warning*: pg_query() [function.pg-query <https://obm.ladb.fr/tools/function.pg-query>]: Query
failed: ERROR: syntax error at or near "JOIN" LINE 7: LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_en... ^ in */usr/share/obm/www/obminclude/phplib/db_pgsql.inc* on line *96*
*Database error:* Invalid SQL: SELECT Current.userobm_id, Current.userobm_firstname,
Current.userobm_lastname, Current.userobm_email FROM field as Property LEFT JOIN UserEntity ON
UserEntity.userentity_entity_id = Property.entity_id JOIN UserObm as Current ON Current.userobm_id =
UserEntity.userentity_user_id LEFT JOIN P_field as Production ON LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_entity_id = Production.entity_id WHERE (Production.id != Property.id OR
(Production.id IS NULL AND Property.id IS NOT NULL) OR (Production.id IS NOT NULL AND Property.id IS
NULL) OR Production.entity_id != Property.entity_id OR (Production.entity_id IS NULL AND
Property.entity_id IS NOT NULL) OR (Production.entity_id IS NOT NULL AND Property.entity_id IS NULL)
OR Production.field != Property.field OR (Production.field IS NULL AND Property.field IS NOT NULL)
OR (Production.field IS NOT NULL AND Property.field IS NULL) OR Production.value != Property.value
OR (Production.value IS NULL AND Property.value IS NOT NULL) OR (Production.value IS NOT NULL AND
Property.value IS NULL)) AND (1=1 AND Current.userobm_domain_id = 2 AND Current.userobm_status =
'VALID') UNION SELECT Current.userobm_id, Current.userobm_firstname, Current.userobm_lastname,
Current.userobm_email FROM P_field as Property LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_entity_id = Property.entity_id JOIN UserObm as Current ON Current.userobm_id
= P_UserEntity.userentity_user_id LEFT JOIN field as Production ON LEFT JOIN UserEntity ON
UserEntity.userentity_entity_id = Production.entity_id WHERE (Production.id != Property.id OR
(Production.id IS NULL AND Property.id IS NOT NULL) OR (Production.id IS NOT NULL AND Property.id IS
NULL) OR Production.entity_id != Property.entity_id OR (Production.entity_id IS NULL AND
Property.entity_id IS NOT NULL) OR (Production.entity_id IS NOT NULL AND Property.entity_id IS NULL)
OR Production.field != Property.field OR (Production.field IS NULL AND Property.field IS NOT NULL)
OR (Production.field IS NOT NULL AND Property.field IS NULL) OR Production.value != Property.value
OR (Production.value IS NULL AND Property.value IS NOT NULL) OR (Production.value IS NOT NULL AND
Property.value IS NULL)) AND (1=1 AND Current.userobm_domain_id = 2 AND Current.userobm_status =
'VALID')
*PostgreSQL Error*: 1 (ERROR: syntax error at or near "JOIN" LINE 7: LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_en... ^)
*Warning*: pg_query() [function.pg-query <https://obm.ladb.fr/tools/function.pg-query>]: Query
failed: ERROR: syntax error at or near "JOIN" LINE 7: LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_en... ^ in */usr/share/obm/www/obminclude/phplib/db_pgsql.inc* on line *96*
*Database error:* Invalid SQL: SELECT Current.userobm_id, Current.userobm_firstname,
Current.userobm_lastname, Current.userobm_email FROM field as Property LEFT JOIN UserEntity ON
UserEntity.userentity_entity_id = Property.entity_id JOIN UserObm as Current ON Current.userobm_id =
UserEntity.userentity_user_id LEFT JOIN P_field as Production ON LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_entity_id = Production.entity_id WHERE (Production.id != Property.id OR
(Production.id IS NULL AND Property.id IS NOT NULL) OR (Production.id IS NOT NULL AND Property.id IS
NULL) OR Production.entity_id != Property.entity_id OR (Production.entity_id IS NULL AND
Property.entity_id IS NOT NULL) OR (Production.entity_id IS NOT NULL AND Property.entity_id IS NULL)
OR Production.field != Property.field OR (Production.field IS NULL AND Property.field IS NOT NULL)
OR (Production.field IS NOT NULL AND Property.field IS NULL) OR Production.value != Property.value
OR (Production.value IS NULL AND Property.value IS NOT NULL) OR (Production.value IS NOT NULL AND
Property.value IS NULL)) AND (1=1 AND Current.userobm_status = 'VALID') UNION SELECT
Current.userobm_id, Current.userobm_firstname, Current.userobm_lastname, Current.userobm_email FROM
P_field as Property LEFT JOIN P_UserEntity ON P_UserEntity.userentity_entity_id = Property.entity_id
JOIN UserObm as Current ON Current.userobm_id = P_UserEntity.userentity_user_id LEFT JOIN field as
Production ON LEFT JOIN UserEntity ON UserEntity.userentity_entity_id = Production.entity_id WHERE
(Production.id != Property.id OR (Production.id IS NULL AND Property.id IS NOT NULL) OR
(Production.id IS NOT NULL AND Property.id IS NULL) OR Production.entity_id != Property.entity_id OR
(Production.entity_id IS NULL AND Property.entity_id IS NOT NULL) OR (Production.entity_id IS NOT
NULL AND Property.entity_id IS NULL) OR Production.field != Property.field OR (Production.field IS
NULL AND Property.field IS NOT NULL) OR (Production.field IS NOT NULL AND Property.field IS NULL) OR
Production.value != Property.value OR (Production.value IS NULL AND Property.value IS NOT NULL) OR
(Production.value IS NOT NULL AND Property.value IS NULL)) AND (1=1 AND Current.userobm_status =
'VALID')
*PostgreSQL Error*: 1 (ERROR: syntax error at or near "JOIN" LINE 7: LEFT JOIN P_UserEntity ON
P_UserEntity.userentity_en... ^)
----
le update.pl semble également poser problème lorsque je lance cette commande :
/usr/share/obm/www/auto/update.pl --domain-global --global
j'ai le message d'aide "Veuillez indiquer les paramètres de mise a jour[...]" qui apparaît, la
syntaxe a changé?
en espérant que ça vous aide dans votre chasse aux derniers bug de cette
nouvelle version
Eric
_______________________________________________
Obm mailing list
[email protected]
http://list.obm.org/mailman/listinfo/obm
