bugphpGroupWare - Bugs: bug #3358, postgresql 7.3x error in comics

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #3358: postgresql 7.3x error in comics

Submitter:  Invalid User ID <#6834>
Submitted:  Sun 27 Apr 2003 11:50:36 PM UTC
   
 
Category:  comic Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  5 - Normal
Status:  Fixed Privacy:  Public
Assigned to:  skwashd Open/Closed:  Closed
Component Version:  None Operating System:  None
Reproducibility:  None Planned Release:  None
Fixed Release: 

Wed 14 Jul 2004 11:58:29 PM UTC, comment #3: 

This has been fixed in CVS and should be available in the next
release.

Dave Hall <skwashd>
Group administrator
Wed 23 Jun 2004 02:41:12 PM UTC, comment #2: 

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?

Steven E. Bourg <darius_>
Wed 28 May 2003 11:51:29 PM UTC, comment #1: 

is this fixed in 16? I forget if i got to it or not :)

Dave Hall <skwashd>
Group administrator
Sun 27 Apr 2003 11:50:36 PM UTC, 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

Invalid User ID <#6834>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 4 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-07-14 skwashd Item GroupNone 0.9.16.000 release
    StatusNone Fixed
    Open/ClosedOpen Closed
2003-04-30 skwashd Summarypostgresql 7.3x error

Back to the top

Powered by Savane 3.13-caa5.
Corresponding source code