It works, thanks!
-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------
On Wed, Jul 19, 2017 at 1:29 PM, Jaroslav Balaz
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 ( 'turlututu@chapeau.tu' , 'turlututu@chapeau.tu' , 'XXXX' , '' , 'Turlututu' , 'CHAPEAU' , '' , '' , '' , '' , '' , '' , '' , '' , 1 , NOW() , 2 , NOW() , 2 );
INSERT INTO customer_preferences (user_id , preferences_key , preferences_value) VALUES ('turlututu@chapeau.tu', 'UserGoogleAuthenticatorSecretKey', '' ) , ('turlututu@chapeau.tu', 'UserLanguage' , 'fr' ) , ('turlututu@chapeau.tu', 'UserRefreshTime' , '0' ) , ('turlututu@chapeau.tu', '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