Hi concrete 5

Had the following installation error by a new installation of Concrete 5.3 on Windows 2008 / IIS / MySQL 5.1:

------
mysql error: [1364: Field 'fvExtension' doesn't have a default value] in EXECUTE("insert into FileVersions (fID, fvID, fvFilename, fvPrefix, fvDateAdded, fvIsApproved, fvApproverUID, fvAuthorUID, fvActivateDateTime, fvTitle, fvDescription, fvTags) values ('1', 1, 'inneroptics_dot_net_aspens.jpg', '111238852101', '2009-04-04 15:35:01', '1', 0, 0, '2009-04-04 15:35:01', '', '', '')")
------

I check the MySQL table fileversions and the field: fvExtension
The field is set to NOT NULL

Then i check the \concrete\config\db.xml file:

<field name="fvExtension" type="C" size="32">
<NOTNULL/>

When you look at the error message, the field fvExtension is not set. I set in the db.xml following line:

<DEFAULT value="0"/>

And the installation works. Have you forgot to set a value for fvExtension or to set <DEFAULT value="0"/> in db.xml - What are the right configuration?

Sorry for my bad english ; )

Greez from Switzerland

Marius