Re: [Phpwebsite-developers] Re: Testing request

[Don S. <do...@se...>]

I think we would best serve everyone if these were filed on the sf.net
bug tracker.  Thoughts?

Don.

On Mon, Nov 10, 2003 at 12:28:03PM -0800, Brian Ghidinelli wrote:
> Matthew McNaney writes:=20
>=20
> >Developers, if you get a chance, please download a copy of phpwebsite094
> >from CVS and try an install.
>=20
> I'm trying on Redhat 7.3 with Postgres 7.3.  Firstly, the new install=20
> screens/process is much easier to follow than before.  That being said, i=
t=20
> seemed to go quite smoothly until installing modules where there were som=
e=20
> problems registering user module to the core.  I'm pretty sure this is=20
> caused by the autoincrement/sequence in Postgres not working properly=20
> (e.g., I think it needs to be specified in the insert even though it=20
> automatically increments).  The error.log indicates:=20
>=20
> 12:21:32 11/10/03 Error [notice] [-1] INSERT INTO users (created, updated=
,=20
> active, approved, username, password, deity) VALUES (1068495691,=20
> 1068495691, 1, 1, 'Anonymous', NULL, 0) [nativecode=3DERROR:  ExecInsert:=
=20
> Fail to add null value in not null attribute id
> ]
> 12:21:32 11/10/03 Error [notice] [-1] INSERT INTO users (created, updated=
,=20
> active, approved, username, password, deity) VALUES (1068495692,=20
> 1068495692, 1, 1, 'xxx', 'xxx', 1) [nativecode=3DERROR:  ExecInsert: Fail=
 to=20
> add null value in not null attribute id
> ]
> 12:21:34 11/10/03 Error [notice] [-1] INSERT INTO modules (title,=20
> proper_name, version, active, register) VALUES ('users', 'Users', '2.0', =
1,=20
> 1) [nativecode=3DERROR:  ExecInsert: Fail to add null value in not null=
=20
> attribute priority
> ]=20
>=20
>=20
> The next step generated more of the same errors trying to install the=20
> control panel and layout manager:=20
>=20
> 12:24:41 11/10/03 Error [notice] [-1] INSERT INTO modules (title,=20
> proper_name, version, active, register) VALUES ('layout', 'Layout', '2.0'=
,=20
> 1, 0) [nativecode=3DERROR:  ExecInsert: Fail to add null value in not nul=
l=20
> attribute priority
> ]
> 12:24:43 11/10/03 Error [notice] [-1] INSERT INTO modules (title,=20
> proper_name, version, active, register) VALUES ('controlpanel', 'Control=
=20
> Panel', '2.0', 1, 1) [nativecode=3DERROR:  ExecInsert: Fail to add null v=
alue=20
> in not null attribute priority
> ]=20
>=20
> I believe the queries for PG need to have id specified in the list of=20
> columns and then nextval() for the value or something to that effect.  I=
=20
> don't have much experience with auto-incrementing columns as I tend to us=
e=20
> UUID/GUIDs for my PKs.=20
>=20
> But, awesome work, I can already see it coming together.  I'll be happy t=
o=20
> help hack away on this as much as possible.=20
>=20
>=20
> Brian=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email sponsored by: ApacheCon 2003,
> 16-19 November in Las Vegas. Learn firsthand the latest
> developments in Apache, PHP, Perl, XML, Java, MySQL,
> WebDAV, and more! http://www.apachecon.com/
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>=20