[ic] mysql update error

[Corey Gilmore]

Hi all,

I am having a strange problem with one of my mysql tables.  I added a
Conference database to interchange, which is an addition to a normal
product, and contains properties specific to a conference.  There is an
interface through the UI, etc.  This has worked well, up until around 2
weeks ago.  Now, when I go and edit any field for a Conference (that is
associated with a product) my changes are not saved.

The permissions on the physical database tables are correct, as are the
directory permissions.  I can update other product attributes, just
nothing with the conference table.

The error message in my error.log is:
[08/June/2001:17:21:59 -0400] pp /cgi-bin/pp/ui.html No key 'sku' found
for function='update' table='conference'

Any ideas?

thanks,
.cfg

Sorry for pastes...

$ head -1 conference.txt
sku     type    defaultlink     header  active1 label1  code1   active2
label2  code2   active3   label3  code3   active4 label4  code4   active5
label5  code5   active6 label6  code6     active7 label7  code7   active8
label8  code8   active9 label9  code9   methods

Permissions for products/conference.* are
-rw-------    1 ic       ic              1 Jun  8 17:20 conference.sql
-rw-rw----    1 ic       ic          23748 Jun  8 17:19 conference.txt

The table in mysql looks like:
desc conference;
+-------------+---------------------+------+-----+---------+-------+
| Field       | Type                | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| sku         | varchar(14)         |      | PRI |         |       |
| type        | varchar(64)         |      |     |         |       |
| defaultlink | tinyint(3) unsigned | YES  |     | 0       |       |
| header      | text                | YES  |     | NULL    |       |
| active1     | tinyint(4)          | YES  |     | NULL    |       |
| label1      | varchar(64)         | YES  |     | NULL    |       |
| code1       | text                | YES  |     | NULL    |       |
| active2     | tinyint(4)          | YES  |     | NULL    |       |
| label2      | varchar(64)         | YES  |     | NULL    |       |
| code2       | text                | YES  |     | NULL    |       |
| active3     | tinyint(4)          | YES  |     | NULL    |       |
| label3      | varchar(64)         | YES  |     | NULL    |       |
| code3       | text                | YES  |     | NULL    |       |
| active4     | tinyint(4)          | YES  |     | NULL    |       |
| label4      | varchar(64)         | YES  |     | NULL    |       |
| code4       | text                | YES  |     | NULL    |       |
| active5     | tinyint(4)          | YES  |     | NULL    |       |
| label5      | varchar(64)         | YES  |     | NULL    |       |
| code5       | text                | YES  |     | NULL    |       |
| active6     | tinyint(4)          | YES  |     | NULL    |       |
| label6      | varchar(64)         | YES  |     | NULL    |       |
| code6       | text                | YES  |     | NULL    |       |
| active7     | tinyint(4)          | YES  |     | NULL    |       |
| label7      | varchar(64)         | YES  |     | NULL    |       |
| code7       | text                | YES  |     | NULL    |       |
| active8     | tinyint(4)          | YES  |     | NULL    |       |
| label8      | varchar(64)         | YES  |     | NULL    |       |
| code8       | text                | YES  |     | NULL    |       |
| active9     | tinyint(4)          | YES  |     | NULL    |       |
| label9      | varchar(64)         | YES  |     | NULL    |       |
| code9       | text                | YES  |     | NULL    |       |
| methods     | varchar(60)         | YES  |     | NULL    |       |
+-------------+---------------------+------+-----+---------+-------+

dbconf/mysql/conference.sql looks like
# MiniVend database definition
Database  conference  conference.txt __SQLDSN__
#ifdef SQLUSER
Database  conference  USER         __SQLUSER__
#endif
#ifdef SQLPASS
Database  conference  PASS         __SQLPASS__
#endif
Database  conference  KEY          sku
Database  conference  COLUMN_DEF   "sku=CHAR(14) NOT NULL PRIMARY KEY"
Database  conference  COLUMN_DEF   "type=CHAR(64) NOT NULL"
Database  conference  COLUMN_DEF   "defaultlink=TINYINT UNSIGNED DEFAULT
'0'"
Database  conference  COLUMN_DEF   "header=TEXT"
Database  conference  COLUMN_DEF   "active1=TINYINT"
Database  conference  COLUMN_DEF   "label1=CHAR(64)"
Database  conference  COLUMN_DEF   "code1=TEXT"
Database  conference  COLUMN_DEF   "active2=TINYINT"
Database  conference  COLUMN_DEF   "label2=CHAR(64)"
Database  conference  COLUMN_DEF   "code2=TEXT"
Database  conference  COLUMN_DEF   "active3=TINYINT"
Database  conference  COLUMN_DEF   "label3=CHAR(64)"
Database  conference  COLUMN_DEF   "code3=TEXT"
Database  conference  COLUMN_DEF   "active4=TINYINT"
Database  conference  COLUMN_DEF   "label4=CHAR(64)"
Database  conference  COLUMN_DEF   "code4=TEXT"
Database  conference  COLUMN_DEF   "active5=TINYINT"
Database  conference  COLUMN_DEF   "label5=CHAR(64)"
Database  conference  COLUMN_DEF   "code5=TEXT"
Database  conference  COLUMN_DEF   "active6=TINYINT"
Database  conference  COLUMN_DEF   "label6=CHAR(64)"
Database  conference  COLUMN_DEF   "code6=TEXT"
Database  conference  COLUMN_DEF   "active7=TINYINT"
Database  conference  COLUMN_DEF   "label7=CHAR(64)"
Database  conference  COLUMN_DEF   "code7=TEXT"
Database  conference  COLUMN_DEF   "active8=TINYINT"
Database  conference  COLUMN_DEF   "label8=CHAR(64)"
Database  conference  COLUMN_DEF   "code8=TEXT"
Database  conference  COLUMN_DEF   "active9=TINYINT"
Database  conference  COLUMN_DEF   "label9=CHAR(64)"
Database  conference  COLUMN_DEF   "code9=TEXT"
Database  conference  COLUMN_DEF   "methods=CHAR(60)"