Re: [Phpwebsite-developers] Re: Testing request

[Matthew M. <ma...@tu...>]

Well, Wendall got me to test phpwebsite in Windows so I might as well
learn postgres.

I am trying to get it to run in my postgres installation. When I get it
fixed I'll commit the changes.

Also Don (rizzo) suggested these discussions go on in SF. I *suppose* we
could start bug tracking and discussion on it but it may be too early.
Anyone else have ideas on this?

Matt


On Mon, 2003-11-10 at 15:28, Brian Ghidinelli wrote:
> 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 
> 
> 
> 
> -------------------------------------------------------
> 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
-- 
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
http://phpwebsite.appstate.edu
http://ess.appstate.edu