one of the customers "broken" after upgrade from 1.5.4.1 to 1.6.0.11

[HiFish]

Greetings to the prestashop community,

 

I am looking for some advice on a "wierd" error that we noticed 3 days after upgrading and sadly not during the 1 week of looking for errors beforehand in our testing environment.

The Shop this concerns is also used to manage the one local Store where people actually come by to buy stuff the old fashioned way. For purposes of Inventory and statistics we use one "Cashier" Customer for all the Sales in the Store. So this one customer is now up to 660 Orders and even more sold items.

Now the wierd behavior:

- In 1.6.0.11 i can no longer "view" this customer, it loads a long time an then i get an Script-Error 500 (i used dev mode and could not find anything in any of the logs for this)

- even worse, when trying to manualy add a order with this customer i can never put more than one item in the basket (the previous item always disapears). I guess there must be a big bunch of abbandoned baskets cluttering up the system for this customer? dont know where to look for that.

- Editing the customer still works (like rename or change password)

- everything works fine with any other customer, or newly created customers.

 

My worst-case solution is to create a new customer everytime this happens (when they have to many orders?), but that mucks up the statistics and doesnt adress the underlying problem. I cant realy imagine that its a performance issue, because the webserver is supposed to have enough resources for running prestashop. Im going to set up a copy in the local test envirenment again to see if the behavior changes.

 

Im grateful for any advice on this,

 

Michael

[HiFish]

I did some database cleanup (like droping 2 mio rows from ps_guest), now the back office feels a lot faster again. Hasn't fixed the problem described above though.

[tuk66]

Your data are probably corrupted. It can be just one record, or many. Ask an expert, she need to see your data.