OBM version 2.3.19
On 08/03/2011 11:52 AM, Raphaël Rougeron wrote: > Bonjour, > > Il s'agit très vraisemblablement d'un bug... Quelle version d'OBM > utilisez-vous ? > > Bien cordialement, > > Le 03/08/2011 11:43, François Bachelier a écrit : >> On 08/03/2011 11:32 AM, François Bachelier wrote: >>> Bonjour à tous, >>> >>> Voila ce que j'obtiens quand je tente d'archiver un utilisateur. >>> Comment régler ce problème ? >>> >>> merci. >>> >>> François >>> >> il manque un petit qque chose on dirait =) >> >> >> >> *Warning*: pg_query() [function.pg-query >> <https://web.ihes.fr/user/function.pg-query>]: Query failed: ERREUR: la >> colonne « userobm_account_dateexp » est de type date mais l'expression >> est de type text LINE 8: userobm_account_dateexp = ( ^ HINT: Vous devez >> réécrire l'expression ou lui appliquer une transformation de type. in >> */usr/share/obm/www/obminclude/phplib/db_pgsql.inc* on line *96* >> *Database error:* Invalid SQL: UPDATE UserObm SET userobm_timeupdate = >> NOW(), userobm_userupdate = 183, userobm_login='bulladmin', >> userobm_perms = 'Scientifique', userobm_gid = '513', >> userobm_account_dateexp = ( CASE WHEN (userobm_archive = 0 AND 1<> 0) >> THEN '2011-08-31' ELSE null END ), userobm_archive = 1, userobm_hidden = >> 0, userobm_datebegin = null, userobm_kind = '', userobm_lastname = >> 'Admin', userobm_firstname = 'Bull', userobm_title = '', userobm_phone = >> '', userobm_phone2 = '', userobm_mobile = '', userobm_fax = '', >> userobm_fax2 = '', userobm_company = '', userobm_direction = '', >> userobm_service = '', userobm_address1 = '', userobm_address2 = '', >> userobm_address3 = '', userobm_zipcode = '', userobm_town = '', >> userobm_expresspostal = '', userobm_email = '[email protected]', >> userobm_description = '' , userobm_delegation_target='' , >> userobm_delegation='' , userobm_mail_perms=1, userobm_mail_ext_perms=0, >> userobm_mail_server_id=1, userobm_mail_quota=0 , >> userobm_email_nomade='', userobm_nomade_perms=1, >> userobm_nomade_enable=0, userobm_nomade_local_copy=0 , >> userobm_vacation_enable=0, userobm_vacation_datebegin= null, >> userobm_vacation_dateend= null, userobm_vacation_message='' , >> userobm_samba_perms=1, userobm_samba_home='\\\\shivasrv\\homes', >> userobm_samba_home_drive='Z', userobm_samba_logon_script='' WHERE >> userobm_id = 136 AND (userobm_domain_id='2') >> *PostgreSQL Error*: 1 (ERREUR: la colonne « userobm_account_dateexp » >> est de type date mais l'expression est de type text LINE 8: >> userobm_account_dateexp = ( ^ HINT: Vous devez réécrire l'expression ou >> lui appliquer une transformation de type.) >> >> >> >> >> >> >> _______________________________________________ >> Obm mailing list >> [email protected] >> http://list.obm.org/mailman/listinfo/obm > -- François Bachelier IHES _______________________________________________ Obm mailing list [email protected] http://list.obm.org/mailman/listinfo/obm
