Hello, I have been getting the following error when attempting to generate reports:
setUser($db_user); $oRpt->setPassword($db_password); $oRpt->setConnection($db_host); $oRpt->setDatabaseInterface("mysql"); // set as $db_server in trunk $oRpt->setDatabase($db_name); ?> Fatal error: Call to a member function setXML() on a non-object in C:\wamp\www\simpleinvoices\modules\reports\report_sales_customers_total.php on line 11
System info: Win XP WampServer 2.0 (release 11/21/07) Apache: 2.2.6 MySQL: 5.0.45 PHP: 5.2.5 Simple Invoices 12-31-07
you may have to enable the php extension xsl in your wamp configuration, im not infornt of a winxp machine at the moment so can;t tell you exactly how to do it
can anyone else with winxp let mttvnst know how to enable xsl?
Simpleinvoices version is latest downloaded from Sourceforge.
I have already enabled php_xsl in Wampserver and I am able to export an invoice in XSL format and open it in Microsoft excel. The extension php_xmlrpc is also enabled.
----- The error references the function on line 11 of the php file, that line is as follows:
I've upgraded from simpleinvoices-20070525.zip to simpleinvoices_20071231.zip and am getting the error above. Note that the reports all worked fine before my upgrade.
No matter which report I choose it fails with:
setUser($db_user); $oRpt->setPassword($db_password); $oRpt->setConnection($db_host); $oRpt->setDatabaseInterface("mysql"); // set as $db_server in trunk $oRpt->setDatabase($db_name); ?>
I'm using:
System info: LAMP Xen VM Apache: 2.0.59 MySQL: 5.0.45 PHP: 5.2.5 Simple Invoices 12-31-07
Should I take your recommendation and patch to the SVN?
I've upgraded from simpleinvoices-20070525.zip to simpleinvoices_20071231.zip and am getting the error above. Note that the reports all worked fine before my upgrade.
No matter which report I choose it fails with:
setUser($db_user); $oRpt->setPassword($db_password); $oRpt->setConnection($db_host); $oRpt->setDatabaseInterface("mysql"); // set as $db_server in trunk $oRpt->setDatabase($db_name); ?>
I'm using:
System info: LAMP Xen VM Apache: 2.0.59 MySQL: 5.0.45 PHP: 5.2.5 Simple Invoices 12-31-07
Should I take your recommendation and patch to the SVN?
Thanks.
Michael.
I upgraded to the SVN version and still get the error:
setUser($db_user); $oRpt->setPassword($db_password); $oRpt->setConnection($db_host); $oRpt->setDatabaseInterface("mysql"); // set as $db_server in trunk $oRpt->setDatabase($db_name); ?>
when attempting to access a report.
Anything I can do to help trouble-shoot this problem please let me know.
setUser($db_user); $oRpt->setPassword($db_password); $oRpt->setConnection($db_host); $oRpt->setDatabaseInterface("mysql"); // set as $db_server in trunk $oRpt->setDatabase($db_name); ?>
Patch to the latest SVN and see that the LOGGING variable exists in the system defaults table and is commented out in the config.inc.php Use all the default data in the sql tables. Hope you have set the variables correctly in the config/config.inc.php The upgrade should be a total wipe out and full upload. Also see that the cache folder is writeable by the webserver process. In windows it should generally be a non-issue.
Patch to the latest SVN and see that the LOGGING variable exists in the system defaults table and is commented out in the config.inc.php Use all the default data in the sql tables. Hope you have set the variables correctly in the config/config.inc.php The upgrade should be a total wipe out and full upload. Also see that the cache folder is writeable by the webserver process. In windows it should generally be a non-issue.
Checking LOGGING variable in the "si_system_defaults" table:
21 logging 0
Checking the config.php:
//To turn logging on set the below to true - not needed as it is set in System Defaults #define("LOGGING",false); #define("LOGGING",true);
cache folder writeable by the web server process:
drwxrwxrwx 2 apache apache 4096 Jan 21 11:23 cache
I'm not sure what you mean by "The upgrade should be a total wipe out and full upload.". I downloaded the latest SVN patch and copied across the files to the si web directory. I then logged into SI and ran the "Options -> Database Upgrade Manager".
When I go to any report I get:
setUser($db_user); $oRpt->setPassword($db_password); $oRpt->setConnection($db_host); $oRpt->setDatabaseInterface("mysql"); // set as $db_server in trunk $oRpt->setDatabase($db_name); ?>
I have placed the entire current release's SVN 1167 fileset temporarily here - 5.68MB Kindly download and setup the ./config/config.inc.php and make the ./cache and ./database_backups folders writeable by the webserver process. I would like to get to the bottom of this issue. It could be an issue with your register globals setting in php.ini. If you provide me putty / radmin / vnc access into the machine I can see what is wrong.
In the file ./include/reportlib.php you will find that we need to make a php.ini setting change. Incase your PHP installation does not allow you to dynamically make a temporary (script scope) php.ini parameter change, you will get this error.
In the reportlib.php file temporarily replace line 10 require_once("PHPReportMaker.php");withrequire_once("./library/phpreports/PHPReportMaker.php");
and see if you get any different errors. If so, it will mean that your php.ini file settings are not overrideable. In that case, locate the include path setting in the php.ini file in your server installation and hard code it to include the above path.
Hi Mttvnst I experienced the exact same problem using Wamp on WinXP with the SF 20071231 download. The hint lingered in that the unparsed code from the preceding include, 'reportlib.php', which is printed in the output. A bit of casual poking around and adding the missing 'php' to the script opening tag, '<?' {also then the same thing in 'reportrunlib.php'}, resolved the issue... The reason for this, be it errata or other, may be worth pondering :-) Hope this helps. -r
