Menu
▾
▴
phpwebsite-developers — For our development team.
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
(1) |
Mar
(265) |
Apr
(166) |
May
(25) |
Jun
(17) |
Jul
(20) |
Aug
(47) |
Sep
(6) |
Oct
(14) |
Nov
(66) |
Dec
(64) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(109) |
Feb
(64) |
Mar
(34) |
Apr
(23) |
May
(64) |
Jun
(9) |
Jul
(13) |
Aug
(6) |
Sep
(33) |
Oct
(272) |
Nov
(67) |
Dec
(75) |
| 2003 |
Jan
(264) |
Feb
(244) |
Mar
(171) |
Apr
(119) |
May
(54) |
Jun
(93) |
Jul
(51) |
Aug
(48) |
Sep
(14) |
Oct
(49) |
Nov
(47) |
Dec
(15) |
| 2004 |
Jan
(13) |
Feb
(27) |
Mar
(18) |
Apr
(44) |
May
(35) |
Jun
(24) |
Jul
(39) |
Aug
(142) |
Sep
(35) |
Oct
(34) |
Nov
(49) |
Dec
(24) |
| 2005 |
Jan
(60) |
Feb
(71) |
Mar
(19) |
Apr
(27) |
May
(68) |
Jun
(4) |
Jul
(30) |
Aug
(10) |
Sep
(23) |
Oct
(24) |
Nov
(13) |
Dec
(6) |
| 2006 |
Jan
(4) |
Feb
(46) |
Mar
(64) |
Apr
(18) |
May
(16) |
Jun
(37) |
Jul
(7) |
Aug
(19) |
Sep
(9) |
Oct
(8) |
Nov
(3) |
Dec
(23) |
| 2007 |
Jan
(25) |
Feb
(21) |
Mar
(32) |
Apr
(36) |
May
(12) |
Jun
(1) |
Jul
(7) |
Aug
(15) |
Sep
(13) |
Oct
(1) |
Nov
|
Dec
|
| 2008 |
Jan
(3) |
Feb
(5) |
Mar
(1) |
Apr
(2) |
May
|
Jun
(1) |
Jul
(2) |
Aug
(7) |
Sep
|
Oct
(5) |
Nov
(1) |
Dec
|
| 2009 |
Jan
(7) |
Feb
(1) |
Mar
|
Apr
|
May
(1) |
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(3) |
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
|
From: Robert <ro...@wo...> - 2006-06-08 21:35:23
|
Thanks Hilmar I did not look close at the other module section and that is why it did not work thanks Robert hr_vbid wrote: > Hi Robert, Hi Matt, > apologize my intervention. From my point of view, when installing falloutRC1 > (that was my 1st experience with pws1.0), webpages are not part of the core > and have to setup by boost later (am I right?). WebPages has dependicies to > MenuManager, why not?, and then its normal to boost MenuManager first and > 2nd WebPages. Thats the way I did. After, everything looked well. > (As reported here ) > Greetings > Hilmar > -- > View this message in context: http://www.nabble.com/rc-1-missing-dependenices-t1726297.html#a4775313 > Sent from the PhpWebsite - Dev forum at Nabble.com. > > > > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > > > |
|
From: hr_vbid <hi...@dc...> - 2006-06-08 16:19:52
|
Hi Robert, Hi Matt, apologize my intervention. From my point of view, when installing falloutRC1 (that was my 1st experience with pws1.0), webpages are not part of the core and have to setup by boost later (am I right?). WebPages has dependicies to MenuManager, why not?, and then its normal to boost MenuManager first and 2nd WebPages. Thats the way I did. After, everything looked well. (As reported here ) Greetings Hilmar -- View this message in context: http://www.nabble.com/rc-1-missing-dependenices-t1726297.html#a4775313 Sent from the PhpWebsite - Dev forum at Nabble.com. |
|
From: Eloi G. <el...@re...> - 2006-06-08 14:02:19
|
I'll start attempting a module update this weekend. -Eloi George- Mike Noyes wrote: > Everyone, > Has anyone other than Robert tested yet? I'm sure Matt is interested in > all the feedback we can generate. > > |
|
From: Gregory M. <gre...@gm...> - 2006-06-07 21:20:57
|
I've been developing for fallout for a little while now, and overall it's very nice. I've already emailed Matt recently with some ideas about that. (subtle reminder to Matt) Tonight I spent some time playing with some of the "shipped" modules. Here are some of my findings: 1) I couldn't find a way to make other existing users a deity via user administration page. 2) When trying to deactivate a user, you will get a 404. 3) No "remember me" feature. ;-) 4) Use graphic authentication? What is that? I tried it and saw no difference. 5) "Want to join?" link appears when user signup is set to "not allowed". 6) Could we get an email from the site or a layout box when items need approved for a module? 7) "Edit blog" appears in mini-admin for non-deity, but when saving update, get permissions error. The user did not have "edit blog" permissions, but the blog was created by that user. 8) Local RSS feeds - how do I use them? Maybe something in the administration to enlighten me? External feeds work great however. 9) Web pages - "Force all pages to use this template" doesn't work. 10) Non-deity users with certain permissions can get permissions errors in web pages. The logic that checks whether links should be displayed apparently needs revisiting. 11) Disapprove on web pages approval page with deity user gets permission error. I better stop there for now. I don't want Matt to get mad at me. ;-) Fallout does have several great features I can't wait to put to use on public sites. So Matt, when are you going to convert phpwebsite.appstate.edu? Overall, great job Matt! Greg On 6/6/06, Mike Noyes <mh...@us...> wrote: > On Fri, 2006-06-02 at 10:36, Matthew McNaney wrote: > > After a very long haul, we have a release candidate of phpWebSite 1.0.0. > > Everyone, > Has anyone other than Robert tested yet? I'm sure Matt is interested in > all the feedback we can generate. > > -- > Mike Noyes <mhnoyes at users.sourceforge.net> > http://sourceforge.net/users/mhnoyes/ > SF.net Projects: leaf, phpwebsite, phpwebsite-comm, sitedocs > > > > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > |
|
From: Mike N. <mh...@us...> - 2006-06-06 20:28:49
|
On Fri, 2006-06-02 at 10:36, Matthew McNaney wrote: > After a very long haul, we have a release candidate of phpWebSite 1.0.0. Everyone, Has anyone other than Robert tested yet? I'm sure Matt is interested in all the feedback we can generate. -- Mike Noyes <mhnoyes at users.sourceforge.net> http://sourceforge.net/users/mhnoyes/ SF.net Projects: leaf, phpwebsite, phpwebsite-comm, sitedocs |
|
From: Mike N. <mh...@us...> - 2006-06-03 17:42:26
|
On Tue, 2006-05-30 at 22:28, Greg Morgan wrote: > This caught my eye. One of the problems with phpWebSite in my estimation > is that information on modules, themes, and the core application are > spread all over the place. Perhaps something like CIA could be used to > aggregate third party changes and the main phpWebSite cvs commits. Now > that works for some of the larger module/theme projects that have CVS > scripts implemented. However, smaller projects may not be able to > integrate into something like CIA since they may or may not be using > CVS/SVN. > https://cia.navi.cx/ > https://cia.navi.cx/doc > https://cia.navi.cx/doc/adding-projects > https://cia.navi.cx/stats/project/BZFlag > https://cia.navi.cx/stats/author/davidtrowbridge Greg, I believe the Mediawiki project is utilizing CIA in #mediawiki on irc.freenode.net. Ideally, CIA would integrate with something like Launchpad. I've advocated SF.net start looking at these features for inclusion in future software updates. https://launchpad.net/ In the mean time, I'm trying to integrate phpwebsite-comm into phpwebsite as a true subproject. Note: Other tasks have slowed my progress on this task. :-( > Another option is something like http://planet.maemo.org/ or > planet.phpWebSite. In the case of CIA, it doesn't matter where the site > is located. The goal of CIA is to track multiple projects to see what's > going on in general in all areas of the Open Source world. The goal of > a planet.phpWebSite is to aggregate multiple community feeds in one > location. There in lies another problem that I see with the phpWebSite > community. Where would something like a planet.phpWebSite be hosted? > Depending on how a system like this works, there may not be enough web > site/database space available to host planet.phpWebSite on sourceforge. > The college site looks like a good place to host something like this > but, then there may be legal or political reasons that a > plaent.phpWebSite cannot be hosted at phpwebsite.appstate.edu. Wendall's phpwsrssfeeds module can aggregate multiple feeds. I'm not sure if it achieves planet like functionality yet, but that's what I requested. Also, I'm not sure of the port status to fallout. > So how would the community do something like this? Ok so some > individual says they'll create the site. The community will come to > rely on the information and then one day poof the site is gone. For > example, some phpWebSite hall of famers are now either just a parking > domain out in the big Internet spewing add links, or the former useful > phpWebSite related info is under a construction banner. > http://www.phpgirl.net/ > http://www.phpgirl.org/ > http://www.shirka.org/ > Let's play where's Mike Winzor while we are at it too. ;-) So how could > the community do something like this so that it lives on past the > initial curator? That's one of the reasons I advocate SF.net or Savannah.gnu.org. > I guess the larger question is how can the cohesiveness of the larger > phpWebSite community be improved? Would tools like these two listed > above help? Is this a worthwhile endeavor? I've attempted coalescing effort for years. I've had some success, but not enough. To-Do: Learn to herd cats. -- Mike Noyes <mhnoyes at users.sourceforge.net> http://sourceforge.net/users/mhnoyes/ SF.net Projects: leaf, phpwebsite, phpwebsite-comm, sitedocs |
|
From: Robert <ro...@wo...> - 2006-06-03 16:22:16
|
Hi Matt Well I redownload rc1 extracted on my winxp box using 7zip. Uploaded installed with now errors showing when I installed. But when I go to the site now web pages are showing up. When I check boost the web pages 0.1.0 module show that it has dependenices problems, when I click on it it show Menu Manger 0.0.1 Current Ver not installed status failed. I have been unable to find the file needed. Any help some times I am a bit thick so dont yell to load. lol Have a great day. ma...@tu... wrote: > The menu module is included in the tarball. It should be in your boost list. > It sounds as if you are having other problems. Please make sure your > php.ini allows error messages to display. Let us know if you find anything > out. > > >> Hi all >> >> Just tried to install rc-1, all seemed fine then I found myself with a >> blank home page. When I went into boost I found that the web page module >> had missing dependenices. Menu manger was not installed where do I find >> it or is it a missing part of the download. >> >> Thanks >> >> Robert >> >> >> >> _______________________________________________ >> Phpwebsite-developers mailing list >> Php...@li... >> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers >> >> > > > > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > > > > > |
|
From: <ma...@tu...> - 2006-06-03 11:30:35
|
The menu module is included in the tarball. It should be in your boost list. It sounds as if you are having other problems. Please make sure your php.ini allows error messages to display. Let us know if you find anything out. > Hi all > > Just tried to install rc-1, all seemed fine then I found myself with a > blank home page. When I went into boost I found that the web page module > had missing dependenices. Menu manger was not installed where do I find > it or is it a missing part of the download. > > Thanks > > Robert > > > > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > |
|
From: Robert <ro...@wo...> - 2006-06-03 04:20:54
|
Hi all Just tried to install rc-1, all seemed fine then I found myself with a blank home page. When I went into boost I found that the web page module had missing dependenices. Menu manger was not installed where do I find it or is it a missing part of the download. Thanks Robert |
|
From: Verdon V. <ve...@gm...> - 2006-06-02 19:16:14
|
HEY!! What kind of thing is that to do to an old geek on a Friday night ;-) verdon Ps. Looking fwd to kicking the tires... On 2-Jun-06, at 1:36 PM, Matthew McNaney wrote: > Hello all, > > After a very long haul, we have a release candidate of phpWebSite > 1.0.0. > > Please grab a copy from Sourceforge or from our home site. > https://sourceforge.net/project/showfiles.php? > group_id=15539&package_id=192441&release_id=421911 > > http://phpwebsite.appstate.edu/downloads/rc/phpwebsite_1_0_0_RC1.tgz > > Bugs can be posted at Sourceforge under the phpws1.0 Group. There is > also a phpwebsite 1.0 discussion forum. > > Have a good weekend, > Matt > > -- > Matthew McNaney > Electronic Student Services > Appalachian State University > http://phpwebsite.appstate.edu > > > > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > |
|
From: Matthew M. <ma...@tu...> - 2006-06-02 17:45:48
|
Hello all, After a very long haul, we have a release candidate of phpWebSite 1.0.0. Please grab a copy from Sourceforge or from our home site. https://sourceforge.net/project/showfiles.php?group_id=15539&package_id=192441&release_id=421911 http://phpwebsite.appstate.edu/downloads/rc/phpwebsite_1_0_0_RC1.tgz Bugs can be posted at Sourceforge under the phpws1.0 Group. There is also a phpwebsite 1.0 discussion forum. Have a good weekend, Matt -- Matthew McNaney Electronic Student Services Appalachian State University http://phpwebsite.appstate.edu |
|
From: Greg M. <drk...@co...> - 2006-05-31 05:28:48
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This caught my eye. One of the problems with phpWebSite in my estimation is that information on modules, themes, and the core application are spread all over the place. Perhaps something like CIA could be used to aggregate third party changes and the main phpWebSite cvs commits. Now that works for some of the larger module/theme projects that have CVS scripts implemented. However, smaller projects may not be able to integrate into something like CIA since they may or may not be using CVS/SVN. https://cia.navi.cx/ https://cia.navi.cx/doc https://cia.navi.cx/doc/adding-projects https://cia.navi.cx/stats/project/BZFlag https://cia.navi.cx/stats/author/davidtrowbridge Another option is something like http://planet.maemo.org/ or planet.phpWebSite. In the case of CIA, it doesn't matter where the site is located. The goal of CIA is to track multiple projects to see what's going on in general in all areas of the Open Source world. The goal of a planet.phpWebSite is to aggregate multiple community feeds in one location. There in lies another problem that I see with the phpWebSite community. Where would something like a planet.phpWebSite be hosted? Depending on how a system like this works, there may not be enough web site/database space available to host planet.phpWebSite on sourceforge. The college site looks like a good place to host something like this but, then there may be legal or political reasons that a plaent.phpWebSite cannot be hosted at phpwebsite.appstate.edu. So how would the community do something like this? Ok so some individual says they'll create the site. The community will come to rely on the information and then one day poof the site is gone. For example, some phpWebSite hall of famers are now either just a parking domain out in the big Internet spewing add links, or the former useful phpWebSite related info is under a construction banner. http://www.phpgirl.net/ http://www.phpgirl.org/ http://www.shirka.org/ Let's play where's Mike Winzor while we are at it too. ;-) So how could the community do something like this so that it lives on past the initial curator? I guess the larger question is how can the cohesiveness of the larger phpWebSite community be improved? Would tools like these two listed above help? Is this a worthwhile endeavor? HTH, Greg -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFEfSmDxyxe5L6mr7IRAoxCAJ9CKKoxEoBNqxqwkkWLYhUbClCpMQCeK+B6 B88ziJsDYq4ECLqIfrk3rpc= =jKhH -----END PGP SIGNATURE----- |
|
From: Greg M. <drk...@co...> - 2006-05-30 00:17:29
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Verdon Vaillancourt wrote:
> Hi,
>
> I'm encountering a strange thing while trying to write an install.sql
> file for a module I am working on. I'm hoping fresh eyes might help.
>
> Thanks for any advice. Regards,
> verdon
>
>
> If I run the sql statement below, in phpmyadmin, it works fine. If I try
> to boost instead, I get this generic error
>
> DB Error: syntax error
> CREATE TABLE mod_cstconference_applications ( id int NOT NULL default
> '0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL
> default '0', regprov varchar(20) default '', regonline tinyint NOT NULL
> default '0', applicants text, firstname varchar(60) default '', lastname
> varchar(60) default '', organization varchar(255) default '', address1
> varchar(255) default '', address2 varchar(255) default '', city
> varchar(120) default '', province varchar(60) default '', postal
> varchar(20) default '', phone varchar(60) default '', email varchar(120)
> default '', total )
- -------------------^
Look here.
[nativecode=1064 ** You have an error in your SQL
> syntax. Check the manual that corresponds to your MySQL server version
> for the right syntax to use near ')' at line 1]
>
> This is the sql...
>
> CREATE TABLE mod_cstconference_applications (
> id int NOT NULL default '0',
> regnum int NOT NULL default '0',
> regstudent tinyint NOT NULL default '0',
> regprov varchar(20) default '',
> regonline tinyint NOT NULL default '0',
> applicants text,
> firstname varchar(60) default '',
> lastname varchar(60) default '',
> organization varchar(255) default '',
> address1 varchar(255) default '',
> address2 varchar(255) default '',
> city varchar(120) default '',
> province varchar(60) default '',
> postal varchar(20) default '',
> phone varchar(60) default '',
> email varchar(120) default '',
total text
);
- --^
- ----------------^
Try taking all the mysql junk out of the create statement at the very
end of the create statement. The translation from PEARDB to mysql my be
bad. Moreover, if you are planning for a fallout module, then this code
would not be portable to postgresql anyhow as I recall.
HTH,
Greg
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFEe48Cxyxe5L6mr7IRAkpmAJ9msbZu96uS8eKSFY89u5GF+88TCgCfY4dA
i+YYSGSlLmelWxEjBEJhBjc=
=725Y
-----END PGP SIGNATURE-----
|
|
From: Verdon V. <ve...@gm...> - 2006-05-29 18:13:46
|
That did the job... thanks Matt :) verdon On 29-May-06, at 1:44 PM, Matthew McNaney wrote: > Have you tried dropping the TYPE=MyISAM;? > > > > On Mon, 2006-05-29 at 12:42 -0400, Verdon Vaillancourt wrote: >> Hi, >> >> I'm encountering a strange thing while trying to write an install.sql >> file for a module I am working on. I'm hoping fresh eyes might help. >> >> Thanks for any advice. Regards, >> verdon >> >> >> If I run the sql statement below, in phpmyadmin, it works fine. If I >> try to boost instead, I get this generic error >> >> DB Error: syntax error >> CREATE TABLE mod_cstconference_applications ( id int NOT NULL default >> '0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL >> default '0', regprov varchar(20) default '', regonline tinyint NOT >> NULL >> default '0', applicants text, firstname varchar(60) default '', >> lastname varchar(60) default '', organization varchar(255) default '', >> address1 varchar(255) default '', address2 varchar(255) default '', >> city varchar(120) default '', province varchar(60) default '', postal >> varchar(20) default '', phone varchar(60) default '', email >> varchar(120) default '', total ) [nativecode=1064 ** You have an error >> in your SQL syntax. Check the manual that corresponds to your MySQL >> server version for the right syntax to use near ')' at line 1] >> >> This is the sql... >> >> CREATE TABLE mod_cstconference_applications ( >> id int NOT NULL default '0', >> regnum int NOT NULL default '0', >> regstudent tinyint NOT NULL default '0', >> regprov varchar(20) default '', >> regonline tinyint NOT NULL default '0', >> applicants text, >> firstname varchar(60) default '', >> lastname varchar(60) default '', >> organization varchar(255) default '', >> address1 varchar(255) default '', >> address2 varchar(255) default '', >> city varchar(120) default '', >> province varchar(60) default '', >> postal varchar(20) default '', >> phone varchar(60) default '', >> email varchar(120) default '', >> total text, >> PRIMARY KEY (id) >> ) TYPE=MyISAM; >> >> >> >> ------------------------------------------------------- >> All the advantages of Linux Managed Hosting--Without the Cost and >> Risk! >> Fully trained technicians. The highest number of Red Hat >> certifications in >> the hosting industry. Fanatical Support. Click to learn more >> http://sel.as-us.falkag.net/sel? >> cmd=lnk&kid=107521&bid=248729&dat=121642 >> _______________________________________________ >> Phpwebsite-developers mailing list >> Php...@li... >> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > -- > Matthew McNaney > Electronic Student Services > Appalachian State University > http://phpwebsite.appstate.edu > > > > ------------------------------------------------------- > All the advantages of Linux Managed Hosting--Without the Cost and Risk! > Fully trained technicians. The highest number of Red Hat > certifications in > the hosting industry. Fanatical Support. Click to learn more > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=107521&bid=248729&dat=121642 > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers > |
|
From: Matthew M. <ma...@tu...> - 2006-05-29 17:51:15
|
Have you tried dropping the TYPE=MyISAM;? On Mon, 2006-05-29 at 12:42 -0400, Verdon Vaillancourt wrote: > Hi, > > I'm encountering a strange thing while trying to write an install.sql > file for a module I am working on. I'm hoping fresh eyes might help. > > Thanks for any advice. Regards, > verdon > > > If I run the sql statement below, in phpmyadmin, it works fine. If I > try to boost instead, I get this generic error > > DB Error: syntax error > CREATE TABLE mod_cstconference_applications ( id int NOT NULL default > '0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL > default '0', regprov varchar(20) default '', regonline tinyint NOT NULL > default '0', applicants text, firstname varchar(60) default '', > lastname varchar(60) default '', organization varchar(255) default '', > address1 varchar(255) default '', address2 varchar(255) default '', > city varchar(120) default '', province varchar(60) default '', postal > varchar(20) default '', phone varchar(60) default '', email > varchar(120) default '', total ) [nativecode=1064 ** You have an error > in your SQL syntax. Check the manual that corresponds to your MySQL > server version for the right syntax to use near ')' at line 1] > > This is the sql... > > CREATE TABLE mod_cstconference_applications ( > id int NOT NULL default '0', > regnum int NOT NULL default '0', > regstudent tinyint NOT NULL default '0', > regprov varchar(20) default '', > regonline tinyint NOT NULL default '0', > applicants text, > firstname varchar(60) default '', > lastname varchar(60) default '', > organization varchar(255) default '', > address1 varchar(255) default '', > address2 varchar(255) default '', > city varchar(120) default '', > province varchar(60) default '', > postal varchar(20) default '', > phone varchar(60) default '', > email varchar(120) default '', > total text, > PRIMARY KEY (id) > ) TYPE=MyISAM; > > > > ------------------------------------------------------- > All the advantages of Linux Managed Hosting--Without the Cost and Risk! > Fully trained technicians. The highest number of Red Hat certifications in > the hosting industry. Fanatical Support. Click to learn more > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 > _______________________________________________ > Phpwebsite-developers mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers -- Matthew McNaney Electronic Student Services Appalachian State University http://phpwebsite.appstate.edu |
|
From: Verdon V. <ve...@gm...> - 2006-05-29 16:41:19
|
Hi, I'm encountering a strange thing while trying to write an install.sql file for a module I am working on. I'm hoping fresh eyes might help. Thanks for any advice. Regards, verdon If I run the sql statement below, in phpmyadmin, it works fine. If I try to boost instead, I get this generic error DB Error: syntax error CREATE TABLE mod_cstconference_applications ( id int NOT NULL default '0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL default '0', regprov varchar(20) default '', regonline tinyint NOT NULL default '0', applicants text, firstname varchar(60) default '', lastname varchar(60) default '', organization varchar(255) default '', address1 varchar(255) default '', address2 varchar(255) default '', city varchar(120) default '', province varchar(60) default '', postal varchar(20) default '', phone varchar(60) default '', email varchar(120) default '', total ) [nativecode=1064 ** You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1] This is the sql... CREATE TABLE mod_cstconference_applications ( id int NOT NULL default '0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL default '0', regprov varchar(20) default '', regonline tinyint NOT NULL default '0', applicants text, firstname varchar(60) default '', lastname varchar(60) default '', organization varchar(255) default '', address1 varchar(255) default '', address2 varchar(255) default '', city varchar(120) default '', province varchar(60) default '', postal varchar(20) default '', phone varchar(60) default '', email varchar(120) default '', total text, PRIMARY KEY (id) ) TYPE=MyISAM; |
|
From: Matthew M. <ma...@tu...> - 2006-05-17 18:58:52
|
On Wed, 2006-05-17 at 08:07 -0400, Matthew McNaney wrote: > I will start on Theme documentation today. http://res.stddev.appstate.edu/cvs/*checkout*/fallout/docs/Theme_Creation.txt?rev=1.1 -- Matthew McNaney Electronic Student Services Appalachian State University http://phpwebsite.appstate.edu |
|
From: Matthew M. <ma...@tu...> - 2006-05-17 12:13:17
|
On Tue, 2006-05-16 at 20:40 -0500, Robert wrote: > Hi Matt > > I have started working with it found my problem for some reason it keep > droping the default.css so added it to style.ini. I will start on Theme documentation today. > > One other thing if you can help is, when I create a user they do not see > anything but the left menu when loged in. You may want to update your copy. There was a bug in a previous version of fallout that was causing this. -- Matthew McNaney Electronic Student Services Appalachian State University http://phpwebsite.appstate.edu |
|
From: Robert <ro...@wo...> - 2006-05-17 01:40:37
|
Hi Matt I have started working with it found my problem for some reason it keep droping the default.css so added it to style.ini. have a look I am working on making the muggle them for fallout. I am just learning php and css style of web display. You may look at http://www.wolfclanwebsolutions.com/hosting/ this is my try at it. Been busy so not to far along. And did get the blue to work. One other thing if you can help is, when I create a user they do not see anything but the left menu when loged in. Thanks Robert Matthew McNaney wrote: > Hi Silverwolfe, > > I changed the default.css body background color to: > > background-color : #000666; > > And didn't have any problem getting a dark blue background. > > You change anything else? > > Matt > > > On Thu, 2006-05-11 at 20:34 -0500, Robert wrote: > >> Hi >> I have installed the fallout on my server. I joined this list is hopes >> of learning a thing or two about the theme engine and making themes. The >> reason is I tried a baby step by changing just the background color and >> when it was applied it hole theme went away, what I mean by that there >> was no color displayed only text and layout. This made me think that >> some things had really changed. >> >> Code from default >> >> body { >> color: #000; >> background-color : #000666; >> } >> >> >> Change >> >> >> body { >> color: #000; >> background-color : #000666; >> } >> >> So now what did I do wrong. I have also notice some things that don't >> quit work. Yes I know it is beta that is not the point, the point is, is >> the error known. >> >> If I am in error posting this here please let me know. >> >> Thanks >> >> Silverwolfe >> >> >> ------------------------------------------------------- >> Using Tomcat but need to do more? Need to support web services, security? >> Get stuff done quickly with pre-integrated technology to make your job easier >> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >> _______________________________________________ >> Phpwebsite-developers mailing list >> Php...@li... >> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers >> |
|
From: james <ja...@so...> - 2006-05-13 12:58:45
|
Thanks, but I was referring to the help file that is included in the download, which installs into www.base_url/manual/html/ Thanks for support. It's working really well (except for HTML editor) - can't wait for next version. James At 10:21 13/05/2006, Greg Morgan wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >James wrote: > > Hi Greg, > > > > Thanks for the info, but guys you *really* have to update your help file >Yeap. It has been updated here >http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=Generic_Install_Introduction >and here >http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=PhpWebSite_Installation > > > with this name change, or put it on the site somewhere obvious 'web > > pages is the new name for pagemaster' > > > > > <http://www.google.co.uk/search?hl=en&q=pagemaster+webpages+name+change+site%3Aphpwebsite.appstate.edu&btnG=Google+Search&meta=> > > > > > > 1 un-obvious reference (or am i blind somehow?) > > > > surely a regex with perl on the help files wouldn't be too hard??? > > > > thanks again for your help > > > > James > >Most phpWebSite problems go away if the installation steps are followed >end to end. Most installation mistakes that cause other problems that >have been resolved here >http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=User_FAQ . > > > > > > > > > > At 04:44 25/04/2006, you wrote: > >> James, > >> The "Web Pages" module is the pagemaster module. Find Web Pages in > >> boost and install. > >> > >> Hope that helps, > >> Greg > >> > >> > >> On 4/24/06, James <ja...@sa...> wrote: > >> > Hello > >> > > >> > Yesterday I installed phpwebsite. I found no pagemaster module > >> listed in > >> > the boost section of my control panel, the module is present in my mod > >> > folder, [phpwebsite/images is writeable by all (chmod 777) and so > >> are the > >> > subfolders (as instructed)]. > >> > > >> > How do I make the pagemakes module appear in my control panel? > >> > > >> > I am using Core Version: 0.10.2, I am not entirely sure which > >> flavour of > >> > Linux I am running (host is register1.net). I am running Apache 2.0.52 > >> > (CentOS), PHP 4.3.9, MySQL 4.1.18 and am currently viewing the admin > >> pages > >> > with Firefox 1.0.7 > >All this looks good. The installation documentation was written on >Fedora Core so you should be at home with CentOS. > > >> > > >> > I notice the same problem has occured to another user, reported in the > >> > forums at: > >> > <http://www.phpwsforums.com/showthread.php?p=16510#post16510> > >> > > >> > Further googling and code sniffing have unfortunately revealed > >> nothing..... > >> > > >> > my phpinfo page can be found here: > >> > http://www.afunnyfarm.org.uk/phpinfo.php > >> > > >> > When installing these were my options for module install and the > >> > conformation screen text: > >> > > >It is better to perform a minimal install following the wiki >installation guide and then boost (install) additional modules as your >site requires them. Boost documentation is located here >http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=Boost > ><snip> > > >> > > >> > All help of course much appreciated, although there is a bit of a time > >> > pressure for me (and I really don't want to have to install and write a > >> > custom theme for Mambo!!) > >> > > >> > Thankyou > >> > > >> > James > >I often recommend that you use the demo site to play with phpWebSite >http://phpwebsite.appstate.edu/demo/0.10.x/ and use the user guide >http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=User_Guide >and modules page >http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=Modules to >play with a working site. That may take some pressure off of you. You >can play on a site that will not matter to you before you try the >concepts on your live site. > >I hope this helps. > >Greg > >-----BEGIN PGP SIGNATURE----- >Version: GnuPG v1.4.2.2 (GNU/Linux) >Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org > >iD8DBQFEZaUuxyxe5L6mr7IRAq58AKCBxVQ13xdFZH+ne7gP1by1v30HZwCdGRny >SEg3UssqASpfv+fqBQGxOyA= >=d4jX >-----END PGP SIGNATURE----- |
|
From: Greg M. <drk...@co...> - 2006-05-13 09:22:14
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 James wrote: > Hi Greg, > > Thanks for the info, but guys you *really* have to update your help file Yeap. It has been updated here http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=Generic_Install_Introduction and here http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=PhpWebSite_Installation > with this name change, or put it on the site somewhere obvious 'web > pages is the new name for pagemaster' > > <http://www.google.co.uk/search?hl=en&q=pagemaster+webpages+name+change+site%3Aphpwebsite.appstate.edu&btnG=Google+Search&meta=> > > > 1 un-obvious reference (or am i blind somehow?) > > surely a regex with perl on the help files wouldn't be too hard??? > > thanks again for your help > > James Most phpWebSite problems go away if the installation steps are followed end to end. Most installation mistakes that cause other problems that have been resolved here http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=User_FAQ . > > > > At 04:44 25/04/2006, you wrote: >> James, >> The "Web Pages" module is the pagemaster module. Find Web Pages in >> boost and install. >> >> Hope that helps, >> Greg >> >> >> On 4/24/06, James <ja...@sa...> wrote: >> > Hello >> > >> > Yesterday I installed phpwebsite. I found no pagemaster module >> listed in >> > the boost section of my control panel, the module is present in my mod >> > folder, [phpwebsite/images is writeable by all (chmod 777) and so >> are the >> > subfolders (as instructed)]. >> > >> > How do I make the pagemakes module appear in my control panel? >> > >> > I am using Core Version: 0.10.2, I am not entirely sure which >> flavour of >> > Linux I am running (host is register1.net). I am running Apache 2.0.52 >> > (CentOS), PHP 4.3.9, MySQL 4.1.18 and am currently viewing the admin >> pages >> > with Firefox 1.0.7 All this looks good. The installation documentation was written on Fedora Core so you should be at home with CentOS. >> > >> > I notice the same problem has occured to another user, reported in the >> > forums at: >> > <http://www.phpwsforums.com/showthread.php?p=16510#post16510> >> > >> > Further googling and code sniffing have unfortunately revealed >> nothing..... >> > >> > my phpinfo page can be found here: >> > http://www.afunnyfarm.org.uk/phpinfo.php >> > >> > When installing these were my options for module install and the >> > conformation screen text: >> > It is better to perform a minimal install following the wiki installation guide and then boost (install) additional modules as your site requires them. Boost documentation is located here http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=Boost <snip> >> > >> > All help of course much appreciated, although there is a bit of a time >> > pressure for me (and I really don't want to have to install and write a >> > custom theme for Mambo!!) >> > >> > Thankyou >> > >> > James I often recommend that you use the demo site to play with phpWebSite http://phpwebsite.appstate.edu/demo/0.10.x/ and use the user guide http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=User_Guide and modules page http://phpwebsite-comm.sourceforge.net/wiki/index.php?title=Modules to play with a working site. That may take some pressure off of you. You can play on a site that will not matter to you before you try the concepts on your live site. I hope this helps. Greg -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFEZaUuxyxe5L6mr7IRAq58AKCBxVQ13xdFZH+ne7gP1by1v30HZwCdGRny SEg3UssqASpfv+fqBQGxOyA= =d4jX -----END PGP SIGNATURE----- |
|
From: Matthew M. <ma...@tu...> - 2006-05-12 18:58:55
|
Hi Silverwolfe,
I changed the default.css body background color to:
background-color : #000666;
And didn't have any problem getting a dark blue background.
You change anything else?
Matt
On Thu, 2006-05-11 at 20:34 -0500, Robert wrote:
> Hi
> I have installed the fallout on my server. I joined this list is hopes
> of learning a thing or two about the theme engine and making themes. The
> reason is I tried a baby step by changing just the background color and
> when it was applied it hole theme went away, what I mean by that there
> was no color displayed only text and layout. This made me think that
> some things had really changed.
>
> Code from default
>
> body {
> color: #000;
> background-color : #000666;
> }
>
>
> Change
>
>
> body {
> color: #000;
> background-color : #000666;
> }
>
> So now what did I do wrong. I have also notice some things that don't
> quit work. Yes I know it is beta that is not the point, the point is, is
> the error known.
>
> If I am in error posting this here please let me know.
>
> Thanks
>
> Silverwolfe
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
--
Matthew McNaney
Electronic Student Services
Appalachian State University
http://phpwebsite.appstate.edu
|
|
From: Robert <ro...@wo...> - 2006-05-12 01:35:06
|
Hi
I have installed the fallout on my server. I joined this list is hopes
of learning a thing or two about the theme engine and making themes. The
reason is I tried a baby step by changing just the background color and
when it was applied it hole theme went away, what I mean by that there
was no color displayed only text and layout. This made me think that
some things had really changed.
Code from default
body {
color: #000;
background-color : #000666;
}
Change
body {
color: #000;
background-color : #000666;
}
So now what did I do wrong. I have also notice some things that don't
quit work. Yes I know it is beta that is not the point, the point is, is
the error known.
If I am in error posting this here please let me know.
Thanks
Silverwolfe
|
|
From: Matthew M. <ma...@tu...> - 2006-05-03 14:30:30
|
Good morning,
This letter is in response to Eloi's and Shaun's emails to the
developer list. You should read each of them to catch up on the
conversion.
As I said yesterday, I am not gungho on rewriting key. Many processes
are balanced against its current functionality. That said, I am also
not willing to make a blunder that could damage the speed of the
program in the long run. So we can discuss the issue further after
this letter.
I will discussing my findings in this email. Contradictory statements
should not mistaken for stubbornness. If the community feels table
separation is needed, so be it. Originally, I thought of using
separate tables, but I figured since I could target only the primary
key of the Key table, access speed should not be an issue. More on
this below.
DO NOT join the conversation without knowing what Key is and how it
works. Install Fallout, install modules, kick it around and, most
importantly, read docs/Key.txt first.
One last thing, this letter will be LONG.
Ok.
I started by greping all the usage of the phpws_key table.
Here are the files that access that table directly (not including the
conversion files). When I write about 'cross-referencing', I am
refering to the following example:
SELECT * FROM phpws_key, some_module WHERE
phpws_key.id=some_module.key_id;
core/class/Key.php
Well duh. There are actually three tables to Key. The other two are
phpws_key_edit and phpws_key_view. They contain the edit and view
permissions respectively.
Queries will cross-reference the key_id columns in each table when
trying to decide whether the particular key should be included in a
list.
A Multi-row result from the phpws_key table, queries the id,
restricted, and active columns. Module column should not be referenced
(it currently is in some cases but read more about that below). For
view and edit restrictions, we will query cross-indexes in the
forementioned tables.
mod/boost/class/Boost.php
It does search on the table's module column, but it only does so when
a module is uninstalled. We can live with that.
mod/categories/class/Action.php
When listing categorized keys, the pager will cross-index against its
category item table. Now there IS a call against the module column
sometimes - which is bad. This can be fixed however by storing the
module in with the category_item. In other words instead of:
SELECT *
FROM phpws_key, category_items
WHERE phpws_key.id=category_items.key_id AND
phpws_key.module = 'some_module';
We use:
SELECT *
FROM phpws_key, category_items
WHERE phpws_key.id=category_items.key_id AND
category_items.module = 'some_module';
This would allow matching only where is was needed and not on the
whole key table.
mod/categories/class/Categories.php
Same deal as above. Need to move module match to the category_items
table.
mod/rss/class/Channel.php
Oh ya.... I wrote an RSS module.
This pulls the last 15 keys. I haven't really worked on this module in
a while. Need to go over it with Wendall at some point.
mod/search/class/User.php
Search would need the same change as categories - create a module
column in the search table. The search process probably requires a
separate discussion outside of the key_id issue.
mod/users/class/Permission.php
Users loads key id's and it searches against the module
column. However, this is only done once per module and then the
permissions are saved in the User session.
mod/webpage/class/Admin.php
When pages are deactivated, Web Page updates the active column on all
the keys. A rare occurrence so it can be disregarded.
Those are all the files. Now back to Eloi's letter:
> It's only faster for... (queries on the key's primary index)
> where the records involved have different module names (but you can't
> search on that). If they're all from the same module, all efficiency
> is lost because of the unnecessarily large index.
Of the queries to phpws_key, two query on the module column and only in
certain instances: categories and search.
If we split the key table into different modules, then we would need
to add the module column for both (so we could know which table
to pull the key id from). We would then search on the primary key in
each separate module key table.
If we are going to add the module column to those tables anyway and we
are still performing searches against the single phpws_key table using
only the primary index, isn't that the same thing?
See the cool thing (to me anyway) about the key table is that other
modules don't have to know where the key came from. If we break it
into module specific tables, purpose of the key becomes kind of
irrelevant. Instead of just storing a single id for information on
another module, I have to keep track of which module it came from. At
that point, why even have the key? We revert back to having to know
DETAILS about the module item. Every module has a single language to
referring to every other content element and it is a single
number. That's nice.
One last thing. Not EVERY item has a key. You only key content items
that have a reason to be bound to something else. For example, Web
Page 'volumes' are keyed. The individual pages in a volume are
not. Blogs entries are keyed as are the comment threads. The
individual comments are not.
Which brings me to Shaun's email:
> Most modules won't be a problem but there's one specific module
which
> needs all the help it can get and that's ANY forum module.
> Potentially you've got millions of posts in a forum. Inefficient
> queries and searches can bring a site to it's knees. Keeping the
> queries as efficient as possible and using the indexes is very
> important.
The current search module is written for keyed elements. Since
comments aren't (and shouldn't) be keyed, they fall outside Search's
capabilities.
What we need to discuss is the ability of Search module "plug-ins". I
will start thinking of a format for comments as an example.
> While I'm on searches. If you're re-doing searching, a time limited
> search would be useful so that, by default at least, a user isn't
> searching every single item ever published on a site.
Very good point. I will add this to the search module.
Ok on to other topics.
> But, users should never be deleted, just made inactive.
Quite true and I should have thought of that. I will recode it.
> That sounds great! "creator" and "updater" could remain as cached
> data as long as the Coding Practices indicate that ownership &
> permissions checks must always be made against "creator_id", as the
> username held in "creator" may be incorrect, obsolete or a duplicate.
I will put the id's in as well.
Something I learned from Eloi's letter was that I need to pay more
attention to optimization. I read some SQL hints this morning and it
is clear I need to create more indexes and watch my query syntax.
I will end this here. Thank you for the feedback on Key. Please
respond to the above if you get a chance.
--
Matthew McNaney
Electronic Student Services
Appalachian State University
http://phpwebsite.appstate.edu
|
|
From: Shaun M. <sh...@ae...> - 2006-05-02 22:03:13
|
On 2 May 2006, at 21:52, Matthew McNaney wrote: > > Understand rewriting key is a major undertaking so I must be positive > the delay would be worth it. > I'll second Eloi's call for separate key tables for each module. Most modules won't be a problem but there's one specific module which needs all the help it can get and that's ANY forum module. Potentially you've got millions of posts in a forum. Inefficient queries and searches can bring a site to it's knees. Keeping the queries as efficient as possible and using the indexes is very important. While I'm on searches. If you're re-doing searching, a time limited search would be useful so that, by default at least, a user isn't searching every single item ever published on a site. I found that on a site with 3-4 years of cruft, and a few hundred thousand forum posts, just setting the default for a search to 'the last 30 days' instead of 'since the dawn of time' resulted in a load less resources being used. A little bit of social engineering goes a long way to make up for cheap-ass servers (not that I have any of those now) or bad code. Shaun aegis design - http://www.aegisdesign.co.uk aegis hosting - http://www.aegishosting.co.uk |
5 messages has been excluded from this view by a project administrator.
