[ic] Unable to write to MySQL table
Interchange User
interchange at framework.cx
Sat Nov 22 14:53:45 EST 2003
>> 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
Renaming my id column to code did the trick! Kind of a pain, as id has
been my MySQL standard for the last 4 years, but there you go. :)
Thanks,
Peter
More information about the interchange-users
mailing list