Thanks for the great software. I'm looking forward to using OCS for our conference, but I ran into a database error that prevents the review system from working properly for me. I'm getting a database error using OCS 2.0.0-1 and postgres 7.4. The problem is that when a Director tries to record "Revisions Required" for the decision for a paper, a database error is thrown:
"ERROR: null value in column "type" violates not-null constraint"
causing the action to fail. You can see the error text and more details in my bug report (http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=3153
). This appears to be related to bug # 3004 where the not null constraint on edit_decisions.type column was apparently removed. However, from psql I see that the not null constraint is still intact on my copy of the database (see psql output in the bug report). Does release 2.0.0-1 not have the changes that were made in Bug # 3004?
Looking at the code in:
TrackDirectorSubmissionDAO.inc.php line 166
it appears that no attempt to provide a value for the type column is made with the SQL insert, and so the not null constraint can't possibly be satisfied. Could this be the problem? Is it safe for me to remove the not null constraint on that column? Or should the SQL insert be providing a value for 'type'?
Thanks for your advice and help.