Email Templates Editor - blank email template not saving, '£' charset DB utf8 and iso-8859-1, wysiw

[bigego]

Hope this helps others as i found various bits and bobs on the forum.

 

The issue i had was that when i went to edit the email templates, either there was no content there, or the saves werent taking and it remained blank, in esence it just wasnt working and loosing the existing template code i had.

 

The reason was my admin localization was using "iso-8859-1" for the British Pound symbol, but the DB tables etc were in a mixture of Latin and UTF8 charset after updates to V6.*.* , the strange '£' symbol appeared ... and I was advised that the localisation needed to be utf8 for the editor to work in email templates and save the edits and not loose existing content .... so using WHMCS supports suuggestion i editd the configuration.php file and added ($mysql_charset="utf8"; after DB name) didnt solve it, but did help in some charset errors i could see:

 

-----------

whmcs support suggestion

-----------

UTF-8 is our default, and recommended setting for this.

Have you tried adding the following to your configuration.php file:

$mysql_charset="utf8";

----------------

 

So I then converted the tables etc in the DB to UTF8 and the Collate to "utf8_general_ci" and then set the charset in "admin > setup > general > localization" to utf-8 and searched and replaced any '£' with just '£' in the DB and it all displays and works ok now ... editor doesnt loose edits, and home > admin summary shows the currency and earnings correctly with just the British pound symbol "£".

 

PHP code to do this DB conversion to UTF8 quickly and easily.

Place the file you make in the WHMCS directory and call it in your browser ...

give it a moment or two to do it's thing:

http://stackoverflow.com/a/12721419

 

 

Cheers Dom

[bigego]

Further to this, for some bizarre reason, I had to request a time out extension to my server as the Heart Module i have was causing errors (DB gone away lol) since the update. Applied two extensions to the time out and eventually the products/services tab page loaded for those clients with heart internet hosting products.

 

47 seconds to oload the products/services page !!!! I will repeat, 47 seconds!!!

 

The error:

----------------------

Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (SQL: select * from `tblapplinks` where `module_type` = servers and `module_name` = heartinternet limit 1) (SQL: select * from `tblapplinks` where `module_type` = servers and `module_name` = heartinternet limit 1)' in /home/myserver/public_html/account/includes/classes/WHMCS/Terminus.php:0 Stack trace: #0 /home/myserver/public_html/account/includes/classes/WHMCS/Terminus.php(0): WHMCS\Terminus::whmcsExceptionHandler() #1 [internal function]: WHMCS\Terminus->whmcsExceptionHandler(Object(Illuminate\Database\QueryException)) #2 {main} thrown in /home/myserver/public_html/account/includes/classes/WHMCS/Terminus.php on line 0

 

The advice from WHMCS:

---------------------

Thank you for contacting WHMCS.

 

The 'MySQL server has gone away' error means that your MySQL Server is closing the connection WHMCS is using. This is usually due to the timeout value being set too low to allow the task to be completed.

 

You'd need to work with your server admin/hosting provider to increase the wait_timeout and perhaps also the max_allowed_packet values in the MySQL Configuration.

 

Other values that might be causing this are the connection timeout values in the HTTP server configuration - please try increasing such settings in the Apache or IIS configuration.