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 > [email protected] > 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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Obm mailing list [email protected] http://list.obm.org/mailman/listinfo/obm
