Menu
▾
▴
phpwebsite-developers
|
From: Matthew M. <ma...@tu...> - 2003-11-10 15:18:21
|
Greetings, Although 0.9.4 is in very early stages of development, we want compatibility to be tested EARLY. Developers, if you get a chance, please download a copy of phpwebsite094 from CVS and try an install. It has been tested under Linux and (GASP!) Windows with Apache and MySQL. We are curious to know how the install will function under IIS and other databases besides MySQL. The install will create you config file and perform a quick install of three modules. You should be able to log in and look at the control panel. That is about the extent of it for now :) Please let us know how it goes. Thanks Matt -- Matthew McNaney Internet Systems Architect Electronic Student Services Appalachian State University Phone: 828-262-6493 http://phpwebsite.appstate.edu http://ess.appstate.edu |
|
From: Richard S. <ri...@ri...> - 2003-11-10 17:12:12
|
Wow! I'm very anxious to test out the new system but I have a drawback. Is there a simply way to download all the files? I think there is with a CVS program but I'm not familiar with using CVS and I don't want to got file by file to download everything. Is there a zip file or something located somewhere that I can download to test it out on Mac OS X Panther with PostgreSQL and MySQL? Regards, Richard S. On Nov 10, 2003, at 7:14 AM, Matthew McNaney wrote: > Greetings, > > Although 0.9.4 is in very early stages of development, we want > compatibility to be tested EARLY. > > Developers, if you get a chance, please download a copy of > phpwebsite094 > from CVS and try an install. > > It has been tested under Linux and (GASP!) Windows with Apache and > MySQL. > > We are curious to know how the install will function under IIS and > other > databases besides MySQL. > > The install will create you config file and perform a quick install of > three modules. You should be able to log in and look at the control > panel. That is about the extent of it for now :) > > Please let us know how it goes. > > Thanks > Matt > > > -- > 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 > > |
|
From: Matthew M. <ma...@tu...> - 2003-11-10 18:46:19
|
I'll leave a copy here for a bit. http://phpwebsite.appstate.edu/downloads/php094.tar.gz Also here are the updated pear libs http://phpwebsite.appstate.edu/downloads/pear/pear-1.3b3+.tar.gz (thanks steven) Matt On Mon, 2003-11-10 at 12:12, Richard Sumilang wrote: > Wow! I'm very anxious to test out the new system but I have a drawback. > Is there a simply way to download all the files? I think there is with > a CVS program but I'm not familiar with using CVS and I don't want to > got file by file to download everything. Is there a zip file or > something located somewhere that I can download to test it out on Mac > OS X Panther with PostgreSQL and MySQL? > > Regards, > > Richard S. -- Matthew McNaney Internet Systems Architect Electronic Student Services Appalachian State University Phone: 828-262-6493 http://phpwebsite.appstate.edu http://ess.appstate.edu |
|
From: Brian G. <br...@vf...> - 2003-11-10 20:29:13
|
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
|
|
From: Brian G. <br...@vf...> - 2003-11-10 22:05:28
|
> 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
> ]
I thought I would provide more information here on my previous post. From
core/boost/install.sql:
CREATE TABLE modules (
title CHAR(40) NOT NULL,
proper_name CHAR(40) NOT NULL,
priority SMALLINT NOT NULL,
active SMALLINT NOT NULL,
version CHAR(20) NOT NULL,
register SMALLINT NOT NULL
);
The query setup uses is like this:
INSERT INTO modules (title, proper_name, version, active, register) VALUES
('layout', 'Layout', '2.0', 1, 0)
The column "priority", which is not null, is not present but needs to be in
order to make it work (or alternatively, don't declare it not null).
I manually adjusted the core/boost/install.sql file to have a DEFAULT 0 on
the priority line which solved that problem. The users module installed ok
although the other SQL errors regarding ID still persist. I manually
inserted two users by adding the ID and a corresponding value to the SQL
queries. Then I went to the next step, here is the boost.log file:
13:54:12 11/10/03 [notice] Module - users : Copying directory
/web/ggc-bmw-cca.org/www/mod/users/img/ to
/web/ggc-bmw-cca.org/www/images/mod/users/
13:58:04 11/10/03 [notice] Module - layout : No installation file found.
13:58:06 11/10/03 [notice] Module - controlpanel : No installation file
found.
13:58:10 11/10/03 [notice] Module - controlpanel : Core::getConfigFile() -
File not found. [file = config/users
/controlpanel.php]
13:58:10 11/10/03 [notice] Module - controlpanel : Core::getConfigFile() -
File not found. [file = config/layout
/controlpanel.php]
13:58:10 11/10/03 [notice] Module - controlpanel : Core::getConfigFile() -
File not found. [file = config/users
/controlpanel.php]
Those spaces in there between the directory names is how it reads in the
logfile... not sure if that is just a display bug or there are really spaces
in the path.
As an FYI, table prefix naming isn't on right now, but I'm sure that's
something to be added later (and not something I'm complaining about :)
Brian
|
|
From: Matthew M. <ma...@tu...> - 2003-11-11 13:48:56
|
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
|
|
From: Richard S. <ri...@ri...> - 2003-11-11 16:58:23
|
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
>
>
|
|
From: Don S. <do...@se...> - 2003-11-10 20:36:15
|
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 |
|
From: Brian G. <br...@vf...> - 2003-11-10 21:32:12
|
I don't know how the phpws team wants to handle ~alpha 0.9.4 stuff, but I'm happy to file it anywhere. Brian Don Seiler writes: > I think we would best serve everyone if these were filed on the sf.net > bug tracker. Thoughts? > > Don. |
|
From: Matthew M. <ma...@tu...> - 2003-11-11 16:33:26
|
phpwebsite 094 has been tested under postgres. I have gotten it to successfully install. Please see if you can replicate my success. Thanks to Brian for pointing out postgres shortcomings. - Matt -- Matthew McNaney Internet Systems Architect Electronic Student Services Appalachian State University Phone: 828-262-6493 http://phpwebsite.appstate.edu http://ess.appstate.edu |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X