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: Ari H. <ah...@la...> - 2002-10-10 12:58:08
|
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- |
From: Dennis F. <de...@co...> - 2002-10-09 19:39:23
|
Hi Andrew, Well yeah, you can turn on error reporting on in the php.ini file (most likely in /etc )but if this is what I think it is this will NOT, repeat NOT show up. It will only return a blank screen. Good luck, Dennis ----- Original Message ----- From: "Andrew S. Hintz" <dr...@st...> To: "Dennis Fleurbaaij" <de...@co...> Sent: Wednesday, October 09, 2002 4:36 PM Subject: Re: [Core-lan-org-devel] Problem installing core lan > Ok, I've got the connection into postgres installed via the RPM, but > even with everything I can try, I can't seem to get PHP to connect into > the database. Is there some way I can turn on like verbose error > reporting so I can see exactly what the problem is? > > thanks in a advance. > Andrew Hintz > > On Wed, 2002-10-09 at 05:21, Dennis Fleurbaaij wrote: > > Well no, > > > > The problem is that the postgresql isn't correcty implemented in php ie. you > > have to > > - Recompile PHP with good postgresql support > > - Install the correct module/rpm file for this support. > > > > Greets, > > Dennis > > > > ----- Original Message ----- > > From: "Andrew Simpson" <and...@pa...> > > To: <cor...@li...> > > Cc: "Andrew S.Hintz" <dr...@st...> > > Sent: Wednesday, October 09, 2002 9:17 AM > > Subject: Re: [Core-lan-org-devel] Problem installing core lan > > > > > > > Hmmm... Very interesting. > > > > > > O.K., let's eliminate some likely culprits: > > > > > > - the login screen calls the database at least once. If the database > > > didn't work you would get an error message about no database. You > > > haven't - so I guess that PHP can connect to the database, and get > > > queries, etc. > > > > > > - the pretty screen is generated throughout the program by > > > /includes/screen.php. If it's working in the login screen it (should) > > > work elsewhere... > > > > > > Now working through the process: > > > > > > - you can login, so you're getting to main.php. > > > > > > - an error is occurring before /includes/screen.php is called in > > > main.php (otherwise you'd get more html). > > > > > > - looking at the code the error then has to be in /includes/database.php > > > or /includes/security.php > > > > > > I think you must have error reporting turned off in PHP, so the error is > > > not getting reported. I once had a bug in /includes/security.php that, > > > with error reporting turned off, gave a blank screen too. Had me totally > > > baffled for hours! > > > > > > Turn on error reporting, and let us know what PHP is reporting. > > > > > > Hope that's helping. > > > > > > Andrew > > > > > > > > > On 08 Oct 2002 08:37:30 -0500 > > > "Andrew S. Hintz" <dr...@st...> wrote: > > > > > > > > > > > I just downloaded the 2.0.2 release, unpacked, and I can't seem to get > > > > it to work. > > > > > > > > I've got PHP 4.2 > > > > Apache 2.0 > > > > Postgresql 7.2 > > > > > > > > Using psql, I can go in and see that data is in the database, so that > > > > worked ok. I can access the index.php page, and I get the pretty > > > > login page, so I would assume that apache and PHP is working fine. > > > > When I try to login, though, I get a blank page where the source of > > > > that page is: > > > > > > > > <html><body></body></html> > > > > > > > > Any ideas on what is causing this problem? > > > > > > > > thanks in adavance. > > > > Andrew Hintz > > > > Engineering Manager > > > > Stage Logic, LLC > > > > > > > > > > > > > ------------------------------------------------------- > > > 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: Dennis F. <de...@co...> - 2002-10-09 10:21:35
|
Well no, The problem is that the postgresql isn't correcty implemented in php ie. you have to - Recompile PHP with good postgresql support - Install the correct module/rpm file for this support. Greets, Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: <cor...@li...> Cc: "Andrew S.Hintz" <dr...@st...> Sent: Wednesday, October 09, 2002 9:17 AM Subject: Re: [Core-lan-org-devel] Problem installing core lan > Hmmm... Very interesting. > > O.K., let's eliminate some likely culprits: > > - the login screen calls the database at least once. If the database > didn't work you would get an error message about no database. You > haven't - so I guess that PHP can connect to the database, and get > queries, etc. > > - the pretty screen is generated throughout the program by > /includes/screen.php. If it's working in the login screen it (should) > work elsewhere... > > Now working through the process: > > - you can login, so you're getting to main.php. > > - an error is occurring before /includes/screen.php is called in > main.php (otherwise you'd get more html). > > - looking at the code the error then has to be in /includes/database.php > or /includes/security.php > > I think you must have error reporting turned off in PHP, so the error is > not getting reported. I once had a bug in /includes/security.php that, > with error reporting turned off, gave a blank screen too. Had me totally > baffled for hours! > > Turn on error reporting, and let us know what PHP is reporting. > > Hope that's helping. > > Andrew > > > On 08 Oct 2002 08:37:30 -0500 > "Andrew S. Hintz" <dr...@st...> wrote: > > > > > I just downloaded the 2.0.2 release, unpacked, and I can't seem to get > > it to work. > > > > I've got PHP 4.2 > > Apache 2.0 > > Postgresql 7.2 > > > > Using psql, I can go in and see that data is in the database, so that > > worked ok. I can access the index.php page, and I get the pretty > > login page, so I would assume that apache and PHP is working fine. > > When I try to login, though, I get a blank page where the source of > > that page is: > > > > <html><body></body></html> > > > > Any ideas on what is causing this problem? > > > > thanks in adavance. > > Andrew Hintz > > Engineering Manager > > Stage Logic, LLC > > > > > ------------------------------------------------------- > 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-09 06:17:26
|
Hmmm... Very interesting. O.K., let's eliminate some likely culprits: - the login screen calls the database at least once. If the database didn't work you would get an error message about no database. You haven't - so I guess that PHP can connect to the database, and get queries, etc. - the pretty screen is generated throughout the program by /includes/screen.php. If it's working in the login screen it (should) work elsewhere... Now working through the process: - you can login, so you're getting to main.php. - an error is occurring before /includes/screen.php is called in main.php (otherwise you'd get more html). - looking at the code the error then has to be in /includes/database.php or /includes/security.php I think you must have error reporting turned off in PHP, so the error is not getting reported. I once had a bug in /includes/security.php that, with error reporting turned off, gave a blank screen too. Had me totally baffled for hours! Turn on error reporting, and let us know what PHP is reporting. Hope that's helping. Andrew On 08 Oct 2002 08:37:30 -0500 "Andrew S. Hintz" <dr...@st...> wrote: > > I just downloaded the 2.0.2 release, unpacked, and I can't seem to get > it to work. > > I've got PHP 4.2 > Apache 2.0 > Postgresql 7.2 > > Using psql, I can go in and see that data is in the database, so that > worked ok. I can access the index.php page, and I get the pretty > login page, so I would assume that apache and PHP is working fine. > When I try to login, though, I get a blank page where the source of > that page is: > > <html><body></body></html> > > Any ideas on what is causing this problem? > > thanks in adavance. > Andrew Hintz > Engineering Manager > Stage Logic, LLC > |
From: Andrew S. H. <dr...@st...> - 2002-10-08 13:37:38
|
I just downloaded the 2.0.2 release, unpacked, and I can't seem to get it to work. I've got PHP 4.2 Apache 2.0 Postgresql 7.2 Using psql, I can go in and see that data is in the database, so that worked ok. I can access the index.php page, and I get the pretty login page, so I would assume that apache and PHP is working fine. When I try to login, though, I get a blank page where the source of that page is: <html><body></body></html> Any ideas on what is causing this problem? thanks in adavance. Andrew Hintz Engineering Manager Stage Logic, LLC |
From: Jeff J. <jj...@ki...> - 2002-10-05 01:41:16
|
I saw a post on freshmeat about your project and thought I would see what its all about. Unfortunatly your demo site wont let me in so I am somewhat flying blind as to what your project can do; for now. From your write up its appears to be very similar to some other tools I have been looking at the last few weeks( PWMS; http://freshmeat.net/projects/pwms/?topic_id=90 and PHP Business Project Management; http://www.phpbuilder.com/snippet/detail.php?type=snippet&id=377) If I missed any other tools please let me know:-) Assuming that this project is close enough to my goals, I can provide a large list of feature requests and hopefully a little help coding. I am new to the php and SQL world but feel I can catch on with a little effort. Jeff PS is the test page dead or am I having trouble spelling "testuser"? |
From: Dennis F. <de...@co...> - 2002-10-04 11:42:02
|
Hi, Another fatal error in the 2.0 release has been fixed. We're now at = 2.0.2 and it seems stable now. The real question is: what shell we do next ? There is just one feature = request and if I can get some spare time I'll implement it. But are there things we should have done/could have done better ? And do = some of you have any ideas left ? I'd be happy to hear from you.. Dennis F. |
From: Andrew S. <and...@pa...> - 2002-09-30 20:07:28
|
Hi all, Fixed in CVS. My last merge (which was a bit botched), removed the double quoting from $status. I've put it back and all is well. The affected file is /tasks/task_submit.php on line 249 Existing line: ".$status.")" ); Change to line: '".$status."')" ); I'm going to be away for a few days (no email). Hope all is O.K. Andrew On Mon, 30 Sep 2002 10:51:21 +0200 "Dennis Fleurbaaij" <de...@co...> wrote: > BUUUUUUUUUUG :-( > > > While trying to add a new project, I got this after clicking "Add > > Project": > > > > Database Query error > > The following query : > > > > INSERT INTO tasks( name, text, created, lastforumpost, edited, > > owner, creator, deadline, priority, parent, taskgroupid, > > usergroupid, globalaccess, status ) values( 'Eat', 'Zzzzz', > > current_timestamp(0), NULL, current_timestamp(0), 1, 1, '2002-10-1 > > 00:00:00+08', 2, NULL, NULL, NULL, true, created) > > > > Had the following error: > > ERROR: Attribute 'created' not found > > > ----- Original Message ----- > From: "Eric Boo" <er...@re...> > To: "Dennis Fleurbaaij" <de...@co...> > Sent: Monday, September 30, 2002 10:19 AM > Subject: Sorry, another thing > > > > Hi Dennis, > > > > While trying to add a new project, I got this after clicking "Add > > Project": > > > > Database Query error > > The following query : > > > > INSERT INTO tasks( name, text, created, lastforumpost, edited, > > owner, creator, deadline, priority, parent, taskgroupid, > > usergroupid, globalaccess, status ) values( 'Eat', 'Zzzzz', > > current_timestamp(0), NULL, current_timestamp(0), 1, 1, '2002-10-1 > > 00:00:00+08', 2, NULL, NULL, NULL, true, created) > > > > Had the following error: > > ERROR: Attribute 'created' not found > > > > > > I ran the script db_create.sh already. What did I miss? > > > > Sorry for the trouble. > > > > > > ------------------------------------------------------- > 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: Dennis F. <de...@co...> - 2002-09-30 08:51:31
|
BUUUUUUUUUUG :-( > While trying to add a new project, I got this after clicking "Add > Project": > > Database Query error > The following query : > > INSERT INTO tasks( name, text, created, lastforumpost, edited, owner, > creator, deadline, priority, parent, taskgroupid, usergroupid, > globalaccess, status ) values( 'Eat', 'Zzzzz', current_timestamp(0), > NULL, current_timestamp(0), 1, 1, '2002-10-1 00:00:00+08', 2, NULL, > NULL, NULL, true, created) > > Had the following error: > ERROR: Attribute 'created' not found ----- Original Message ----- From: "Eric Boo" <er...@re...> To: "Dennis Fleurbaaij" <de...@co...> Sent: Monday, September 30, 2002 10:19 AM Subject: Sorry, another thing > Hi Dennis, > > While trying to add a new project, I got this after clicking "Add > Project": > > Database Query error > The following query : > > INSERT INTO tasks( name, text, created, lastforumpost, edited, owner, > creator, deadline, priority, parent, taskgroupid, usergroupid, > globalaccess, status ) values( 'Eat', 'Zzzzz', current_timestamp(0), > NULL, current_timestamp(0), 1, 1, '2002-10-1 00:00:00+08', 2, NULL, > NULL, NULL, true, created) > > Had the following error: > ERROR: Attribute 'created' not found > > > I ran the script db_create.sh already. What did I miss? > > Sorry for the trouble. > |
From: Andrew S. <and...@pa...> - 2002-09-27 06:40:26
|
Hi all, No complaints. As you can see from the CVS over the last few weeks, I've been fairly busy re-working practically every file at least once. Glad you didn't find too much wrong :-) We still haven't got the rendering right with browsers other than IE and Konqueror. Please fix me! I'll have a go at the updating changelog tonight - it's so far out of date that it's an embarassment. I'll probably miss a few things when I update it, but it'll be better. Looking forward to Ver 2.0 - it's going to be a good 'un! Andrew On Thu, 26 Sep 2002 13:40:28 +0200 "Dennis Fleurbaaij" <de...@co...> wrote: > Hi guys, > > Well after a lot of work by you I think the CVS is now stable. > > I've just gone trough all of the code and found just a couple of minor > items. Check my last commit for comments. > > I hereby want to propose the release of the 2.0 version. Does anyone > still have items that must be done before release ? I've found a > couple of minor-items that can be fixed and they are listed below. > I'll include our todo list below in every email concidering the > release of 2.0. > > Todo: > > [ ] Explination of the single-letter abbrivations. > > > Greetings, > Dennis |
From: Dennis F. <de...@co...> - 2002-09-26 16:22:48
|
Hello Alex, Well if all goes well I expect to make a release on friday night or sat morning. When it's released there will also be a release doc and I'll cover all the things you want to see in it. Thanks for your interest and for putting it up on the PHP Foundry! Greetings, Dennis Fleurbaaij de...@co... ----- Original Message ----- From: "Alex Pagnoni" <al...@am...> To: <de...@co...> Sent: Thursday, September 26, 2002 3:51 PM Subject: CORE-Lan Hi Dennis, I'm a PHP Foundry guide at SourceForge. I've just seen your announce about CORE-Lan. I've given a look to your project site and it seems interesting to me, so when you release the final 2.0 version I'll post the announce in the PHP Foundry page. When you release it, you may also write a few more lines about it (what it does, which are the improvements, relevant links, etc) so that I can post a news about it in the PHP Foundry News section, that is more visible than the announces section. What do you think? Alex -- Alex Pagnoni Ampoliros Team - Project Leader - http://ampoliros.com/ SourceForge PHP Foundry guide - http://sourceforge.net/ |
From: Dennis F. <de...@co...> - 2002-09-26 11:40:40
|
Hi guys, Well after a lot of work by you I think the CVS is now stable. I've just gone trough all of the code and found just a couple of minor = items. Check my last commit for comments. I hereby want to propose the release of the 2.0 version. Does anyone = still have items that must be done before release ? I've found a couple = of minor-items that can be fixed and they are listed below. I'll include = our todo list below in every email concidering the release of 2.0. Todo: [ ] Explination of the single-letter abbrivations. Greetings, Dennis |
From: Andrew S. <and...@pa...> - 2002-09-15 07:12:18
|
Hi all, I've spent the last few weeks doing big updates to the CVS. I started by turning off global variables, and I found all kinds of horror stories within... No functionality changes, just some very serious bugfixing. I've lost track of what I've done :) The changes are all recorded in the CVS over several checkins, but some highlights that I remember are are: - changed to global variables turned off throughout the code - serious bugfixing to tasks, usergroups and users - project list now lets admin see all projects (!), and all users can see usergroups with global access on - users can't get file list for a usergroup they aren't entitled to - major bugfixing to forums (zero's and null mixed up) - when deleting a thread in a forum, all the children messages are now deleted too. Previously they became orphaned in the database until the associated task was deleted. Not good. - had another go at time registration What I haven't fixed is rendering in browsers other than IE. I've done the bugfixing is small steps, heavily testing between; there shouldn't be any lingering problems from the editing - I hope. I'll test again over the next few days, might be a few small typos that I've missed. I think the CVS is now stable; I don't see much need for me to do more work on it at present. Regards Andrew |
From: Dennis F. <de...@co...> - 2002-08-25 09:06:04
|
Hi Andrew, Great work! The getting started is just great, it provides users a step-by-step example and rundown of the technology, i've now included in the install file so that people are forced to read it. A few misalignment bugs that we need to squash before releasing: - All the [] - buttons need to be on the right in the same size. So I'll make a css tag for it ( squarebutton ) and I'll try to get them all, please also look for missed buttons or so. - Menu-structure; are the links in the menus sane ? Are they in the ideal sequence ? Re-align as you see fit. - Opera, CSS and HTML file structural integrity. http://www.htmlhelp.com/tools/validator/direct.html it is NOT html 4.01 compatible at the moment and I'd really love to see that status back ( saves on rendering-problems too ). - Code clean. Check for bugs, indent right and maybe, also and this is especially important, try to look for security-bugs. We need to fix them before releasing. This brengs me to another area. php 4+ has superglobals ( $_GET, $_POST ) that hold the arrays of the given values. If you install coreapm on a clean machine you need to alter the php-config to allow (register_globals=On ) using the direct name instead of the superglobal name (example http://www.site.com/page.php?hello=me ) that will result in $_GET["hello"]="me"; and if register_globals is on it will also lead to $hello = me; You can see the obvious mistakes you can make here and therefore I opt to use the $_GET and $_POST superglobals everywhere we can. What does this mean: - Check a lot of files. - Use a lot more isset()'s - if a variable checks out convert it to it's real variable: if( isset( $_GET["lala"] && is_numeric( $_GET["lala"]) ) { $lala = $_GET["lala"]; } The plus side is that we have a more bullitporrf version of core-lan-org AND that we re-audit out code ( can't this just be in OpenBSD default install ;) ). I'll start converting the code and the buttons, but can somebody else please check the accounting code as I agree with Andrew and do not yet fully trust it. That's my E0.02 (approx.) Dennis Fleurbaaij de...@co... ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: <cor...@li...> Sent: Sunday, August 25, 2002 8:12 AM Subject: [Core-lan-org-devel] CVS Update and bugfixing > Hi all, > > Just entered a large amount of bugfixes in the CVS. Please test and > check whether I've broken something. It all works for me (tm). > > Areas of concern: > > - found lots of NULL's, 0's and "" mixed up in tasks. Variables input > into database are NULL, and variables output are "". Many cases were > wrong. I've found it confusing to debug - please check. > > - fixed deleting usergroups. This appears to have been broken since > version 1.0 - unless I've missed something? > > After some more testing, I think we will be ready for Version 2.0. The > rendering on Opera is not fixed yet, otherwise I don't know of any major > bugs. > > IMHO the time estimate code is not very mature / fully functioned yet, > but it works. > > Andrew > > > ------------------------------------------------------- > This sf.net email is sponsored by: OSDN - Tired of that same old > cell phone? Get a new here for FREE! > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > _______________________________________________ > Core-lan-org-devel mailing list > Cor...@li... > https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel > |
From: Andrew S. <and...@pa...> - 2002-08-25 06:13:43
|
Hi all, Just entered a large amount of bugfixes in the CVS. Please test and check whether I've broken something. It all works for me (tm). Areas of concern: - found lots of NULL's, 0's and "" mixed up in tasks. Variables input into database are NULL, and variables output are "". Many cases were wrong. I've found it confusing to debug - please check. - fixed deleting usergroups. This appears to have been broken since version 1.0 - unless I've missed something? After some more testing, I think we will be ready for Version 2.0. The rendering on Opera is not fixed yet, otherwise I don't know of any major bugs. IMHO the time estimate code is not very mature / fully functioned yet, but it works. Andrew |
From: Marshall R. <mr...@db...> - 2002-08-11 01:44:46
|
hi. well, i created a converted database and re-sync'd my tree to cvs. basically, there are a large number of small cosmetic edits. most are for consistency. i'm running what's in cvs (on my test system, i still have the old schema running in production), and it looks good to me. good job on the recent work! /mtr |
From: Dennis F. <de...@co...> - 2002-08-10 10:15:39
|
Good point :) ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: "Dennis Fleurbaaij" <de...@co...> Sent: Friday, August 09, 2002 10:26 PM Subject: Re: [Core-lan-org-devel] Fw: ERROR on CORE Advanced Project Management DEMO SITE > On Fri, 9 Aug 2002 12:07:10 +0200 > "Dennis Fleurbaaij" <de...@co...> wrote: > > > Example: > > > > i finished it: we now also need to account the hours worked on it. > > That is not as simple as it looks :) > > > > Hi Dennis, > > No, it _is_ simple. The 'I finished it' button is really useful for > deadline projects, and really bad for estimate projects. So, make the > button only show if it's a deadline project/task. No complicated coding > required. > > Andrew > |
From: Dennis F. <de...@co...> - 2002-08-09 10:07:48
|
Well the bug was not too hard :) $taskid did not exist but $task_id does (look in the url) so adding the = underscore was enough. But now I've found a myrad of other small problems. Back to coding I = guess.. Met vriendelijke groet, =20 Dennis Fleurbaaij Voorzitter stichting CORE ---------------------------- Tel : +31 (0) 6 54 21 53 65 Mail: de...@co... www : http://www.core-lan.nl Adres: Marco-pololaan 22 4562 AC Hulst |
From: Dennis F. <de...@co...> - 2002-08-09 09:47:49
|
Hi, Okay I''ll try to fix the code now.. About the documentation: that is a VERY good idea. Can you try to implement it into the site itself ? Maybe we need another button but I've allready made a help page and there are a few links to it. But that really could use some more linking, text, images and cleaning up. Thank you. Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: <de...@co...> Sent: Friday, August 09, 2002 11:35 AM Subject: CoreAPM rendering with Opera > Hi Dennis, > > As I said before the the stylesheet doesn't work too well with Opera. > Here are some screenshots. > > Had another look at the time_reg error tonight and realised that I > hadn't fixed it :-( The error is in line 188. The variable $taskid > does not exist. Tried $task_row["id"], but that wouldn't work either. > I'll have another go tomorrow. Bo's code is not easy to follow! > > There is also an error when deleting usergroups, but otherwise it's > looking good. I'll keep testing the code. I think we are ready for 2.0 > soon. > > However, I'd like to write some more documentation before 2.0 goes out. > > Andrew |
From: Dennis F. <de...@co...> - 2002-08-08 10:35:52
|
Um Does any of you guys have this error too ? Dennis ----- Original Message ----- From: <cor...@co...> To: <de...@co...> Sent: Thursday, August 08, 2002 7:01 AM Subject: ERROR on CORE Advanced Project Management DEMO SITE > Hello, > This is the CORE Advanced Project Management DEMO SITE site and I have an error :/ Please take a look at this and decide wether or not to mail the coder ( de...@co... ). > > > User that created the error: Test user ( de...@co... ) > The erroneous component: Database Query error > The error message: The following query :<BR><BR><B>SELECT id FROM tasks WHERE id= AND owner=2</B><BR><BR>Had the following error:<BR><B>ERROR: parser: parse error at or near "AND" > </B> > Page that was called: /opt/php > Called URL: /apm-demo/users.php?x=7dc9e49aa716d34dabe25f6d94eb6494&action=timereg > Browser: Mozilla/4.0 (compatible; MSIE 6.0; MSN 2.5; Windows 98; Crazy Browser 1.0.5) > Time: August 8, 2002, 07:01 > IP: 207.166.194.115 > POST vars: > > P.S. Please email the user that the error will be worked on !!! > > |
From: Andrew S. <and...@pa...> - 2002-08-07 09:10:38
|
On Tue, 6 Aug 2002 16:48:17 -0700 "Marshall Rose" <mr...@db...> wrote: > hi. sorry to be dense, but is it our concensus that the database > conversion script that's checked into cvs is now good to go??? > > thanks, > > /mtr > Yes, it is. The script gave me a bunch of permission denied errors about pg_class, but it worked fine. I think this relates to temporarily disabling the primary keys on each table. The number of table rows is then counted, and the sequence counter reset at the correct value. However despite the error message the sequence counter is being correctly set. Would be nice to get rid of the errors, but I don't fully understand how/why they are occurring. Hopefully Dennis will be able to sort this one out. Andrew |
From: Marshall R. <mr...@db...> - 2002-08-06 23:47:25
|
hi. sorry to be dense, but is it our concensus that the database conversion script that's checked into cvs is now good to go??? thanks, /mtr |
From: Andrew S. <and...@pa...> - 2002-08-06 06:21:25
|
On Mon, 5 Aug 2002 12:40:19 +0200 "Dennis Fleurbaaij" <de...@co...> wrote: > Yeah I know, > > Allthough it doesn't seem to have any effect. It's a matter of the > contraints not being alterd but the shouldn't be alterd in the first > place. > > the question is: > > Does it work ? > > Dennis > Yes, it works! Indexing is O.K too. Regarding the error messages: The way you sort the data with grep "INSERT", and then grep -v badly screws up the order of the constraints loading and unloading in the SQL dump. In the dump the constaint is disabled, the table data inserted, and then the constraint is re-enabled. I realise that you're using grep to reduce the risk of altering the wrong data with sed, but if we get rid of grep, we might get rid of the error messages too? BTW - the new style sheet is bombing with Opera 5.0 for Linux. I'll send you some screenshots later - it's not good :-) Netscape and Mozilla a bit wonky, Konqueror is O.K. Andrew |
From: Dennis F. <de...@co...> - 2002-08-05 10:40:30
|
Yeah I know, Allthough it doesn't seem to have any effect. It's a matter of the contraints not being alterd but the shouldn't be alterd in the first place. the question is: Does it work ? Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: <de...@co...> Sent: Monday, August 05, 2002 10:10 AM Subject: Core-lan-org database script > Hi Dennis, > > Conversion script worked a treat. Some small errors though: > > - (4/6) Inserting new data > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > ERROR: pg_class: Permission denied. > - (5/6) Inserting contraints > |
From: Andrew S. <and...@pa...> - 2002-08-04 19:30:47
|
On Sun, 4 Aug 2002 13:38:00 +0200 "Dennis Fleurbaaij" <de...@co...> wrote: > Well I -think- (sort of a disclaimer) that the code is getting stable > again. I've updated the db_update.sh scripts and it works here on > serveral production databases. The scripts are also self-securing now > so your data should be safe. > > Can you guys please test the scripts ? > Just a quick note: Thanks for totally improving and enhancing the database script. I haven't tried yet, but I had a problem with my script late last night. The data transfers O.K., but you can't add any tasks / projects / contacts etc, etc. This is because the table indexes are out of sync after the transfer. You may have already fixed this - I can't tell yet: But if not, we can fix this by finding the max value in each index, and then using using setval() to set the index straight. Andrew |