SQL Server install pb

Help
RV999
2004-10-28
2013-06-03
  • RV999
    RV999
    2004-10-28

    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.

     
    • David Sitsky
      David Sitsky
      2004-10-28

      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.