UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Create Table Problem

I've just downloaded the latest beta and the latest stable release and with both of them I get the following error on installation:

We cannot proceed.
Script:
Line#:
SQL Error: Invalid default value for 'C_Number'
SQL Error #: 1067
Query: CREATE TABLE w3t_mannelContentIslands ( C_Number MEDIUMINT(8) NOT NULL PRIMARY KEY AUTO_INCREMENT DEFAULT '0', C_Name VARCHAR(255), C_Type VARCHAR(25), C_LastUpdate INT(11), C_Source TEXT, C_IncludeNumber MEDIUMINT(4), C_IncludeBody MEDIUMINT(8), C_Javascript TINYINT(1), C_Include TINYINT(1), C_Width VARCHAR(20), C_RSS_92 TINYINT(1), C_RSS_1 TINYINT(1), C_RSS_2 TINYINT(1), C_FileLock VARCHAR(100), C_CacheFor MEDIUMINT(4), C_Ext VARCHAR(10), C_Members MEDIUMINT(4) )

Please use your back button to return to the previous page.

Anyone have any ideas on this? I'm running on Redhat ES4 with mysql-4.1.10a-2.RHEL4.1

Wynand

See https://www.ubbcentral.com/boards/s...oard=threads652bugs&Number=42386

Awesome <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" /> thanks .. works

Wynand

What's the answer to this error? The above link takes you to an access denied page.

An auto increment table can not have a default value.
Delete " DEFAULT '0' " and it will work.