Checkout_shipping error & 1226 max_questions error

[kenb]

Hello,

 

Our live store at http://www.jksalesinc.com/catalog/ is experiencing two problems, and I hope the forum can help me solve these.

 

PROBLEM 1: When a customer clicks on checkout they get 404 File not found with IE and document contains no data with Netscape. I thought this was a problem with using the shared SSL certificate at iPowerWeb, so we actually purchased our own certificate. After installing the certificate everything worked okay for a few days. At this point, I am stumped! Our catalog/includes/config.php file is configured as:

 

define('HTTP_SERVER', 'http://www.jksalesinc.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://www.jksalesinc.com'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.jksalesinc.com');

define('HTTPS_COOKIE_DOMAIN', 'www.jksalesinc.com');

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/');

 

//Added for BTS1.0

define('DIR_WS_TEMPLATES', 'templates/');

define('DIR_WS_CONTENT', DIR_WS_TEMPLATES . 'content/');

define('DIR_WS_JAVASCRIPT', DIR_WS_INCLUDES . 'javascript/');

//End BTS1.0

define('DIR_WS_DOWNLOAD_PUBLIC', 'download/');

define('DIR_FS_CATALOG', '/home/jksalesi/public_html/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'public_html/');

define('DIR_FS_DOCUMENT_ROOT', '/home/jksalesi/public_html/');

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'xxxxxxxx');

define('DB_SERVER_PASSWORD', 'xxxxxxxxx');

define('DB_DATABASE', 'jksalesi_oscommerce');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

 

PROBLEM 2: The other problem we are experiencing is a repeating error:

 

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

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]"

 

There shouldn't be enough traffic to our store to generate this. We are using osCommerce version MS2 and have quite a few contributions added. Is there any way to tweak osCommerce's PHP to lower the amount of 'max_questions'? Are there any known contributions that cause this? What webhost is recommended by most osCommerce users?

 

Any help with these problems would be greatly appreciated!! Our store is down at the most lucrative time of the year. I would like to stay with osCommerce.

[polaris]

Good Luck with ipowerweb.

[Noobish-n-stuff]

i agree, i use them also and ran into a similar problem. <_<

 

i need you to answer a couple of questions before i can tell if if i know the fix or not.

 

First, are you sure it is a SSL issue? Are you able to login, but not checkout? if so, it's not an SSL issue. Login uses SSL also.

 

Second, are you using the UPS shipping module? Not a contribution, the original that came with OSC.

 

If you can say it's not an SSL issue and you are using the UPS module, i can help!

 

It is an ISP issue. Don't go running to ipowerweb, they won't do anything. :angry: From everything that i can find, it appears that they are somehow blocking the "get" command in UPS.php. You will need to uninstall that module. Your checkout should start working again after that. One problem though (at least in my case), now there is no shipping options or charges. You now need to replace that module with a different one.

 

I found a contribution called Fedex zones or something along those lines. It works good for me, however i ran into several parse and sql errors when i was installing it. If you need a clean copy, let me know and i'll either post it or email it to you.

 

hope this helps... B)

[SaStudios]

i am having the same problem.. and i am calling ipowerweb now.. lol

[Guest]

AH! I have been searching for EVER (almost) and making change after change.. I keep getting the max_questions resource error when i try to connect to my database with checkout_shipping.php.. it must be the $products -> $cart get_products(); or whatever line. Is there an alternative to 'get'? how else can i get the array of the products in the cart? thanks for any help.

[thecodingmonkey]

you have a limit on database queries most likely --- change host unless they resolve

[Guest]

I just got this error

 

1226 - User 'importpo_ipo' has exceeded the 'max_questions' resource (current value: 10000)

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

And it has been running flawlessly since installed about 6 months ago. Nothing was changed and I can't even get into the Admin front end to see the sales I have done recently. Nor can customers get to my site. This message occurs for every query. And yes, it's Ipowerweb. :angry:

[normanhinks]

I.m also on ipowerweb and the same error has been occuring for about two weeks.

Again the tech support blame osc script even though it has run flawless prior to this.

 

I'm going to find a new home for my site.

 

Norman

 

sensual desire

[ontimedesigns]

I was receiveing this error message:

 

1226 - User 'eahobbyc_eahobby' has exceeded the 'max_questions' resource (current value: 20000)

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

E-mailed the Ipowerweb customer service....And they increased the Current Value: to 50000)

 

Hope this helps

[Guest]

anyone who was having max questions problems at iPower on the 20th? I might know why... We were _really_ hit hard that night. We could be on the same host (163), and if so, I apologize.

 

Cheers,

 

Mark

 

http://www.personalizedmementos.com

[normanhinks]

Hi Guys,

 

Glad to say that at the moment, and after extensive communication, Ipowerweb have sorted the problem (what ever it was) for my site.

 

Dont know what they did.

 

All I know is, the limit has been raised to 80000 for my admin user and it works fine.

 

so for now my site stays where it is..

 

Norm

[Guest]

Distribute your database queries into multiple users. If you are allowed to create 3 users in your database administratration panel, create 3 users using the same password.

 

Then change the line

 

define('DB_SERVER_USERNAME', 'xxxxxx');

 

to

 

$DB_SERVER_USERNAME_group[] = "xxxxxx1";
$DB_SERVER_USERNAME_group[] = "xxxxxx2";
$DB_SERVER_USERNAME_group[] = "xxxxxx3"; 
define('DB_SERVER_USERNAME', $DB_SERVER_USERNAME_group[ rand( 0, (sizeof($DB_SERVER_USERNAME_group)-1) ) ]);

 

This way, you'll be able to tripple your maximum limit.