CORE-14516 Call to a member function marketingEmailOptIn() on null

[Anasco]

Dear all, 

After I update to 7.10 "host-experts.com" all registrations fail and I get this error: 

Error: Call to a member function marketingEmailOptIn() on null in ـــــــــــــــــــ public_html/control-panel/includes/clientfunctions.php:0
Stack trace:
#0 /home/hostexperts/public_html/control-panel/register.php(0): addClient('test2', 'test2', 'test2', 'test@host-exper...', 'dubai', 'dubai', 'dubai', 'dubai', '12345', 'AE', '+971.12312323', 'Password121', '', '', true, Array, '936de65c-81a7-4...', false, '1')
#1 {main}

 

Can anyone help me with that? or how can i returns to the old version of WHMCS

Kind Regards.

[WHMCS Dan]

Hi There,

I've seen this issue when MySQL Strict Mode was enabled on the server and caused issues with the updater performing the required database changes to the schema, resulting in missing columns in various database tables.

As a first step I would suggest checking and ensuring that MySQL Strict Mode is disabled on your server, we have a great guide on how to do this here: https://help.whmcs.com/m/installation/l/678317-disabling-mysql-strict-mode

Once disabled you will likely need to manually apply the required database changes, you should ensure you take a suitable database backup before making any live changes:
 

alter table `tbllog_register` modify `namespace_value` mediumtext COLLATE utf8_unicode_ci NOT NULL;
alter table `tblemailmarketer` add `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `marketing`;
alter table `tblemailmarketer` add `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `created_at`;
alter table `tblclients` add `email_preferences` TEXT COLLATE utf8_unicode_ci DEFAULT NULL AFTER `email_verified`;

 

You can then compare the table schemas to the .sql files under resources/sql/install/ and add any missing fields to the tables in the appropriate places using a tool like PHPMyAdmin.

If you have any problems or issues making these changes, please feel free to raise a support ticket and we can assist.

[WHMCS John]

Hi @Anasco,

Dan's steps should get you back up and running. I'd also like to gather some more information about how these columns might have failed to be created.:

1. Did you encounter any errors when applying the 7.10 update?

2. Did you update manually or via Utilities > Update WHMCS?

3. Could you please share some information about your server configuration:

• Previous sql_mode configuration value:
• SQL server Type (eg. MySQL, MariaDB):
• SQL Version:

 

I've not yet been able to replicate an update situation where the tables are not created, even with an sql_mode of STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION.

Input on your server configuration at the time of upgrading will be most appreciated.

[DennisHermannsen]

It still boggles me how WHMCS can't run properly with strict mode enabled.

Strict mode just controls how MySQL handles invalid queries. Instead of fixing them, you just advise that strict mode should be disabled. It doesn't feel right.

[WHMCS John]

WHMCS should run fine with Strict Mode enabled. However I've yet to reproduce reproduce this problem with Strict Mode enabled myself, so it's important we gather as much information about the OP's environment  to understand why the  new columns weren't created.

[Brad (SaneChoice Limited)]

Hi All,

I have also upgraded to the 7.10 and the Weebly Free plan seems to be having some issues.

Does anyone have the issue when clicking the free plan (from the client portal) they are presented with a Whoops! error?  Screenshot below.

Thanks,

Brad

 

Edited April 10, 2020 by sanechoice

[DennisHermannsen]

In ticket ID #ECE-874862, I reported an issue (last year) and was told that WHMCS requires strict mode disabled.

[WHMCS John]

Hi @sanechoice,

I've been able to replicate this issue on my end as well when updating from a previos version of WHMCS in which Weebly was activated for selling.

Case #CORE-14516 is now is open with our developers in order to have this reviewed for future releases. Once we resolve cases and push features they are available at our change log, here:

https://changelog.whmcs.com/

This does not appear to impact installations activating Weebly for the firs ttime.

I apologize for the inconvenience, and appreciate your patience as we work to resolve this.

Thanks for taking the time to report your findings.

[Mohsin Sumar]

Hi @WHMCS John

I'm also having the same problem, previously selling Weebly already prior to upgrading to 7.10. 

Is there any hot fix available?

Thanks.

[WHMCS John]

Hi there,

As a workaround please follow these steps in your WHMCS admin:

* Navigate to Setup > Marketplace

* Click Manage in the Weebly section

* Click Deactivate

* Then click the Activate button

The issue will now be resolved.

[Mohsin Sumar]

@WHMCS John

thank you - worked!

 

[Brad (SaneChoice Limited)]

Thanks @WHMCS John! Appreciate your persistent and finding a workaround.