Hi,
I’m trying to install suitecrm 7.10 LTS on my local server (Pop OS / Ubuntu 20.04 LTS).
PHP: 7.4.3
MySQL: 8.0.20
Everything goes find including validation and just after entering my db details, I get this screen that says:
Creating SuiteCRM configuration file (config.php)
Creating SuiteCRM application tables, audit tables and relationship metadata
Creating the database suitecrm on localhost:3306…done
…Database error. Please check suitecrm.log for details.
So here are the logs:
Mon Jun 15 20:04:32 2020 [25780][-none-][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Mon Jun 15 20:04:32 2020 [25780][-none-][FATAL] “name” field does not exists in field definition.
Mon Jun 15 20:04:32 2020 [25780][-none-][FATAL] Mysqli_query failed.
Mon Jun 15 20:04:32 2020 [25780][-none-][FATAL] Error creating table: : Query Failed: CREATE TABLE ( NULL ) >
I don’t have a clue why it does not work. I’ve been testing pretty much everything all day and everything is functional.
Any ideas ?
@vincegar72,
May be problem with version MySQL. Look at: https://docs.suitecrm.com/admin/compatibility-matrix/
MySQL 8 don’t support.
1 Like
Oh… I can’t believe I haven’t thought of that.
Thank you for pointing it out. I’ll move to MariaDB or an older version of MySQL and I’ll keep you informed.
Don’t forget PHP version - you’re also too far ahead on that one. 
1 Like
Yes… Saw that too. That’s kind of annoying. Weeks ago, I upgraded all my systems to the latest Ubuntu 20.04 LTS version.
Unfortunately, it is shipped with PHP 7.4 and Mysql 8 as default. And it is almost impossible to downgrade PHP and MySQL without breaking hundreds of dependencies.
At the end of the day (litterally), I had to setup a virtual machine and install an older version of Ubuntu (ie: 18.04 LTS) and re-install a server and reconfigure a DB and reinstall SuiteCRM…
I may now say everything works fine.
But what a pity I can’t use suiteCRM on my production systems… Well… I guess I’ll wait a little longer till I can redeploy it for good.
2 Likes
I think the MySQL 8.0 issue on Github already has a PR for it, I guess you could apply it manually. I am not sure if the PHP 7.4 problems are extensive or not. I wouldn’t use them for production but I would definitely give it a try on a test machine. Out of curiosity. 
Sure !
I’ll do that on my spare time though
1 Like