(Hiring) for database update

[buko]

Hi people!

Anyone  can help with updating database error messages after upgrade to v8.4 from v8.1 database. All works fine except editing invoices and manually creating new invoices.

Did contact WHMCS ended with diagnose and ;

Upon comparing the tables mentioned within this error I have been able to identify the following;

tblinvoices & tblclients: 
     (current)-> utf8_general_ci
     within my test installation:-> utf8_unicode_ci

tblpaymentgateways: 
      (current)-> utf8_unicode_ci this is correct

 

Thank you very much!

 

[WHMCS Development Company]

Hi Mate,

We ca help you in updating the data base. Kindly visit our website, submit your requirements. Our technical team will get in touch with you within 2 hours
Visit our website at - https://whmcsdigital.com/

Regards

[Evolve Web Hosting]

It's pretty easy to do.

Go to phpMyAdmin and Export a DB backup first

Then, because it's only 2 tables, click one of them in phpMyAdmin then open the Operations tab. Middle of the page, there's a drop down to change the Collation

Choose utf8_general_ci and click Go

Repeat the process for the 2nd table

Test it and you should be all set.