Campaign Wizard presents blank page on Templates option

I have just installed a clean version of SuiteCRM 7.7, with demo data and it still fails.

Server is Ubuntu 16.04
PHP 7 - all prereq’s installed
MySQL Database

Installation was successful no issues/warnings.

I have looked in the apache2 error.log and see this:

PHP Warning: strpos(): Empty needle in /home/rick/public_html/suitecrm7/cache/smarty/templates_c/%%85^852^85294558%%get_form_header.tpl.php on line 23, referer: http://suitecrm7.<omitted_URL>:189/index.php?module=ProspectLists&action=Popup&query=true&list_type=test&mode=single&create=true&metadata=undefined&field_to_name[]=name

undefined means permissions issue, do you have all permission/ownership set correctly?

best regards

It appears the SQL database was not set right, I ran a command and it fixed it. Directory permissions and ownership are correct, but the install docs do not provide much help. Found it all on the internet. All is working now. Noted everything to get this working. Took a while.

Thanks for the response.

Hi!

I have exactly the same config, and the same issue. What did you do on the Mysql database to correct it?

Bye!

found:

set global sql_mode=""

This seems to happen in MySQL’s ‘sql_mode’ setting contains STRICT_TRANS_TABLES. The following steps fixed this issue for me:

Check your current sql_mode setting. In mysql client:

SELECT @@GLOBAL.sql_mode

You will see something like this:
±------------------------------------------------------------------------------------------------------------------------------------------+
| @@GLOBAL.sql_mode |
±------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
±------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Now go to your my.conf file. Usually it’s in /etc/mysql/my.cnf. And add the following lines:
[mysqld]
sql_mode=“”

For example:
[mysqld]
sql_mode=“ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

Now restart mysqld. On Ubuntu:

service mysql restart

And enjoy.

Dear All,

This is not complete or fully-correct solution, w.r.t., MySQL 5.7 As removing STRICT_TRANS_TABLES is not advisable as per the latest documentations of MySQL.

You may like to visit at: https://suitecrm.com/forum/developer-help/12567-campaign-wizard-is-going-blank-at-end-of-step-4#42549

Further, the upcoming upgraded SuiteCRM 7.8 (awaited) will be compatible with MySQL 5.7.

With thanks,

RK

Hmm,

Running the latest 7.9.5 and this is still an issue.

Any official fix?