4 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.