Benoit Hamet wrote: > (Sorry for posting the user discussion from users to devs, but I think > that's more relevant here) > > Hi all, > > After some discussion with this guy, I remember some discussion about > setting null instead of '' in pgsql. He is using pg 7.2 and perhaps this > explain why the attempt of Chris fails, since perhaps this version of pg > consider '' as null. > > Make shure about this. No distro carries 7.2 anymore. Its all 7.4 and up. If such is the case id say the solution is...upgrade!
> I attach a partial dump of the phpgw_vfs table with first entry ... > looks strange for me. > > Regards, > > Caeies. > > Chris Weiss wrote: > >> a guy on IRC (who can't join the mailing list for some reason, but >> that's for another email) is getting this sql error on Step1 when >> upgrading from .14 to .16. >> # >> Database error: Invalid SQL: INSERT INTO phpgw_vfs >> (file_id,owner_id,createdby_id,modifiedby_id,created,modified,size,mime_type,deleteable,comment,app,directory,name,link_directory,link_name,version,content) >> VALUES >> (1,0,0,0,'1970-01-01',null,null,'Directory','Y',null,null,'/',null,null,null,'0.0.0.0',null) >> # >> PostgreSQL Error: 1 (ERROR: ExecAppend: Fail to add null value in not >> null attribute name ) >> >> >> In my install, "name" is '' and not NULL, so I have him set the name >> ='' and try again and it gave the same message. >> >> any idea's? I don't have pgsql to test with. >> >> >> _______________________________________________ >> Phpgroupware-users mailing list >> [email protected] >> http://lists.gnu.org/mailman/listinfo/phpgroupware-users >> >> > > > ------------------------------------------------------------------------ > > -- > -- Selected TOC Entries: > -- > \connect - diverse > > -- > -- TOC Entry ID 2 (OID 105982) > -- > -- Name: phpgw_vfs Type: TABLE Owner: diverse > -- > > CREATE TABLE "phpgw_vfs" ( > "file_id" integer DEFAULT nextval('seq_phpgw_vfs'::text) NOT NULL, > "owner_id" integer NOT NULL, > "createdby_id" integer, > "modifiedby_id" integer, > "created" date DEFAULT '1970-01-01' NOT NULL, > "modified" date, > "size" integer, > "mime_type" character varying(150), > "deleteable" character(1) DEFAULT 'Y', > "comment" character varying(252), > "app" character varying(25), > "directory" character varying(508), > "name" character varying(252) NOT NULL, > "link_directory" character varying(508), > "link_name" character varying(252), > "version" character varying(30) DEFAULT '0.0.0.0' NOT NULL, > Constraint "phpgw_vfs_pkey" Primary Key ("file_id") > ); > > -- > -- Data for TOC Entry ID 3 (OID 105982) > -- > -- Name: phpgw_vfs Type: TABLE DATA Owner: diverse > -- > > > COPY "phpgw_vfs" FROM stdin; > 1 0 0 0 1970-01-01 \N \N Directory > Y \N \N / \N \N 0.0.0.0 > 2 0 0 0 1970-01-01 \N \N Directory > Y \N \N / home \N \N 0.0.0.0 > 3 6 6 \N 2003-03-25 \N 4096 Directory > Y \N infolog /infolog 1 \N \N 0.0.0.0 > 4 5 5 \N 2003-03-25 \N 4096 Directory > Y \N infolog /infolog 4 \N \N 0.0.0.0 > 5 3 3 \N 2003-03-26 \N 4096 Directory > Y \N infolog /infolog 10 \N \N 0.0.0.0 > 8 3 3 \N 2003-03-26 \N 4096 journal-deleted > Y Deleted infolog /infolog 17 \N \N 0.0.0.0 > 9 3 3 \N 2003-03-26 \N 4096 journal-deleted > Y Deleted infolog /infolog 14 \N \N 0.0.0.0 > 11 3 3 \N 2003-03-26 \N 0 journal Y > Created infolog /infolog/1 20020816.prn.txt \N \N > 0.0.0.0 > 10 6 3 \N 2003-03-26 \N 10695 text/plain > Y infolog /infolog/1 20020816.prn.txt \N \N > 0.0.0.1 > \. > > ------------------------------------------------------------------------ > > _______________________________________________ > Phpgroupware-developers mailing list > [email protected] > http://lists.gnu.org/mailman/listinfo/phpgroupware-developers > _______________________________________________ Phpgroupware-developers mailing list [email protected] http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
