Fails to create tabledefs table

[Anonymous]

Fails to create tabledefs table

When installing on MySQL version 4.1.13 the tabledefs table is not created.

the problem is in the createtables.sql file.

CREATE TABLE tabledefs ( <snip> id int(11) NOT NULL auto_increment default '1000', <snip> ) TYPE=MyISAM;

should be...

CREATE TABLE tabledefs ( <snip> id int(11) NOT NULL auto_increment, <snip> ) TYPE=MyISAM;

you can only set a default value of null to an auto_increment field.

[pokejabba]

In createtables.sql, in the tabledefs function, change this line:

) TYPE=MyISAM;

to this:

) TYPE=MyISAM AUTO_INCREMENT=1000;

Also, remove " default '1000'" from 'id' line.

[Anonymous]

ALTER TABLE tabledefs AUTO_INCREMENT=1000;

is probably what was trying to be done.

- Stewart Smith (stewart@…)

[mipalmer]

This looks like it was resolved in changeset:67