[ic] Orderline is not being written

Kevin Walsh interchange-users@icdevgroup.org
Mon Sep 16 12:25:02 2002


> I have a catalog that is not recording to the orderline table and could use
> some tips.  (This is IC 4.8.1, RH Linux 7.2, Perl 5.6.1, and mySQL 3.23.41)
> 
> It is likely the data stopped being written about the time I added a new
> field to the table (which I didn't get around to using yet), but I didn't
> pay close attention.  Transactions are being written to that table.  I've
> checked permissions, and they're the same.  The keys are the same as for
> other catalogs.  I've restarted the IC server, and the mysql server.  I even
> made the dbconf/orderline.mysql file match the data table exactly (even
> though I doubted that was important) and restarted IC.
> 
> The catalog's logs/log file says "There was an error adding to the
> transaction log" and there are no entries there to indicate addition of an
> sku to the orderline table.
> 
> Otherwise I see no clues.  Nothing in the interchange error log, nor the
> catalog's error log.  My programs have no problem reading the table, and
> I've used an SQL gui front end to manually add an orderline record.
> 
What sort of column did you add?  If the column is numeric, rather than
character-based then did you note that in your orderline.mysql?

Check that the new column name is not a reserved word.  I expect that
MySQL would have prevented you from modifying the table if that was
the case, but check it anyway.

Are you trying to add multiple lines of data into a character-based
column without filtering the CRs?

Are you attempting to add a NULL value into a NOT NULL column?

...and various other questions.

Try removing your new column from the log_transaction file to see if
the column is to blame at all.  Perhaps something else is wrong, such
as a syntax error elsewhere or MS editor artefacts in the file (LF at
the end of each line, for instance).

You could restore a working backup and then check for diffs.

If you can't get it working, then there are several consultants who
will be able to sort it out for you.

Good luck.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/