Cannot see total pipeline

[looneysaint]

Hi..

After entering some datas, I still cannot see any graph for all the total pipeline graph. Only a red X appear. Any idea? Thanks.

[lcba]

Maybe you don't have the GD library installed...
:unsure:

[looneysaint]

Hi Icba,

I have checked, GID is working fine.
I installed using XAMPP 1.4.4 Win32 on Win 2003 Server.
XAMPP installed Apache HTTPD 2.0.50, MySQL 4.0.20, PHP 4.3.7 + PEAR, and more.
It has an interface to show GID loaded and running fine. Just cannot see the graph/pipeline. At a lost man. Cheers.

[Jacob]

What version of the GD graphics library do you have installed?

We require GD 2+

Many systems only have GD 1.8.

Jacob

[Ficarra]

I am having the same problem. According to phpinfo() on my Windows 2000 box, I am running 2.0.15. See below

GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled

Upon further investigation, i tried plugging in the URL that the graphic was using directly into the web browser.
http://localhost/sugarcrm/graph.php?...graph=pipeline

..and I get the following error:

JpGraph Error: No path specified for TTF_DIR. Please specify a path for that DEFINE in jpgraph.php

I tried forcing the DEFINE values as follows in /jpgraph/src/jpg-config.inc:

[code:1]DEFINE("TTF_DIR", "c:/windows/fonts/"«»
DEFINE("CACHE_DIR", "c:/windows/temp/"«»[/code:1]

But still no go.

I took the value of $_ENV[''SystemRoot] (line 48 in jpgraph.php) and stuck it in a test .php file to see what it came up with. It came up empty.

Running:
SugarCRM 1.0e
Win2k Pro
IIS 5.0
PHP 4.3.4

Thoughts?

-Jim

Post edited by: ficarra, at: 2004/07/16 23:44

[Jacob]

You need a TEMP environment variable and a SystemRoot environment variable..

Define the TEMP and SystemRoot environment variables as a valid folder.
You should be able to set it from right clicking on "My Computer" and picking properties.

To test and see if it is correctly done, check by running 'set temp' from a command prompt. You should see something like:
set TEMP=C:\DOCUME~1\Jacob\LOCALS~1\Temp
'set SystemRoot' should return somthing like:
SystemRoot=C:\WINDOWS

The other option is to make sure that you are defining cache_dir before line 30.
if (!defined('CACHE_DIR')) {

And line 47 for TTF_DIR respectively.
if (!defined('TTF_DIR')) {

Let me know how it goes.

Jacob

[Ficarra]

I had alread made sure these were set before posting. TEMP and SystemRoot environment variables are set...pretty standard stuff under windows, but for the record here they are:

C:\>set SystemRoot
SystemRoot=C:\WINDOWS

C:\>set TEMP
TEMP=C:\DOCUME~1\JFICAR~1.XCU\LOCALS~1\Temp

The if !defined() statements to check CACHE_DIR and TTF_DIR are at lines 29 and 46 respectively in jpgraph.php. Since it requires jpg-config.inc, I had tried hard-coding the variables for kicks and giggles to see if that worked. No go.

One thing I noticed is that $_ENV[] does not seem to see the environment variables. Here's some sample php code that makes me believe there's an issue:

[code:1]<?php
print 'SystemRoot using $_ENV[]: ' . $_ENV["SystemRoot"] . "<br>";
print 'SystemRoot using getenv(): ' . getenv('SystemRoot') . "<br>";
print 'TEMP using $_ENV[]: ' . $_ENV["TEMP"] . "<br>";
print 'TEMP using getenv(): ' . getenv('TEMP') . "<br>";
?>[/code:1]

And the results:

SystemRoot using $_ENV[]:
SystemRoot using getenv(): C:\WINDOWS
TEMP using $_ENV[]:
TEMP using getenv(): C:\WINDOWS\TEMP

Is there a setting in php.ini I am missing? Any other thoughts?

Thanks.

[Ficarra]

I tried a fewmore things and still no luck. I tried the following:

[ol]
[li]I changed each occurance of $_ENV['variable_name'] to getenv('variable_name')[/li]
[li]To rule out security/permissions issues, I made the IUSR_computername and IWAM_computername users administrators on the local box and rebooted.[/li]
[li]Turned DEBUG logging on. At least the log thinks it's drawing the image (see below)[/li]
[/ol]
Here's an excerpt from the debug log:

07/17/04 23:23:39,826 [2560] DEBUG graph - array (
'module' => 'Opportunities',
'action' => 'Charts',
'graph' => 'pipeline',
'flat_array1' => 'Prospecting,Qualification,Needs Analysis,Value Proposition,Id. Decision Makers,Perception Analysis,Proposal/Price Quote,Negotiation/Review,Closed Won,Closed Lost',
'flat_array2' => '460,315,365,265,525,495,410,370,300,260',
'title' => 'Total Pipeline is $3765K',
'subtitle' => 'Opportunity size in $1K',
'PHPSESSID' => 'a11cef3eb5a31e2871b08e2881a6a8b4',
)
07/17/04 23:23:39,827 [2560] INFO graph - current module is Opportunities
07/17/04 23:23:39,827 [2560] INFO graph - including modules/Opportunities/Charts.php
07/17/04 23:23:39,913 [2560] DEBUG graph - draw_this->pipeline
07/17/04 23:23:39,913 [2560] DEBUG graph - flat_array1 is Prospecting,Qualification,Needs Analysis,Value Proposition,Id. Decision Makers,Perception Analysis,Proposal/Price Quote,Negotiation/Review,Closed Won,Closed Lost
07/17/04 23:23:39,914 [2560] DEBUG graph - flat_array2 is 460,315,365,265,525,495,410,370,300,260
07/17/04 23:23:39,914 [2560] DEBUG graph - title is Total Pipeline is $3765K
07/17/04 23:23:39,914 [2560] DEBUG graph - subtitle is Opportunity size in $1K

I'm running outof ideas.

[thermopyl]

I had the same problem, but now sorted !

Edit your jpgraph.php and change $_ENV in the TTF_DIR section to $_SERVER. Refresh your page and voila!

Thermopyl

[Ficarra]

Thanks for the info, but it didn't work. When I plug the URL in to view the graphic, I get the same error as if I used $_ENV.

JpGraph Error: No path specified for TTF_DIR. Please specify a path for that DEFINE in jpgraph.php

getenv() at least seemed to get the appropriate environment variables.

I was perusing the jpgraph boards the other night and some people had similar problems, but no one seems to have a solution that works.