[FIXED] Asset Transaction Reports - Error 0.20 Issue

Hi

I get the same error. Any resolution yet?

Could you test commenting out the offending lines of code? Lines 364 and 365 of includes/php/PHPReports/PHPReportsUtil.php.

Example:

function showMsg($sMsg_=null,$oParms_=null){
            if(!$sMsg_)
                return;
            if($_SESSION["phpReportsLanguage"])
                $sLang = $_SESSION["phpReportsLanguage"];
            //else
            //    $sLang = $GLOBALS["phpReportsLanguage"];

I was able to get by this by commenting out line number 366.. however after that i get an error as follows

Invalid argument supplied for foreach()
Error Type:   E_WARNING   
Rendered Page:   Click here to view contents able to be rendered
Source File:   C:\wamp\www\tracmor\reports\asset_transaction_report.php         Line:   337   

Line 332:              //some data to show in the report
Line 333:              $sSql = AssetTransaction::LoadArrayBySearch(true, $this->.....snipped..
Line 334:              $strXmlColNameByCustomField = "";
Line 335:              $strXmlFieldByCustomField = "";
Line 336:              $intCustomFieldCount = 0;
Line 337:              foreach ($this->chkCustomFieldArray as $chkCustomField) {
Line 338:                if ($chkCustomField->Checked) {
Line 339:                  $strXmlColNameByCustomField .= "<COL CELLCLASS='report_column_header'>".$chkCustomField->Text."</COL>";
Line 340:                  $strXmlFieldByCustomField .= "<COL TYPE='FIELD' CELLCLASS='report_cell'>__".$chkCustomField->ActionParameter."</COL>";
Line 341:                  $intCustomFieldCount++;
Line 342:                }

Thank you for your reply

i have commenting out line number 364 ,365 ,366 i now get a error

OOOOPS, THERE'S AN ERROR HERE.

There is no XSLT processor available. Check if you compiled PHP with --enable-xslt and the Sablotron library (for PHP4) or with --enable-xsl (for PHP5).

This error message was generated by phpReports.

hi

I have install xsl looks beter now - don't get the failure anymore, but now I get a blank page with a "could not connect" error when i run the report

any ideas?

Last edited by matt (2009-07-15 04:37:13)

I am running RHEL 5 with Apache and MySql installed.  In order to resolve this issue, I had to install the XML module for PHP.  To do this I ran the following command

yum install php-xml

After restarting the httpd service I was able to generate reports.

I was getting the phpReportsLanguage Error

I installed php5-xsl

Now I get:

Error in PHP Script
/reports/asset_transaction_report.php     PHP Version: 5.3.2-1ubuntu4.9;  Zend Engine Version: 2.3.0;  Qcodo Version: 0.3.32 (Qcodo Beta 3)
Application: Apache/2.2.14 (Ubuntu);  Server Name: 10.224.3.47
HTTP User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0

Call-time pass-by-reference has been deprecated
Error Type:   Unknown

Source File:   /var/www/includes/php/PHPReports/PHPReportMaker.php(273) : eval()'d code     Line:   295

Call Stack:

#0 /var/www/includes/php/PHPReports/PHPReportMaker.php(273): QcodoHandleError()
#1 /var/www/includes/php/PHPReports/PHPReportMaker.php(273): PHPReportMaker::run()
#2 /var/www/reports/asset_transaction_report.php(426): PHPReportMaker->run()
#3 /var/www/includes/qcodo/_core/qform/QFormBase.class.php(657): AssetTransactionListForm->btnGenerate_Click()
#4 /var/www/includes/qcodo/_core/qform/QFormBase.class.php(774): QFormBase->TriggerMethod()
#5 /var/www/includes/qcodo/_core/qform/QFormBase.class.php(242): QFormBase->TriggerActions()
#6 /var/www/reports/asset_transaction_report.php(475): QFormBase::Run()

Any ideas?

Last edited by jadobbins (2011-07-26 11:40:59)