[solved] "shopping cart" page back-office problem

[NNGNews]

Hello, I have big problems lately with the pages of shopping carts in the back-office, gradually got worse and now I can almost never open it, and the page goes often in error

 

Basically, from "Customers" clicking on "shopping carts" there is a little time of waiting and then I get the classic white page error.

 

I thought it was a problem of "too much data" I tried to delete half of the carts but the problem still is not solved.

 

It seems that before open the page makes some controls (not sure if Admin or thing like that) and then goes into error.

 

How to solve it, please?

 

thanks, sorry for my english

 

PS

I have version 1.4.7

 

__________________________

http://www.kissene.com/en

Edited April 30, 2013 by NNGNews (see edit history)

[PascalVG]

Many times things that get 'gradually worse' might be a memory problem.

Try to increase your memory_limit to say 128M and see if that helps:

 

Open file config/config.inc.php and add:

ini_set('memory_limit','128M');

 

My 2 cents,

pascal

Edited April 30, 2013 by PascalVG
(Missing apostrophe fixed) (see edit history)

[NNGNews]

Many times things that get 'gradually worse' might be a memory problem.

Try to increase your memory_limit to say 128M and see if that helps:

 

Open file config/config.inc.php and add:

ini_set('memory_limit','128M');

 

My 2 cents,

pascal

 

Ok, I thought it was a problem of cookies, 'cause I had the same problem in cookie.php page and someone told me to cancel some instructions.

 

Anyway your suggestion is about a prestashop page or do you mean change config of my pc ?

Thank you

Edited April 30, 2013 by PascalVG
(Missing Apostrophe fixed) (see edit history)

[PascalVG]

On your host, in your prestashop installation folder, you have a 'config' folder. In there should be a file config.inc.php

Make the addition there.

 

Hope it helps,

pascal

[benjamin utterback]

Thanks Pascal, you should also get in contact with your hosting provider to make sure that they allow those changes. Sometimes the host actually needs to "approve' or "turn on" the changes

[NNGNews]

I made the changes but the problem still remain

:-(

 

In your sentence there is an apostrophe missing at the end

 

Sometimes it works sometimes not, that's the worst way, 'cause you can't find the real problem ...

It seems something of cookies or you're right about memory capacity, because the page takes some second to load and then appear the blank page error

 

Anyway I left your suggestions on the config file

[PascalVG]

Does the problem stay the same using other browsers? Try chrome, firefox, safari, ...

[NNGNews]

Does the problem stay the same using other browsers? Try chrome, firefox, safari, ...

 

OPS !

I have only Chrome, but now I've tried 3 times and every time worked !

It takes a very long time to load the page but instead of I.Explorer with Chrome works !

 

Thanks very much !

But now I would know what is the problem, which setting we have to change to make it works also with IE ..

[PascalVG]

Hmm,

Maybe download firefox as well (great browser for development, many add-ons available) and see how that works. IE is really a special case. Many 'Microsoft Improvements" in it, that make it 'less compatible' with the rest of the world. They have their own standards...

Why it is slow can be many factors. Your internet provider used, internet speed/sharing, Wifi local problems (interference with other wifi devices), the host you use, the 'path' from you to your host and back, memory (local and host), etc.

Hard to say what can help.

 

Locally, have enough memory, a de-fragmented harddisk with enough free GB's, take a speedy enough internet package (not shared with too many customers etc.). Not too many apps on the background (especially internet contents limiters (parent-controlling constraints, anti ID theft)/Virusscanners/firewalls can be a big bottleneck. You might check when turning it off, if that increases speed significantly. If so, consider to change virus scanner/firewall)).

 

Host can be a cause when sharing with other customers limits your speed, other limitations (memory, resources). You might try out other hosts with a test setup and see if that works faster. Where do they have their servers, who are your clients (geographically etc). Does that match?

 

You see, quite a list (not complete by far) with points to consider/think of.

Try the most obvious and see if there's any significant change.

 

My 2 cents,

pascal

[NNGNews]

Thanks very very much

Now I will work on it

[PascalVG]

You're welcome. Let us know when there are any specific points you bump into.

[Pronesis]

Hi,

sorry if I re-open the thread marked as [solved] but for me the access to the BO page Customers->Shopping cart is drammatically slow.

Consider that i have a dedicated server where only one shop is running and the performance are very good.

I saw that the list of shopping cart is created with a query that require approx. 3 sec to execute, in AdminTabControllor:

 

$this->_select = 'CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) `customer`, a.id_cart total, ca.name carrier, o.id_order, IF(co.id_guest, 1, 0) id_guest';
        $this->_join = 'LEFT JOIN '._DB_PREFIX_.'customer c ON (c.id_customer = a.id_customer)
        LEFT JOIN '._DB_PREFIX_.'currency cu ON (cu.id_currency = a.id_currency)
        LEFT JOIN '._DB_PREFIX_.'carrier ca ON (ca.id_carrier = a.id_carrier)
        LEFT JOIN '._DB_PREFIX_.'orders o ON (o.id_cart = a.id_cart)
        LEFT JOIN `'._DB_PREFIX_.'connections` co ON (a.id_guest = co.id_guest AND TIME_TO_SEC(TIMEDIFF(NOW(), co.`date_add`)) < 1800)';

 

I've try to clean the ghost shopping carts (carts where i don't have an id_customer and carts not finalized to an order) now i've only 2199 finalized/confirmed carts but the page still loading very slow.

Someone can suggest me which is the class or the method that I can check to resolve this problem?

The version of my PS is 1.5.4.1


Many thanks

 

[Pronesis]

Found it

the problem is this function:

getOrderTotalUsingTaxCalculationMethod

 

called as callback of the column 'Total' in the list viwe of all carts:

'total' => array(
                'title' => $this->l('Total'),
                'callback' => 'getOrderTotalUsingTaxCalculationMethod',

 

The function is slow beacuse for every cart make the sum of the price of all products and add also the rules (if present).

 

I think there's no solution for now if you want the "real" total cart!!!

 

But a reply from a Prestashop [spam-filter] would be appreciated