Data truncation error on all updates

[TQ]

I'm trying to install splashCMS on a CF9 developer environment (using
built in web server running on port 8500 - Windows XP). After
following the steps from the install text file, I am able to log in
and browse the admin section of the cms and view all the parts but
when i go to update any of the layouts and/or snippets (or update for
anything for that matter), I get the following error:

Data truncation: Data too long for column 'fileName' at row 1

The error occurred in C:\ColdFusion9\wwwroot\SplashCMS_025\wheels\model
\adapters\mysql\functions.cfm: line 64

SQLSTATE 22001
SQL UPDATE layouts SET content = (param 1) , fileName = (param 2) ,
updatedAt = (param 3) , updatedById = (param 4) WHERE id = (param 5)

I ran the 'mysql_2009-08-12.sql' script on the database during
installation and for the layouts table, the filename field is set to
varchar(35) as the installation script calls for. Is there another
script, I am missing?

Oh and I am using mySQL 5.1.39 for the database

Thanks

[Clarke Bishop]

Some of the database scripts still have bugs.

Change the filename field to varChar(50), and it should work for you!

Clarke

[Russ Johnson]

Yeah especially the MSSQL scripts since most of us never use MSSQL.. you could try just running the dbmigrate plugin to create your tables. That should actually work better for you.

By the way, the filename fields are supposed to be 39 characters long.

- Russ