Re: INSERT INTO customer_user

Hi,

Did you tried to delete the cache?

bin/otrs.Console.pl Maint::Cache::Delete.

BR,

Jaroslav


On 7/19/17 13:21, Santiago DIEZ wrote:
> Hi all,
>
> I installed otrs-5.0.20 from source 10 days ago and it works fine.
> Today I tried to add customer_user directly into the MySQL backend with:
>
> INSERT INTO customer_user (
>     login
> ,   email
> ,   customer_id
> ,   title
> ,   first_name
> ,   last_name
> ,   phone
> ,   fax
> ,   mobile
> ,   street
> ,   zip
> ,   city
> ,   country
> ,   comments
> ,   valid_id
> ,   create_time
> ,   create_by
> ,   change_time
> ,   change_by
> )
> VALUES (
>     '[email protected]'
> ,   '[email protected]'
> ,   'XXXX'
> ,   ''
> ,   'Turlututu'
> ,   'CHAPEAU'
> ,   ''
> ,   ''
> ,   ''
> ,   ''
> ,   ''
> ,   ''
> ,   ''
> ,   ''
> ,   1
> ,   NOW()
> ,   2
> ,   NOW()
> ,   2
> );
>
> INSERT INTO customer_preferences (user_id   , preferences_key
>          , preferences_value)
> VALUES                           ('[email protected]',
> 'UserGoogleAuthenticatorSecretKey', ''               )
> ,                                ('[email protected]',
> 'UserLanguage'                    , 'fr'             )
> ,                                ('[email protected]',
> 'UserRefreshTime'                 , '0'              )
> ,                                ('[email protected]',
> 'UserShowTickets'                 , '25'             );
>
> But the new users do not show in
> otrs/index.pl?Action=AdminCustomerUser;Nav=Agent
>
> Does anyone knows why?
> Is there a better way to programmatically insert customer_user?
>
> Regards
> -------------------------
> Santiago DIEZ
> Quark Systems & CAOBA
> 23 rue du Buisson Saint-Louis, 75010 Paris
> -------------------------
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
>

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs