[ic] Cant insert into new mysql table with UI

Martin Conrad martin at praktikant-online.org
Sun Mar 14 12:09:55 EST 2004


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'

Table structure of news:

+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| id      | int(255)     |      | PRI | NULL    |                |
| subject | varchar(255) | YES  | MUL | NULL    |                |
| content | longtext     | YES  |     | NULL    |                |
| date    | varchar(12)  |      |     | 0       |                |
+---------+--------------+------+-----+---------+----------------+

I think i have to tell funktion "insert" that id is the primary key, 
but i don't know where...

Can someone help me?

Best regards

Martin



More information about the interchange-users mailing list