[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