[Obm] [2.4] Outils mise à jour

[Guillaume ALAUX]

On 02/01/2011 11:16 AM, furlot wrote:
> 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
> Obm at list.obm.org
> http://list.obm.org/mailman/listinfo/obm

Bonjour,

Je souhaitais vous prévenir que nous apportons ces jours-ci des
modifications techniques relativement importantes à OBM.

Votre problème ne provient peut-être pas de là, mais la "daily" reste
une version utilisée par les développeurs et qui n'a pas la même
stabilité que les release.

Guillaume ALAUX
LINAGORA - OBM

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 230 bytes
Desc: OpenPGP digital signature
Url : http://list.obm.org/pipermail/obm/attachments/20110201/62b45c32/attachment.pgp