alexp4 Posted March 12, 2007 Posted March 12, 2007 Servcer was down due to error like this 1226 - User 'alexrevo_090806' has exceeded the 'max_questions' resource (current value: 50000) delete from whos_online where time_last_click < '1173731314' Is anybody there who can solve this database problem. Please help. Please......
Guest Posted March 12, 2007 Posted March 12, 2007 Make a back up of your DB and then dump the contents of your "who's online" table. It is usually an error somewhere in the table that causes those types of messges. People in your store with products in their carts will loose them, if your store if functioning that is. back up first :-"
Britney Posted March 13, 2007 Posted March 13, 2007 Make a back up of your DB and then dump the contents of your "who's online" table. It is usually an error somewhere in the table that causes those types of messges. People in your store with products in their carts will loose them, if your store if functioning that is. back up first :-" I had the same issue, this is how I resolved it! First off 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.
alexp4 Posted March 13, 2007 Author Posted March 13, 2007 I had the same issue, this is how I resolved it! First off 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. Thanks. Britney It works well. Great Job!!!!
digitalpowerpro Posted May 16, 2007 Posted May 16, 2007 i have just done the suggestions and is working so far, ipowerweb.com must have started putting a limitation on the max user requests in March because we have had no problems before then and now our website has been going down every week since then, and we have to delete the user and set it up again for the website to start working again. Hopefully this will fix the problem, other than that they are suggesting dedicated hosting.
Comicweb Posted November 4, 2007 Posted November 4, 2007 I had the same issue, this is how I resolved it! First off 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. I tried this, but I got the following error: Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/comicweb/public_html/osCommerce1/catalog/includes/configure.php:97) in /home/comicweb/public_html/osCommerce1/catalog/includes/functions/sessions.php on line 67 This error occurs at the top of the page. The cart sorta works with the error until you try to checkout, then I get the following two errors and the screen is blank, except for the error messages: Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/comicweb/public_html/osCommerce1/catalog/includes/configure.php:97) in /home/comicweb/public_html/osCommerce1/catalog/includes/functions/sessions.php on line 67 Warning: Cannot modify header information - headers already sent by (output started at /home/comicweb/public_html/osCommerce1/catalog/includes/configure.php:97) in /home/comicweb/public_html/osCommerce1/catalog/includes/functions/general.php on line 29 Can anyone help me figure this out? Thanks, Jeff
darkside212 Posted November 27, 2007 Posted November 27, 2007 I have tried this and it seems that every other time I navigate to a page I get this error (whether I'm in the Admin or catalog): Warning: mysql_connect(): Access denied for user: '*****@localhost' (Using password: YES) in /home/rcepower/public_html/osCommerce1/catalog/includes/functions/database.php on line 19 Unable to connect to database server! my url is www.*****.com any help would be appreciated!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.