Zen Cart Not Closing DB Connections URGENT HELP

I've installed zen cart dozens of times and I now have an installation that keeps hanging my DB up.

When calling the ISP they are telling me that Zen Cart is keeping to many open queries and not closing the connections causing the mysql db to time out which is really frustrating me as well as my client.

I'm hoping someone here can tell me how to easily solve this issue.

It is the latest version of Zen if that helps.

Please Help.

Thanks,
Cris...

In your includes/application_bottom.php file, if you

replace:

// $db->close();

with:

$db->close();

does it correct the problem ?

Thanks if i can ever get my isp on the phone to have them re establish my database connection i'll let you know if this solved my problem ;-)

Cris...

ok when i change that code i get the following code at the bottom of each zen cart page

in:
[select count(*) as total from zensessions where sesskey = '7ef07dedd21730a769cff520084edc0d']

anyway to get rid of that?

Cris...

Make sure that you did not enable persistent connections when you set up Zen Cart. This is what you should see in both configure.php files:
define('USE_PCONNECT', 'false');

If it says 'true' then that could be the source of your problem.

Vger

Hey Vger,
They are both set to FALSE.

Any other ideas?

Cris...

If those settings are both set to 'false' then it's likely a hosting issue. Some hosts who have over-stuffed their servers get onto people running dynamic sites and tell them that they are using up too many resources on the server and need to take action to reduce their usage or else fork out for a dedicated server. 1and1 does this but so do others.

However, even on the best of shared servers, if it is a very busy website (100 customers at a time online, or more) then the problem can simply be that you keep hitting max sql parent and child queries limits, in which case things will either time out or slow down. In this case you would need either a Virtual Dedicated Server or a full Dedicated Server.

Vger