You can subscribe to this list here.
2003 |
Jan
|
Feb
|
Mar
(2) |
Apr
(2) |
May
(24) |
Jun
(1) |
Jul
(6) |
Aug
(1) |
Sep
(3) |
Oct
(2) |
Nov
|
Dec
(1) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Adrian C. - D. <ad...@da...> - 2004-05-22 12:34:56
|
Dear Syntax team, For over a year now my webmaster and I have been trying to work out how = to configure Syntax as a content management system for our site = http://www.danceportalglobal.com/ but have yet to succeed. The reason = for our perseverance has been that from the outset Syntax looks like it = would be somewhat perfect for our needs if we could just work out how to = use it but its too difficult for us to comprehend in its current state = of development! We have decided to abandon Syntax on this attempt and = look for another system that is easier to deploy and configure with our = meagre programming skills or code a custom CMS from the ground up. = However, if one (or more) of you developers could volunteer your time = and expertise to help us by configuring Syntax on our behalf then we'd = be more than willing to make it worth your while in the form of payment = in the future when the site becomes profitable, or in the form of dance = music recordings and/or nightclubbing event tickets in the present if = any of that remotely interests you. Kindest regards and thank you for all your support so far, Adrian and Ian at DancePortalGlobal ___ Adrian Columb Editor, DancePortalGlobal GLOBAL DANCE MUSIC MEDIA http://www.danceportalglobal.com Mobile: +61 (0) 421237478 "Everybody who wants to be a somebody is a nobody. They're the ones you have to watch." Mixmag UK |
From: <ben...@id...> - 2004-05-22 12:05:02
|
Dear Open Source developer I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate. You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it. With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development. With many thanks for your participation, Benno Luthiger PS: The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/. We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list. _______________________________________________________________________ Benno Luthiger Swiss Federal Institute of Technology Zurich 8092 Zurich Mail: benno.luthiger(at)id.ethz.ch _______________________________________________________________________ |
From: Sandy S. <ss...@fo...> - 2004-01-26 16:54:49
|
There are a couple of possibilities: 1) You've created the DBFields entry for Organization_Types but the=20 actual picktable itself. To verify this, see if it's listed under the=20 "pick lists" tab in DBasis. Also you can use PHPMyAdmin or the command=20= line to see if the table exists on your database (command is "SHOW=20 TABLES" on the command line). 2) There's a bug in Context. We haven't seen it, but the relevant code=20= in Context is in "display/picktables.php", assuming this bug happens on=20= every page. A quick note about *types tables. Generally Syntax expects them to be=20 mapped to the "type" field in dbfields, and named with the name from=20 the "type" field in the "datatypes" tab in DBasis, contatenated with=20 "types". So an "organisation" object with a list of types of=20 organizations would have a picklist called "organisationtypes". That=20 spares you having to create a field in the records table to store the=20 value. HTH, Sandy On Jan 21, 2004, at 9:00 PM, Adrian Columb wrote: > Hi Syntax team, > =A0 > We have just reinstalled Syntax from CVS so we are working with the=20 > latest version... There is a strange issue where Context isn't finding=20= > all the picktables - eg, when you click on the 'Organization_Types'=20 > picklist in Context it says "Fatal error: mysql error: [1146: Table > 'pxdb.Organization_Types' doesn't exist] in EXECUTE("SHOW COLUMNS FROM=20= > Organization_Types") in > /home/danceportal/PxDB/resources/adodb/adodb-errorhandler.inc.php on=20= > line 76", however when in DBasis I can see that the=20 > 'Organization_Types' picklist is alive and well, though apparently=20 > invisible to Context. Any ideas how to fix this problem? > =A0 > Also, while I was adding 'sunrise' and 'sunset' as=A0'dbfields'=20 > and=A0adding them both to the=A0'contact' data object type that was = asking=20 > for=A0them, I firstly created a 'preferences' entry for both=A0of = them=A0by=20 > mistake - can I just delete these from the 'preferences' section or=20 > are there things that now depend on them/will I break something if I=20= > do? > =A0 > Best, > =A0 > Adrian > !DSPAM:400f2d38168861732337885! -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ss...@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |
From: Adrian C. <ad...@da...> - 2004-01-22 01:53:57
|
Hi Syntax team, We have just reinstalled Syntax from CVS so we are working with the = latest version... There is a strange issue where Context isn't finding = all the picktables - eg, when you click on the 'Organization_Types' = picklist in Context it says "Fatal error: mysql error: [1146: Table 'pxdb.Organization_Types' doesn't exist] in EXECUTE("SHOW COLUMNS FROM = Organization_Types") in /home/danceportal/PxDB/resources/adodb/adodb-errorhandler.inc.php on = line 76", however when in DBasis I can see that the 'Organization_Types' = picklist is alive and well, though apparently invisible to Context. Any = ideas how to fix this problem? Also, while I was adding 'sunrise' and 'sunset' as 'dbfields' and adding = them both to the 'contact' data object type that was asking for them, I = firstly created a 'preferences' entry for both of them by mistake - can = I just delete these from the 'preferences' section or are there things = that now depend on them/will I break something if I do? Best, Adrian |
From: Adrian C. <ad...@da...> - 2003-12-15 01:14:42
|
Hi Syntax team, Sorry to have left this so long since we last spoke but we have just = managed to get our Syntax installation working again in a basic fashion, = and would really appreciate some help if you have any time... I've worked out pretty much how we should be setting up our datatypes to = make them work with each other to create our site's content, but I have = uncovered an error as follows that I was wondering if you would know how = to fix it? Fatal error: mysql error: [1064: You have an error in your SQL = syntax near '' at line 1] in EXECUTE("SELECT DISTINCT dt1 FROM = datatypesrel WHERE relid =3D ") in = /home/danceportal/www/DBasis/includes/errorhandler.inc.php on line 77 =20 The error can be found in the 'Event' datatype, in the 'Object' section = of http://www.danceportalglobal.com/DBasis/ (user: adrian, pass: = columb). Another problem I've found is that the names of relationships are still = being deleted if I edit them after creation - does it matter if I just = delete the damaged relationships and recreate them when that happens? Thanks a heap if you can help - hope you are well! Best, Adrian ___ Adrian Columb Editor, DancePortalGlobal GLOBAL DANCE MUSIC MEDIA http://www.danceportalglobal.com "Everybody who wants to be a somebody is a nobody. They're the ones you have to watch." Mixmag UK |
From: Hans L. <ha...@ve...> - 2003-10-30 14:38:18
|
Hi Folks, For the past sevaral months I've been developing Propel, a PHP5 port of the Apache Torque object persistence layer. In many ways Propel (and Torque) is quite similar to PxDB/Syntax, so it might be interesting to look at. http://propel.phpdb.org for the glossy view. In short, the way Propel works is: 1) You define your data model in XML (a fairly simple schema) 2) You use Phing (PHP build tool, based on ANT) to "build" the object model; this step creates classes for manipulating objects in the database and SQL definition (dump) files to create the database in your specific RDBMS. 3) You use the created classes in your scripts to search & manipulate rows & tables in your database. Every class has a Base class and an [initially] empty subclass which is where custom behavior can go (i.e. you use overrides in subclass to avoid needing to change the om templates for custom behavior). Some features: + Advanced support for inter-related objects. Ability to fetch related records within the same primary query (BookPeer::doSelectJoinAuthor($criteria). Also, cascading save & delete is supported. + Support for inheritance + The DB structure is much more traditional than Syntax's: e.g. there's no monster "records" table. + Similar to Syntax, a Criteria/Criterion system is used to construct queries. Propel's Criteria system is quite a bit more complex than Syntax's, though, making it possible to do very complicated logical combinations. On the other hand, Propel is not a CMF; it's just an object persistence layer. There is no perms/privs support; there is no DBasis tool for working with the XML. Neither is there a "Context" tool to provide an admin interface. Things like this may come to exist in the future; the team member who is writing the Oracle drivers is also working on "Combine", a port of Turbine which provides a framework on top of Propel. Obviously this servers a different need from PxDB/Syntax, but wanted to let you know that the Propel tools are pretty nice for working with traditional database designs in an object-oriented fashion. Anyway, it's been a fun project. It was neat to see that PxDB stuff is quite good at stuff like SearchCriteria objects for query construction, etc. Cheers, Hans |
From: Sandy S. <ss...@fo...> - 2003-10-29 21:57:37
|
At long last, the DBasis disappearing relationship bug has been quashed. The fix has been tested and is in CVS. If you are relatively current, just update from CVS in your classes/metadata directory. Documentation has also been updated to accurately reflect public and private methods, and slight improvements (inclusion of parameter and return documentation, where possible) have been made. Sorry for the length of time between updates, but we've been incredibly busy on client work. The good news is we should be on track for an 0.0.5 release in the relatively near future. Stay tuned. -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ss...@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |
From: Hans L. <ha...@ve...> - 2003-09-10 18:12:57
|
Hi Adrian, The decision of how to setup your database really depends on the kinds = of questions (queries) that you plan to ask. I would lean toward a more generic approach -- i.e. Person, Organization, Place -- because you can always add attributes to set apart one type of person (or org, place) = from another. Having generic datatypes makes it very easy to answer very = broad questions like "how many people are associated with a particular place?" instead of having to ask several question ("how many DJs?", "How many Producers?", etc.) and then adding up the answers. And, of course, even if these are all the same datatype, the filtering = stuff in Syntax makes it very easy to write queries that will only return the = DJs in the db. This is assuming, though, that all types of Person object share roughly = the same fields. If a DJ record looks completely different from a Producer record, then you may want to make these separate datatypes. Another way to attack the problem is to think about how your = relationships will be structured. Does it make sense to think of your Person<->Org relationship at a high level (i.e. could any type of person be related = to any type of organization)? If so, then you probably want to keep these datatypes generic. If not -- i.e. if only DJs can be related to Pubs -- then you may want more specific datatypes (so that, for example, only = DJs would be displayed in the picklist relating people and pubs). Hope that helps a bit. Someone else may have some more up-to-date suggestions on Syntax use, as it's been awhile since I've worked in that paradigm. Cheers, Hans |=20 | -----Original Message----- | From: web...@li...=20 | [mailto:web...@li...] On Behalf=20 | Of Adrian Columb | Sent: Wednesday, September 10, 2003 1:46 PM | To: web...@li... |=20 | Hi Syntax team, |=20 | I am still unsure about how to set up datatypes for our=20 | Syntax site and would appreciate some assistance - |=20 | Should I create generic datatypes like 'Person',=20 | 'Organisation', and 'Place', and then categorise individual=20 | records under 'Person Types', 'Organisation Types', and=20 | 'Place Types' picklists? |=20 | Or should I create more specific datatypes such as 'DJ',=20 | 'Producer', 'Remixer' (types of People), 'Promotion Company',=20 | 'Record Label', 'Talent Agency' (types of Organisations), and=20 | 'Nightclub Venue', 'Bar/Pub', 'Outdoor Venue' (types of Places)? |=20 | Hope someone can help clarify this for me. |=20 | Regards, |=20 | Adrian |=20 |=20 |=20 | ------------------------------------------------------- | This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. | http://thinkgeek.com/sf | _______________________________________________ | Websyntax-core mailing list | Web...@li... | https://lists.sourceforge.net/lists/listinfo/websyntax-core |=20 |
From: Sandy S. <ss...@fo...> - 2003-09-10 18:00:44
|
There is no hard and fast rule for this. For background reading, I suggest reading any work on object oriented programming, particularly object-oriented design. What level of class differentiation is a key question of such design. My rule of thumb is: if you need the same information but it needs to be processed differently, then use the same object but designate a type for it. If, however, the information needed for an object depends on the type (more than a few fields, few being a judgment call), then I'd break it into different types of objects. If you ever need to display collections of the different types of objects, that's also a hint to make them one object and use the {classname}types functionality to differentiate. HTH, Sandy On Wednesday, September 10, 2003, at 01:46 PM, Adrian Columb wrote: > Hi Syntax team, > > I am still unsure about how to set up datatypes for our Syntax site and > would appreciate some assistance - > > Should I create generic datatypes like 'Person', 'Organisation', and > 'Place', and then categorise individual records under 'Person Types', > 'Organisation Types', and 'Place Types' picklists? > > Or should I create more specific datatypes such as 'DJ', 'Producer', > 'Remixer' (types of People), 'Promotion Company', 'Record Label', > 'Talent > Agency' (types of Organisations), and 'Nightclub Venue', 'Bar/Pub', > 'Outdoor > Venue' (types of Places)? > > Hope someone can help clarify this for me. > > Regards, > > Adrian > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core > > -- Sandy Smith, Senior Programmer Forum One Communications <ss...@fo...> http://www.forumone.com/ tel. (703) 548-1855 x28 |
From: Adrian C. <ad...@da...> - 2003-09-10 17:45:03
|
Hi Syntax team, I am still unsure about how to set up datatypes for our Syntax site and would appreciate some assistance - Should I create generic datatypes like 'Person', 'Organisation', and 'Place', and then categorise individual records under 'Person Types', 'Organisation Types', and 'Place Types' picklists? Or should I create more specific datatypes such as 'DJ', 'Producer', 'Remixer' (types of People), 'Promotion Company', 'Record Label', 'Talent Agency' (types of Organisations), and 'Nightclub Venue', 'Bar/Pub', 'Outdoor Venue' (types of Places)? Hope someone can help clarify this for me. Regards, Adrian |
From: Randum I. <ia...@ra...> - 2003-08-01 18:09:02
|
Hi guys, had an email from the Editor and was wondering if any of you could help me? [snip] I now understand that datatypes can be designated as hierarchical children (subcategories) of other datatypes using 'indirect' relationships (called noderel in Syntax wiki's Data Objects page).... There is no mention of noderel relationships in Dbasis that I can see - could you please ask Nyk how they can be set up? Also, on our database plan document (attached) we have specified that records of the Event datatype are related to Organisation datatype records but in actual fact they are related to Promoter datatype records which is a hierarchical subcategory of the Organisation datatype - Could you also please ask Nyk whether Event datatype records should be related to Organisation datatype records (the parent) or the Promoter datatype (the child) in this type of instance? [snip] Hope you can help. Cheers, Randum Ian ia...@ra... CBDagency Web Consultant http://www.cbdagency.com DancePortalGlobal Webmaster http://www.danceportalglobal.com |
From: Randum I. <ia...@ra...> - 2003-07-09 14:06:36
|
Thanks for your input Oscar, I am indeed going to try and configure a RedHat box on my old AMD PC which if it all goes well should work thru the network with my windows PC. If all that doesn't work then I will have to resort to Firepages.com.au and its bodged up windows server. > I'll just chime in with my two cents. Phptriad > (http://sourceforge.net/projects/phptriad) hasn't been updated in over a > year so you might not be getting the latest php, mysql, apache there. > I'd recommend setting up a redhat box since you can get php, apache, and > mysql working right out of the box. > > -Oscar Merida > >>--__--__-- >> >>Message: 4 >>Date: Tue, 8 Jul 2003 16:05:23 +0100 (BST) >>Subject: RE: [Websyntax-core] [OT] Test Server Examples/Conditions >> From: "Randum Ian" <ia...@ra...> >>To: <ny...@fo...> >>Cc: <ss...@fo...>, <ia...@ra...>, >> <web...@li...> >> >>You know I really want a Linux install more than anything but I haven't >> got the first idea on how to start creating one! I will have a look at >> those you have suggested to me. The reason I didn't want to create >> another install on my web server is that I would get too confused with >> two copies flying around! I would like to be able to test an instant of >> it without bringing the whole web server down with me! >> >> >> >> > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Parasoft > Error proof Web apps, automate testing & more. > Download & eval WebKing and get a free book. > www.parasoft.com/bulletproofapps > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core Randum Ian ia...@ra... CBDagency Web Consultant http://www.cbdagency.com DancePortalGlobal Webmaster http://www.danceportalglobal.com |
From: Oscar M. <om...@fo...> - 2003-07-09 13:51:47
|
I'll just chime in with my two cents. Phptriad (http://sourceforge.net/projects/phptriad) hasn't been updated in over a year so you might not be getting the latest php, mysql, apache there. I'd recommend setting up a redhat box since you can get php, apache, and mysql working right out of the box. -Oscar Merida >--__--__-- > >Message: 4 >Date: Tue, 8 Jul 2003 16:05:23 +0100 (BST) >Subject: RE: [Websyntax-core] [OT] Test Server Examples/Conditions >From: "Randum Ian" <ia...@ra...> >To: <ny...@fo...> >Cc: <ss...@fo...>, <ia...@ra...>, > <web...@li...> > >You know I really want a Linux install more than anything but I haven't >got the first idea on how to start creating one! I will have a look at >those you have suggested to me. The reason I didn't want to create another >install on my web server is that I would get too confused with two copies >flying around! I would like to be able to test an instant of it without >bringing the whole web server down with me! > > > > |
From: Randum I. <ia...@ra...> - 2003-07-08 14:46:39
|
You know I really want a Linux install more than anything but I haven't got the first idea on how to start creating one! I will have a look at those you have suggested to me. The reason I didn't want to create another install on my web server is that I would get too confused with two copies flying around! I would like to be able to test an instant of it without bringing the whole web server down with me! > Short answer is that it is time to setup that Linux desktop machine you > always wanted :-) > > However, PHP Triad worked very well for me when I installed it about a > year ago and I am guessing that it has only got better > (http://sourceforge.net/projects/phptriad). Also, if you are feeling > adventurous and want to put a unix environment on your Windows box > (including Apache, MySQL and PHP) you might want to play around with > Cygwin (http://www.cygwin.com/). > > However, another alternative that leverages your exsisting server > environment is simply to set up a dev folder on your server and install > a separate instance of Syntax under there - you will also need a > development database in MySQL too for this to work. > > Nyk Cowham, Systems Architect > Forum One Communications > http://www.forumone.com/ > Communicate Collaborate Change the world > >> -----Original Message----- >> From: web...@li... >> [mailto:web...@li...]On Behalf Of Sandy >> Smith >> Sent: Tuesday, July 08, 2003 9:51 AM >> To: Randum Ian >> Cc: web...@li... >> Subject: Re: [Websyntax-core] [OT] Test Server Examples/Conditions >> >> >> We use a Red Hat server that is (with a very few exceptions) identical >> to our production environment and access it over Samba like it's just >> another network drive. That being said, it is fairly easy to obtain >> MySQL, PHP, and Apache for a Windows box and test using "localhost". >> On how to do that, I leave you to the caring hands of Google, as I'm >> primarily a Mac-based guy. >> >> Quick googling got me this: >> >> http://faq.ozoneasylum.com/60 >> >> Enjoy, >> Sandy >> >> On Tuesday, July 8, 2003, at 09:12 AM, Randum Ian wrote: >> >> > Hi guys, a bit off-topic this question but I am intrigued as to how >> you test versions of your server in-house. Do you have an example of >> how to set up a test server on a windows machine? If you don't then >> how do you do >> > it on Unix? I should be able to set up a test box with Red Hat or >> something like that on to test the server. The reason I am asking >> this is >> > because development time is costly and slow on dialup. I am open to >> all ideas, any help much appreciated. >> > >> > Regards, >> > Randum Ian >> > ia...@ra... >> > CBDagency Web Consultant >> > http://www.cbdagency.com >> > DancePortalGlobal Webmaster >> > http://www.danceportalglobal.com >> > >> > >> > >> > >> > >> > ------------------------------------------------------- >> > This SF.Net email sponsored by: Free pre-built ASP.NET sites >> including Data Reports, E-commerce, Portals, and Forums are >> available now. Download today and enter to win an XBOX or Visual >> Studio .NET. >> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/ >> 01 >> > _______________________________________________ >> > Websyntax-core mailing list >> > Web...@li... >> > https://lists.sourceforge.net/lists/listinfo/websyntax-core >> > >> > >> -- >> Sandy Smith, Senior Programmer >> Forum One Communications >> <ss...@fo...> >> http://www.forumone.com/ >> tel. (703) 548-1855 x28 >> >> >> >> ------------------------------------------------------- >> This SF.Net email sponsored by: Free pre-built ASP.NET sites including >> Data Reports, E-commerce, Portals, and Forums are available now. >> Download today and enter to win an XBOX or Visual Studio .NET. >> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 >> _______________________________________________ >> Websyntax-core mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/websyntax-core Randum Ian ia...@ra... CBDagency Web Consultant http://www.cbdagency.com DancePortalGlobal Webmaster http://www.danceportalglobal.com |
From: Nyk C. <ny...@fo...> - 2003-07-08 14:35:54
|
Short answer is that it is time to setup that Linux desktop machine you always wanted :-) However, PHP Triad worked very well for me when I installed it about a year ago and I am guessing that it has only got better (http://sourceforge.net/projects/phptriad). Also, if you are feeling adventurous and want to put a unix environment on your Windows box (including Apache, MySQL and PHP) you might want to play around with Cygwin (http://www.cygwin.com/). However, another alternative that leverages your exsisting server environment is simply to set up a dev folder on your server and install a separate instance of Syntax under there - you will also need a development database in MySQL too for this to work. Nyk Cowham, Systems Architect Forum One Communications http://www.forumone.com/ Communicate Collaborate Change the world > -----Original Message----- > From: web...@li... > [mailto:web...@li...]On Behalf Of Sandy > Smith > Sent: Tuesday, July 08, 2003 9:51 AM > To: Randum Ian > Cc: web...@li... > Subject: Re: [Websyntax-core] [OT] Test Server Examples/Conditions > > > We use a Red Hat server that is (with a very few exceptions) identical > to our production environment and access it over Samba like it's just > another network drive. That being said, it is fairly easy to obtain > MySQL, PHP, and Apache for a Windows box and test using "localhost". On > how to do that, I leave you to the caring hands of Google, as I'm > primarily a Mac-based guy. > > Quick googling got me this: > > http://faq.ozoneasylum.com/60 > > Enjoy, > Sandy > > On Tuesday, July 8, 2003, at 09:12 AM, Randum Ian wrote: > > > Hi guys, a bit off-topic this question but I am intrigued as to how you > > test versions of your server in-house. Do you have an example of how to > > set up a test server on a windows machine? If you don't then how do > > you do > > it on Unix? I should be able to set up a test box with Red Hat or > > something like that on to test the server. The reason I am asking this > > is > > because development time is costly and slow on dialup. I am open to all > > ideas, any help much appreciated. > > > > Regards, > > Randum Ian > > ia...@ra... > > CBDagency Web Consultant > > http://www.cbdagency.com > > DancePortalGlobal Webmaster > > http://www.danceportalglobal.com > > > > > > > > > > > > ------------------------------------------------------- > > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > > Data Reports, E-commerce, Portals, and Forums are available now. > > Download today and enter to win an XBOX or Visual Studio .NET. > > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/ > > 01 > > _______________________________________________ > > Websyntax-core mailing list > > Web...@li... > > https://lists.sourceforge.net/lists/listinfo/websyntax-core > > > > > -- > Sandy Smith, Senior Programmer > Forum One Communications > <ss...@fo...> > http://www.forumone.com/ > tel. (703) 548-1855 x28 > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core > > |
From: Sandy S. <ss...@fo...> - 2003-07-08 13:51:36
|
We use a Red Hat server that is (with a very few exceptions) identical to our production environment and access it over Samba like it's just another network drive. That being said, it is fairly easy to obtain MySQL, PHP, and Apache for a Windows box and test using "localhost". On how to do that, I leave you to the caring hands of Google, as I'm primarily a Mac-based guy. Quick googling got me this: http://faq.ozoneasylum.com/60 Enjoy, Sandy On Tuesday, July 8, 2003, at 09:12 AM, Randum Ian wrote: > Hi guys, a bit off-topic this question but I am intrigued as to how you > test versions of your server in-house. Do you have an example of how to > set up a test server on a windows machine? If you don't then how do > you do > it on Unix? I should be able to set up a test box with Red Hat or > something like that on to test the server. The reason I am asking this > is > because development time is costly and slow on dialup. I am open to all > ideas, any help much appreciated. > > Regards, > Randum Ian > ia...@ra... > CBDagency Web Consultant > http://www.cbdagency.com > DancePortalGlobal Webmaster > http://www.danceportalglobal.com > > > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/ > 01 > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core > > -- Sandy Smith, Senior Programmer Forum One Communications <ss...@fo...> http://www.forumone.com/ tel. (703) 548-1855 x28 |
From: Randum I. <ia...@ra...> - 2003-07-08 12:53:55
|
Hi guys, a bit off-topic this question but I am intrigued as to how you test versions of your server in-house. Do you have an example of how to set up a test server on a windows machine? If you don't then how do you do it on Unix? I should be able to set up a test box with Red Hat or something like that on to test the server. The reason I am asking this is because development time is costly and slow on dialup. I am open to all ideas, any help much appreciated. Regards, Randum Ian ia...@ra... CBDagency Web Consultant http://www.cbdagency.com DancePortalGlobal Webmaster http://www.danceportalglobal.com |
From: Adrian C. <ad...@da...> - 2003-06-18 18:24:21
|
Hi there guys, I've been pondering how to set up our Syntax DB structure and have a question for you... Is it possible/wise for use us to set up datatypes such as the Organisations datatype to contain all the fields used by the various Organisation types (Ie, subcategory and then create different Views of the Organisation datatype for each specific Organisation type subcategory that use some different fields (Eg, an Event Promoter organisation type would require some slightly different fields to a Record Label organisation type but they would use mostly the same fields as each other)? If that is a good approach then I think we can probably begin to configure it soon! Also, did anyone take a look at the DancePortalGlobal_SyntaxCMF_May2003 plan document I sent over a couple of weeks ago? Is that useful at all? And, have you made any progress in diagnosing and fixing the two bugs that are preventing our install of Syntax from functioning correctly (Ie, so we can include relationship descriptions as well as delete unused datatypes without needing to use the command line/PHPMyAdmin to fix the corruptions these issues cause in our DB)? Sincerely, Adrian |
From: Adrian C. <ad...@da...> - 2003-05-18 16:20:15
|
Hi Syntax core team, I was able to debug the missing datatype problem in our MyAdmin tool with the help of a database professional - thanks for your advice on that. Also, we have updated all packages from CVS yesterday - unfortunately the problem with the empty Relationships picklist when creating object fields persists, as does the problem with the Context login not working at all. What should we do next to try and fix these? Is there any chance one of you would be willing to take a look at our setup to help get us back on track? Best, Adrian From: Sandy Smith <ssmith@fo...> Install Issues 2003-05-14 07:38 Hi Adrian and Ian-- I would suggest re-updating from CVS all your packages and see if that does not solve your problem. I have been bugfixing for the past week and there may be incompatibilities in your packages as we ramp up to the 0.0.5 release. If that doesn't work, let us know. It should NOT be necessary to delete and reinstall everything. -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ssmith@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |
From: Adrian C. <ad...@da...> - 2003-05-15 21:09:40
|
Hi Nyk, Sandy, Hans, Syntax Core, Would it be possible for one of you to take a look at the plan I've uploaded to http://www.danceportalglobal.com/monopolyboarddiagramtemplate.doc and let me know if its OK or how it can be improved? I've concentrated on the datatypes relevant for an event-related item to be added to the database so the other datatypes are not all complete yet. When the plan document is perfected I'm guessing we'll be able to reinstall Syntax to get rid of the bugs we are experiencing, and then customise it to our needs pretty quickly. As long as we don't ever delete a datatype then that problem probably won't re-occur. Also hoping that the problem with the relationships dropdown not showing up when I'm creating new object fields, and the problem where we cant log in to context at all despite having updated from CVS will both hopefully be fixed when we reinstall it again. Is that plausible at all? Also, does it matter which order the fields appear/are created in each datatype in the dbasis tool (Ie, as that would define the order of the fields in the input form)? Or can the order be changed when creating input forms (Eg, by using views maybe)? If someone could please try to help us soon that would be fantastic as our deadline is looming. If you could you please reply directly to me that would be great as I am unable to subscribe to the Syntax core list for some reason. Best, Adrian |
From: Nyk C. <nc...@fo...> - 2003-05-14 15:32:58
|
On Wednesday, May 14, 2003, at 11:09 AM, Randum Ian wrote: > Hi Sandy, is there a way of getting notified of a new change to the CVS > either by email or on a webpage somewhere? If you have an account with Sourceforge you can set it to monitor activity in the CVS. > The Smarty and Php ones are on a sort of email list which is very > useful. I > will update our packages tonight and see how we do. Significant updates will always be announced on the websyntax-core and websyntax-users lists. > One thing I did note was that even though Adrian has removed all > traces of > the offending table from Dbasis the table of the same name still > occurs in > the database. Is this normal? > > Regards, Ian. > >> Hi Adrian and Ian-- >> >> I would suggest re-updating from CVS all your packages and see if that >> does not solve your problem. I have been bugfixing for the past week >> and there may be incompatibilities in your packages as we ramp up to >> the 0.0.5 release. >> >> If that doesn't work, let us know. It should NOT be necessary to >> delete >> and reinstall everything. >> >> -- >> Sandy Smith, Senior Programmer >> Forum One Communications, Inc. >> ss...@fo... >> tel. 703-548-1855 x28 >> http://www.forumone.com/ >> >> >> >> ------------------------------------------------------- >> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara >> The only event dedicated to issues related to Linux enterprise >> solutions www.enterpriselinuxforum.com >> >> _______________________________________________ >> Websyntax-core mailing list >> Web...@li... >> https://lists.sourceforge.net/lists/listinfo/websyntax-core > > > Randum Ian > ia...@ra... > DancePortalGlobal Webmaster > http://www.danceportalglobal.com > > > > ------------------------------------------------------- > Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara > The only event dedicated to issues related to Linux enterprise > solutions > www.enterpriselinuxforum.com > > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core > |
From: Sandy S. <ss...@fo...> - 2003-05-14 15:13:29
|
Not especially, as that's the group 'admin' (datatype 2) rather than the user 'admin' (datatype 1). I'd assumed you had the default install that comes with both a user and group named "admin". On Wednesday, May 14, 2003, at 11:33 AM, Randum Ian wrote: > There is admin, etc in "name" but not "idnum". Is that not wierd? > >> Note my caveat about substituting other user IDs. It looks like you've >> deleted or altered your admin user, so, assuming that you are in the >> admin group: >> >> UPDATE records SET password = ENCRYPT('yourPassHere') WHERE idnum = >> 'iroke' AND datatype = 1; >> >> If that doesn't work, look up try: >> >> INSERT INTO primaryrel (relid, id1, id2) VALUES (1, 2, 1); >> INSERT INTO primaryrel (relid, id1, id2) VALUES (1, 1, 2); >> >> INSERT INTO usergroup (idnum, groups) VALUES ('iroke', 'admin'); >> >> >> On Wednesday, May 14, 2003, at 11:17 AM, Randum Ian wrote: >> >>> Hi Sandy, thanks for your reply. >>> >>> Unfortunately that SQL doesn't work because there is nothing in the >>> idnum >>> field. I have attached a dbdump of the records table. >>> >>> ---[paste]--- >>> # phpMyAdmin MySQL-Dump >>> # version 2.2.4 >>> # http://phpwizard.net/phpMyAdmin/ >>> # http://phpmyadmin.sourceforge.net/ (download page) >>> # >>> # Host: localhost >>> # Generation Time: May 14, 2003 at 10:51 AM >>> # Server version: 3.23.56 >>> # PHP Version: 4.2.3 >>> # Database : `pxdb` >>> # -------------------------------------------------------- >>> >>> # >>> # Table structure for table `records` >>> # >>> >>> CREATE TABLE records ( >>> id int(11) NOT NULL auto_increment, >>> datatype int(11) NOT NULL default '0', >>> approved int(11) NOT NULL default '0', >>> idnum varchar(64) NOT NULL default '', >>> name varchar(127) NOT NULL default '', >>> title varchar(127) NOT NULL default '', >>> email varchar(127) NOT NULL default '', >>> fname varchar(64) NOT NULL default '', >>> mi varchar(32) NOT NULL default '', >>> lname varchar(64) NOT NULL default '', >>> address1 varchar(127) NOT NULL default '', >>> address2 varchar(127) NOT NULL default '', >>> city varchar(127) NOT NULL default '', >>> state char(2) NOT NULL default '', >>> zip varchar(16) NOT NULL default '', >>> country varchar(127) NOT NULL default '', >>> desc1 text, >>> password varchar(32) NOT NULL default '', >>> modified timestamp(14) NOT NULL, >>> updatedby varchar(127) NOT NULL default '', >>> date1 datetime NOT NULL default '0000-00-00 00:00:00', >>> date2 datetime NOT NULL default '0000-00-00 00:00:00', >>> phone varchar(32) default NULL, >>> fax varchar(32) default NULL, >>> url varchar(255) default NULL, >>> amount double(12,2) default NULL, >>> type int(10) unsigned NOT NULL default '0', >>> desc2 text, >>> active enum('Y','N') NOT NULL default 'N', >>> file varchar(255) NOT NULL default '', >>> weight int(3) unsigned NOT NULL default '50', >>> subject int(10) unsigned NOT NULL default '0', >>> filetype int(10) unsigned NOT NULL default '0', >>> created datetime NOT NULL default '0000-00-00 00:00:00', >>> bool1 tinyint(4) NOT NULL default '0', >>> bool2 tinyint(4) NOT NULL default '0', >>> bool3 tinyint(4) NOT NULL default '0', >>> phone2 varchar(32) default NULL, >>> phone3 varchar(32) default NULL, >>> text1 varchar(127) NOT NULL default '', >>> url2 varchar(255) default NULL, >>> PRIMARY KEY (id), >>> KEY modified (modified), >>> KEY updatedby (updatedby), >>> KEY name (name), >>> KEY lname (lname), >>> KEY city (city), >>> KEY state (state), >>> KEY idnum (idnum), >>> KEY weight (weight), >>> KEY datatype (datatype), >>> KEY approved (approved) >>> ) TYPE=MyISAM PACK_KEYS=1; >>> >>> # >>> # Dumping data for table `records` >>> # >>> >>> INSERT INTO records VALUES (1, 2, >>> 0, '', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', >>> 'Gu7aFKO54pm >>> AU', 20020827205407, '', '0000-00-00 00:00:00', '0000-00-00 >>> 00:00:00', >>> NULL, NULL, NULL, NULL, 0, NULL, 'N', '', 50, 0, 0, '2002-08-27 >>> 20:54:07', >>> 0, 0, 0, NULL, NULL, '', NULL); >>> INSERT INTO records VALUES (2, 1, 0, 'iroke', 'Ian >>> Roke', 'Mr', 'ad...@yo...', 'Ian', 'Thomas', 'Roke', '', '', >>> '', '', >>> '', 'Angola', 'Adminstrative User', '', 20030510040547, '', >>> '0000-00-00 00:00:00', '0000-00-00 00:00:00', '111', '', NULL, NULL, >>> 0, '', 'Y', '', >>> 50, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '', '', '', NULL); >>> INSERT INTO records VALUES (3, 7, >>> 0, '', 'CBDAgency.com', '', '', '', '', '', '', '', 'Hull', '', '', >>> 'United >>> Kingdom', '', '', 20030510040440, '', '0000-00-00 00:00:00', >>> '0000-00-00 >>> 00:00:00', '666', '', 'http://www.cbdagency.com', NULL, 7, NULL, 'N', >>> '', >>> 50, 0, 0, '2003-05-10 04:04:40', 0, 0, 0, NULL, NULL, '', NULL); >>> ---[paste]--- >>> >>>> The SQL to directly update a password for the admin user (substitute >>>> 'admin' with any user ID for other users): >>>> >>>> UPDATE records SET password = ENCRYPT('newpass') WHERE idnum = >>>> 'admin' AND datatype = 1; >>>> >>>> Also, your "organisationtypes" bug may come from the fact that the >>>> "type" field gets automagically mapped to the {objectname}types >>>> table, where {objectname} is the name of the currently-selected >>>> object. If you >>>> still have "type" selected for your Organisation object, you will >>>> get >>>> this error if you do not have an organisationtypes table. >>>> >>>> -- >>>> Sandy Smith, Senior Programmer >>>> Forum One Communications, Inc. >>>> ss...@fo... >>>> tel. 703-548-1855 x28 >>>> http://www.forumone.com/ >>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa >>>> Clara >>>> The only event dedicated to issues related to Linux enterprise >>>> solutions www.enterpriselinuxforum.com >>>> >>>> _______________________________________________ >>>> Websyntax-core mailing list >>>> Web...@li... >>>> https://lists.sourceforge.net/lists/listinfo/websyntax-core >>> >>> >>> Randum Ian >>> ia...@ra... >>> DancePortalGlobal Webmaster >>> http://www.danceportalglobal.com >>> >>> >> -- >> Sandy Smith, Senior Programmer >> Forum One Communications, Inc. >> ss...@fo... >> tel. 703-548-1855 x28 >> http://www.forumone.com/ > > > Randum Ian > ia...@ra... > DancePortalGlobal Webmaster > http://www.danceportalglobal.com > > -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ss...@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |
From: Sandy S. <ss...@fo...> - 2003-05-14 15:07:26
|
Yes--DBasis doesn't delete a picktable if you delete the attribute associated with it, or even if you delete all of the picktable's entries. On Wednesday, May 14, 2003, at 11:09 AM, Randum Ian wrote: > One thing I did note was that even though Adrian has removed all > traces of > the offending table from Dbasis the table of the same name still > occurs in > the database. Is this normal? > -- Sandy Smith, Senior Programmer Forum One Communications, Inc. ss...@fo... tel. 703-548-1855 x28 http://www.forumone.com/ |
From: Randum I. <ia...@ra...> - 2003-05-14 14:53:07
|
Hi Sandy, thanks for your reply. Unfortunately that SQL doesn't work because there is nothing in the idnum field. I have attached a dbdump of the records table. ---[paste]--- # phpMyAdmin MySQL-Dump # version 2.2.4 # http://phpwizard.net/phpMyAdmin/ # http://phpmyadmin.sourceforge.net/ (download page) # # Host: localhost # Generation Time: May 14, 2003 at 10:51 AM # Server version: 3.23.56 # PHP Version: 4.2.3 # Database : `pxdb` # -------------------------------------------------------- # # Table structure for table `records` # CREATE TABLE records ( id int(11) NOT NULL auto_increment, datatype int(11) NOT NULL default '0', approved int(11) NOT NULL default '0', idnum varchar(64) NOT NULL default '', name varchar(127) NOT NULL default '', title varchar(127) NOT NULL default '', email varchar(127) NOT NULL default '', fname varchar(64) NOT NULL default '', mi varchar(32) NOT NULL default '', lname varchar(64) NOT NULL default '', address1 varchar(127) NOT NULL default '', address2 varchar(127) NOT NULL default '', city varchar(127) NOT NULL default '', state char(2) NOT NULL default '', zip varchar(16) NOT NULL default '', country varchar(127) NOT NULL default '', desc1 text, password varchar(32) NOT NULL default '', modified timestamp(14) NOT NULL, updatedby varchar(127) NOT NULL default '', date1 datetime NOT NULL default '0000-00-00 00:00:00', date2 datetime NOT NULL default '0000-00-00 00:00:00', phone varchar(32) default NULL, fax varchar(32) default NULL, url varchar(255) default NULL, amount double(12,2) default NULL, type int(10) unsigned NOT NULL default '0', desc2 text, active enum('Y','N') NOT NULL default 'N', file varchar(255) NOT NULL default '', weight int(3) unsigned NOT NULL default '50', subject int(10) unsigned NOT NULL default '0', filetype int(10) unsigned NOT NULL default '0', created datetime NOT NULL default '0000-00-00 00:00:00', bool1 tinyint(4) NOT NULL default '0', bool2 tinyint(4) NOT NULL default '0', bool3 tinyint(4) NOT NULL default '0', phone2 varchar(32) default NULL, phone3 varchar(32) default NULL, text1 varchar(127) NOT NULL default '', url2 varchar(255) default NULL, PRIMARY KEY (id), KEY modified (modified), KEY updatedby (updatedby), KEY name (name), KEY lname (lname), KEY city (city), KEY state (state), KEY idnum (idnum), KEY weight (weight), KEY datatype (datatype), KEY approved (approved) ) TYPE=MyISAM PACK_KEYS=1; # # Dumping data for table `records` # INSERT INTO records VALUES (1, 2, 0, '', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', 'Gu7aFKO54pm AU', 20020827205407, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, 0, NULL, 'N', '', 50, 0, 0, '2002-08-27 20:54:07', 0, 0, 0, NULL, NULL, '', NULL); INSERT INTO records VALUES (2, 1, 0, 'iroke', 'Ian Roke', 'Mr', 'ad...@yo...', 'Ian', 'Thomas', 'Roke', '', '', '', '', '', 'Angola', 'Adminstrative User', '', 20030510040547, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '111', '', NULL, NULL, 0, '', 'Y', '', 50, 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '', '', '', NULL); INSERT INTO records VALUES (3, 7, 0, '', 'CBDAgency.com', '', '', '', '', '', '', '', 'Hull', '', '', 'United Kingdom', '', '', 20030510040440, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '666', '', 'http://www.cbdagency.com', NULL, 7, NULL, 'N', '', 50, 0, 0, '2003-05-10 04:04:40', 0, 0, 0, NULL, NULL, '', NULL); ---[paste]--- > The SQL to directly update a password for the admin user (substitute > 'admin' with any user ID for other users): > > UPDATE records SET password = ENCRYPT('newpass') WHERE idnum = 'admin' > AND datatype = 1; > > Also, your "organisationtypes" bug may come from the fact that the > "type" field gets automagically mapped to the {objectname}types table, > where {objectname} is the name of the currently-selected object. If you > still have "type" selected for your Organisation object, you will get > this error if you do not have an organisationtypes table. > > -- > Sandy Smith, Senior Programmer > Forum One Communications, Inc. >ss...@fo... > tel. 703-548-1855 x28 > http://www.forumone.com/ > > > > ------------------------------------------------------- > Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara > The only event dedicated to issues related to Linux enterprise > solutions www.enterpriselinuxforum.com > > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core Randum Ian ia...@ra... DancePortalGlobal Webmaster http://www.danceportalglobal.com |
From: Randum I. <ia...@ra...> - 2003-05-14 14:45:16
|
Hi Sandy, is there a way of getting notified of a new change to the CVS either by email or on a webpage somewhere? The Smarty and Php ones are on a sort of email list which is very useful. I will update our packages tonight and see how we do. One thing I did note was that even though Adrian has removed all traces of the offending table from Dbasis the table of the same name still occurs in the database. Is this normal? Regards, Ian. > Hi Adrian and Ian-- > > I would suggest re-updating from CVS all your packages and see if that > does not solve your problem. I have been bugfixing for the past week > and there may be incompatibilities in your packages as we ramp up to > the 0.0.5 release. > > If that doesn't work, let us know. It should NOT be necessary to delete > and reinstall everything. > > -- > Sandy Smith, Senior Programmer > Forum One Communications, Inc. >ss...@fo... > tel. 703-548-1855 x28 > http://www.forumone.com/ > > > > ------------------------------------------------------- > Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara > The only event dedicated to issues related to Linux enterprise > solutions www.enterpriselinuxforum.com > > _______________________________________________ > Websyntax-core mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/websyntax-core Randum Ian ia...@ra... DancePortalGlobal Webmaster http://www.danceportalglobal.com |