acatalog/OrderLock.num ().

[Andrew]

Hi all

Just had a problem when a customer tried to order. He got an error message

Error reading from ../acatalog/OrderLock.num ().

Very strange as I have not touched the site for days and I was downloading orders yesterday.

Any ideas?

Andrew

[Andrew]

gone through knowledge base.

deleted *.num filesetc as it says.

refreshed site but still no *.num files.

As i have deleted them can i just make a text file with the extension .num and FTP it into acatalog directory?

Andrew

[Darren]

Hi there.

The num files should be recreated when you place an order, the problem with this is that your order numbers will start from 1 again. In version 6.1.0 and above you can change this quite simply. In Actinic version 5 you will need to do a script change:

To do this, locate OrderScript.pl in your Site folder. The path will be something like:

C:\Program files\Actinic ecommerce V5\Sites**SiteName**

Make a backup of OrderScript.pl and keep it save

Open OrderScript.pl with notepad

Find the line

my $nCounter = pack("N", 0);

in sub GetOrderNumber and change the 0 to whatever required. E.g.

my $nCounter = pack("N", 1234);

Save the file, update the site and test. If it fails, restore your original OrderScript.pl

I hope this helps.

[Andrew]

Altered the file in the OrderScript file to the next consecutive number.

Refreshed the site but orders still coming in starting at 1 then 2 etc and not my next required number.

Anyone?

Andrew

[Darren]

Hi there.

Try this, FTP to the website, browse to the acatalog folder and locate Order.num and Backup.num and rename them. Update the site with your modified OrderScript.pl

If it does not work, let me know what order number you want. I presume the site in question is http://www.jewellery247.co.uk/ ?

If it is, you are on version 5.1.6 and I have tested that it works, I can make the change and send you my OrderScript.pl (So long as you have not customised it in the past else, zip up OrderScript.pl and attach it to this thread.)

[Andrew]

Yeeeehhhhhhhhh

Worked a treat.

Didn't loose any orders as catalog emailed me with the orders in that were aborted.

Thanks Actinic for great software.

Andrew

[jayzee]

Why does this problem occur?, I have had it happen recently and followed your instruction and this sorted it out with no problems, but what is the root cause of this error.

thanks

J

[Nadeem]

Hi there

Have a read through our knowledge base article on what causes this. Here is the link

Kind Regards

[jayzee]

I have read through this and can't seem to find anything which fits as the explanation of why it stopped working.

On friday it is fine, I come back on monday and the error has appeared. I have not changed anything all weekend and I have another site as well using actinic which did not have any problems.

Any ideas how this might have happened then, as all the suggestions seem to suggest user intervention?

J

[Nadeem]

Hi there

If you have not changed anything and it stopped working, then i would imagine that the hosting company has updated their server over the weekend, which resulted in this issue. That’s the only explanation. The error is to do with ownership of files, the Actinic software cannot change this, and the system administrator can only change this.

Kind Regards

[jayzee]

Hi Thanks for the reply,

this is what i had thought. when I had come to the server on monday, the Mysql server had stopped responding so Ihad to restart the server, unfortunately I didnot check if this problem was occuring before the restart but I assume so.

could the mysql server crashing cause this problem, or maybe rebooting while someoine was in the middle of a transaction, or too much traffic on the server?

thanks
fo the help

J