SugarCRM Timezone Errors

February 1st, 2016, by Ryan H.

[FATAL] Configuration variable date.timezone is not set, guessed timezone America/Chicago. Please set date.timezone="America/Chicago" in php.ini!

If you set that in your php.ini and are still getting that error, it’s likely getting thrown from you cronjob, which is calling the cli version of PHP. Make sure you add date.timezone="America/Chicago" to /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini

MySQL Wildcard Search [%] in SugarCRM

March 6th, 2013, by Ryan H.

There are a lot of posts in the SugarCRM forums and on Google about getting better search results in SugarCRM by adding the MySQL wildcard operator in the front and back of the search query.  As of late last year, an un-announced feature popped up to enable this functionality without having to hack the include/SearchForm/SearchForm2.php file.

Now, simply add the following to your config_override.php:

'search_wildcard_infront' => true,

(Just as a note, the search wildcard is always added to the end of a search)