Using the "admin" section causes error

[maddhouz]

Whenever I insert a new item in my cart, I get this error:

1226 - User 'XXXX' has exceeded the 'max_questions' resource (current value: 36000)

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]

I then change the user name manually in my configure file in the admin/includes folder so that I may continue adding products. As soon as I enter another item, I get the same error after saving the product.

Is there a way to stop this error? I'm only able to enter one product each time and then I get the error. How is it that I'm exceeding the max question just by entering one product? Is it the codes?

I use "username1" in the catalog/includes/configure.php so that my visitors won't get that error. I've notice that works fine.

I use "username2" and "username3" in the admin/includes/configure.php.

Now I have to wait for both username2 & 3 to reset. Can someone Help?

[maddhouz]

Here's my configure code:

<?php
/*
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://domain.com'); // eg, http://localhost or - https://localhost should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://domain.com');
define('HTTPS_CATALOG_SERVER', 'https://domain.com');
define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/'); // where the pages are located on the server
define('DIR_WS_ADMIN', '/Store/admin/'); // absolute path required
define('DIR_FS_ADMIN', '/www/d/domain/htdocs/Store/admin/'); // absolute pate required
define('DIR_WS_CATALOG', '/Store/catalog/'); // absolute path required
define('DIR_FS_CATALOG', '/www/d/domain/htdocs/Store/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');


// define our database connection
define('DB_SERVER', 'mysql02.powweb.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'username3');
define('DB_SERVER_PASSWORD', 'xxxxxxxxxx');
define('DB_DATABASE', 'xxxxxxxxx');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'
?>

[stevel]

I note that mysql02 has been flaky - there is an announcement about it. That might be your problem.

[maddhouz]

Stevel, that's not the problem. I'm getting the same error after mysql02 was put online again.

I'm only able to input 1 product before I get the error. Something is wrong. How is it that I'm exceeding the max question (36000) just by entering one product? Is something looping?

[stevel]

I don't know what to tell you - I never see this problem on my site and don't know enough about tbe inner workings to help diagnose it. Is this a new install of osc? Are you using PowWeb's version or something newer? Have you added any "contributions" to the code?

[maddhouz]

It's not a new install. I'm using Powweb ver with no added codes.

It started one day after mysql02 went down. At that time, I was able to update at least 5 products before getting max out, which was no better.

My catalog is using "username1" which never max out for my customers. I'm using the other 2 username for the Admin section only.

[Song]

Hi MadHouz,

I was recieving that error at the begining also. I dont quite remember what I did but after looking at your config.php (admin), I see slight descrepancy from mine. See if you can adapt it. Also, look closely at the Config.php(Catalog) area also. I will be visiting the forum to see how you are fairing. Good Luck!

----Song
"I still haven't figure out why penguins walk...It annoys me"
----------------------------------------------------------------------------------


// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
define('HTTP_CATALOG_SERVER', 'http://www.yourdomain.com');
define('HTTPS_CATALOG_SERVER', 'https://www03.powweb.com:XXXXX');
define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
define('DIR_FS_DOCUMENT_ROOT', '/www/X/XXXXX/htdocs/catalog/'); // where the pages are located on the server
define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required
define('DIR_FS_ADMIN', '/www/X/XXXXX/htdocs/catalog/admin/'); // absolute pate required
define('DIR_WS_CATALOG', '/catalog/'); // absolute path required
define('DIR_FS_CATALOG', '/www/X/XXXXX/htdocs/catalog/'); // absolute path required
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
define('DB_SERVER', 'mysql03.powweb.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'XXXXX');
define('DB_SERVER_PASSWORD', 'XXXXX');
define('DB_DATABASE', 'XXXXX');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

[maddhouz]

Hey Song,

Thanks for the help.

Before: define('STORE_SESSIONS', ''); added "mysql" between quotes.

After: define('STORE_SESSIONS', 'mysql');


Before: define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/'); added "Store" after htdocs/

After: define('DIR_FS_DOCUMENT_ROOT', '/www/d/domain/htdocs/Store/');

Your code helped a great deal. After I changed my code, I updated 3 files in a row with no problems, something I wasn't able to do before. Also updated quick. Before it took around 10 seconds, this time 1 sec.

Thanks Again,

Maddhouz

[Song]

Hello Madhouze,

The following recommendations came to my mind as I joggled my memory. Please compare them to yours and please remember to backup any files before trying them.


Good Luck to you!


--- Song
"The dilemma was resolved when I found out that Penguins and Chihuahuas are really human beings...they are unsually little"


------------------------------------------------------------------------------------

LOGGING (Back office - admin/My store)

Title Value Action
Store Page Parse Time = false
Log Destination = /var/log/www/tep/page_parse_time.log
Log Date Format =
%d/%m/%Y %H:%M:%S
Display The Page Parse Time = true
Store Database Queries = false

-----------------------------------------------------------------------------------

CACHE (Back office - Admin/ My store configuration)

Title Value Action
Use Cache = false
Cache Directory= /tmp/
-----------------------------------------------------------------------------------

Config.php (catalog Area):


*/

// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
define('HTTP_SERVER', 'http://www.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
define('HTTPS_SERVER', 'https://XXXXX.powweb.com:XXXXX'); // eg, https://localhost - should not be empty for productive servers
define('ENABLE_SSL', 'true'); // secure webserver for checkout procedure?
define('HTTP_COOKIE_DOMAIN', 'www.yourdomain.com');
define('HTTPS_COOKIE_DOMAIN', 'XXXXX.powweb.com:XXXXX');
define('HTTP_COOKIE_PATH', '/catalog/');
define('HTTPS_COOKIE_PATH', '/catalog/');
define('DIR_WS_HTTP_CATALOG', '/catalog/');
define('DIR_WS_HTTPS_CATALOG', '/catalog/');
define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
define('DIR_FS_CATALOG', '/www/v/viladdia/htdocs/catalog/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
define('DB_SERVER', 'mysql03.powweb.com'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'USERNAME');
define('DB_SERVER_PASSWORD', 'PASSWORD');
define('DB_DATABASE', 'XXXXX');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>







:D :D

[maddhouz]

I did back up my files before I made the changes. It is working correctly.

Many Thanks.