[Phpgroupware-tracker] [bugs #3358] postgresql 7.3x error in comics

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #3358] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Wed 07/14/2004 at 23:58 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Item Group | None                      | 0.9.16.000 release
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This has been fixed in CVS and should be available in the next
release.






/**************************************************************************/
[bugs #3358] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=3358>
Project: phpGroupWare
Submitted by: Reiner Jung
On: Sun 04/27/2003 at 23:50

Category:  comic
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  Fixed
Assigned to:  skwashd
Status:  Closed
Component Version:  None
Platform Version:  None
Reproducibility:  None


Summary:  postgresql 7.3x error in comics

Original Submission:  you know why this bug is very importent :-)

Database error: Invalid SQL: insert into phpgw_comic (comic_owner) values ('3')
PostgreSQL Error: 1 (ERROR: ExecInsert: Fail to add null value in not null 
attribute comic_list 

Follow-up Comments
------------------


-------------------------------------------------------
Date: Wed 07/14/2004 at 23:58       By: skwashd
This has been fixed in CVS and should be available in the next
release.

-------------------------------------------------------
Date: Wed 06/23/2004 at 14:41       By: darius_
comic/setup/tables_current.inc.php
'comic_list' => array('type' => 'blob', 'nullable' => False),

The table is explicitly created with a NOT NULL constraint.  There are a few 
bug reports related to violation of null constraints in various applications - 
all PostgreSQL.  Why wouldn't I see similar reports w/ MySQL?  Are null 
constraints honored or supported in MySQL?  Who maintains this application (Sam 
Wynn?) ?  I emailed Sam Wynn on 6/21 requesting clarity on the null constraint 
- no response thus far.  Comic, Chat, and Polls are broke at install w/ 
PostgreSQL because of null constraints.  Were the null constraints added 
without consultation with the authors?

-------------------------------------------------------
Date: Wed 05/28/2003 at 23:51       By: skwashd
is this fixed in 16? I forget if i got to it or not :)












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=3358>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/