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 <[email protected]> wrote: > 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
