Sybase based on problem tracking database
Bugzero one-for-all problem tracking database
 
Q: Sybase, error when creating tables and create the admin user during setup:
   The column default_project in table person does not allow null values.

A: With Sybase, by default, it may not allow null values in string columns 
   (like VARCHAR, TEXT, etc). In that case, you will have the above error. The
   solution is to change the database option "allow nulls by default" from false to true.
   With Interactive SQL (isql), run

   sp_dboption db_name, "allow nulls by default", true

   Here, "db_name" is your database name, such as bugzero_db.






* Reference brought to you by Bugzero, it's more than just bug tracking software!

Home - FAQs