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: 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?