[SOLVED] FATAL error on install - SuiteCRM 7.10 LTS

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. :slight_smile:

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. :slight_smile:

Sure ! :wink: I’ll do that on my spare time though

1 Like