[ic] mixed up catalog.cfg files

Paul Jordan paul at gishnetwork.com
Wed May 9 12:43:06 EDT 2007


interchange-users-bounces at icdevgroup.org wrote:
> On May 9, 2007, at 11:27 AM, Dan Bergan 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.
> You'll want to check out the NoImport directive to prevent that from
> happening in the future: 
> 
> http://www.icdevgroup.org/interchange-doc-5.2.0/frames/icconfi
> g_118.html 


I agree - I use this religiously. I think NoImport should be the default
BTW, or there should be some NoImport * facility that can be overridden by
the mysql definition itself, or lack thereof.

Paul Jordan




More information about the interchange-users mailing list