[ic] Disappearing Orders

[interchange-users@icdevgroup.org (Ed LaFrance)]

At 11:24 AM 10/07/2002 -0400, you wrote:
>Using IC 4.8.3.  All of our orders are not appearing in the administration 
>pages, in reports or in the order list.  All of the orders appear to be 
>files in the orders directory, but are for some reason not in the order 
>database.  Is there anyway to recreate the orders database or check its 
>integrity.  I am using the gdbm database.
>
>Thanks,
>Michael Stearne

Michael -

You should definitely check the catalog and Interchange error logs for any 
messages which pertain to problems with writing order data to the 
transactions and/or orderline tables.  I suggest you also take a look at 
the actual transactions table contents with the UI table editor, and 
perhaps export the table to text file, so you can take a peek and see if it 
contains truncated or corrupt records. WRT to rebuilding the tables from 
the files in orders or the tracking table, there is no prebuild way to do 
it that I know of. I suppose it is possible that a script could be build to 
parse the contents of the files into tab-delimited tables, but unless we 
are talking about 100's of orders here, it might be easier to just re-enter 
the missing orders by hand.

- Ed L.


===============================================================
New Media E.M.S.              Technology Solutions for Business
463 Main St., Suite D         eCommerce | Consulting | Hosting
Placerville, CA  95667        edl@newmediaems.com
(530) 622-9421                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (530) 622-9426 Fax
===============================================================