7 replies to this topic

[ptouch]

HELP EMERGENCY

i can't see my website nor fix anything in admin
i tried to read up on what BOXTEL suggested but i dont kno how to dd users in my database?


i get this error in my admin control pannel

1226 - User 'breakgir_p_os2' has exceeded the 'max_questions' resource (current value: 50000)

select orders_status_name, orders_status_id from orders_status where language_id = '1'

[Jack_mcs]

It means you have reached a limit set by your host. Wait for the cycle to reset and it wil work again (until you reach the limit once more). You could ask your host to increase the limit but they usually won't. In that case, if it is not something you want to put up with, you will need to change hosts.

Jack

[alexp4]

I had the same issue, I just resolved it with others help.

First of all create additional user names for your database then

go into includes/configure.php
and admin/includes/configure.php

replace this
define('DB_SERVER_USERNAME', 'username');

with

// define our database connection
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
// define('DB_SERVER_USERNAME', 'username');
$DB_SERVER_USERNAME_group[] = "username2";
$DB_SERVER_USERNAME_group[] = "username3";
$DB_SERVER_USERNAME_group[] = "username4";
$DB_SERVER_USERNAME_group[] = "username5";
$DB_SERVER_USERNAME_group[] = "username6";
define('DB_SERVER_USERNAME', $DB_SERVER_USERNAME_group[ rand( 0, (sizeof($DB_SERVER_USERNAME_group)-1) ) ]);


*Note username2 thru username6 are the additional user names you created for your database.

[nudylady]

yes, above method is good

[Jan Zonjee]

nudylady, on 21 November 2009, 06:38, said:

yes, above method is good

But reducing the number of queries is obviously a better way.

[noott123]

hi there guys.

i too am having this problem. i understand that this is a fix:

"First of all create additional user names for your database then

go into includes/configure.php
and admin/includes/configure.php

replace this
define('DB_SERVER_USERNAME', 'username');

with

// define our database connection
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
// define('DB_SERVER_USERNAME', 'username');
$DB_SERVER_USERNAME_group[] = "username2";
$DB_SERVER_USERNAME_group[] = "username3";
$DB_SERVER_USERNAME_group[] = "username4";
$DB_SERVER_USERNAME_group[] = "username5";
$DB_SERVER_USERNAME_group[] = "username6";
define('DB_SERVER_USERNAME', $DB_SERVER_USERNAME_group[ rand( 0, (sizeof($DB_SERVER_USERNAME_group)-1) ) ]);


*Note username2 thru username6 are the additional user names you created for your database. "

My question is how does one create additional user names for the database?

Any help would be most appreciated.

Regards
James

[ssfcsv]

How do I create additional user names for my database. The above directions look easy enough after that point

[Jack_mcs]

ssfcsv, on 05 May 2012, 15:18, said:

How do I create additional user names for my database. The above directions look easy enough after that point

The user names are created in that code. It is the only change you need. You create the names and then the code randomly uses one. I think a better way would be cycle through them and check the result but the above will work. However, it is not the best solution. First, it may vilate the TOS of your host and get you suspened. Second, the extra connections come at a cost and may slow the avearage access time, depending upon how often it is failing. The best solution is get a hosting plan that will accomodate your shop.