[Obm] Bug SQL archivage des comptes utilisateurs

[François Bachelier]

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 = 'bulladmin at ihes.fr', 
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.)




-- 
François Bachelier
IHES

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.obm.org/pipermail/obm/attachments/20110803/6f459275/attachment.htm