Numpaque Posted November 9, 2011 Share Posted November 9, 2011 Hi, I have a critical error PrestaShop Fatal error: no utf-8 support. Please check your server configuration. this happens all time and I don't know why already I contact with my hosting service and all is Okay , also I tried disable all modules and continue the issue, any suggestions ? please help me!! my actual version of Ps 1.4.5.1 My theme : Matrice thanks in advance Link to comment Share on other sites More sharing options...
Numpaque Posted November 10, 2011 Author Share Posted November 10, 2011 Hi , I really need your help with my problem this happend with PS 1.4.5.1 and I don't know why happen!! already check the 3d party modules and now I don't know what can I do Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 10, 2011 Share Posted November 10, 2011 Hi Numpaque, This is likely due to a check in your MySQL.php file that is blocking you because your hosting provider does not support UTF-8 for SQL. To test this out, please open your classes/MySQL.php file and comment out if (!mysql_query('SET NAMES \'utf8\'', $this->_link)) die(Tools::displayError('PrestaShop Fatal error: no utf-8 support. Please check your server configuration.')); Hopefully that will allow you to get around this restriction, but please let me know if it works for you. -Mike Link to comment Share on other sites More sharing options...
Numpaque Posted November 11, 2011 Author Share Posted November 11, 2011 Thank You Mike, I 'll try I hope that works I'll comment about the result in next 24 hours Hi Numpaque, This is likely due to a check in your MySQL.php file that is blocking you because your hosting provider does not support UTF-8 for SQL. To test this out, please open your classes/MySQL.php file and comment out if (!mysql_query('SET NAMES \'utf8\'', $this->_link)) die(Tools::displayError('PrestaShop Fatal error: no utf-8 support. Please check your server configuration.')); Hopefully that will allow you to get around this restriction, but please let me know if it works for you. -Mike Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 11, 2011 Share Posted November 11, 2011 Thank You Mike, I 'll try I hope that works I'll comment about the result in next 24 hours I look forward to hearing more! -Mike Link to comment Share on other sites More sharing options...
Numpaque Posted November 11, 2011 Author Share Posted November 11, 2011 Mike, my hosting service support UTF-8 for SQL my shop hosted since 2008 without any issue now afther upgrade to the latest PS version i have this issue when I comment in Msql.php, lost all the Spanish accents Hi Numpaque, This is likely due to a check in your MySQL.php file that is blocking you because your hosting provider does not support UTF-8 for SQL. To test this out, please open your classes/MySQL.php file and comment out if (!mysql_query('SET NAMES \'utf8\'', $this->_link)) die(Tools::displayError('PrestaShop Fatal error: no utf-8 support. Please check your server configuration.')); Hopefully that will allow you to get around this restriction, but please let me know if it works for you. -Mike Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 11, 2011 Share Posted November 11, 2011 Mike, my hosting service support UTF-8 for SQL my shop hosted since 2008 without any issue now afther upgrade to the latest PS version i have this issue when I comment in Msql.php, lost all the Spanish accents Hi Numpaque, You should not have that issue when commenting out those lines, but if it indeed did that to your store, please go ahead and remove the '//" you used to comment out those lines and revert your site to how it was before. In order to get this taken care of, can you please post your issue here so that our Developers can look into this more deeply for you? -Mike Link to comment Share on other sites More sharing options...
Numpaque Posted November 16, 2011 Author Share Posted November 16, 2011 Hi mike I try again comment the line if (!mysql_query('SET NAMES \'utf8\'', $this->_link)) die(Tools::displayError('PrestaShop Fatal error: no utf-8 support. Please check your server configuration.')); before I fogot the semicolon ( but afther this change now the error that show my show is Bad subdomain Sql query if I uncommented the line the error change to PrestaShop Fatal error: no utf-8 support. Please check your server configuration. I already post my issue in the http://forge.prestashop.com here without any answer Hi Numpaque, You should not have that issue when commenting out those lines, but if it indeed did that to your store, please go ahead and remove the '//" you used to comment out those lines and revert your site to how it was before. In order to get this taken care of, can you please post your issue here so that our Developers can look into this more deeply for you? -Mike Link to comment Share on other sites More sharing options...
Mike Kranzler Posted November 16, 2011 Share Posted November 16, 2011 Hi Numpaque, Thanks for posting that link, I will keep an eye on our development team's progress for you. -Mike Link to comment Share on other sites More sharing options...
Vasil Posted March 18, 2012 Share Posted March 18, 2012 I have a same problem, but I found out that this is not prestashop problem. The problem with my hosting - MySql query limit per hour. 2 Link to comment Share on other sites More sharing options...
Bankai Posted May 31, 2012 Share Posted May 31, 2012 I have a same problem, but I found out that this is not prestashop problem. The problem with my hosting - MySql query limit per hour. One of my web site on the same server usually has this error. I occasinally have to change database's user privillage back and forward to solve it. The other site, with lot fewer product never has this problem. Link to comment Share on other sites More sharing options...
mobilafitness Posted July 24, 2012 Share Posted July 24, 2012 I also got this message at upgrading prestashop: SET NAMES 'utf8' ALTER TABLE `ps_feature_product` ADD INDEX `id_product`(`id_product`) SET NAMES 'utf8' SET NAMES 'utf8' Is it a problem? Link to comment Share on other sites More sharing options...
CrS27 Posted August 17, 2012 Share Posted August 17, 2012 Hi! you should check your server and test your prestaShop, to find out the reason of this error. I usually use this service http://www.shopping-cart-diagnostics.com/ Hope, it'll help 1 Link to comment Share on other sites More sharing options...
tdelios Posted November 25, 2013 Share Posted November 25, 2013 I had the exact same error message when trying to update my existing 2,500+ products with a couple of pieces of information. I had my csv files broken down into 50 rows and each time after the first file goes through successfully, then the next file wouldn't resulting in the error message. Could not even get to the site or the admin user interface without that message popping up. I thought I crashed my web site with bad data. Found out from my hosting company that there is a mysql limit on the number of queries per hour. Mine is set to 75,000 but you would figure that with only 50 rows a file that I would be way under my limit. I was told that the php files being used for the importing are not optimized and eat up a lot of unecessary queries. They told me if I could, try to use the phpmyadmin interface to get around this limit, but not familar enough with it and how prestashop would handle it that i'm using the regular import method through the prestashop interface.. end result, that I wait 1 hour after loading each 50 row csv file for product updates.. ugh! Link to comment Share on other sites More sharing options...
PrestaAlexShop Posted February 12, 2015 Share Posted February 12, 2015 If you see that There is no problem with your shop! The problem is your host setting or configurations. Ask your host provider about your SQL Query Limit ( my was 75000) Then your host provider ask your to pay. This is replay on my request: We apologize for any inconvenience this may have caused you. You have signed up for shared hosting account ‘XXXXXXXXX’ with us. On a shared hosting platform, there are practical limits to the amount of resources we can dedicate to individual customers. The maximum number of database queries per user is 75000/hr. If the MySQL user exceeds the database query limit, which is 75,000 per hour per user, then the WordPress website will be redirected to the installation page or query limit page. This setting is in place to ensure that the MySQL database cannot be overloaded with too many query requests. The queries will reset every hour and is kept by user. However, every time the pages on your website are accessed you are still attempting to make queries to the database server. If this becomes an issue for you, you may be able to reduce the number of queries you are running by using application-level caching, combining queries or taking advantage of nested queries wherever you can. As a temporary fix for this issue you can delete and recreate your user however this error will still come back if you do not condense the amount of queries your script uses by optimizing your SQL usage. Below is a link that should help show you how to optimize your MySQL usage: I would suggest you to upgrade your account to the WordPress Essential plan for better performance, query limit and security. To know more about our WordPress Essential plan, please visit: http://www.xxxxxxxxxx . If you want us to upgrade your account to WordPress Essential plan, please let us know how many years you wish to upgrade and authorize us to charge your PayPal or credit card. Link to comment Share on other sites More sharing options...
PrestaAlexShop Posted February 12, 2015 Share Posted February 12, 2015 I occasionally have to change MySQL database's user privileges back and forward to solve it. Or that way Link to comment Share on other sites More sharing options...
Recommended Posts