simply by running the below mysql command update vtiger_field set typeofdata = 'V~O' where tablename = 'vtiger_leaddetails' and columnname = 'lastname';
Problem: When using the Overview: Support Assessment i find the following "error" Check "System Time" vs "Current Timestamp". There is a material difference (443201 seconds) between application server (2323691961) and database server (12323148760) time. Solution: I got my problem solved by simply restart the mysql daemon sevice > service mysqld restart
Solution: Run the below command to check the modules first > /opt/otrs/bin/otrs.CheckModules.pl Then if not installed -> Time::HiRes run the below command > yum install "perl(Time::HiRes)" And if you are updating the Ticket::StorageModule then you should run the below command too so that all the attcahmemts will switch from DB to FS bin/otrs.ArticleStorageSwitch.pl -s ArticleStorageDB -d ArticleStorageFS