Installing Data Base

Posted: Sat Apr 15, 2006 12:34 am

When I try to install DB after intalling the first four country DB my site will not let me install 5 & 6.
I get the following message:

ERROR! The exact error message that your MySQL server reported is User 'vodkaliq_host' has exceeded the
'max_questions' resource (current value: 50000).

How do I ichange the (current value:) to a large size?
I als want to install a second data base on the same site.
Thanking you

Sells PC To Pay For Divorce Joined: Posts: 5661

as i recall those are restrictions caused by your host...

Posted: Sat Apr 15, 2006 8:12 am

Yes, those restrictions are caused by the host. There are some solutions posted on these forums that involve increasing the number of users and "hacking" config.php but you need to search for them, I don't have the reference handy. One thing that works as a temporary solution is to go into your host manager (that's what it's called on Ipowerweb but it depends on your host) and find the user account that is used for your msyql database for Nuke (the one that's defined as "dbuname" in config.php) and just reset it. That resets the statistics for the number of queries and allows you to go on your way. Theoretically the host is supposed to reset this after an hour elapses but I've found that's inconsistent on my host. Resetting the user has always worked and I've done the hack too to increase the number of users and spread the queries over 3 users instead of one. Fools the host until I can switch to Raven's web hosting.

edit ...
And, what the heck, I found the solution a week ago so I can find it again, look here:

http://www.ravenphpscripts.com/posts3509-highlight-.html

Just test carefully.