Reports not working in SimleInvoices-2011.1 about simpleinvoices HOT 17 CLOSED

phpreports library is now deprecated.
Use the latest v2013.1b2-git
Take the snapshot from:
https://github.com/simpleinvoices/simpleinvoices/archive/master.zip
----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Monday, September 30, 2013 8:59 PM
Subject: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

Hi,

I am new to simpleinvoices. I tried to use the simple invoices in my windows system itself as web software using XAMPP.
I followed every installation steps properly (I think!).

My Versions:
Simle Invoices 2011.1
XAMPP 1.8.1
PHP 5.4.7
Perl 5.16.1
5.5.27 - MySQL Community Server (GPL)
Apache/2.4.3 (Win32)
OpenSSL/1.0.1c
phpMyAdmin 3.5.2.2
Windows 7

Everything working fine except some reporting which shows nothing.

1. Total Sales

2. Sales by customers

3. Total Tax

4. Products Sales .. etc

   Then I enabled the error log and it showed the following message.

   Fatal error: Call-time pass-by-reference has been removed in
   D:\xampp\htdocs\simpleinvoices-2011.1\library\phpreports\PHPReportMaker.php(274) :
   eval()'d code on line 151

   I tried cleared issues, I tried at my level best.

   Please suggest list of things to be done to get the reports right!

   Thanks,
   Selva

   —
   Reply to this email directly or view it on GitHub.

from simpleinvoices.

In case you want to use the old version, then the fix is at:
http://www.simpleinvoices.org/wiki/phpreport_mods

----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Monday, September 30, 2013 8:59 PM
Subject: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

Hi,

I am new to simpleinvoices. I tried to use the simple invoices in my windows system itself as web software using XAMPP.
I followed every installation steps properly (I think!).

My Versions:
Simle Invoices 2011.1
XAMPP 1.8.1
PHP 5.4.7
Perl 5.16.1
5.5.27 - MySQL Community Server (GPL)
Apache/2.4.3 (Win32)
OpenSSL/1.0.1c
phpMyAdmin 3.5.2.2
Windows 7

Everything working fine except some reporting which shows nothing.

1. Total Sales

2. Sales by customers

3. Total Tax

4. Products Sales .. etc

   Then I enabled the error log and it showed the following message.

   Fatal error: Call-time pass-by-reference has been removed in
   D:\xampp\htdocs\simpleinvoices-2011.1\library\phpreports\PHPReportMaker.php(274) :
   eval()'d code on line 151

   I tried cleared issues, I tried at my level best.

   Please suggest list of things to be done to get the reports right!

   Thanks,
   Selva

   —
   Reply to this email directly or view it on GitHub.

from simpleinvoices.

set allow_call_time_pass_reference to true in the php.ini, the error is removed
----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Monday, September 30, 2013 8:59 PM
Subject: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

Hi,

I am new to simpleinvoices. I tried to use the simple invoices in my windows system itself as web software using XAMPP.
I followed every installation steps properly (I think!).

My Versions:
Simle Invoices 2011.1
XAMPP 1.8.1
PHP 5.4.7
Perl 5.16.1
5.5.27 - MySQL Community Server (GPL)
Apache/2.4.3 (Win32)
OpenSSL/1.0.1c
phpMyAdmin 3.5.2.2
Windows 7

Everything working fine except some reporting which shows nothing.

1. Total Sales

2. Sales by customers

3. Total Tax

4. Products Sales .. etc

   Then I enabled the error log and it showed the following message.

   Fatal error: Call-time pass-by-reference has been removed in
   D:\xampp\htdocs\simpleinvoices-2011.1\library\phpreports\PHPReportMaker.php(274) :
   eval()'d code on line 151

   I tried cleared issues, I tried at my level best.

   Please suggest list of things to be done to get the reports right!

   Thanks,
   Selva

   —
   Reply to this email directly or view it on GitHub.

from simpleinvoices.

Hi,

Thanks very much.

While I am trying the older version I did the following as your instructions.

1. set allow_call_time_pass_reference to true in the php.ini
2. Change in \library\phpreports\php\PHPReportRow.php
   function addCol($oCol_) {
   array_push($this->aCols,$oCol);
   }
3. Change in \library\phpreports\xsl\PHPReportCol.xsl
   xsl:text $oRow->addCol($oCol/xsl:text<xsl:value-of select="count(preceding::*[name()='COL'])+1"/>xsl:text); /xsl:text
4. PHPReportUtil.php is no longer exists.
5. Changes in /library/phpreports/PHPReportMaker.php
   $this->_sTmp = dirname(dirname(dirname(FILE))) . "/cache";
6. Changes in /library/phpreports/xslt/PHPReportRpt.xsl
   if(!is_resource($oCon) && !is_object($oCon))
   $oError->showMsg("INVALIDCON");
7. /modules/reports/PHPReportsUtil.php is not exists
8. Changes in /templates/default/css/screen.css

/* Old PHP Reports CSS - uses class="reportTable" */

table.reportTable {
border:1px solid #000; }

*+html table.reportTable {
border-collapse:separate; }

*+html td.PAGE_LAYER {
border-width:thin;
border:1px solid #000;
border-collapse:separate; }

*+html table.reportTable tr {
border:1px solid #000;
border-collapse:separate; }

table.reportTable td.PAGE_LAYER {
background-color:#ccc;
border-color:#000; }

/* New PHPreports CSS - uses ID="pg2" or "pg1" - Although HEADER and FOOTER are used now instead of PAGE_LAYER, it is left as is for compatibility */

table#pg1 {
border:1px solid #000; }

*+html table#pg1 {
border-collapse:separate; }

*+html td.PAGE_LAYER {
border-width:thin;
border:1px solid #000;
border-collapse:separate; }

*+html table#pg1 tr {
border:1px solid #000;
border-collapse:separate; }

table#pg1 td.PAGE_LAYER {
background-color:#ccc;
border-color:#000; }

table#pg1 td.GROUP_LAYER {
background-color:#fff;
border-color:#000; }

table#pg2 {
border:1px solid #000; }

*+html table#pg2 {
border-collapse:separate; }

*+html td.PAGE_LAYER {
border-width:thin;
border:1px solid #000;
border-collapse:separate; }

*+html table#pg2 tr {
border:1px solid #000;
border-collapse:separate; }

table#pg2 td.PAGE_LAYER {
background-color:#ccc;
border-color:#000; }

table#pg2 td.GROUP_LAYER {
background-color:#fff;
border-color:#000; }

Even though the error still occurs:
Fatal error: Call-time pass-by-reference has been removed in
D:\xampp\htdocs\simpleinvoices-2011.1\library\phpreports\PHPReportMaker.php(274) :
eval()'d code on line 156

Did I missed anything?

Regards,
Selva.

from simpleinvoices.

When you edit your php.ini, please restart your apache server.

----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Monday, September 30, 2013 9:53 PM
Subject: Re: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

Hi,

Thanks very much.

While I am trying the older version I did the following as your instructions.

1. set allow_call_time_pass_reference to true in the php.ini

2. Change in \library\phpreports\php\PHPReportRow.php
   function addCol($oCol_) {
   array_push($this->aCols,$oCol);
   }

3. Change in \library\phpreports\xsl\PHPReportCol.xsl
   xsl:text $oRow->addCol($oCol/xsl:textxsl:text); /xsl:text

   1.. PHPReportUtil.php is no longer exists.

   2.. Changes in /library/phpreports/PHPReportMaker.php
   $this->sTmp = dirname(dirname(dirname(FILE_))) . "/cache";

   3.. Changes in /library/phpreports/xslt/PHPReportRpt.xsl
   if(!is_resource($oCon) && !is_object($oCon))
   $oError->showMsg("INVALIDCON");

   4.. /modules/reports/PHPReportsUtil.php is not exists

   5.. Changes in /templates/default/css/screen.css

   /* Old PHP Reports CSS - uses class="reportTable" */

   table.reportTable {
   border:1px solid #000; }

   *+html table.reportTable {
   border-collapse:separate; }

   *+html td.PAGE_LAYER {
   border-width:thin;
   border:1px solid #000;
   border-collapse:separate; }

   *+html table.reportTable tr {
   border:1px solid #000;
   border-collapse:separate; }

   table.reportTable td.PAGE_LAYER {
   background-color:#ccc;
   border-color:#000; }

   /* New PHPreports CSS - uses ID="pg2" or "pg1" - Although HEADER and FOOTER are used now instead of PAGE_LAYER, it is left as is for compatibility */

   table#pg1 {
   border:1px solid #000; }

   *+html table#pg1 {
   border-collapse:separate; }

   *+html td.PAGE_LAYER {
   border-width:thin;
   border:1px solid #000;
   border-collapse:separate; }

   *+html table#pg1 tr {
   border:1px solid #000;
   border-collapse:separate; }

   table#pg1 td.PAGE_LAYER {
   background-color:#ccc;
   border-color:#000; }

   table#pg1 td.GROUP_LAYER {
   background-color:#fff;
   border-color:#000; }

   table#pg2 {
   border:1px solid #000; }

   *+html table#pg2 {
   border-collapse:separate; }

   *+html td.PAGE_LAYER {
   border-width:thin;
   border:1px solid #000;
   border-collapse:separate; }

   *+html table#pg2 tr {
   border:1px solid #000;
   border-collapse:separate; }

   table#pg2 td.PAGE_LAYER {
   background-color:#ccc;
   border-color:#000; }

   table#pg2 td.GROUP_LAYER {
   background-color:#fff;
   border-color:#000; }

   Even though the error still occurs:
   Fatal error: Call-time pass-by-reference has been removed in
   D:\xampp\htdocs\simpleinvoices-2011.1\library\phpreports\PHPReportMaker.php(274) :
   eval()'d code on line 156

   Did I missed anything?

   Regards,
   Selva.

   —
   Reply to this email directly or view it on GitHub.

from simpleinvoices.

Hi,

I have restarted my system and checked, still the same problem present.
I think some thing else I missed.

I think better I go for https://github.com/simpleinvoices/simpleinvoices/archive/master.zip.
I will test this and I will update here..

Thanks for your kind help!

Regards,
Selva

from simpleinvoices.

Hi,

I downloaded the simpleinvoices-master.zip (Bleeding Edge Code) and going to use that one.
Am new to simpleinvoices, so please help me that how to use this master.zip with existing simpleinvoices-2011.1?

Thanks.

from simpleinvoices.

I merged the simpleinvoices-master folder with the simpleinvoices-2011.1 folder and started installation again.
I used simple copy and paste operation from master to 2011.1 version folder.
It is working fine regarding the reports generation.

I am really thank you very much to apmuthu.
I also would like to contribute to simpleinvoices, hope soon I will do this after mastering with that.

Thanks.

from simpleinvoices.

Great vselva,

Actually the new code alone could have been used.
It could have been installed anew.

Ap.Muthu
----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Tuesday, October 01, 2013 4:39 PM
Subject: Re: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

I merged the simpleinvoices-master folder with the simpleinvoices-2011.1 folder and started installation again.
I used simple copy and paste operation from master to 2011.1 version folder.
It is working fine regarding the reports generation.

I am really thank you very much to apmuthu.
I also would like to contribute to simpleinvoices, hope soon I will do this after mastering with that.

Thanks.

from simpleinvoices.

Hi Muthu,

I tried first simply using simpleinvoices-master package as per the simpleinvoices installation procedure.
But it gave the error:

Warning: require_once(Zend/Loader/Autoloader.php): failed to open stream: No such file or directory in D:\xampp\htdocs\simpleinvoices-master\include\init.php on line 10
 Fatal error: require_once(): Failed opening required 'Zend/Loader/Autoloader.php' (include_path='.;D:\xampp\php\PEAR;./include/class;./library/;./library/pdf;./include/') in D:\xampp\htdocs\simpleinvoices-master\include\init.php on line 10

I searched the Zend folder which is empty in simpleinvoice-master pack. (why is this empty?)
It is present in simpleinvoices-2011.1 packl, so I thought this is a patch not complete one.
I proceeded with merging work! Am I wrong??

Selva.

from simpleinvoices.

Hi Muthu,

I think the simpleinvoice-master pack does not contain the library/Zend folder, and the same to be copied from simpleinvoices-2011.1 pack. So this should be given in the release notes right?

~ Selva.

from simpleinvoices.

The Zend Package is available from:
https://github.com/dmelo/Zend-1.11/archive/master.zip

Unzip it's contents to library/Zend folder

----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Tuesday, October 01, 2013 8:41 PM
Subject: Re: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

Hi Muthu,

I think the simpleinvoice-master pack does not contain the library/Zend folder, and the same to be copied from simpleinvoices-2011.1 pack. So this should be given in the release notes right?

~ Selva.

from simpleinvoices.

Yes, Thatz fine!

Everything I tested are fine! But seems it is very slow.

When I used in my local server-client setup using XAMP, It took more resource from my PC, Slow performance.
Then I tried online server, still it take some time. I did not feel such a delay in any other database based online applications. Testing still..

Is there any ways to improve the SI performance?
Should I do anything like 'Disable Logging'?

from simpleinvoices.

Please check for any background processes hogging your local computer's CPU resources.
What is the public server's url? I can try the latency from other places.
Where is the datacenter?
Our experience with SI is that it is qute fast whether XAMPP local or Linux Remote.
Logging warnings can be disabled but log errors.
Check the increase in database sql dump size on entering records and verify that there are no collation conflicts.
Check the Apache logs for clues on missing files and convoluted redirects (.htaccess) or any rootkits.

----- Original Message -----
From: vselva
To: simpleinvoices/simpleinvoices
Sent: Friday, October 04, 2013 10:35 AM
Subject: Re: [simpleinvoices] Reports not working in SimleInvoices-2011.1 (#65)

Yes, Thatz fine!

Everything I tested are fine! But seems it is very slow.

When I used in my local server-client setup using XAMP, It took more resource from my PC, Slow performance.
Then I tried online server, still it take some time. I did not feel such a delay in any other database based online applications. Testing still..

Is there any ways to improve the SI performance?
Should I do anything like 'Disable Logging'?

from simpleinvoices.

Regarding SI Testing in Public Server, I used a Free Web Hosting Services.
I think It is the reason for the delay. I will try in a Good Paid Hosting service..

Also Testing the same in my Local Machine!

from simpleinvoices.

SOLUTION: I have slow simpleinvoice but after i debug all the codes (yes all the codes) i try 4 hosting 3 local servers and the same result SLOW. but when i change database.params.host=localhost with database.params.host= 127.0.0.1 in config/config.ini and magic happend super fast simpleinvoice. you can try this.

from simpleinvoices.

@elminson: Please open a separate issue for each problem.
Depending on the way your apache (webserver) conf and my.cnf/my.ini are configured your performance can be tuned accordingly.
Thankyou for your input as it will be one more means to speedup SI.

from simpleinvoices.