[ic] Cant insert into new mysql table with UI
Mike Heins
mike at perusion.com
Sun Mar 14 12:27:17 EST 2004
Quoting Martin Conrad (martin at praktikant-online.org):
> Hallo all,
>
> I created a new mysql table "news"
> then i create dbconf/mysql/news.mysql
>
> Database news news.txt __SQLDSN__
> Database news COLUMN_DEF "id=INT(255) primary key NOT NULL"
> Database news COLUMN_DEF "subject=VARCHAR(255) DEFAULT '' NULL,
> index(subject)"
> Database news COLUMN_DEF "content=LONGTEXT DEFAULT '' NULL"
> Database news COLUMN_DEF "date=VARCHAR(12) DEFAULT '0' NOT NULL"
>
> products/news.txt also exists as csv file
>
> At the time i try to insert data with the admin Interface i became
> the following error in debug.log:
> No key 'id' found for function='insert' table='news'
Naming a field "id" conflicts with Interchange's use of that
variable as an alias for mv_session_id. The easiest thing by
far is to name it "uid", or "code", or somesuch.
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.647.1295 tollfree 800-949-1889 <mike at perusion.com>
Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer
More information about the interchange-users
mailing list