[ic] Cant insert into new mysql table with UI
Joachim Leidinger
jojo at leidinger.net
Sun Mar 14 18:39:08 EST 2004
Martin Conrad wrote:
> So, 14. März 2004 18:27 Mike Heins:
>
>>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.
Where can I find a list of such kind of protected reserved variable
names for IC?
Many Thanks!
Joachim
--
Hans-Joachim Leidinger | Dipl.-Phys.Ing.
[joachim at leidinger.net]
http://www.leidinger.net
More information about the interchange-users
mailing list