I am using QC2.0 for 2,5 years now and it has always worked flawless. Many, many thanks for this product!
This morning I noticed that for more than 50 orders in my admin panel, the status record was empty! So no "pending" or "completed" but an empty field! I browsed through this forum and I discovered that this is a bug, sometimes the database files get corrupted. Nice surprise :(
Opened orders.php and indeed a whole lot of orders have disappeared from this file. How can that happen? Unfortunately I never make backups, not expecting this.
Soon I figured out the system and I noticed I can manually "repair" the orders.php by inserting the orders by hand using notepad. The system is
ordernumber $ en $ status $ unique-id
I am not sure what the "$en$" does. Found out that status 0 = waiting 1 = in order 2 = completed and 3 = cancelled. Using the unique ID, orders.php and orders_ext.php link together info of a specific order. I guess. So i can reconstruct orders and set a status. So far, so good! the only thing is... I don't remember of all 50 orders which one was completed, which one was pending and which one was cancelled??? I'd have to guess there, and maybe send a couple of e-mails to customers in order to get things straight. All in all this will take at least tonight to work through.
Any suggestions on how to restore a hidden backup or something would be nice. Otherwise... bear with me :)
Hey, I think this is the infamous QC 2.x and 1.x db corruption bug. Your orders file got very big and it got corrupted by php writing to it very frequently. I am sorry to inform you that it's going to happen again in the future. That's why it is necessary that you upgrade to newer version.
"en" means that the order was made in that language, I think.
