News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

avoid max_questions error

Started by Wounded Knee, September 15, 2005, 08:29:13 AM

Previous topic - Next topic

Wounded Knee

i'm spanish, sorry for my english

yesterday i had this problem in ipowerweb hosting.

searching in google found one tip. it's work for me

in settings.php

find
$db_user = 'your_db_user;


and remplace by
$db_user_array[] = "one_db_user";
$db_user_array[] = "other_db_user";
$db_user_array[] = "other_db_user";
$db_user = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];


if this tip was posted before sorry i don't found it.


Joshua Dickerson

wtf? You don't know what your MySQL user privs are? I am not sure I understand what you are doing with that array.
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?


Joshua Dickerson

That is the most retarded thing I have ever seen a host do. Why the hell would you have them create extra users? That host is retarded.
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

[Unknown]

Calm down, Groundup.

Although, I have to say it's a bit strange... why not just raise the limit, if you're going to tell your clients how to bypass it?

-[Unknown]

Joshua Dickerson

heh, wow. I didn't even realize how bad that post looks. They say they use PHP 5 and PHP 4. Do they move you to another server if you want to upgrade? Also using Zend Optimizer..
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

calash

There are a few hosts that do this.  Powweb posted the reason once...I forget the exact text but basically it was more of a load to have one user do 3 times as many queries than for it to be split up between 3..plus not everybody checks the forum, so many only use 1 account.

For the php question, they let you use the .htaccess file to direct what will process your php, so you can choose.  Also if you name your files .php5 it will use the PHP 5 processor.


Joshua Dickerson

calash: that makes no sense. It would be better to have less users.
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

calash

*shrug*

I dont make the rules, I just pay the montly fee to follow them ;)

Metelee

That's right, i'm with Ipowerweb also...

Now what do i have to do to fix it please??

Elmacik

hmm.. then we shouldnt use powweb for php+mysql scripts..
Home of Elmacik

houston

#11
I'm on hold right now with ipowerweb. I can not connect to any of my databases.


They were absolutly no help at all. Accordong to them everything was working as it should.

And now I can connect to all my db's again. Must be thoose gremlins

oscar2001

Quote from: houston on October 13, 2005, 02:47:45 PM
I'm on hold right now with ipowerweb. I can not connect to any of my databases.


They were absolutly no help at all. Accordong to them everything was working as it should.

And now I can connect to all my db's again. Must be thoose gremlins
I know that feeling,, even the online support chat they keep you waiting till never

oscar2001

Quote from: Wounded Knee on September 15, 2005, 08:29:13 AM
i'm spanish, sorry for my english

yesterday i had this problem in ipowerweb hosting.

searching in google found one tip. it's work for me

in settings.php

find
$db_user = 'your_db_user;


and remplace by
$db_user_array[] = "one_db_user";
$db_user_array[] = "other_db_user";
$db_user_array[] = "other_db_user";
$db_user = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];


if this tip was posted before sorry i don't found it.


Many thanks for this tip as its stopped a lot of headaches for me with ipowerweb(all tied together with poweb,ipower etc) and their stupid 50,000 max queries limit , seems like a silly thing to not just raise the limit but hey this seems to work ok. :)

googlebot2

Thanks for this tip...

My server/database : so far so good..... ;)
articlemarketer.com - This website SUCKS!!! :mad: Do not sign up with them. They are rip off plus bad customer service. Consider yourself warned.

edi67

for example i have db_user=crazyzonews
i must complete the orhter lines?
CrazyZone - My SMF Forum


From the difficult the hardening of the man you can see

metallica48423

did you try the tip posted in the first post of this topic?
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Advertisement: