HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Local Setup on OSX

I am doing a local test install on OSX running MAMP Pro with PHP 5.6.31 and MySQL 5.6.35. after getting a “something is wrong” message, I enabled debugging in the Config file and got this message:

HelpSpot could not connect to the database, likely due to incorrect credentials supplied in config.php. The error received from the database was: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8_unicode_ci’ is not valid for CHARACTER SET ‘utf8mb4’

Yet I have the config file set to these as it recommends in the comments:

define(‘cDBCHARSET’, ‘utf8mb4’); // Use “utf8mb4” for MySQL 5.5.3+
define(‘cDBCOLLATION’, ‘utf8_unicode_ci’); // Use “utf8mb4_unicode_ci” for MySQL 5.5.3+

Which is correct?


Please ignore this post as I just noticed that I did not have the cDBCOLLATION set to utf8mb4_unicode_ci (as you can obviously see!). I changed it over and it now works!

I must lay the blame on me following US politics way too much over the last few weeks (I am from Australia!) and not being focussed on the job at hand… Sorry!