Gantt charts not displayed

[Ozzy]

I have checked for other solutions to this problem, but they don't fix it for me.

I'm using;
Apache 2.0.50
PHP 4.3.2.8
MySQL 4.0.20a
dotProject 1.0.2-1

So far everything seems OK except for Gantt charts which aren't displayed

GD Support is enabled
(GD Version bundled (2.0.23 compatible))

The Apache error log doesn't show any problems
The Apache access log shows:

127.0.0.1 - - [05/Aug/2004:13:16:23 +0100] "GET /dotproject/index.php?m=tasks&a=gantt&suppressHeaders=1&project_id=1&start_date=2004-08-05&end_date=2004-09-05&width=891.0999999999999 HTTP/1.1" 200 3025

I'd really appreciate any help anyone can supply.

Thanks,
Ozzy

[Ozzy]

I forgot to mention: the OS is Windows 2000

[cyberhorse]

do gantt charts display anything, or a missing image entirely? Perhaps you have two versions of PHP, and it's accessing the other one. I had a problem before when gantt charts wouldn't work because I was missing a .ttf font, but it was giving me a picture with an indication of that error ...

[Ozzy]

Thanks for responding, Cyberhorse.

IE shows the white square with a red cross
Opera shows a rectangle with the word "image" in it.

I don't think I have two versions of PHP.
If I do, then one of them is hidden somehow.

I added this line to C:\Root\dotproject\lib\jpgraph\src\jpgraph.php

DEFINE("TTF_DIR","C:\WINNT\Fonts/");

so that the gantt charts could find fonts OK.
Maybe that was a mistake.

Regards,
Ozzy

[cyberhorse]

I think if it was a font issue, it would have told you. Not having any image points to a gd/php problem - not sure where to go from here though :(

[Ozzy]

I had a look at the source for the page generated by the demo project on the web, and my project.
The two were essentially the same except that my page began with

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

In fact I have dotProject on on two different machines, and on one machine I get the above line twice.

When I first set up dotProject I got a problem with it not even getting to the login page. Instead I got a bunch of warnings like:

Warning: Cannot modify header information - headers already sent by (output started at . . .

I fixed this by turning output_buffering on

Is this related to the lines at the beginning of my page?

Thanks in advance for any help or suggestions anyone can give.
Ozzy

[caseydk]

Hey, what's the actual package that creates the Gantt Charts? Is it Jpgraph or something else?

[Ozzy]

OK people, I've figured out how to get Gantt charts working in my installation at least.

As I noted in my last post, the page which should contain the chart contained the line

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

whereas the page on the demo project on the web didn't contain this line.
I searched through my dotProject installation for this line and found that it occurred in a number of files:
C:\Root\dotproject\lib\jpgraph\src\jpgraph.php
C:\Root\dotproject\includes\config.php
C:\Root\dotproject\index.php

I removed it from these files, and hey presto! Habemus Gantt charts!.

So, is this a bug in php?

Hope this helps someone else.

Ozzy

[busfish]

I have just found an answer to the no show Gantt Chart problem. Check to make sure that you have an .htaccess with the following:
php_flag register_globals off
php_value session.auto_start "1"
php_value session.use_trans_sid "0"

I initially had taken the htaccess out of my root and then could not run the Gantt charts. Then, put it back and there it goes!

FYI... my environment is:
MySQL Server Version 3.23.56
Operating System Linux
PHP Version 4.3.8 OK
Web Server Apache/1.3.31 (Unix) mod_jk2/2.0.0

[busfish]

I have just found an answer to the no show Gantt Chart problem. Check to make sure that you have an .htaccess with the following:
php_flag register_globals off
php_value session.auto_start "1"
php_value session.use_trans_sid "0"

I initially had taken the htaccess out of my root and then could not run the Gantt charts. Then, put it back and there it goes!

FYI... my environment is:
MySQL Server Version 3.23.56
Operating System Linux
PHP Version 4.3.8 OK
Web Server Apache/1.3.31 (Unix) mod_jk2/2.0.0


OK, here is a big problem....only use the globals off line. The others interfere with downloading files. It took me hours to figure that out. Sorry if it caused anyone any problems.

Just include this line in your .htaccess (if you do not have access to your php.ini):
php_flag register_globals off

[pmcsorley]

Tried this, I'll try anything at this point - it didn't work though. :cry:
Were you on a Windows 2003 Server?

[zeth0]

It's a session problem like i'm showing you in this topic

http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=877&highlight=

sorry for my bad english

[zeth0]

Got to DotProjectPath/modules/tasks, open the file viewgantt.php and go to the end of the script and change this

<?php
if (db_loadResult( "SELECT COUNT(*) FROM tasks WHERE task_project=$project_id" )) {
$src =
"?m=tasks&a=gantt&suppressHeaders=1&project_id=$pro ject_id" .
( $display_option == 'all' ? '' :
'&start_date=' . $start_date->format( "%Y-%m-%d" ) . '&end_date=' . $end_date->format( "%Y-%m-%d" ) ) .
"&width=' + ((navigator.appName=='Netscape'?window.innerWidth: document.body.offsetWidth)*0.95) + '&showLabels=".$showLabels."&showWork=".$showWork;

echo "<script>document.write('<img src=\"$src\">')</script>";
} else {
echo $AppUI->_( "No tasks to display" );
}
?>



FOR THIS


<?php
$sess = SID;
if (db_loadResult( "SELECT COUNT(*) FROM tasks WHERE task_project=$project_id" )) {
$src =
"?$sess&m=tasks&a=gantt&suppressHeaders=1&project_i d=$project_id" .
( $display_option == 'all' ? '' :
'&start_date=' . $start_date->format( "%Y-%m-%d" ) . '&end_date=' . $end_date->format( "%Y-%m-%d" ) ) .
"&width=' + ((navigator.appName=='Netscape'?window.innerWidth: document.body.offsetWidth)*0.95) + '&showLabels=".$showLabels."&showWork=".$showWork;

echo "<script>document.write('<img src=\"$src\">')</script>";
} else {
echo $AppUI->_( "No tasks to display" );
}
?>

[pmcsorley]

It's a session problem like i'm showing you in this topic

http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=877&highlight=

sorry for my bad english

Thank you for the ol' college try here, zeth0 - I tried editing the addedit.php as you describe, and still do not have a Gantt chart.

Paula

[zeth0]

Paula, if you want to fix the Gantt chart you have to modify the viewgantt.php file like i've show in my last post in this topic.

[pmcsorley]

Paula, if you want to fix the Gantt chart you have to modify the viewgantt.php file like i've show in my last post in this topic.

Yup - I'm sorry I did not see that post at the time. My sincere apologies.
OK - tried that too, still no luck. I'll be following up with AJ soon.
Thank you again,
Paula

[scorpio9a]

Paula, are you missing other .PNG images?, can you see .GIF images? ok
make sure you upload all images as BINARY. I had same problem mentioned above and tried all the suggestions. It started working only when I changed the transfer option in my FTP program to BINARY and upload images again. I did not have to do any theing else

[wheeda]

Got to DotProjectPath/modules/tasks, open the file viewgantt.php and go to the end of the script and change this

<?php
if (db_loadResult( "SELECT COUNT(*) FROM tasks WHERE task_project=$project_id" )) {
$src =
"?m=tasks&a=gantt&suppressHeaders=1&project_id=$pro ject_id" .
( $display_option == 'all' ? '' :
'&start_date=' . $start_date->format( "%Y-%m-%d" ) . '&end_date=' . $end_date->format( "%Y-%m-%d" ) ) .
"&width=' + ((navigator.appName=='Netscape'?window.innerWidth: document.body.offsetWidth)*0.95) + '&showLabels=".$showLabels."&showWork=".$showWork;

echo "<script>document.write('<img src=\"$src\">')</script>";
} else {
echo $AppUI->_( "No tasks to display" );
}
?>



FOR THIS


<?php
$sess = SID;
if (db_loadResult( "SELECT COUNT(*) FROM tasks WHERE task_project=$project_id" )) {
$src =
"?$sess&m=tasks&a=gantt&suppressHeaders=1&project_i d=$project_id" .
( $display_option == 'all' ? '' :
'&start_date=' . $start_date->format( "%Y-%m-%d" ) . '&end_date=' . $end_date->format( "%Y-%m-%d" ) ) .
"&width=' + ((navigator.appName=='Netscape'?window.innerWidth: document.body.offsetWidth)*0.95) + '&showLabels=".$showLabels."&showWork=".$showWork;

echo "<script>document.write('<img src=\"$src\">')</script>";
} else {
echo $AppUI->_( "No tasks to display" );
}
?>

I tried this. After turning on the error reporting in index.php I got the following error:

Notice: Undefined variable: showLabels in /opt/lampp/htdocs/dotproject/modules/tasks/viewgantt.php on line 170

Notice: Undefined variable: showWork in /opt/lampp/htdocs/dotproject/modules/tasks/viewgantt.php on line 170

[wheeda]

Yup, Gantt chart not working.

I have checked the following:
gd php module installed (checked via phpinfo() )
xml php module installed (checked via phpinfo() )
tried zeth0's code snippet, got errors

found that my /usr/X11R6/lib/X11/fonts/truetype/ didn't exist
To try to fix this I created the truetype directory and copied in the contents of the corresponding directory from another machine.
This is my best guess as to what the problem is. How do I find out if dotproject is really pointing to this directory? How do I find out what .ttf files should be in this directory?

[pmcsorley]

Just a quick update to all on the outstanding issue I had.
I wanted to confirm for all that you can get gantt charts to work in Windows 2003. :-)

With some help from AJ, I realized that I had made a change to php.ini that was munging the end date of the gantt chart (don't touch your precision settings in php.ini). Additionally, I found that just placing php.ini in your path isn't the whole picture. You really need to put your php folder in your environment path settings. It is funny that phpinfo test worked fine anyway.

Thank you to all for your help and patience.
Paula

[scross1276]

Alright, well, I've been through every suggestion in this posting, and none of them fixed this problem for me. Does anyone have any other ideas as to why the Gantt charts won't work?

[pmcsorley]

Some details about your problem would help people provide feedback. OS/PHP ver/Apache ver/steps you've taken to verify PHP is in place.

[scross1276]

Yeah, I thought about that last night. :)

Windows 2000
IIS 5
PHP 4.3.8
mySQL 3.23.42

I'm able to render test PHP pages, so I know PHP is working.

[pmcsorley]

There are some bugs in PHP 4.3.8 that don't allow it to play well with dotproject. Please try to revert to 4.3.6.

[scross1276]

Hu, will do.

[NeoGeo]

Some problem.

XP SP2
Apache 2.0.51
PHP 5.0.2
MySQL 4.0.18-nt

[ajdonnison]

Same answer. PHP5 is not supported at this point. Try 4.3.6 instead.

[NeoGeo]

ReGrade to PHP 4
New bugs.

I use Russian Lang. If in JPGraph I setup Cyrillic = TRUE, dotproject dont show image. If set False it show image with non russian symbols.

When I try start any examples from JPGraph - russian chars shows perfect.

?????

[fhensley]

:shock: :shock: :shock:

This is how people look after hours and hours of attempting to get these silly Gantt charts working...

I have come back to the beginning, and have a fundamental question.. How do I know from the output of PHPInfo() that I have GDLIB properly included?

My output has the applicable information shown in the configure command section (--with-gd=shared, etc.), but is that all I should see? For example, later in the PHPINFO() output am I supposed to see a separate section specifically regarding or entitled "GD"?

Please advise.

Thanks,

-Fred-

p.s. I am running Debian v3.1 (sarge), PHP 4.3.9, apache 1.3.31, mysql 4.0.21...

Help?

[pmcsorley]

Yes, you should see a separate gd section in phpinfo (mine is after ftp and before mysql). It should show enabled, with the version and the different graphics support that are enabled.

PS - PHP 4.3.6 is known to work, later versions are iffy at best.

[jkpalmer52]

I've read through all the information that I'm able to find and have attempted to verify that I have my machine set up as described previously in this thread.

Machine configuration and software licenses as follows:

OS; Windows XP Professional
PHP: 4.3.6 (manually installed)
Apache: 2.0.52
dotProject: 1.0.2-1
MySQL: 4.0.22

I had dotProject on a previous install, but had to downgrade PHP to 4.3.6 from 4.3.9 and downgraded MySQL from 4.1....

I do have an error in my Apache log which is -

[client 172.30.12.16] PHP Notice: Undefined offset: 1 in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\dotproject\\lib\\jpgraph\\ src\\jpgraph.php on line 382, referer: http://172.30.12.16/dotproject/index.php?m=projects&a=view&project_id=1&tab=4

Read throught the discussion
and did NOT perform the code change as was described by Ozzy


OK people, I've figured out how to get Gantt charts working in my installation at least.

As I noted in my last post, the page which should contain the chart contained the line

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

whereas the page on the demo project on the web didn't contain this line.
I searched through my dotProject installation for this line and found that it occurred in a number of files:
C:\Root\dotproject\lib\jpgraph\src\jpgraph.php
C:\Root\dotproject\includes\config.php
C:\Root\dotproject\index.php

I removed it from these files, and hey presto! Habemus Gantt charts!.

So, is this a bug in php?

Hope this helps someone else.

Ozzy




Any help would be appreciated.

-jP

[deye]

Go to php.ini and look for a line that says

extension=php_gd2.dll

if it has a ; in front of it, remove the ;
save the file and restart the server.

The FAQ has a similar line that it says to look for,
extension=php_gd.dll

[alei_osc1]

I've been having trouble with the gantt Charts for a while now. I'm not able to display any chart nor any graphics related to the charts on my public site. I've tried every thing postyed in here without any result. the funny thing is that I have a very similar configuration in my local machine and the charts are working.

Anyway, If anybody can help me I will appreciate it...

My enviroment:
MySQL Server Version 4.0.22
PHP Version 4.3.9
Operating System Linux
GD Version bundled (2.0.28 compatible)
XML Support active

Web Server Apache/1.3.31 (Unix) mod_auth_passthrough/1.8mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.9 FrontPage/5.0.2.2634a mod_ssl/2.8.20 OpenSSL/0.9.7a

My local config:
MySQL 4.0.21-nt-log
PHP Version 4.3.9
Operating System Windows NT/XP 5.1 build 2600
GD Version bundled (2.0.28 compatible)
XML Support active

Web Server Apache/2.0.52 (Win32) mod_ssl/2.0.52 OpenSSL/0.9.7c PHP/4.3.9 mod_python/3.1.3 Python/2.3.3 mod_jk2/2.0.4

[sdabel]

I am having the same problems with Gantt charts not displaying (red X only).

Running on Win2000 server
IIS
PHP 4.39

phpinfo reports that gd and xml are both working

Other applications can use GD to generate graphics.

Have tried ozzy's code snippets and other advice here. Also tried retrograding to PHP 4.3.1

Any ideas ?

regards
sean

My environment includes a link to the php folder.

[pmcsorley]

I found that just placing php.ini in your path isn't the whole picture. You really need to put your php folder in your environment path settings.

[sperryman]

pmcsorley,

For those of us who are not in the know, what settings for environmental path are you talking about?

Could you please give the file name and string changes made?

Thanks. Sean.

[pmcsorley]

For example - if you have installed PHP in your C:\PHP folder - make sure you add that to your path. The above cases involved Windows-based OS, so my reply is referencing the Windows environment. In your environment variables area, there is a setting for Path - make sure to add the folder which holds your PHP files to that path (for example C:\PHP).

In Windows 2003, you can find this by right-clicking on My Computer, going into Properties, going to Advanced, and at the bottom, clicking on the Environment Variables button. Look for the option "Path" listed under your System variables.

[greenjeep]

I have read through the thread and have NOT made any of the suggested changes yet.

First, I am running on a hosted system and do not have access to php.ini nor can I downgrade PHP (which is PHP5).

Second, the GANTT displays for projects with a few tasks (<15 or so) but not onve the task list grows above this limit.

Any thoughts?

[pmcsorley]

My current system has over 150 tasks on a project. So tasks shouldn't drive this. I am running the older PHP though. However...
The Gantt chart doesn't show when I say "show full project", but does show up if I got by specific dates. I suspect it has to do with our usage (or lack thereof) of specific dates on a lot of the tasks. You might try that.

Hope this helps, Paula

[greenjeep]

Paula,

Thanks for the reply.

Changing the data range does not seem to have any impact on the ability to display the GANTT chart.

Have you made any changes to config paramaters or scripts that might make a difference?

Carl

[greenjeep]

I followed the instructions under troubleshooting in the documentation and ran check.php. I have a fatal error indicating that session.save_path is not set. where do I set this option?

[ajdonnison]

session.save_path is set in your PHP.INI file, or in a .htaccess file. The PHP documentation suggests that you can also edit index.php and put an ini_set('session.save_path', '/my/new/save/path'); but make sure it goes before any of the session management commands.

You may find that this is not a real problem, though. If your web hosting provider uses what is known as a chroot gaol for your website you will find that the session.save_path will be reported as missing. If you can log in and you don't get any errors, and it doesn't log you out on every page request, then your session.save_path is fine.

[scooter]

So far displaying a Gantt chart from the Projects list seems to work fine, BUT cannot for the life of me get and kind of chart displayed for any task.

PHP Version 4.3.2
MYSQL Version 3.23.58
GD is enabled
DotProject Alpha 2

Why would it work in Projects and not Tasks?

I have also made another topic about this int the Latest CVS Snapshot forum, but no replies:
http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=1675

[sdabel]

From looking at these posts it seems that there is a problem with displaying Gantt charts using Windows 2000.

I can display Gantt charts in other packages using my system (Jgraph, PHP etc) so it looks like something in dotproject. rather than system configuration.

regards
sean

jpgraph V 1.6 does not work (dotproject)
jpgraph V 1.143 does work (phpcollab)

regards
sean

[ajdonnison]

Do you know what version(s) of JpGraph are working?

[greenjeep]

I have found a workaround for this issue. It has been reported as bug 000428 by george meany and has been discussed in several other threads. Anyway, resizing the browser (making it narrower and shorter) and refreshing the screen ultimately gets the chart to display (I had to play with the size until it worked).

Any thoughts on the root cause of this problem?

:D

[jame]

Go to php.ini and look for a line that says

extension=php_gd2.dll

if it has a ; in front of it, remove the ;
save the file and restart the server.

The FAQ has a similar line that it says to look for,
extension=php_gd.dll


worked for me!

cheers! :D

[xpericon]

Hi all,

I read through this thread cause I was also experiencing problems in displaying my gantt charts.
Since I'm running on PHP5 I know I'm not running a fully supported environment but so far dotProject is running fine.

To fix my Gantth problem I donwloaded the latest version of jpgraph 2.0alpha2 (release 22 jan 2005) on http://www.aditus.nu/jpgraph.
Then I rename the dotproject/lib/jpgraph/src folder to somethings else to have the backup, created a new src folder and copied all files from the download in this src folder.

And now it finally works!! Hope this helps for others also.

Greetz,
Bert

[caseydk]

Bert,

Keep a list of every change you have made in order to make it php5 compatible and then attach it to Mantis.

That will come in handy later on because we'll have to update to php5 eventually.

[sdabel]

I am having the same problems with Gantt charts not displaying (red X only).

Running on Win2000 server
IIS
PHP 4.39

phpinfo reports that gd and xml are both working

Other applications can use GD to generate graphics.

Have tried ozzy's code snippets and other advice here. Also tried retrograding to PHP 4.3.1

Any ideas ?

regards
sean

My environment includes a link to the php folder.

I have resolved this. I had an extra php.ini file in my path that was over riding the php.ini file I was editing, for some reason this did not show when I browsed php.info :evil:

So my suggestion is to search for extra copies of php.ini and rename or remove.

regards
sean

[elmuchacho]

Hello,

Here is my input to this problem.

On Win2000 with apache2triad 1.2.8, I have failed to make the Gantt chart appear. I've tried all versions of jPgraph that I could download and it didn't solve the problem, although, the latest (2.0-alpha) seemed to behave a bit differently : it didn't monopolize the processor for seconds like the previous versions (although it is supposed not to work with PHP5).
Another thing that doesn't work at all is the user preferences.

After having changed my Apache distribution to EasyPHP 1.8.0, though, the Gantt graphs work fine. (I still can't see the user preferences though) Beware that this distribution needs some security adjustment.
I didn't even have to do any adjustment concerning the paths to the TrueType fonts !

EasyPHP 1.8.0 uses the latest version of PHP4, i.e 4.3.10, but not Apache 2. So it seems to me that the problems are linked with the Apache distributions.

[bering]

Hi. I've just upgraded to 2.0 and I'm having problems with displaying Gantt charts as well. Where the Gantt charts used to be (they worked before) I now see this picture:

http://e-governments.org/project/1.png

I've tried some of the solutions suggested in this thread, but none of them seem to work (or mention having the same error)

Setup:
Apache/1.3.33
PHP Version 4.3.10
MySQL 3.23.58
GD 2.0.28 compatible

Any suggestions?

[ajdonnison]

You might want to check the lib/ezpdf/fonts directory and remove any old files in there. Then make sure the directory is writable.

[bering]

I've tried that, but it doesn't work (set the permissions of the fonts folder to 666). Doesn't the expdf folder have to do with creating PDF documents? Shouldn't I be changing something in the jgraph folder?

[ajdonnison]

Sorry, yes it does, and I'm in need of a lot of sleep. JpGraph gets its fonts from the system, and normally gives a better error than that if it is font related. I must admit I haven't seen that before and am a bit stumped.

[bering]

So have anyone else seen this error before? ... or does anyone have suggestions? I'm really bummed about the Gantt charts not working and am seriously considering downgrading if I can't get it to work.

[bering]

Wooo! Fiddling around with the language files as described in this (http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&p=9565&sid=e901d4b5497c070fea5d9ef213a50d78#9565)
thread solved the problem! All this due to incompatible translation files (1.0 on a 2.0 installation). Thank you very much for your help.

[Rgerla]

Yes, you should see a separate gd section in phpinfo (mine is after ftp and before mysql). It should show enabled, with the version and the different graphics support that are enabled.

PS - PHP 4.3.6 is known to work, later versions are iffy at best.

Does anybody has anyexperience with php version 4.3.11

I have also problems with the Gantt charts. I'm have installed on a windows 2000 system with IIS 5.0
Mysql 4.1.12a-nt
and PHP 4.3.11

[gwp-1]

Perhaps I'm going off-thread here, but I'm still stuck back at this:

"You are trying to use the locale (C) which your PHP installation does not support. Hint: Use ' ' to indicate the degaulr locale for this geographic region."

I''ve tried the fixes listed elsewhere in these forums and that only made it worse. (At first I had the ability to do Gantt's from the PROJECTS tab but not the TASKS tab. Now I can't do from either. Please help!!!!! ::BB

[pedroa]

dP 1 or dP2?

Pedro A.

[gwp-1]

dp2

I'm new. I started fresh on dp2, never had to upgrade from dp1. I just discovered you guys totally by accident about four weeks or so ago. I'm in love with dp lol And so is the rest of the team in my small company.

[pedroa]

Its that this forum is for dP 1...
But see this:
http://www.dotproject.net/vbulletin/showpost.php?p=13621&postcount=9

and the locales that you can set in the System Admin., System Config. jpgraph Locale (you should use the one that applies to you and works):

http://meshier.com/dev/jpgraph/ref/DateLocale.html#_DATELOCALE_SET

Pedro A.