[ic] Unable to write to MySQL table
Stefan Hornburg
racke at linuxia.de
Sat Nov 22 22:36:44 EST 2003
On Sat, 22 Nov 2003 14:53:45 -0500
Interchange User <interchange at framework.cx> 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
>
> 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. :)
I moved to idf for the same reason :-)
Ciao
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users
mailing list