Thread

Hello,

We are in the process of changing http://newmediastrategies.net/ to http://nms.com/ and are experiencing an issue.

Changing the site root url in system preferences causes an issue with EE opening / not closing too many database connections.  As soon as we update the system preferences we receive the following error:

“Database Error: Unable to connect to your database. Your database appears to be turned off or the database connection settings in your config file are not correct. Please contact your hosting provider if the problem persists.”

Changing the root url back to the original setting immediately resolves the issue.

Any help is greatly appreciated.

-Shawn

What version and build of EE are you on? What, exactly, are you changing? The site url? That wouldn’t work unless EE was installed at that URL, would it? My suggestion would be to follow these instructions if you need to move the site physically.

Hi Ingmar,

It’s an old EE site (running great for over a year) but it’s on the latest build of 1.6.8 (upgraded last night).  I’m not actually moving servers…  nms.com is an alias of newmediastrategies.net and both are currently active and pointing to the same location on the server.  All I want to do is make nms.com the primary domain and everything works great until I change the root url.  “URL to the root directory of your site” under General Configuration. 

As soon as I do that we start getting mysql connection errors.

-Shawn

Did you change everything else as well? Config.php, all the path info etc?

I have.  The server paths are not changing, only urls.  What are you thinking?

Have you set any variables in path.php? You’d have to change those, too.

Nope, nothing set in path.php

Are you using Query caching?

Can you manually remove the contents of /system/cache vie FTP. Remove everything but the index.html file.

“Enable SQL Query Caching” is set to yes.  Manually cleared the cache and I am still experiencing the same issue.

Discovered something else along the way…  I can switch the site url and as long as I browse the site with the system off.  Turning the system on causes the connection errors. 

So two symptoms so far:
#1.  Change of root url
#2.  System is on

You can close this support request.  I found an embed template that was causing an issue.

Glad you are up and running again. Feel free to start a new thread if you have any more questions.