Menu
▾
▴
core-lan-org-devel — Developers and feature-requests overhere please
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(12) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(50) |
Aug
(15) |
Sep
(6) |
Oct
(16) |
Nov
(11) |
Dec
(7) |
| 2003 |
Jan
(10) |
Feb
(8) |
Mar
(11) |
Apr
(3) |
May
(1) |
Jun
|
Jul
(2) |
Aug
(3) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2004 |
Jan
(2) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
(2) |
| 2006 |
Jan
(1) |
Feb
|
Mar
(1) |
Apr
(1) |
May
(3) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(5) |
Nov
|
Dec
|
| 2008 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Marshall R. <mr...@db...> - 2002-12-27 21:56:47
|
> Hi Marshall, > > First of all to all readers: Happy xmas! > > Um well that would not be too hard. Core-lan-org 1 even had the feature > but I threw it away for some reason :-/. > > I'll take a peek into it somewhere next week. > > Also now that Andrew's functions seem to be maturing I'm going to > release the new version along with that feature. So please do _TEST_ the > new code that Andrew released and try to break it :-) groovy! /mtr |
|
From: Dennis F. <de...@co...> - 2002-12-27 19:54:13
|
Hi Marshall, First of all to all readers: Happy xmas! Um well that would not be too hard. Core-lan-org 1 even had the feature but I threw it away for some reason :-/. I'll take a peek into it somewhere next week. Also now that Andrew's functions seem to be maturing I'm going to release the new version along with that feature. So please do _TEST_ the new code that Andrew released and try to break it :-) Cheers, Dennis -----Original Message----- From: cor...@li... [mailto:cor...@li...] On Behalf Of Marshall Rose Sent: vrijdag 27 december 2002 19:44 To: cor...@li... Subject: [Core-lan-org-devel] a useful feature? hi. one thing that some of my users are asking for is a link they can click on to bring them "up to date" with respect to all the projects in the system. right now core/org does a real nice job of telling folks that a task is new or has a new posting or file upload, etc. what folks would like is a link they could click on that would basically update whatever needs to be updated so they get a clean slate, i.e., someone returns from a two week vacation would prefer to not see half the tasks are new. comments? /mtr ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Core-lan-org-devel mailing list Cor...@li... https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel |
|
From: Marshall R. <mr...@db...> - 2002-12-27 18:43:45
|
hi. one thing that some of my users are asking for is a link they can click on to bring them "up to date" with respect to all the projects in the system. right now core/org does a real nice job of telling folks that a task is new or has a new posting or file upload, etc. what folks would like is a link they could click on that would basically update whatever needs to be updated so they get a clean slate, i.e., someone returns from a two week vacation would prefer to not see half the tasks are new. comments? /mtr |
|
From: Andrew S. <and...@pa...> - 2002-12-24 07:33:09
|
Actually, having had a bit more time to think about it... It could well be that your PHP doesn't have PostgreSQL support compiled in. This would also give a blank screen. To check, create a website file with this in it: <?php phpinfo; ?> Save it into your webserver root directory as, say, phpinfo.php. Then look it up with your web browser. PHP will spew out pages and pages of configured status data onto your web browser. Look for a subsection on 'pgsql' or 'PostgreSQL'. If it's not present, then your PHP won't/can't make pgsql database calls. You need then either to find a binary copy of PHP with pgsql compiled in, or re-compile from source with the pgsql option. Alternately, the CVS, is reasonably stable, and now has support for both MySQL & PostgreSQL databases. You are more likely to have MySQL support already compiled into your PHP. Andrew Simpson On Mon, 23 Dec 2002 14:41:11 -0500 Kevin Murphy <mu...@ge...> wrote: > Hi, > > I just downloaded 2.0.2 and installed it on my OS X 10.1.5 system > running Apache 1.3.26 with PHP 4 and PostgreSQL 7.2. > > After typing admin/admin123 on the entry screen, I get a blank page in > response after a long timeout. > > What am I doing wrong? > > I can use "psql org postgresql" and see the core-lan-org tables. > |
|
From: Andrew S. <and...@pa...> - 2002-12-24 02:08:58
|
On Mon, 23 Dec 2002 14:41:11 -0500 Kevin Murphy <mu...@ge...> wrote: > Hi, > > I just downloaded 2.0.2 and installed it on my OS X 10.1.5 system > running Apache 1.3.26 with PHP 4 and PostgreSQL 7.2. > > After typing admin/admin123 on the entry screen, I get a blank page in > response after a long timeout. > > What am I doing wrong? > > I can use "psql org postgresql" and see the core-lan-org tables. > > I don't see any postgres or apache errors in the logs. > I've seen a blank screen on login a few times. Usually because it's a version of PHP before 4.1.0, and can't handle the form POST with the (new) superglobals ($_POST, $_GET etc.). Though this usually occurs immediately - no long timeout. Apache 1.3.26 and PostgreSQL 7.2 are compatible with Core 2.02. Database errors (including no connection) will give detailed error messages. A quick Google around the OS X Knowledgebase (looking for PHP version) revealed that OS X 10.0 had problems with form POST not working!! It was apparently fixed in OS X 10.1. It's article ID 106400. Andrew Simpson |
|
From: Kevin M. <mu...@ge...> - 2002-12-23 19:41:19
|
Hi, I just downloaded 2.0.2 and installed it on my OS X 10.1.5 system running Apache 1.3.26 with PHP 4 and PostgreSQL 7.2. After typing admin/admin123 on the entry screen, I get a blank page in response after a long timeout. What am I doing wrong? I can use "psql org postgresql" and see the core-lan-org tables. I don't see any postgres or apache errors in the logs. The config.php looks like this: $BASE_URL="http://159.141.123.23/org/"; $MANAGER_NAME="CORE Advanced Project Management"; $DATABASE_NAME="org"; $DATABASE_USER="postgresql"; $DATABASE_PASSWORD="sometin"; $EMAIL_MAILINGLIST=""; $EMAIL_ERROR=""; $EMAIL_FROM=""; $EMAIL_REPLY_TO=""; $FILE_BASE = "files/filebase"; $FILE_MAXSIZE = 2000000; $TIMEOUT_SECS = 3600; $TIMEOUT_TEXT = "60 minutes"; $SITE_IMGSRC = ""; $PROJECT_ORDERED_BY = "name"; $CHECKED_DEFAULT = ""; Thanks, Kevin Murphy |
|
From: Dennis F. <de...@co...> - 2002-11-26 08:49:03
|
Hi Ricardo,
Thank you for the good work you're doing !
About the translation you're doing: I think it might be a good idea
(coding-wise) to do it as follows:
1) Create a function that translates like
text( $string );
2) Create an array filled with words to translate per language:
$_LANGUAGE['ok_button'] = 'Ok';
3) put it in the code:
echo '<INPUT type="button" value="'.text( 'ok_button' ).'">';
That way we're much more compatible if we're going to translate to later
words.
Greetings,
Dennis Fleurbaaij
de...@co...
----- Original Message -----
From: "R. Strusberg" <str...@ve...>
To: <cor...@li...>
Sent: Tuesday, November 26, 2002 5:27 AM
Subject: [Core-lan-org-devel] CoreAPM others languages localization
> Hi,
>
> I am begining the Spanish localization for CoreAPM. For this I am
> replacing any output text string to var string (same name in English) in
> any PHP file. The variables will be assigned using another
> include/<language>.php. For example:
>
> // Spanish strings begin
>
> $priority = "prioridad";
> $project = "proyecto"
>
> // End Spanish strings
>
> In this way, it is possible to include anothers languages.
>
> Also, I have ready the docs translation to Spanish. I did use Lyx for
> write the Spanish docs.
>
> Sincerely,
>
> Ricardo Strusberg
> UNDP/MPD Modernization support program coordinator
> Caracas, Venezuela
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Get the new Palm Tungsten T
> handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
> _______________________________________________
> Core-lan-org-devel mailing list
> Cor...@li...
> https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel
>
|
|
From: R. S. <str...@ve...> - 2002-11-26 03:11:59
|
Hi, I am begining the Spanish localization for CoreAPM. For this I am replacing any output text string to var string (same name in English) in any PHP file. The variables will be assigned using another include/<language>.php. For example: // Spanish strings begin $priority = "prioridad"; $project = "proyecto" // End Spanish strings In this way, it is possible to include anothers languages. Also, I have ready the docs translation to Spanish. I did use Lyx for write the Spanish docs. Sincerely, Ricardo Strusberg UNDP/MPD Modernization support program coordinator Caracas, Venezuela |
|
From: Dennis F. <de...@co...> - 2002-11-20 11:06:19
|
Hi bobby, Well to be honest we don't give out anything else then sourcecode :) Just download the tarball and that contrains the code. It is a scripting language you know... Better download first and ask questions later ;-) Greetings, Dennis ----- Original Message ----- From: "bobby" <bo...@so...> To: <de...@co...> Sent: Wednesday, November 20, 2002 9:46 AM Subject: can you mail to me the source code of CORE project management > dear sir: > i am interesting in your CORE project management, can you mail to me the > source code of CORE project management? > > thanks > > hava a good day! > > bobby > > |
|
From: Andrew S. <and...@pa...> - 2002-11-15 22:58:33
|
On Fri, 15 Nov 2002 20:18:27 +0100 "Dennis Fleurbaaij" wrote: > Hi guys, > > Andrew, I've fixed the database creation-script to use your > mysql-database. > Thanks! > Keep up the good work but do remember to set php's debugging level to > E_ALL. I'm getting all kinds of variable-not-set errors. I'll try to > look into them tomorrow. > Hmmm... there are some new variables in config.php (and one more going in with a CVS commit today). After that I _think_ all the variables are set. I'm running with E_ALL (just double checked) and global register variable turned off; interesting if you're getting some errors that I'm not. I've had 'hard-to-track-down' database warnings with task_summary_list, but I think I've fixed those in a CVS commit a couple of days ago. Andrew |
|
From: Dennis F. <de...@co...> - 2002-11-15 19:21:04
|
Hi guys, Andrew, I've fixed the database creation-script to use your = mysql-database. Keep up the good work but do remember to set php's debugging level to = E_ALL. I'm getting all kinds of variable-not-set errors. I'll try to = look into them tomorrow. Greets, Dennis |
|
From: Joe S. <jst...@cf...> - 2002-11-11 18:39:05
|
Join Thanks Joe Stephenson 386-235-5608 cell 386-441-2301 ofc 253-399-9764 fax |
|
From: Andrew S. <and...@pa...> - 2002-11-10 08:09:34
|
Hi all, I've ported across the org-mysql files into the main CVS. For most of the code this was done by merging the two code bases. I'm confident this will be reasonably bug free, because I've been stress testing org-mysql for a few weeks now. The /tasks directory was a bit harder. I've done a rough merge, then lots and lots of patching up, because the two code bases are a long way apart. There will be some bugs here! However, I've done some limited testing of both MySQL and PostgreSQL, and all seems to be working flawlessly. I'll start thoroughly testing, debugging and cleaning up now. Practically every file has been altered... Also, I've added an extra column to the tasks table as per org-mysql. The extra column is projectid, and contains the taskid of the mother project. This starts to work well when the tasks are nested more than one layer deep. No longer does project_list have to recursively search every task for children - on a slow machine the time savings are very noticeable. In task_edit, task_add and emails, we also now show the project and parent of a task (without recursively searching). There is a file /includes/update.php to populate the projectid column for existing pgsql data. A few more things are in the Changelog. Andrew |
|
From: Andrew S. <and...@pa...> - 2002-11-06 04:38:00
|
On Wed, 6 Nov 2002 00:19:47 +0100 > > Dennis, > > > > I picked up your tool today and have a few ideas you might consider > adding. > > In no particular order: > > > > 1. Convert between deadline and estimated project timelines. > > 2. The total time report for each task/project should also report > > time usage for each subtask recursively. This could also be broken > > down per person per task/project. The estimate stuff lacks a lot of functionality. It's not an area that anyone seems to be working on, and it really needs someone to work on it. > > 3. Even estimated tasks need a "I finished it!" button. :) After a bit of discussion on this list, I coded that one out for version 2. It's easy to reverse in the code. > > 4. Deleting a task fails, telling me there was nothing to do. I'm > running > > PHP 4.12 and PGSQL 7.2.1. Haven't looked into this too much... Umm yeah... Pushing the 'button' gives this - it's a bug. Choosing 'delete' from the menu on the left works O.K. I fixed the problem in CVS a few weeks back. The affected files are /tasks.php and /tasks/task_delete.php. The changes are just a couple of lines. > > 5. Task dependencies and being able to sort tasks based on > > dependency-driven work order would be cool! > > Hmmm... interesting idea. > > My team at work has recently grown to the point that we need a tool > > to > track > > our project development. I think what you've built so far will aid > > us a lot. Thanks for all your time and effort! > > > > Andrew |
|
From: Dennis F. <de...@co...> - 2002-11-05 23:19:57
|
Hi Aaron, This mail is now cc'ed to the devel mailing list. I'll see if I can find some time to do it. Greetings, Dennis Fleurbaaij de...@co... ----- Original Message ----- From: "LAMBERS,AARON (HP-Boise,ex1)" <aar...@hp...> To: <de...@co...> Sent: Tuesday, November 05, 2002 11:51 PM Subject: core-lan project manager > Dennis, > > I picked up your tool today and have a few ideas you might consider adding. > In no particular order: > > 1. Convert between deadline and estimated project timelines. > 2. The total time report for each task/project should also report time > usage for each subtask recursively. This could also be broken down per > person per task/project. > 3. Even estimated tasks need a "I finished it!" button. :) > 4. Deleting a task fails, telling me there was nothing to do. I'm running > PHP 4.12 and PGSQL 7.2.1. Haven't looked into this too much... > 5. Task dependencies and being able to sort tasks based on > dependency-driven work order would be cool! > > My team at work has recently grown to the point that we need a tool to track > our project development. I think what you've built so far will aid us a > lot. Thanks for all your time and effort! > > > Aaron Lambers (Non-HP) > NAOD HPA Tier 2 UX Server Support > Technical Lead > 1.208.396.2727 > US/MDT > > *****Internet Email Confidentiality********* > > This communication may contain privileged or other confidential information. > If you are not the intended recipient, or believe that you may have received > this communication in error, please reply to the sender indicating that fact > and delete the copy you received. In addition, you should not print, copy, > retransmit, disseminate, or otherwise use the information contained in this > communication. Thank you. > |
|
From: Dennis F. <de...@co...> - 2002-11-05 23:18:03
|
Hi Salavdor, That would be appricited ! You'd have to create a language file and a function to replace texts though. That way we can switch between languages. Please let me know on how you're going to implement it. Greetings, Dennis ----- Original Message ----- From: "Salvador Maravilla Gil/Contraloria/Jalisco" <sma...@ja...> To: <de...@co...> Sent: Tuesday, November 05, 2002 9:08 PM Subject: Core Translation > Hi Dennis. > > I did download your PHP application and I've been using it around two > weeks, I like it, and I would like translate it to spanish, my natal lang. > > Are you interesting in do this ? > > I would like translate the application to spanish, ( and maybe the home > site ). > > > PD. Soory, my english isn't good. > > > Ing. Salvador Maravilla Gil > Network Administrator > Contraloria del Estado de Jalisco > sma...@ja... > > |
|
From: Andrew S. <and...@pa...> - 2002-11-01 23:16:44
|
Hi all, I believe the MySQL port in CVS is looking stable. That is, I can't find any more bugs :-) I've set up installation scripts, added indexes to MySQL and generally tidied up. What it needs now is some testing by others. The PostgreSQL option (in this port) is working fine too. The database schema is based on ver 1.11, but with an extra column added to the 'tasks' table. Extra column is 'projectid' - it's in the database create script. (The file in /includes/update.php will populate the column for existing data. There is also a commented out reference in /includes/mainmenu.php). Andrew |
|
From: Dennis F. <de...@co...> - 2002-10-29 08:24:56
|
Hi Andrew, Err that wasn't exactly what I meant I suppose :-) A branch is uploaded to the org release. I'll see if I can fix it but it might be a good idea to read the CVS braching notes ;-) Great stuff btw :) Cheers, Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: "Dennis Fleurbaaij" <de...@co...>; <cor...@li...> Sent: Tuesday, October 29, 2002 5:48 AM Subject: Re: [Core-lan-org-devel] MySQL on Core-Lan-Org > Hi all, > > Yes, sounds like a good plan. > > Just loaded the files into CVS (directory is org-mysql). There is a > README file that gives some info on various things - and a bug list of > bugs that I know of. None of them are too serious :-) > > Andrew > > > On Mon, 28 Oct 2002 20:48:51 +0100 > "Dennis Fleurbaaij" <de...@co...> wrote: > > > Hi Andrew, > > > > Whoa great work! > > > > Um, why not create a CVS branch, stabilize it and then we'll merge the > > 2. > > > > Do you agree ? > > > > Thanks for the work!, > > Dennis > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Core-lan-org-devel mailing list > Cor...@li... > https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel > |
|
From: Andrew S. <and...@pa...> - 2002-10-29 04:48:58
|
Hi all, Yes, sounds like a good plan. Just loaded the files into CVS (directory is org-mysql). There is a README file that gives some info on various things - and a bug list of bugs that I know of. None of them are too serious :-) Andrew On Mon, 28 Oct 2002 20:48:51 +0100 "Dennis Fleurbaaij" <de...@co...> wrote: > Hi Andrew, > > Whoa great work! > > Um, why not create a CVS branch, stabilize it and then we'll merge the > 2. > > Do you agree ? > > Thanks for the work!, > Dennis > > |
|
From: Dennis F. <de...@co...> - 2002-10-28 20:10:55
|
Hi Andrew, Whoa great work! Um, why not create a CVS branch, stabilize it and then we'll merge the 2. Do you agree ? Thanks for the work!, Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: <cor...@li...> Sent: Monday, October 28, 2002 2:20 AM Subject: [Core-lan-org-devel] MySQL on Core-Lan-Org > Hi all, > > I've been having a go at getting Core to run on MySQL, and I think I'm > mostly there. > > Firstly, I made database abstraction layers for pgsql and mysql, and > converted the main code to suit (Sorry Dennis, I didn't use your > excellent work in the end). Then I had to change some of the SQL > queries to suit both MySQL and PostgreSQL - that bit hasn't been > straightforward. Big problems were subqueries and date manipulation in > SQL. Also the lack of OID in MySQL. Used some SQL simplification and > additional PHP code as workarounds. > > I have converted the Core version that I use at work. This is a mixture > of released versions 1.11 and 2.02. Notable differences to version 2.02 > are time estimation removed, and the database uses zero's instead of > 'null'. > > Both database types are up and running, and I estimate that I've fixed > 95 % of the bugs (I hope). > > If Dennis is agreeable I'll port my coding across to ver 2.02 in the CVS > (I'm a bit suspicious on how MySQL is handling 'null' values though). > Alternately, I can dump my present version (1.11/2.02 hybrid) as a > separate directory in CVS, for others to have a look at. > > If anyone wants a copy in the interim, I can email the code to them. > > Andrew > > > ------------------------------------------------------- > This SF.net email is sponsored by: ApacheCon, November 18-21 in > Las Vegas (supported by COMDEX), the only Apache event to be > fully supported by the ASF. http://www.apachecon.com > _______________________________________________ > Core-lan-org-devel mailing list > Cor...@li... > https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel > |
|
From: Andrew S. <and...@pa...> - 2002-10-28 01:20:30
|
Hi all, I've been having a go at getting Core to run on MySQL, and I think I'm mostly there. Firstly, I made database abstraction layers for pgsql and mysql, and converted the main code to suit (Sorry Dennis, I didn't use your excellent work in the end). Then I had to change some of the SQL queries to suit both MySQL and PostgreSQL - that bit hasn't been straightforward. Big problems were subqueries and date manipulation in SQL. Also the lack of OID in MySQL. Used some SQL simplification and additional PHP code as workarounds. I have converted the Core version that I use at work. This is a mixture of released versions 1.11 and 2.02. Notable differences to version 2.02 are time estimation removed, and the database uses zero's instead of 'null'. Both database types are up and running, and I estimate that I've fixed 95 % of the bugs (I hope). If Dennis is agreeable I'll port my coding across to ver 2.02 in the CVS (I'm a bit suspicious on how MySQL is handling 'null' values though). Alternately, I can dump my present version (1.11/2.02 hybrid) as a separate directory in CVS, for others to have a look at. If anyone wants a copy in the interim, I can email the code to them. Andrew |
|
From: Dennis F. <de...@co...> - 2002-10-23 07:12:48
|
Hey guys, Well just take the CoreAPM abstration layer. I'm using it now for the last 5-10 months and it's stable. It supports MySQL and Postgresql in a totally compatible way. It also has support for all those cool things like booleans (beleave it or not but mysql can handle the true(th) ;) ) I'll up the new version to coreapm cvs and then I'll copy it to the core-lan-org cvs. Implementation should be trivial then. Greetins, Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: "Dennis Fleurbaaij" <de...@co...> Cc: <fra...@so...>; <cor...@li...> Sent: Wednesday, October 23, 2002 8:10 AM Subject: Re: [Core-lan-org-devel] Re: Core/Org -> mySql ... Help > On Tue, 22 Oct 2002 11:03:34 +0200 > "Dennis Fleurbaaij" <de...@co...> wrote: > > > Hi François, > > > > Well I would suggest you do it another way :/ > > Agreed. (I've been thinking the about the steps toward converting to > MySQL for a while too). > > > > > First of all call the query-function db_query(); that way you can > > include different files for different database types and still have > > all you calls the same. (eg. i can now also create an oracle include > > file that has the db_query(); ) > > > > I'd planned to go a bit further. Make a database abstraction layer for > ALL the different database functions. This would also make it easier to > change to other databases (like Oracle) later. I made a list of the > functions required in PostgreSQL, and their equivalents in MySQL: > > pg_exec mysql_query (this is already function db_query) > pg_fetch_array mysql_fetch_array > pg_result mysql_result > pg_numrows mysql_numrows > > These are all easy to implement, because they are 'more or less' > functionally equivalent. > > The last one: > > pg_getlastoid mysql_insert_id > > - needs a bit of re-coding to get it to work. > > > > And second the database is selected at connection time. most likely > > you meant to use the defined variable DATABASE_NAME and not it's > > variable variant $DATABASE_NAME. (so use the one without the $). But > > as said before I would not advise to include it in every function all. > > > > Agreed. > > > As you can see in the query there are a LOT of non SQL'92 comaptible > > functions like: > > current_timestamp() > > extract() > > > > Umm... I think I looked at these. Current_timestamp is O.K. Extract is > in MySQL but different. Null is O.K too. > > > You will need to work around them in code. > > > > In anycase it'll be probably be more difficult then just replacing the > > function calls. > > > > Yes, problems! > > - 'Extract' is similar but different syntax in places - I think > > - Date and time handling is different - particularly with extract. Most > of the date functions in /includes/common.php should still be workable > with care. This is where I gave up previously - I think it could be > solved though... > > - 'Epoch' is not in MySQL - the equivalent is Unix_timestamp. Some > workarounds are required. Only affects /includes/security.php and some > in /tasks/* . > > Small problems: > > There is also a lone pg_exec in index.php that should be converted to > db_query. And tasks/task_project_list and tasks/task_summary_list have > subqueries that won't (?) work in MySQL. > > Andrew Simpson > > > Thanks, good luck and don't give up, > > Dennis Fleurbaaij > > de...@co... > > > > > > ----- Original Message ----- > > From: "François TRICARD" <fra...@so...> > > To: "Dennis Fleurbaaij" <de...@co...> > > Sent: Tuesday, October 22, 2002 9:20 AM > > Subject: RE: Core/Org -> mySql ... Help > > > > > > Hello Dennis ! > > > > My first big problem is the following request, do you know how to port > > it in mysql ? > > > > q = mysql_db_query( $DATABASE_NAME, "SELECT user_id, ip, email, admin, > > fullname, current_timestamp(0) AS now, lastaccess, extract( epoch FROM > > (current_timestamp(0) - lastaccess) ) AS sec_lastaccess FROM users > > LEFT JOIN logins ON (logins.user_id=users.id) WHERE > > session_key='".$x."'",$database_connection ) ) ) > > > > (From security.php) > > > > Thanks > > > > François > > > > -----Message d'origine----- > > De : Dennis Fleurbaaij [mailto:de...@co...] > > Envoyé : lundi 21 octobre 2002 11:16 > > À : François TRICARD > > Objet : Re: Core/Org > > > > > > Hello François, > > > > There is _NO_ mysql port. Mysql lacks features that Core/Org depends > > on. > > > > - Subqueries ( could be fixed by rewriting all subqueries to joins or > > wait > > for a mysql that supports it. ) > > - References ( not a neccesity but you do want security on the > > database layer ) > > > > So unfortunately there is no support yet. If you are interested in > > building > > that I would help as I've allready did > > it once but lost the code. The developement path would be: > > > > - get rid of all the pg_calls and replace them by calls to our own > > database > > object. > > - build a postgresql and a mysql database object > > - config it in > > > > in al 4 hours work or less. > > > > Greetings, > > Dennis Fleurbaaij > > de...@co... > > > > > > ----- Original Message ----- > > From: "François TRICARD" <fra...@so...> > > To: <de...@co...> > > Sent: Monday, October 21, 2002 10:38 AM > > Subject: Core/Org > > > > > > Hello, > > > > Your web's soft is very good for groupware, but I'm just a php/mysql > > user... Do you know is someone is working on Core for Mysql ? > > > > Thanks, > > > > François TRICARD > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > This sf.net emial is sponsored by: Influence the future of > > Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) > > program now. http://ad.doubleclick.net/clk;4699841;7576301;v? > > http://www.sun.com/javavote > > _______________________________________________ > > Core-lan-org-devel mailing list > > Cor...@li... > > https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel > > > |
|
From: Andrew S. <and...@pa...> - 2002-10-23 06:11:11
|
On Tue, 22 Oct 2002 11:03:34 +0200
"Dennis Fleurbaaij" <de...@co...> wrote:
> Hi François,
>
> Well I would suggest you do it another way :/
Agreed. (I've been thinking the about the steps toward converting to
MySQL for a while too).
>
> First of all call the query-function db_query(); that way you can
> include different files for different database types and still have
> all you calls the same. (eg. i can now also create an oracle include
> file that has the db_query(); )
>
I'd planned to go a bit further. Make a database abstraction layer for
ALL the different database functions. This would also make it easier to
change to other databases (like Oracle) later. I made a list of the
functions required in PostgreSQL, and their equivalents in MySQL:
pg_exec mysql_query (this is already function db_query)
pg_fetch_array mysql_fetch_array
pg_result mysql_result
pg_numrows mysql_numrows
These are all easy to implement, because they are 'more or less'
functionally equivalent.
The last one:
pg_getlastoid mysql_insert_id
- needs a bit of re-coding to get it to work.
> And second the database is selected at connection time. most likely
> you meant to use the defined variable DATABASE_NAME and not it's
> variable variant $DATABASE_NAME. (so use the one without the $). But
> as said before I would not advise to include it in every function all.
>
Agreed.
> As you can see in the query there are a LOT of non SQL'92 comaptible
> functions like:
> current_timestamp()
> extract()
>
Umm... I think I looked at these. Current_timestamp is O.K. Extract is
in MySQL but different. Null is O.K too.
> You will need to work around them in code.
>
> In anycase it'll be probably be more difficult then just replacing the
> function calls.
>
Yes, problems!
- 'Extract' is similar but different syntax in places - I think
- Date and time handling is different - particularly with extract. Most
of the date functions in /includes/common.php should still be workable
with care. This is where I gave up previously - I think it could be
solved though...
- 'Epoch' is not in MySQL - the equivalent is Unix_timestamp. Some
workarounds are required. Only affects /includes/security.php and some
in /tasks/* .
Small problems:
There is also a lone pg_exec in index.php that should be converted to
db_query. And tasks/task_project_list and tasks/task_summary_list have
subqueries that won't (?) work in MySQL.
Andrew Simpson
> Thanks, good luck and don't give up,
> Dennis Fleurbaaij
> de...@co...
>
>
> ----- Original Message -----
> From: "François TRICARD" <fra...@so...>
> To: "Dennis Fleurbaaij" <de...@co...>
> Sent: Tuesday, October 22, 2002 9:20 AM
> Subject: RE: Core/Org -> mySql ... Help
>
>
> Hello Dennis !
>
> My first big problem is the following request, do you know how to port
> it in mysql ?
>
> q = mysql_db_query( $DATABASE_NAME, "SELECT user_id, ip, email, admin,
> fullname, current_timestamp(0) AS now, lastaccess, extract( epoch FROM
> (current_timestamp(0) - lastaccess) ) AS sec_lastaccess FROM users
> LEFT JOIN logins ON (logins.user_id=users.id) WHERE
> session_key='".$x."'",$database_connection ) ) )
>
> (From security.php)
>
> Thanks
>
> François
>
> -----Message d'origine-----
> De : Dennis Fleurbaaij [mailto:de...@co...]
> Envoyé : lundi 21 octobre 2002 11:16
> À : François TRICARD
> Objet : Re: Core/Org
>
>
> Hello François,
>
> There is _NO_ mysql port. Mysql lacks features that Core/Org depends
> on.
>
> - Subqueries ( could be fixed by rewriting all subqueries to joins or
> wait
> for a mysql that supports it. )
> - References ( not a neccesity but you do want security on the
> database layer )
>
> So unfortunately there is no support yet. If you are interested in
> building
> that I would help as I've allready did
> it once but lost the code. The developement path would be:
>
> - get rid of all the pg_calls and replace them by calls to our own
> database
> object.
> - build a postgresql and a mysql database object
> - config it in
>
> in al 4 hours work or less.
>
> Greetings,
> Dennis Fleurbaaij
> de...@co...
>
>
> ----- Original Message -----
> From: "François TRICARD" <fra...@so...>
> To: <de...@co...>
> Sent: Monday, October 21, 2002 10:38 AM
> Subject: Core/Org
>
>
> Hello,
>
> Your web's soft is very good for groupware, but I'm just a php/mysql
> user... Do you know is someone is working on Core for Mysql ?
>
> Thanks,
>
> François TRICARD
>
>
>
>
>
>
>
>
>
> -------------------------------------------------------
> This sf.net emial is sponsored by: Influence the future of
> Java(TM) technology. Join the Java Community Process(SM) (JCP(SM))
> program now. http://ad.doubleclick.net/clk;4699841;7576301;v?
> http://www.sun.com/javavote
> _______________________________________________
> Core-lan-org-devel mailing list
> Cor...@li...
> https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel
>
|
|
From: Dennis F. <de...@co...> - 2002-10-22 09:03:46
|
Hi François, Well I would suggest you do it another way :/ First of all call the query-function db_query(); that way you can include different files for different database types and still have all you calls the same. (eg. i can now also create an oracle include file that has the db_query(); ) And second the database is selected at connection time. most likely you meant to use the defined variable DATABASE_NAME and not it's variable variant $DATABASE_NAME. (so use the one without the $). But as said before I would not advise to include it in every function all. As you can see in the query there are a LOT of non SQL'92 comaptible functions like: current_timestamp() extract() You will need to work around them in code. In anycase it'll be probably be more difficult then just replacing the function calls. Thanks, good luck and don't give up, Dennis Fleurbaaij de...@co... ----- Original Message ----- From: "François TRICARD" <fra...@so...> To: "Dennis Fleurbaaij" <de...@co...> Sent: Tuesday, October 22, 2002 9:20 AM Subject: RE: Core/Org -> mySql ... Help Hello Dennis ! My first big problem is the following request, do you know how to port it in mysql ? q = mysql_db_query( $DATABASE_NAME, "SELECT user_id, ip, email, admin, fullname, current_timestamp(0) AS now, lastaccess, extract( epoch FROM (current_timestamp(0) - lastaccess) ) AS sec_lastaccess FROM users LEFT JOIN logins ON (logins.user_id=users.id) WHERE session_key='".$x."'", $database_connection ) ) ) (From security.php) Thanks François -----Message d'origine----- De : Dennis Fleurbaaij [mailto:de...@co...] Envoyé : lundi 21 octobre 2002 11:16 À : François TRICARD Objet : Re: Core/Org Hello François, There is _NO_ mysql port. Mysql lacks features that Core/Org depends on. - Subqueries ( could be fixed by rewriting all subqueries to joins or wait for a mysql that supports it. ) - References ( not a neccesity but you do want security on the database layer ) So unfortunately there is no support yet. If you are interested in building that I would help as I've allready did it once but lost the code. The developement path would be: - get rid of all the pg_calls and replace them by calls to our own database object. - build a postgresql and a mysql database object - config it in in al 4 hours work or less. Greetings, Dennis Fleurbaaij de...@co... ----- Original Message ----- From: "François TRICARD" <fra...@so...> To: <de...@co...> Sent: Monday, October 21, 2002 10:38 AM Subject: Core/Org Hello, Your web's soft is very good for groupware, but I'm just a php/mysql user... Do you know is someone is working on Core for Mysql ? Thanks, François TRICARD |
|
From: Dennis F. <de...@co...> - 2002-10-10 19:02:59
|
Hi Ari,
Well you have to create them first. Also clicking on the word can be a =
good idea as you get the help file:
Taskgroups:
When you get more and more tasks they probably need to be categorized in =
some way or another. Taskgroups are invented for this, you can easily =
add a taskgroup and then add the task to the taskgroup. If you leave =
this open all tasks will be sorted on alpabet. If you select a group =
then you will notice that the group has appeared in the =
project-task-list and that your task has been added to that group.
Good luck,
Dennis
----- Original Message -----=20
From: Ari Hahto=20
To: Dennis Fleurbaaij=20
Sent: Thursday, October 10, 2002 8:51 PM
Subject: Re: [Core-lan-org-devel] Cannot login
Hi
Thanks, now this working. I have question about taskgroups. How and =
where I can use these ? I don't find any place where I can select =
different taskgroups, and put projetcs to these goups. Could you explain =
?
-Ari-
----- Original Message -----=20
From: Dennis Fleurbaaij=20
To: Ari Hahto=20
Sent: Thursday, October 10, 2002 4:03 PM
Subject: Re: [Core-lan-org-devel] Cannot login
Hello Ari,
The problem is that php does not support postgreqsql. You need to =
either recomplile postgresql or download and install the correct =
rpm-modules so that php can communicate with postgresql.
Greetings and good luck,
Dennis
----- Original Message -----=20
From: Ari Hahto=20
To: cor...@li...=20
Sent: Thursday, October 10, 2002 2:57 PM
Subject: [Core-lan-org-devel] Cannot login
Hi
I have core-lan-org installed, but I can't login to it. I get only =
blank screen after login. What is right username and password, and what =
I should change in config.php ? Can anyone help me ?
-Ari-
|
11 messages has been excluded from this view by a project administrator.
