Is SuiteCRM 7.8.0/1 compatible with MySql 5.7?

Hi there,

Does anyone know if SuiteCRM 7.8.0/1 is compatible with mysql Ver 14.14 Distrib 5.7.17, for Linux?
The compatibility matrix isn’t updated (yet), so I want to know if I have to apply the ZERO_DATE fix in this new version.

Kind regards,
Eef Vreeland

Installed SuiteCRM 7.8.1 in a test server (Wamp) out of the box

Apache 2.4.18
PHP Version 7.0.11
Mysql 5.7.17

Thank you Horas68,

Would you be so kind, did you run into the ZERO_DATE/SQLMODE problem?

Eef Vreeland

Sorry, your name is horus68

Currently installed:

Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-62-generic
mysql Ver 14.14 Distrib 5.7.17, for Linux
PHP 7.0.13-0ubuntu0.16.04.1 (cli)
Apache/2.4.18 (Ubuntu)

Eef Vreeland

I just installed on curiosity and to reply to your question!
Didn’t noticed the ZERO_DATE/SQLMODE
Where should I test it?!

In the logfile: /var/www/html/suiteCRM_name_you_used/suitecrm.log

Look for something like this:

Thu Feb 2 14:25:38 2017 [1805][1][FATAL] Error inserting into table: campaigns: Query Failed: INSERT INTO campaigns (id,name,date_entered,date_modified,modified_user_id,created_by,deleted,assigned_user_id,tracker_count,refer_url,end_dat
e,status,impressions,currency_id,campaign_type,content)
VALUES (‘b3d3dea0…’,‘XXXX xxxxxx’,‘2017-02-02 13:25:38’,‘2017-02-02 13:25:38’,‘1’,‘1’,0,‘3044b37e…’,0,‘http://’,‘0000-00-00’,‘Active’,0,’-99’,‘Xxxxxxx’,‘Xxxxxx Xxxxxx’): MySQL error 1292: Incorrect date value: ‘0000-00-00’ for column ‘end_date’ at row 1
Thu Feb 2 14:25:38 2017 [1805][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

I used a quick fix found at https://github.com/salesagility/SuiteCRM/pull/2454 and https://github.com/salesagility/SuiteCRM/pull/2454/files
The added code will change ‘0000-00-00’ into NULL when it is a date-field, before it goes to the database.

Need more info? Let me know okay?

Chers,
Eef Vreeland

In short:

cat /var/www/html/suiteCRM_name_you_used/suitecrm.log | grep 1292

:slight_smile:

Eef