I'm not 100% sure if this has been mentioned before or anything (I've tried searching, didn't come up with any results though).

1) Just a side question, but is php5 not supported? If I put in the information for the database and push the next button it displays a blank page, using php4 fixes this though (I didn't search for php compatability, this is only a side question).

2) The installer works fine on the first few steps, but the step where you put your login credentials it doesn't work, it says this:

"Oops. We came across some problems while setting up Vanilla...
Something bad happened when we were trying to create your administrative user account. Mysql said: Field 'Attributes' doesn't have a default value"

So I immediately tried changing my php settings, etc, which didn't seem to work, so I tried a manual install. That too didn't work and I ended up with a similar message, always to do with the Attributes table.

First I'll mention the manual installation fix that I made (not sure if it's the 'best' way to do it).

At the end of the topic "Note 3" mentions a way that I fixed the problem with the installer.

Manual Install Fix:
I simply changed the following (in the sql file):
INSERT INTO LUM_User (`RoleID`,`Name`,`Password`,`Email`,`FirstName`,`LastName`,`DateFirstVisit`,`DateLastActive`)
VALUES (6,'Admin',md5('Admin'),'bogus@email.com','Administrative','User','2005-06-22 00:00:00','2005-06-22 00:00:00');

to:
INSERT INTO LUM_User( `RoleID` , `Name` , `Password` , `Email` , `FirstName` , `LastName` , `DateFirstVisit` , `DateLastActive` , `Attributes`)
VALUES ( 6, 'Admin', md5( 'Admin' ) , 'bogus@email.com', 'Administrative', 'User', '2005-06-22 00:00:00', '2005-06-22 00:00:00', ' ' ) ;

so that the attributes field would be blank by default, and register in the database. Did I miss something in the installation instructions prior to using the installer that would have fixed this easier?

Note: Using the Lussumo Vanilla (0.9.2.6) version.

Note 2: Also, I'm using MySQL 5.0.

Note 3: For the installer, the best fix seems to be the following:
Change:
`Attributes` text NOT NULL,
to:
`Attributes` text,

in the database.sql file under:
CREATE TABLE `LUM_User` (

Or is that "NOT NULL" important?

Thanks for the reply, mysql 5 being the culprit doesn't surprise me much. It seems most new software doesn't work with anything lately. lol.

Now that you mention it, I really wish I hadn't gotten it to work, I know almost nothing about SQL so it took forever. Downgrading to version 4 would have been much faster. :/

I'm running Vanilla 0.9.2.6 on Dreamhost with PHP 5.1.2 and MySQL5...but I didn't exactly *install* it on there. I actually installed and developed it (and the rest of the site) on a different host and moved it to the Dreamhost account later.

That being said, I'm having no problems running it on the aforementioned setup after the migration.