Re: [Phpwebsite-developers] Re: Testing request

[Richard S. <ri...@ri...>]

After using postgres and seeing it's advantages over mysql you might 
not want go back ;-)


On Nov 11, 2003, at 5:41 AM, Matthew McNaney wrote:

> 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
>
>
>
> -------------------------------------------------------
> 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
>
>