[Phpwebsite-developers] Re: Testing request

[Brian G. <br...@vf...>]

Matthew McNaney writes: 

> Developers, if you get a chance, please download a copy of phpwebsite094
> from CVS and try an install.

I'm trying on Redhat 7.3 with Postgres 7.3.  Firstly, the new install 
screens/process is much easier to follow than before.  That being said, it 
seemed to go quite smoothly until installing modules where there were some 
problems registering user module to the core.  I'm pretty sure this is 
caused by the autoincrement/sequence in Postgres not working properly (e.g., 
I think it needs to be specified in the insert even though it automatically 
increments).  The error.log indicates: 

12:21:32 11/10/03 Error [notice] [-1] INSERT INTO users (created, updated, 
active, approved, username, password, deity) VALUES (1068495691, 1068495691, 
1, 1, 'Anonymous', NULL, 0) [nativecode=ERROR:  ExecInsert: Fail to add null 
value in not null attribute id
]
12:21:32 11/10/03 Error [notice] [-1] INSERT INTO users (created, updated, 
active, approved, username, password, deity) VALUES (1068495692, 1068495692, 
1, 1, 'xxx', 'xxx', 1) [nativecode=ERROR:  ExecInsert: Fail to add null 
value in not null attribute id
]
12:21:34 11/10/03 Error [notice] [-1] INSERT INTO modules (title, 
proper_name, version, active, register) VALUES ('users', 'Users', '2.0', 1, 
1) [nativecode=ERROR:  ExecInsert: Fail to add null value in not null 
attribute priority
] 


The next step generated more of the same errors trying to install the 
control panel and layout manager: 

12:24:41 11/10/03 Error [notice] [-1] INSERT INTO modules (title, 
proper_name, version, active, register) VALUES ('layout', 'Layout', '2.0', 
1, 0) [nativecode=ERROR:  ExecInsert: Fail to add null value in not null 
attribute priority
]
12:24:43 11/10/03 Error [notice] [-1] INSERT INTO modules (title, 
proper_name, version, active, register) VALUES ('controlpanel', 'Control 
Panel', '2.0', 1, 1) [nativecode=ERROR:  ExecInsert: Fail to add null value 
in not null attribute priority
] 

I believe the queries for PG need to have id specified in the list of 
columns and then nextval() for the value or something to that effect.  I 
don't have much experience with auto-incrementing columns as I tend to use 
UUID/GUIDs for my PKs. 

But, awesome work, I can already see it coming together.  I'll be happy to 
help hack away on this as much as possible. 


Brian