Orders are disappearing

Mutant

2011-08-19 09:03

In 2008, I installed Quick Cart 2.0 for a client. It has been working like a charm for them since then, and I have never been asked to help with any problems or to upgrade their shop.

Until now. Orders are disappearing (when you click an order in admin it says the data can not be found). Over 80 past orders are now gone.

1) Can I fix this easily with Quick Cart 2.0? How?

2) Will an upgrade to the current version fix this? How do I perform such an upgrade? Can it be done in one step or do I need to upgrade to 3.0 first?

Thanks!

» Quick.Cart v2.x

Mutant

2011-08-19 09:15

Clarification: looks like the orders are still present in orders_ext.php but when I click the magnifying glass icon in admin I get the data can not be found error message.

Mutant

2011-08-19 10:17

Addition: checked this thread: http://opensolution.org/Quick.Cart/forum/?p=readTopic&nr=4647 and that's how our order file looks. Also checked backups dating three years back and it looks the same all the way back.

Also read this thread: http://opensolution.org/Quick.Cart/forum/?p=readTopic&nr=4688

These threads discuss how to avoid this in the future once it has happened. But how do I get my orders back?

My two questions in post #1 remain.

beholder

2011-08-23 03:57

1: no, unless you make regular weekly backups, but this has to be researched by someone knowledgeable. It could be a small thing but it could be a complete corruption. You might get some data back but probably not all orders. I've been solving this with QC 1.x and 2.x frequently.

2: yes. You should get a professional help for transition to make it right into QC 4.1. Unless you have a very very slow server in conjunction with thousands of orders, this problem should never return.

For the last year I've been fixing various problems in a system that is very heavy on resources -- I've made large progress in Quick Cart text-database format which compresses the files substantially and also speeds up operation of various parts of QC 3.x. It is all still being developed a little and might not be ready for a wide-range public deployment but once it is finished, Quick Cart will be ready for and able to process not just thousands, but tens of thousands of products/orders/files/images.
The main task now with it is to identify and fix the problems that arise from QC using too many resources. Sounds easy but it is not very easy to track these quirks.

http://cicmanec.sk/easyplugins/

Mutant

2011-08-24 20:33

Thanks for your reply. I upgraded to 4.1 in two steps (via 3.0). Looks like it solved the problem - all the old orders reappeared. Now on to tweak the design...

beholder

2011-09-06 12:05

Inspect the imported db/orders.php visually inside, if you can notice any corrupted orders. Other than that, good work, very nice.