[Obm] [2.4] Outils mise à jour

[furlot]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.obm.org/pipermail/obm/attachments/20110201/09968a8a/attachment.htm