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: ---------------------- The advice from WHMCS: ---------------------

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