Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Anyone who can solve 1226 error massege?


alexp4

Recommended Posts

Posted

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

Posted

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 :-"

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

Posted
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!!!!

  • 2 months later...
Posted

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.

  • 5 months later...
Posted
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

  • 4 weeks later...
Posted

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...