[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