[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