Codestriker: collaborative code reviewer

Well, I'm not very familiar with perl stuff so you may blast me if I did wrong :-)

However, I installed the product + DBI + DBD-ODBC as explained (poorly), created the ODBC entry and created the Database and when running the checksetup.pl script, I get this error:

...
Creating table commentstatehistory...
Creating table participant...
Creating table topicbug...
Creating table topicfile...
Creating table delta...
Creating table project...
Creating default project...
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'state', table 'CodeStriker.dbo.project'; column does not allow nulls. INSERT fails. (SQL-23000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
at C:\downloads\codestriker-1.8.4\codestriker-1.8.4\bin\checksetup.pl line 787.
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'state', ta
ble 'CodeStriker.dbo.project'; column does not allow nulls. INSERT fails. (SQL-23000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (SQL-01000)(DBD: st_execute/SQLExecute err=-1)
at C:\downloads\codestriker-1.8.4\codestriker-1.8.4\bin\checksetup.pl line 787.

Any idea?
Thanks for your support in advance.

This is interesting... this is actually due to a bug in checksetup.pl but I didn't see this error occurring for other databases.

Line 729 in checksetup.pl should actually read as:

print "Creating default project...\n";
my $timestamp = Codestriker->get_timestamp(time);
my $create = $dbh->prepare_cached('INSERT INTO project ' .
'(name, description, creation_ts, ' .
'modified_ts, version, state) ' .
'VALUES (?, ?, ?, ?, ?, ?) ');
$create->execute('Default project', 'Default project description',
$timestamp, $timestamp, 0, 0);

I have committed the fix into CVS, and we'll get this in the 1.8.5 release. Thanks for your report.