Changed Domain Name In Prestashop Now sites is switching between old url and new

[bteo]

I've switched the default url of many prestashop sites in the past for 1.5.*

 

However for 1 site I have there seems to be a slight problem. My domain was originally a .COM and I switched it to a .COM.AU

 

Now the website seems to appear down to site monitoring tools like monitor.us.

 

If you go to isup.me/priceritemart.com.au see if its down. If its up, just refresh the page a couple of times and you will see its down. (Note: I delegated my domain name on Friday 2 days ago and the website has propagated from all my whois.sc/priceritemart.com.au checks)/

 

HOWEVER, the website seems to be working and does not appear to be down at all. I'm in Australia.

 

=PROBLEM=

(1) I have a module which is licensed to my domain priceritemart.com.au and if I change my domain the module will be DISABLED. This module seems to enable but disable a min or two later. Its saying that my domain is switching between .com and .com.au

 

(2) This shows up on my error logs not a few times a day

PHP Warning: mysql_connect(): Lost connection to MySQL server at 'sending authentication information', system error: 32 in /home/USERNAME/public_html/classes/db/MySQL.php on line 38

 

 

 

 

===I Fixed===

In mysql I have changed all my domains in to .com.au so there's nothing pointing to .com

 

If anyone has anyone can lend me a hand with a few pointers on what I need to check please do that would be help a lot. I might even buy you a beer!!!! if that helps.

[Alex Simonchik BelVG]

Hi,

 

problem #1: did you try to contact with module developer?

problem #2: do you know what the query down the mysql server? Is it cron-job or some havy sql-query? What value of connect_timeout param?

 

Regards

[bteo]

Thanks for your reply,

 

I found this error on the site. If I open like 20 or 30 tabs of links from the site I sometimes get this error.

 

PHP Warning: mysql_connect(): Lost connection to MySQL server at 'sending authentication information', system error: 32 in /home/USERNAME/public_html/classes/db/MySQL.php on line 38

 

PHP Fatal error: Uncaught Link to database cannot be established. thrown in /home/USERNAME/public_html/classes/db/MySQL.php on line 39

 

I know it could be that mysql is overloaded. Do you know maybe what type of settings I need to look at?

 

I changed php.ini

max connections=300

Restarted sql server also

 

Update:

I also don't think the URL is switching I'm guessing it just sql overloaded.

Edited August 6, 2013 by bteo (see edit history)