Orders disappear

marik

2007-02-01 09:21

I got some orders in my admin witch have a link but if i click on it there is no order
In the file order_ext standing the adress of the costumer but futher things as what they ordered is gone.

How can that be?
Chmod is ok

treewood (OpenSolution)

2007-02-01 13:40

marik - please tell me:
1. do You see customers data but without any products? if yes - db/orders_products.php fails ... contact with provider to return backup of this file
2. You dont see any details even customers data? if yes - db/orders.php fails ... return backup of this file

marik

2007-02-02 08:17

i see the order nr, costumer, data but no sending option
if i look at the db files
everything is ok except orders.php
that one is missing the order, nr (some strange nr unix date?) and the sending option

what was going wrong than?

treewood (OpenSolution)

2007-02-02 09:10

marik - do You see in orders list status of this orders?

marik

2007-02-03 00:32

no non status

treewood (OpenSolution)

2007-02-03 10:34

marik - then problem is in db/orders.php file. contact to Your provider and ask to return backup of this file from few days

marik

2007-02-03 11:07

I have the orders back
they standing in the files so that's not the problem

but what is the problem? it's the 4th time

treewood (OpenSolution)

2007-02-03 16:29

marik - there are few possible situations:
- You have many orders and file is loaded
- server is over loaded or is very poor
- some peoples order something in the same time and maybe script colapse

marik

2007-02-04 13:48

Got a file of 100 orders
Got a new server (dual core)
orders are placed between 9 hours

treewood (OpenSolution)

2007-02-05 08:06

marik - 100 orders between 9 hours ?

marik

2007-02-05 12:36

no 10 :p

treewood (OpenSolution)

2007-02-05 13:37

marik - i can answer You what is a problem ... but in QC 2.0 we focus about this and add some security fixes

marik

2007-02-05 13:42

But i have changed the whole QC with stockcontrol etc.
i don't want start over ;)

treewood (OpenSolution)

2007-02-05 16:06

marik - best way ... do backup. maybe some cron work ... automatic script to do backup of db/ directory ... and i think it will be enough

marik

2007-02-06 09:14

The back-ups are working that's not the problem
But i want this bug fixed!

it's evil ;)

treewood (OpenSolution)

2007-02-06 10:32

marik - then read about flock() function in PHP manual and edit core/orders-ff.php files and check for function: dbThrowOrderIdTemp
You need to add flock() to file when is writting

nicarcola

2007-07-20 12:49

Can you show me how to integrate the flock statemen, because I found the function but I don;t see a write statement?

noudshoorn@scarlet.nl

nicarcola

2007-07-20 13:45

in order-ff.php of QCv2.1 I see this staement, $oFF->setLock( );, at several places. Is it allright to put this in orders-ff.php of V2.1 at the same places???