[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] mysql update error
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)"
