[rt-users] No Graph in the Statistics page

[Joel Johnson]

I'm getting the same result here.....with the addition that when I go to 
the "Tickets by status" tab, I get the following system error:

*error:*  Can't bind a reference (RT::Queues=HASH(0xb459e1c)) at 
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 410.
*context:* 
*...*  	
*406:*  	delete $bhash->{'value'};
*407:*  	$sth->bind_param($bind_idx+1, undef, $bhash );
*408:*  	}
*409:*  	}
*410:*  	unless ( $sth->execute(@bind_values) ) {
*411:*  	if ($DEBUG) {
*412:*  	die "$self couldn't execute the query '$QueryString'"
*413:*  	. $self->dbh->errstr . "\n";
*414:*  	
*...*  	

*code stack:*  /usr/share/perl5/DBIx/SearchBuilder/Handle.pm:410
/usr/share/perl5/DBIx/SearchBuilder/Record.pm:899
/usr/share/perl5/DBIx/SearchBuilder/Record.pm:819
/usr/share/perl5/DBIx/SearchBuilder/Record/Cachable.pm:110
/usr/share/request-tracker3/lib/RT/Record.pm:225
/usr/share/request-tracker3/lib/RT/Queue_Overlay.pm:330
/usr/local/share/request-tracker3/html/Statistics/OpenStalled/index.html:118
/usr/share/request-tracker3/html/autohandler:196


I'm running Debian (in spite of recent discussion on the list!) with the 
request-tracker3 package on apache2 with mod_perl, and extracted the 
tarball into the /usr/local/share/request-tracker3/ (the html and lib 
directories). When running like that, RT grabs the ./html/Elements/Tabs 
file and displays the tab on the menu, but when I click on the tab it 
gives a file not found, and doesn't appear to notice anything in the 
./html/Statistics directory. I copy it over manually into 
/usr/share/request-tracker3/html and it seems to work fine, just without 
the graphs.

Any ideas on either of these issues?

Joel Johnson


Asif Iqbal wrote:

>Hi All
>
>I did follow the instructions on
>http://wiki.bestpractical.com/index.cgi?RT3StatisticsPackage page
>
>I expanded the archive on my /opt/rt3/local page. I am running RT-3-10
>with Apache 1.x and mod_perl1. I did install GD::Graph using CPAN tool
>
>perl -MCPAN -e shell 
>cpan> install GD::Graph
>
>I don't see any graphs. Here is the source page looks like
>
><IMG SRC="Elements/Chart?x_labels=Fri,Sat,Sun,Mon,Tue,Wed,Thu,Fri,Sat,Sun&data1=0,0,0,6,5,2,3,0,0,0&data2=1,0,0,4,3,5,3,1,0,0&data3=0,0,0,0,0,0,0,0,0,0" type="image/png"> 
>
>Is that mean I need to install Apache::GD::Graph?
>
>Please help
>
>Thanks
>
>  
>