[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