[ic] mixed up catalog.cfg files

Paul Jordan paul at gishnetwork.com
Wed May 9 12:38:13 EDT 2007


interchange-users-bounces at icdevgroup.org wrote:
> Hello All -
> 
> I made a big error yesterday and loaded a catalog.cfg file for a test
> catalog into my live catalog (and restarted).  I quickly realized my
> error and put the correct file back in place and restarted the
> catalog.  Everything looked to be running fine again.
> 
> However, when I looked at the error.log, I saw this (when applying
> the incorrect cfg file): - - - [08/May/2007:17:25:53 -0400] - - table
> orderline created: create table orderline (
>> code char(14) NOT NULL PRIMARY KEY,
>> store_id varchar(9) DEFAULT '' NOT NULL, (etc...)
> 
> There were a few other tables as well.
> 
> Then I noticed that the last two years worth of transactions and
> orderline records were gone from my database!  It also looks like
> about 5 months worth of userdb records are missing as well.
> 
> I do have a backup, but why would some of the records be deleted?  I
> just want to understand what happened so I can make sure I
> fix/restore everything correctly. 

Maybe that was the data in the products/foo.txt files? You probably
exported userdb 5 months ago (to it's unused txt file - assuming you are
using a sql db). Not sure why overwriting catalog.cfg tried to import the
txt files if there were .sql files in place... That is a little scary.


Paul Jordan



More information about the interchange-users mailing list