[ic] Unable to write to MySQL table
Interchange User
interchange at framework.cx
Sat Nov 22 08:17:34 EST 2003
Greetings!
IC 4.9.9, MySQL 4.0.13
I have a table that I am unable to write to using the Admin UI. I can
read it just fine, and I know the MySQL account I am using has full
access to the tables. I get the following in the logs:
------------------------------------------------------------------------
192.168.0.100 gKjyC9oq:192.168.0.100 - [22/November/2003:07:49:50
-0500] n /cgi-bin/n/admin/flex_editor No key 'id' found for
function='update' table='wish_list'
------------------------------------------------------------------------
I have the following in catalog.cfg (I just added the WRITE_CONTROL
and READ_ONLY lines, but they don't appear to make a difference):
------------------------------------------------------------------------
Database wish_list wish_list.txt __SQLDSN__
Database wish_list WRITE_CONTROL 0
Database wish_list READ_ONLY 0
Database wish_list KEY id
Database wish_list COLUMN_DEF "id=int(11) NOT NULL PRIMARY KEY"
Database wish_list COLUMN_DEF "title=varchar(32)"
Database wish_list COLUMN_DEF "vendor=varchar(32)"
Database wish_list COLUMN_DEF "url=varchar(255)"
Database wish_list COLUMN_DEF "description=varchar(255)"
NoImport wish_list
------------------------------------------------------------------------
Here's the MySQL table:
mysql> desc wish_list;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| title | varchar(255) | YES | | NULL | |
| vendor | varchar(255) | YES | | NULL | |
| url | varchar(255) | YES | | NULL | |
| description | text | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
Can anyone tell me what I am doing wrong or missing?
Thank you,
Peter
More information about the interchange-users
mailing list