[ic] Unable to write to MySQL table

[Jon Jensen]

On Sat, 22 Nov 2003, Interchange User wrote:

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

You can most likely make the problem go away be renaming your primary key
to be something other than "id". The reason this is a problem is that the
table editor is passing the "id" parameter via CGI, and "id" is an alias
in Interchange for "mv_session_id".

Many two-character names have such an alias. See $ICROOT/etc/varnames for
a complete list. You should be able to remove the mv_session_id = id
mapping to fix the problem too, but if you have the chance to change the
primary key name it'll probably make life easier for you to do it that
way.

Jon