[ic] Unable to write to MySQL table

[Jonathan Clark]

> 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?

I think I came across a similar problem a while ago but as of yey have had
no time to investigate it.

I suspected that the flex_editor was not happy with the key name, or aware
that it was not the default name. In my case changing the primary key name
to 'code' was the workaround.

Jonathan

--
Jonathan Clark
Webmaint.com - Building Clever Websites   http://www.webmaint.com/
Webmaint.net - Business Web Hosting       http://www.webmaint.net/