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


Resetting your Ghost Blog password

January 11th, 2014, by Ryan H.

Didn’t set up Mailgun in your Ghost blog, and lost your password? Hmm. A little bit of fancy-footwork, and we can be back up and running in no time.

 

You’ll need to reset the password in the SQLite DB by manually inserting a new hash into the DB.

  • Get access to your DB from the console, or through a gui tool if you have it.
  • If you are going through the console, CD to your ghost webroot, (the DB is under content/data/) and then type: sqlite3 ghost.db
  • Generate a temporary BCrypt hash (Find a generator online. I used this one: https://passwordhashing.com/BCrypt)
  • Or just use this hash which is for “password”: $2a$10$BQToDNdBtBKCvnrTmMi5m.NK.7i6Qx7YASs.jTkE86I5zqxzE8klC
  • Type UPDATE users SET password='<<PASTE_HASH_HERE>>' WHERE email = '<<YOUR_EMAIL_ADDRESS>>'
  • Type .exit to exit sqlite3
  • Log into your blog, and change your password to something secure.
  • Set up an email service at Mailgun as detailed here: http://docs.ghost.org/mail/

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)