Creating a campaign causes a problem

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello everyone,

i have just installed the SuiteCRM and evaluating it for my project.

Within the creation of a new campaign my SuiteCRM has a problem:

  • Hello …

  • Your version of SuiteCRM
    Version 7.6.6
    Sugar Version 6.5.23 (Build 1061)

  • Your version of OS
    Ubuntu Server 16.04.1 LTS

  • Php version
    PHP Version 7.0.8-0

  • Log Apache or Php

Fri Jul 29 22:49:03 2016 [3315][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Europe/Berlin. Please set date.timezone="Europe/Berlin" in php.ini!
Fri Jul 29 22:49:03 2016 [3315][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_date,status,impressions,currency_id,campaign_type,frequency)
					VALUES ('ed27bfde-bd8f-66c6-97ab-579bc159664e','test','2016-07-29 20:49:03','2016-07-29 20:49:03','1','1',0,'1',0,'http://','0000-00-00','Planning',0,'-99','Email',''): MySQL error 1292: Incorrect date value: '0000-00-00' for column 'end_date' at row 1
Fri Jul 29 22:49:03 2016 [3315][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

I try to create a campaign: marketing - campaigns - create - email: name=test -next -select no target list or do select a target list (has no effect on the problem)
After that i get a white UI:

http://f18i.imgup.net/Unbenannt2d0f.PNG

The suitecrm.log tells me there is an mysql error with the end date but i never had to enter an end date.

Do you have any ideas?

Thank you very much!

2

I fixed it with the SQL Command:

set global sql_mode=""

Topic can be closed.

3

That is a bit of overkill. The only flag you need to remove from sql_mode is NO_ZERO_DATE.

See https://github.com/salesagility/SuiteCRM/issues/1719

There is PR waiting to be merged that seems to address this.

4

SHOW variables WHERE variable_name = ‘sql_mode’;

SET GLOBAL sql_mode = ‘STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;