I am using QC v1.4 loaded, I was just looking at my orders list and then all of a sudden there was no status for any order written in the order status column, and now when I click on the orders 'more' button I get the following message:
"Data not found « go back"
I have checked the database files and all the information is still there but for some reason isn't loading. I hope someone can help me fix this because otherwise I am going to have re-build my cart from the beginning! :(
Thank you in advance!
Jo
2007-01-19 16:59
Also, I have just tried to place a test order, it hasn't saved the data at all and has given me a ID no. which is not correct.
I have no idea what has happened as I have not altered the code for months, I have just been using it through the admin panel as normal.
I'm sad because I think if it is possible for the cart to just go wrong for no reason I might have switch to something more stable, but I love QC! *sigh*
Jo
2007-01-19 17:06
Sorry, me again. The test order has been saved but it has given it order ID no. 6, when previously I was up to order ID 218. Does anyone have any idea why it would do this?!
This thought occurs, isn't there a discussion on the size limitation of orders in the cart? something about the volume of the allocated items being around 200 or so..
Do you have lots of thingys for sale or orders made? - also another item - where it has been mentioned that once this limitation has been reached the only thing to do is.... :-<
Hope this helps you - but I'm sorry it happened...
Jo
2007-01-22 19:06
Thanks for the response idaryl.
I have replaced db/orders.php, db/orders_ext.php & db/orders_products.php with original blank files and this seems to have fixed the problem.
I have kept the 1 test order that was already in the original files there, then copied that and renamed it order ID. no 219, so that when customers start placing orders again it will start at 220. I hope this doesn't cause a problem if there is a limitation of 200 as you say. If it does I will just have to start at ID no. 1 again.
skaven krysa
2007-01-23 20:18
I have the same problem. When I have replaced the db/orders.php, db/orders_ext.php & db/orders_products.php with original blank files, after a few new orders the problem starts again.
skaven krysa - in QC 2.0 we give some security functions to safe this files. we have some questions: - do You have many visits every day? - server have big load?
skaven krysa
2007-01-25 12:22
treewood: I have amout 120 visites per day and i thing, that server is ok (quite big load) - www.savana.cz
skaven krysa - if they missing that is good ... if someone will finish order then this last column will be empty. it is for optimization and to have smaller files. strange is that:
82$$$$ 40$$$$ 06$$$$
skaven krysa
2007-01-29 08:48
hmm... any advice?
skaven krysa
2007-01-29 08:53
Strange are also ids of orders:
169655507 2007-01-28 15:35:16 Nevyřízena tisk více smaž 169655487 2007-01-28 10:28:25 Nevyřízena tisk více smaž 169652757 2007-01-25 15:47:57 tisk více smaž 169534324 2007-01-24 10:49:22 tisk více smaž 169533583 2007-01-23 19:53:41 tisk více smaž 327 2007-01-22 20:12:30 tisk více smaž
I have the very same problem with QC 1.3. Order Status column in administration is empty and Data not found while clicking More icon.
I have usually 20-50 visits per day, 2 orders per day and database files are 3 kB (orders.php), 39 kB (orders_ext.php) and 35 kB respectively (orders_products.php). I have nearly 300 products.
Everything has been working great, cart is online for about 6 months and I didn't touch the code ever since.
It seems like something reset. I can't reach details for orders placed until 20th April through administration, although each order placed after 20th April is alright. I can click More, go through details and Status is shown in Order list column. Order ID is coming again from 0.
I'm working on another e-shop using Quick.Cart 2.1, so I tried to move Orders db files into that and: I can click and go through orders details but Status column is still empty (core/order-admin.php, lines 60-66. It acts like $aStatus[$aList['iOrder']] is not set).
I will try to find out what happened, but any info is appreciated.
Polygrafix - first contact with server provider and ask for backup of db/orders.php, db/orders_products.php and db/orders_ext.php. We suggest to create backup every day.
I went through the db files. Problem is definitely there, in orders.php. That file was/is broken and started all over with order IDs 40, 63, 122, 182 for finished orders. Then I have IDs 389-576 for unfinished orders (status 0), only 2 are finished and shown in administration.
My observation of what probably happened few days ago, with almost 300 finished orders and 15100 both finished and unfinished orders (= basket was used, I suppose):
orders.php -------------------> somehow blanked ------> starts giving out IDs from 0 orders_ext.php ------------> ----------------------------> writes new finished Orders info OVER already stored information orders_products.php -------> ----------------------------> continues with adding products from new orders
So, I have lost data in orders.php, that's why browsing orders in administration doesn't behalf as expected. I will contact my provider for backups of orders db files and either use them or go on with blank files.
