Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

The CabinetGuy

Started by cabinetguy on 13 Jan 2012, 5:36 PM · Views: 4,117

Results 21 to 40 of 43
15 Jan 2012, 8:42 PM
#21
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

The CabinetGuy

thanks, I'll do that and let you know if I find something helpful and how it turns out....

Keith

15 Jan 2012, 8:44 PM
#22
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Sounds like a winner ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

17 Jan 2012, 6:30 PM
#23
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: The CabinetGuy

Hey Keith. As Zen Cart's resident "server tech guy," Linda asked me to step in and offer some advice.

Based on Linda's encyclopedic knowledge of product attributes, we believe that the server is choking on the sheer volume of data in this scenario. The available memory is not enough to hold the data. So there's two memory limits that you need to check, and max out.

Linda pointed you to the first one, PHP's memory limit (memory_limit in php.ini). You upped it to 512 MB, but I would guess that your server has additional capacity. Find out how much RAM your system has, and then set memory_limit somewhere below that amount. For example, if your system has 4 GB of memory, I might set PHP's memory_limit to 3 GB.

memory_limit = 3G

Restart Apache, and try your checkout again.

If you still choke out, then the choke point is likely further down the stack in MySQL. One step at a time though; try this and report back.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

17 Jan 2012, 7:44 PM
#24
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

thanks for the insight.

my vps plan has a limit of 768 mb of php memory and we are maxed out without having to go to another plan.

With this, there is no improvement.

thx

21 Jan 2012, 7:26 PM
#25
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: The CabinetGuy

I'm afraid you've run into the all-too-common scenario of having outgrown your server. Time to upgrade. :smile:

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

23 Jan 2012, 7:57 PM
#26
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

so, you think this is solely a function of my server?

I can process large orders in my cart all day long until I sign in...that's when the trouble starts. If I sign in, the system seems to time out. If i do this as a guest, everything is fine until I sign in then it bogs...

What is the relationship with signing in versus not signing in...?

Keith.

24 Jan 2012, 3:56 PM
#27
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: The CabinetGuy

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

24 Jan 2012, 4:03 PM
#28
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: The CabinetGuy

(Per discussion with Ajeh) When you're not logged in, items in the shopping cart exist only in the session. As soon as you log in, those items get permanently stored in the database. In this case, your products' high degree of complexity is exposing some inefficiencies in the optimization of the core code in ZC v1.x, resulting in the slowdown you see, due to higher number of queries.

Unfortunately, optimizing memory in MySQL is not as straightforward as with PHP. To get started, could you please post the contents of your my.cnf file?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

24 Jan 2012, 4:32 PM
#29
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Are you using USPS only for First Class?

What are you using Zone Rates for?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Jan 2012, 4:40 PM
#30
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

i added the zone rate only for Ontario, canada... for some reason, the usps would not pull the other international rates.

Keith

24 Jan 2012, 4:42 PM
#31
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

You also have 10000 products and the 1 special in the sidebox ... and going to the Specials page get 1 Special and a broken page ... how many specials do you really have?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Jan 2012, 4:44 PM
#32
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Ajeh:

Are you using USPS only for First Class?

What are you using Zone Rates for?

I have turned it off again. It was not normally active.

Keith

24 Jan 2012, 4:49 PM
#33
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Ajeh:

You also have 10000 products and the 1 special in the sidebox ... and going to the Specials page get 1 Special and a broken page ... how many specials do you really have?

1 special

24 Jan 2012, 5:02 PM
#34
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Just as a test, can you turn off the Specials sidebox?

What about the USPS are you only using it for First Class shipping?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Jan 2012, 5:29 PM
#35
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

i am now running no specials and yes, i only ship USPS 1st Class.

thx

24 Jan 2012, 5:50 PM
#36
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

If you only use USPS on 13oz orders, then you could customize it not to even get the quote for larger orders with the code in RED:

    // disable only when entire cart is free shipping
    if (zen_get_shipping_enabled($this->code)) {
      $this->enabled = ((MODULE_SHIPPING_USPS_STATUS == 'True') ? true : false);
    }

    if (!IS_ADMIN_FLAG) {
      global $cart;
      if ($_SESSION['cart']->show_weight() > 0.8125) {
        $this->enabled = false;
      }
    }

Then, you do not waste time on the quote and do not see that USPS at all with the error message ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Jan 2012, 5:55 PM
#37
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Could you check the file:
/includes/modules/footer.php

and see if it is current and up to date?

It is missing some of the data on the Parse time display ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

24 Jan 2012, 5:58 PM
#38
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Ajeh:

Could you check the file:
/includes/modules/footer.php

and see if it is current and up to date?

It is missing some of the data on the Parse time display ...

if (!defined('IS_ADMIN_FLAG')) {

die('Illegal Access');

}

$time_start = explode(' ', PAGE_PARSE_START_TIME);

$time_end = explode(' ', microtime());

$parse_time = number_format(($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0])), 3);

if (STORE_PAGE_PARSE_TIME == 'true') {

error_log(strftime(STORE_PARSE_DATE_TIME_FORMAT) . ' - ' . $_SERVER['REQUEST_URI'] . ' (' . $parse_time . 's)' . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);

}

?>

24 Jan 2012, 6:00 PM
#39
cabinetguy avatar

cabinetguy

Zen Follower

Join Date:
Feb 2008
Location:
Tx gulf coast
Posts:
126
Plugin Contributions:
0

Re: The CabinetGuy

Ajeh:

If you only use USPS on 13oz orders, then you could customize it not to even get the quote for larger orders with the code in RED:

// disable only when entire cart is free shipping
if (zen_get_shipping_enabled($this->code)) {
  $this->enabled = ((MODULE_SHIPPING_USPS_STATUS == 'True') ? true : false);
}

if (!IS_ADMIN_FLAG) {
global $cart;
if ($_SESSION['cart']->show_weight() > 0.8125) {
$this->enabled = false;
}
}

> 
> Then, you do not waste time on the quote and do not see that USPS at all with the error message ...

Sometimes, I turn on the priority mail if I need to for a customer situation...  What effect will this have on doing that?

Keith
24 Jan 2012, 6:13 PM
#40
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: The CabinetGuy

Yes it would as the code is designed to turn it off if the weight is over 13oz ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!