Post by AutoSuppliesDirect » Mon Mar 31, 2014 11:29 am

Hey guys I've been having problem after problem, talked to my host and they say now this is through opencart. My current problem is that my site and my backend either don't load at all or take forever (I mean like 15 minutes), or gives me an error that I can't get right now. I'm hosting with Bluehost and they said what it means is that there are too many users online, and that somehow opencart is keeping a mysql? or something like that open instead of closing it.
This is my website, maybe you can get the error or have an idea...
http://www.autosuppliesdirect.com
This is keeping me from uploading products and most of all from having people view the site! Like I said I've had nothing but problems, the site recently vanished and wasn't backed up, I re-did everything once again. I just want a nice functioning website!

Some background info (I don't know what's relevant or not)
-Through my one account with Bluehost I have about 5 domains, the others are flops and aren't used but when I check dont have these problems
-I have several extensions installed including a template
-In the past I have had people work to speed up the site and did some myself (it was much better back then)
-There are probably around 15,000 products uploaded now, will have closer to 100,000 soon

Any help would be great! Thank you

http://www.autosuppliesdirect.com/<<Import & Domestic Performance Parts
http://www.lovelylionesa.com/<<Perfume, Makeup, Bags, Clothes & More


New member

Posts

Joined
Fri Mar 01, 2013 11:22 pm

Post by melbagnato » Mon Mar 31, 2014 11:40 am

Hi AutoSuppliesDirect,

I'll try to get to your site and let you know how I go. I think I understand what they are saying to you, basically your host believes that someone/something is using up your resources (or connections to your database), preventing any new ones from working.

Once I have a look, I'll let you know how it goes.

- Mel

http://online.enterpriseconsulting.com.au

Site with OpenCart extensions & code downloads, many new extensions coming soon!
Follow us on twitter for more updates

Image


User avatar
Active Member

Posts

Joined
Wed Jan 13, 2010 1:39 pm
Location - Melbourne

Post by AutoSuppliesDirect » Mon Mar 31, 2014 11:42 am

Thanks Mel!

http://www.autosuppliesdirect.com/<<Import & Domestic Performance Parts
http://www.lovelylionesa.com/<<Perfume, Makeup, Bags, Clothes & More


New member

Posts

Joined
Fri Mar 01, 2013 11:22 pm

Post by AutoSuppliesDirect » Mon Mar 31, 2014 11:44 am

Okay got it to come up, here's what it says:

Warning: mysql_connect() [function.mysql-connect]: User autosup3_ope1 already has more than 'max_user_connections' active connections in /home2/autosup3/public_html/system/database/mysql.php on line 6

Notice: Error: Could not make a database link using autosup3_ope1@localhost in /home2/autosup3/public_html/system/database/mysql.php on line 7

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home2/autosup3/public_html/system/database/mysql.php on line 10

Notice: Error: Could not connect to database autosup3_ope1 in /home2/autosup3/public_html/system/database/mysql.php on line 11

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/autosup3/public_html/system/database/mysql.php on line 14

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/autosup3/public_html/system/database/mysql.php on line 15

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/autosup3/public_html/system/database/mysql.php on line 16

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/autosup3/public_html/system/database/mysql.php on line 17

Notice: Trying to get property of non-object in /home2/autosup3/public_html/admin/index.php on line 47

Warning: Invalid argument supplied for foreach() in /home2/autosup3/public_html/admin/index.php on line 47

http://www.autosuppliesdirect.com/<<Import & Domestic Performance Parts
http://www.lovelylionesa.com/<<Perfume, Makeup, Bags, Clothes & More


New member

Posts

Joined
Fri Mar 01, 2013 11:22 pm

Post by melbagnato » Mon Mar 31, 2014 12:22 pm

Yep,

it timed out after 15 mins, then I got the same error page you just showed me.

There is something using up your connections to the database, then not closing them. Without access to your cpanel admin screen, I won't be able to give you hands-on-help.

Do you want to send me the cpanel details via PM and I'll take a look ?

- Mel

http://online.enterpriseconsulting.com.au

Site with OpenCart extensions & code downloads, many new extensions coming soon!
Follow us on twitter for more updates

Image


User avatar
Active Member

Posts

Joined
Wed Jan 13, 2010 1:39 pm
Location - Melbourne

Post by rempong » Mon Mar 31, 2014 12:33 pm

AFAIK, your problem is "max_user_connections". try search the forum / google it. If this happen when you have high traffic, then its time to upgrade / move hosting.

OPENCART MODULE :
Opencart Compare Link VQMOD, Link your compared product to forum/email

Copy and DIRECTLY Edit Product, the easy way.

Custom Product Sort, Full control to product sorting options

Already Sold Product Module, shows total product sold

Opencart Shortcode (Wordpress Clone)


Active Member

Posts

Joined
Fri Sep 14, 2012 2:38 pm
Location - Indonesia

Post by AutoSuppliesDirect » Tue Apr 01, 2014 3:46 am

My traffic is very low, I'm averaging only around 60 uniques a day, in the past was getting around 200 with no problems

http://www.autosuppliesdirect.com/<<Import & Domestic Performance Parts
http://www.lovelylionesa.com/<<Perfume, Makeup, Bags, Clothes & More


New member

Posts

Joined
Fri Mar 01, 2013 11:22 pm

Post by AutoSuppliesDirect » Tue Apr 01, 2014 3:48 am

Mel thank you, I PMed you

http://www.autosuppliesdirect.com/<<Import & Domestic Performance Parts
http://www.lovelylionesa.com/<<Perfume, Makeup, Bags, Clothes & More


New member

Posts

Joined
Fri Mar 01, 2013 11:22 pm

Post by melbagnato » Tue Apr 01, 2014 12:51 pm

Hi AutoSuppliesDirect,

I've worked out part of your problem and have your site responding again, but it didn't last too long.

I tested your site on the default template and the issue was still there (so it's nothing to do with your template)

I also installed a vqMod manager here. I used this to go through your extensions to see if any of those were causing the issue. I think indirectly, your SEO extensions may be contributing to the issue.

I monitored your sites visits for an hour, and almost 100% of the traffic was from Search Engine Bots (google, bing etc.). This gave pointed me to the view that your SEO modules may be affecting their behaviour (maybe your site is too attractive to them). They were taking up all the available connections to your database, and blocking everyone else out (similar symptoms to a 'Denial of Service' attack).

I have PM'd you some screenshots of some of your database issues, so you might want to get someone to look into these. Most are related to caching and other MySQL settings.

I have modified your .htaccess file to prevent the web crawlers searching your site, as they are continually taking up connections to your database. Also keep in mind, the other sub-sites you have are also going to suffer from the same issue and contribute to the problem. You can change it to allow those engines you trust to the sections of your site you'd like them to interrogate.

Your site is still a little slow for me (maybe cause I'm in Australia), but you can be the judge of that.

- Mel

http://online.enterpriseconsulting.com.au

Site with OpenCart extensions & code downloads, many new extensions coming soon!
Follow us on twitter for more updates

Image


User avatar
Active Member

Posts

Joined
Wed Jan 13, 2010 1:39 pm
Location - Melbourne

Post by melbagnato » Tue Apr 01, 2014 1:53 pm

Hi AutoSuppliesDirect,

I waited an hour and have checked your site and it's experiencing the same problem again. There are other bots at play including this one.

I'll add some more entries to the exclusion list and see how we go. I'm also going to put a robots.txt file in for now.

I've also disabled your "Smart Microdata" vqmod by renaming it to ".xml_" as it has some errors in it.

Also, your Pav Blog extension seems to be throwing up a few errors (look in your error.log in the admin console).

EDIT: 2 hours later and I've had to resort to blocking the IP addresses of the bots as they were taking over your available processes. Seems to have made a big difference.


- Mel

http://online.enterpriseconsulting.com.au

Site with OpenCart extensions & code downloads, many new extensions coming soon!
Follow us on twitter for more updates

Image


User avatar
Active Member

Posts

Joined
Wed Jan 13, 2010 1:39 pm
Location - Melbourne

Post by AutoSuppliesDirect » Thu Apr 03, 2014 10:30 am

Mel- I can't thank you enough! It works now! It's still slow as hell, but at least I can edit everything. Thank you so much

http://www.autosuppliesdirect.com/<<Import & Domestic Performance Parts
http://www.lovelylionesa.com/<<Perfume, Makeup, Bags, Clothes & More


New member

Posts

Joined
Fri Mar 01, 2013 11:22 pm
Who is online

Users browsing this forum: No registered users and 29 guests