[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] MySQL Query
the first column is sku, in both the mysql db, and conference.txt.
My conference.mysql file in /dbconf looks like
Database conference conference.txt __SQLDSN__
#ifdef SQLUSER
Database conference USER __SQLUSER__
#endif
#ifdef SQLPASS
Database conference PASS __SQLPASS__
#endif
Database conference KEY sku
Database conference COLUMN_DEF "sku=char(14) NOT NULL PRIMARY KEY"
and i've tried dropping the database, removing products/conference.sql,
and re-importing (letting ic create the db) with no luck.
.cfg
On 13 Jun 2001, Stefan Hornburg (Racke) wrote:
> Corey Gilmore <cfg@dln.uvm.edu> writes:
>
> > Is there a way to get interchange to display the queries that its
> > executing?
> >
> > I get the following error when I try to update a field in the admin ui
> >
> > /cgi-bin/pp/ui.html No key 'sku' found for function='insert'
> > table='conference'
> >
> > and I want to see what query ic is trying to run.
>
> What is the name of the first column of table conference ?
>
> This error message is generated within update_data() in
> the main script (interchange).
>
> Ciao
> Racke
>
>
