Knowledgebase
Home » Item #281
Cannot view modify_orderstatus.asp without errors after upgrading to v4.5 from a previous CactuShop version
Question
After upgrading from version 4 to version 4.5, whenever we try to look at order details or modify order status on any order placed prior to the upgrade, we get the following error message:
Order Details
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/cactushopback/modify_orderstatus.asp, line 0
Why is this?
Answer
One of the problems with upgrading is that some legacy data may not be compatible with the latest version.
In v4.5, CactuShop stores orders in more detail than before. In addition to an order record in the table tblCactuShopOrderNumbers, records for each line of the order are created in the table tblCactuShopInvoiceRows.
The modified query on the back end of CactuShop v4.5 tries to pull the invoice rows records corresponding to the order but on older v4 orders, these don't exist, hence the error.
As a workround, it may be worth considering setting up a second back end folder to allow you to view the older orders, but this won't rectify the problem on the front end with customers viewing older orders through the new v4.5 order history features.