[ic] Unable to write to MySQL table

[Grant]

> 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

If changing the key name doesn't do it, make sure you have the key as a
field to be edited in the item edit section.  I just had the same problem
and that turned out to be the solution.

- Grant