Orders that cause V8 to crash

[chris ashdown]

We have two orders that we cannot do anything with, if we try to open them they crash actinic, If we try to delete them they crash Actinic

Guess I need to delete them from Access, Can anyone advise how to do this

No clear reason why they got corrupted but something to do with ammending the orders

V8.3 Multi-site

[outdooraction]

when the order is highlighted, right click and click on export order.

this will export it to where you say, and try and delete that way

[chris ashdown]

No joy with that, as just shows as exported but stays in same place

[cdicken]

Hi Chris

I suggest deleting the order from the database and then recreating it as a 'new order'. So take a record of all the order details, so you can recreate it accuratley.

Obviously take a snapshot of your store before attempting this, but what you can do is:

• Open the 'ActinicCatalog.mdb' file in Microsoft Access
• Open the 'Order' table
• Click in the 'Order Number' field and press 'Ctrl+F' and search for the order number you want to delete.
• Make a note of the 'Order Sequence Number'
• Now scroll along until you find the 48th and 49th columns. They should be called 'InvoiceContactID' and 'DeliverContactID'
• Make a note of the contact IDs for this order.
• Highlight the entire order row (by clicking on the grey button to the left of the row) and press 'Delete' on the keyboard.
• Next, go into the 'OrderDetail' table and look in the sixth column - 'OrderSequenceNumber'.
• You want to search for order sequence number of the order you just deleted, and delete any order detail rows with the same order sequence number.
• Now go to the 'Person' table and look at the 13th field along - ContactID.
• Delete the two contacts that apply to the deleted order.
• Finally, go to the 'PaymentHistory' table and look in the first column 'OrderNumber'.
• Delete any payment row that corresponds to the deleted order.

You can now go back into Actinic and use the 'New Order' button to recreate the order. Obviously, it will have a different number, but the details will all be the same.

[chris ashdown]

GGGGG Gulp

Thanks Chris will do