index.php and server overload?

[Kim]

... and the answers to the questions your host asked you? (Same questions we would have, especially if you have been running the site successfully for a while)

[DrByte]

FYI, since v1.2.4, Zen Cart does not use persistent connections at all, regardless of the setting in your configure.php files.

[lextechs]

... and the answers to the questions your host asked you? (Same questions we would have, especially if you have been running the site successfully for a while)

1) Using mysql_pconnect instead of mysql_connect. Is ZenCart set up to use persistent connections?,

I am not sure if i am using this how would be able to find out in the Zencart config file?


2) Refreshing pages constantly. Are you, or possibly any of your customers, refreshing pages?

I am not doing any page refreshing however i have no clue if my customers are or not


3) Connection flood. Have you experienced any increase in traffic lately?
I would have to log in to my account and see that however the account has been suspended so i can not get that information. However this is what they are telling me
"Hello,

The zencart on lextechs.com specifically was causing the server to be overloaded. This may have been caused by an exploit to zencart which do exist or heavily increased traffic to the site. At this time I do not believe we can reenable your site with that zencart still online unless it is moved to a vps or fixed."

"Hello,

You'll need to contact ZenCart about this issue and see if there are any known issues with ZenCart. We cannot provide script debugging support."

"Hello,

It looks like you are just getting too much traffic to be on a shared hosting platform. You need to upgrade to a VPS. The issue isn't with the disk space and bandwidth, it's that you're using too much CPU time. On a VPS you have a very large slice of the CPU all to yourself, so you would not have these issues."


4) mySQL code injection attempts. Are you running the latest version of ZenCart?" I am running 1.3.8a

[data_digger]

Hosting company should be able to tell You if Your traffic isn't normal.

Is this new site or old one? How many products You have? Have You added many products/categories/manufacturers/images recently? Maybe You installed some module recently?

[Kim]

Also - who is your host?
And have you applied the Security patch posted back in June?

[DrByte]

Since you decided to post your issue in someone else's thread, I would hope that you actually read through the thread and considered the suggestions given to the previous poster.
However, I see no evidence in your post which suggests you've done anything to inspect the root cause yourself.
ie: what happened when you followed my suggestions posted as the first reply to the original poster?

I'd start by using FTP to download a complete copy of all the files on your site.
Then use WinMerge to compare them with your working files already on your PC. Make sure there's no corruption in any of the files and that nothing has been hacked in them.
Then do a comparison against a freshly-downloaded-and-unzipped copy of the same version of Zen Cart ... just to be sure it wasn't caused by an edit you did in your own working files. Naturally your customizations will be different, but need to be looked at carefully.

You could also ask your host if (during the time of the overload) there were any extremely-slow-running MySQL queries or excessive numbers of unclosed MySQL connections from your account?

Also, as Kim mentioned, is your site fully patched? All forum members were emailed about an important security patch back in June 2009.
And, a list of important patches is prominently posted in the News area, as well as at the top of every forum section.

Also, I notice that all the URLs from the logs you posted, are not standard URLs generated by Zen Cart. Thus, you've got some sort of addon involved too. Perhaps turning that off, and maybe several others too, might help you isolate where some of the performance bottlenecks are for you.

If your hosting account has NOT been having these performance problems previously, then you've likely installed an addon that's causing you problems, or you've been hacked.
Only *you* can figure that part out.

http://www.zen-cart.com/wiki/index.p...ing_From_Hacks

It could also be that you've been having these problems all along, causing some server problems for the hosting company, and maybe the hosting company has just recently turned on some performance monitoring and your site suddenly came up in their first analysis, thus making you their first candidate to slap around. Either way, you'll need to narrow down the problem by working up a list of differences between your site and a brand new clean uncustomized install, and sort out whatever you've got that's breaking things.

[lextechs]

Also - who is your host?
And have you applied the Security patch posted back in June?

hosting company is hostforweb.com. yes i applied the new patch when the zencart admin told me i was not up date and a new patch was needed back when it first came out.

[lextechs]

Since you decided to post your issue in someone else's thread, I would hope that you actually read through the thread and considered the suggestions given to the previous poster.
However, I see no evidence in your post which suggests you've done anything to inspect the root cause yourself.
ie: what happened when you followed my suggestions posted as the first reply to the original poster?

Also, as Kim mentioned, is your site fully patched? All forum members were emailed about an important security patch back in June 2009.
And, a list of important patches is prominently posted in the News area, as well as at the top of every forum section.

Also, I notice that all the URLs from the logs you posted, are not standard URLs generated by Zen Cart. Thus, you've got some sort of addon involved too. Perhaps turning that off, and maybe several others too, might help you isolate where some of the performance bottlenecks are for you.

If your hosting account has NOT been having these performance problems previously, then you've likely installed an addon that's causing you problems, or you've been hacked.
Only *you* can figure that part out.

http://www.zen-cart.com/wiki/index.p...ing_From_Hacks

It could also be that you've been having these problems all along, causing some server problems for the hosting company, and maybe the hosting company has just recently turned on some performance monitoring and your site suddenly came up in their first analysis, thus making you their first candidate to slap around. Either way, you'll need to narrow down the problem by working up a list of differences between your site and a brand new clean uncustomized install, and sort out whatever you've got that's breaking things.

i was not aware that threads with similar problems are only for the person having the problem. I read this thread and it seems the closet to what problem i am having if it is not by all means remove my thread and place in the respective area of the forum.

Thanks for you help, i decided the VPS might be a better move for now, since there seem to be no clear answer.

[lextechs]

Hosting company should be able to tell You if Your traffic isn't normal.

Is this new site or old one? How many products You have? Have You added many products/categories/manufacturers/images recently? Maybe You installed some module recently?

this site has being running on this hosting company for 3-4 year now. I have a direct feed from my distributors that uploads products and categories daily. There are no new modules every thing have always been there on the site

[DrByte]

i was not aware that threads with similar problems are only for the person having the problem. I read this thread and it seems the closet to what problem i am having if it is not by all means remove my thread and place in the respective area of the forum.

You missed my point.

I was identifying the fact that suggestions were made, and you didn't indicate whether you had *used* those same suggestions for your situation, which you acknowledged seemed "close" enough to theirs.