My b2evolution Version: 3.1.0-beta

Hi All,

anybody got an idea what is going wrong here?

My mySQl version is 4.0.24. Character set is set to "latin1". Character sets available are "latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251"

Error Message:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL, PRIMARY KEY (ufdf_ID) (Errno=1064)

Your query:

CREATE TABLE evo_users__fielddefs (
ufdf_ID int(10) unsigned NOT NULL,
ufdf_type char(8) NOT NULL,
ufdf_name varchar(255) collate latin1_general_ci NOT NULL,
PRIMARY KEY (ufdf_ID)
)

Many Thanks,
Martin.