About 100 DB error messages-too many connections?

[MickDoneDee]

Originally Posted by snakes1100

It means your host has set a limit as to how many times your db user can connect to your db, talk to your host about raising the limit of connections for that user.

If you are on a shared plan like I am and your site is crawled by many bots at the same time this error will be flagged. Since my ISP had already raised the connection limit for my site I had to block the Yahoo! Slurp Spider because there would be as many as 200 visiting my site at the same time. I asked Yahoo to limit the number of crawlers to my site. When they ignored my request I blocked the crawler using .htaccess.

I put this code at the bottom of the .htaccess file:

 # Deny access to Yahoo! Slurp spider
 RewriteCond %{HTTP_USER_AGENT} Slurp
 RewriteRule .* - [F,L]

Now, I get about 2 Yahoo! Slurp Spiders a day instead of hundreds. I've never received a 'max_user_connections' error since.