max question

shimshon · Hangin' Around Joined: Sep 25, 2005 Posts: 48

I never had problems with my host (ipower) but recently I started to get the max questions recourse 50000 problem.
I posted about it in the forum since in the beginning I thought it was something with nuke.
However quickly people told me to change the host. Of course I was sceptic in the beginning because I thought they only wanted to make buisness (I am sure you want).
My server doesn't seem to be able to resove the problem and always claims I should reduce my queries?!
I want to change my host now and wanted to know what the best way is to do that.
I need transfer of my domain name and of my site.
I need it at a minimum cost (I don't want to pay for 2 hosts)

What is the best way to do it in a smooth manner?

Thanks,
Shimshon

fkelly · Posted: Tue Oct 03, 2006 3:45 pm

First of all, there is a work around to the Ipower problem that has been posted several times. Use the search function on "max questions" or "max queries" or the like and you will find it. It involves setting up additional users and distributing the queries among them and it also has some suggestions for getting the site going again when Ipower determines that you have exceeded the threshold and "suspends" you.

Second, you should look at what the term of your contract is with Ipower. Then do some research on hosts. Raven offers high quality, low cost hosting and there are forums devoted to that topic and where you can post pre-sales questions. Whoever you choose will set you up and you will just have to copy over your files and tables and transfer your domain name registration "pointers" to the IP addresses they give you. The transfer can take a couple of days to work thru the system but otherwise it's no big deal.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2793

Transfering is fairly easy, just have to get your files and database. I guess the hardest part is importing the database if it is too big for phpMyAdmin. You will have to use Big Dump. I've done this plenty of times.

As I'll post again, phpNuke is a database intensive script. A cap of 50000 won't support many users at all.

Raven · Posted: Tue Oct 10, 2006 5:48 pm

fkelly wrote:

First of all, there is a work around to the Ipower problem that has been posted several times. Use the search function on "max questions" or "max queries" or the like and you will find it. It involves setting up additional users and distributing the queries among them and it also has some suggestions for getting the site going again when Ipower determines that you have exceeded the threshold and "suspends" you.

Second, you should look at what the term of your contract is with Ipower. Then do some research on hosts. Raven offers high quality, low cost hosting and there are forums devoted to that topic and where you can post pre-sales questions. Whoever you choose will set you up and you will just have to copy over your files and tables and transfer your domain name registration "pointers" to the IP addresses they give you. The transfer can take a couple of days to work thru the system but otherwise it's no big deal.

Frank, if/when you get a chance, could/would you dig up that solution? I'd like to study it. Thanks!

fkelly · Posted: Tue Oct 10, 2006 7:04 pm

The threads where this is addressed are here:

Only registered users can see links on this board!
Get registered or login to the forums!

and here:

Only registered users can see links on this board!
Get registered or login to the forums!

Basically what you need to do is to set up an array of users in config.php and randomly select one of them each time config.php is loaded. Then go into your host manager and create the additional users for the database. This way the queries get "spread" over the additional users so the limit is not so easily reached.

In addition, I've found that if and when the problem happens the best solution is not to sit there waiting but just go into your host manager and reset the userids. Supposedly the user is supposed to "clear up" after a specified time period but I've found that's hit or miss.

For what it's worth, the original idea was not mine but I don't recall where I saw it. In a Forum somewhere.

montego · Posted: Tue Oct 10, 2006 9:13 pm

Wouldn't it be cool if PHP-Nuke could do this automatically AND even be able to identify, very quickly, which users are now "off limits" so that it grabs another in line. Wink

Raven · Posted: Tue Oct 10, 2006 11:05 pm

Frank - Thanks!

Montego - killing me