Problems when Installing

[Milky]

SMF Version: SMF 1.0.8
I have used SMF before and had no problems when installing on to XP, with php 4 and My SQL 5, I am now installing it on to a Server 2003 Machine with php 5 and My sql 5, after inputting all of the details of smf location DB user and password and the rest of the details, i am then greeted with the following error -

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #17: BLOB/TEXT column 'filename' can't have a default value
Line #43: BLOB/TEXT column 'hostname' can't have a default value
Line #161: BLOB/TEXT column 'name' can't have a default value
Line #316: BLOB/TEXT column 'name' can't have a default value
Line #381: BLOB/TEXT column 'IP' can't have a default value
Line #438: BLOB/TEXT column 'IP' can't have a default value
Line #449: BLOB/TEXT column 'ip' can't have a default value
Line #500: BLOB/TEXT column 'url' can't have a default value
Line #550: BLOB/TEXT column 'stars' can't have a default value
Line #629: BLOB/TEXT column 'lngfile' can't have a default value
Line #658: BLOB/TEXT column 'subject' can't have a default value
Line #750: BLOB/TEXT column 'question' can't have a default value
Line #762: BLOB/TEXT column 'label' can't have a default value
Line #772: BLOB/TEXT column 'variable' can't have a default value
Line #1009: BLOB/TEXT column 'variable' can't have a default value

Click here to try this step again.

Please can you help me to solve this problem

[IchBin™]

I wonder if this has something to do with strict mod in mysql? I'm not a DB guru, so it's just a suggestion.

[Oldiesmann]

Yes, that's definitely due to Strict Mode, which makes MySQL a lot more picky... Try this file - upload it to your forum directory, overwriting the existing one.

[Milky]

Yes, that's definitely due to Strict Mode, which makes MySQL a lot more picky... Try this file - upload it to your forum directory, overwriting the existing one.

Well that got me past that part but now when I click finish on the Administration Account creation page I get the following error -

A database error occurred while trying to create an administrator. This error was:
Field 'lngfile' doesn't have a default value
Click here to try this step again.

[H]

I recommend you try installing SMF 1.1 RC3 as this should be fully compatible with strict mode.

[Oldiesmann]

I would also recommend SMF 1.1 RC3 as it is fully strict-mode compatible, but if you want to use 1.0.8, try this SQL file instead.

I was thinking that setting those columns to NULL would cause problems in cases where SMF expects them to be empty strings, but NULL == '' returns TRUE in PHP, so it shouldn't cause any problems.

[Milky]

Took your advice and tried 1.1 rc3, worked first time, thanks for the help