[ic] autonumber with mySQL
Stefan Hornburg
racke at linuxia.de
Wed Jan 14 15:25:15 EST 2004
On Wed, 14 Jan 2004 11:50:48 -0800
"Grant" <listbox at email.com> wrote:
> Hello, I'm trying to set up a new table (correspondence) that will
> "autonumber" a new key every time a new record is written. I have this in
> my correspondence.mysql file:
>
> Database correspondence COLUMN_DEF "code=INT(5) UNSIGNED AUTO_INCREMENT
> PRIMARY_KEY"
>
> and this in my catalog.cfg
>
> Database correspondence AUTO_SEQUENCE 1
>
> The correspondence.txt file is set up with field names, but when I restart I
> get the following errors:
>
> table correspondence index failed: Table 'catname.correspondence' doesn't
> exist
> table 'correspondence' failed: Table 'catname.correspondence' doesn't exist
>
> A correspondence.autonumber file is created, but no correspondence.sql .
> Can anyone tell me what I'm missing?
Isn't your problem pretty obvious ? Take a look at the first line of any
*.mysql file of current foundation.
Bye
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users
mailing list