Page 1 of 1
Report generates empty page
Posted: Mon Dec 23, 2013 11:58 am
by johnbertell
Hi,
I am trying to build reports for my application but have struggled. Right now my nuBuilder only generates absolutely empty pages for the reports I built. I have tried installing the samplefinancial, and I get the same result on the reports which are there. When I press 'Print to screen' from the criteria form it generates an empty browser. The page source of the new browser page is completely empty. Exactly the same result from Print to PDF.
Anyone having a good idea where I should start troubleshooting?
John
Re: Report generates empty page
Posted: Tue Dec 24, 2013 3:39 am
by massiws
johnbertell, based on my experience, white pages often result from errors in PHP code.
Some suggestions:
- are you sure about minimal resources required by nuBuilder? (see here);
- are you sure your code in Report Builder is working right?
- are you able to build the #dataTable# with all data you need on the report?
Max
Re: Report generates empty page
Posted: Tue Dec 24, 2013 1:37 pm
by johnbertell
Thanks Max for quick response.
- I have the min resources configured just like in the link you sent me
- I am new to using the reports, so this was my first thought. That is why I installed the samplefinancial and tested the reports which exist there. And they produce the same result. Just for testing I made a very simple report with as little possibility for error as possible showing only one field and one label.
- This is the php code for my simple test report:
Code: Select all
$str = "CREATE TABLE #dataTable# SELECT NOW() AS d ";
nuRunQuery($str);
I have tried to get the sql statement debugged there also, but it will not bring up the debug window.
John
Re: Report generates empty page
Posted: Wed Dec 25, 2013 1:00 pm
by johnbertell
This seem to be the error. I get the same on two of my Linux machines (UBUNTU) but not on the third one.
Code: Select all
Wed Dec 25 13:54:08.310141 2013] [:error] [pid 22959] [client 10.102.164.74:44039] PHP Fatal error: Cannot redeclare hex2bin() in /var/www/productionnu2/report_object.php on line 240, referer: http://10.64.0.115/productionnu2/form.php?x=1&f=run&r=152b98294d2234&dir=db/tankbulk&fly=&ses=152bac727e0e1f&BF=&newwin=0&historySession=152bac72aacef3&historyIndex=2&historyLocation=QnJvd3NlfHx8UnVuIEFjdGl2aXR5|||aHR0cDovLzEwLjY0LjAuMTE1L3Byb2R1Y3Rpb25udTIvYnJvd3NlLnBocD94PTEmcD0xJmY9cnVuJnM9Jm51b3BlbmVyPTE1MmJhYzcyYWE2NDNjJnByZWZpeD0mZGlyPWRiL3RhbmtidWxrJnNlcz0xNTJiYWM3MjdlMGUxZiZmb3JtX3Nlcz0mbG9va3VwX2NvZGU9Jmhpc3RvcnlTZXNzaW9uPTE1MmJhYzcyYWFjZWYzJmhpc3RvcnlJbmRleD0xJmhpc3RvcnlMb2NhdGlvbj1mSHg4U0U5TlJRPT18fHxhSFIwY0Rvdkx6RXdMalkwTGpBdU1URTFMM0J5YjJSMVkzUnBiMjV1ZFRJdlptOXliUzV3YUhBL2VEMHhKbVk5YVc1a1pYZ21jajB0TVNaa2FYSTlaR0l2ZEdGdWEySjFiR3NtYzJWelBURTFNbUpoWXpjeU4yVXdaVEZtSm5SaFlqMHomdGFiPTA=
John
Re: Report generates empty page
Posted: Wed Dec 25, 2013 1:17 pm
by johnbertell
Now got it fixed, here is the solution. Appearently a problem everyone with PHP 5.4 or newer versions will have.
http://forums.nubuilder.cloud/viewtopic.p ... in+#p11827
John
Re: Report generates empty page
Posted: Wed Dec 25, 2013 8:00 pm
by massiws
John, sorry for delay: are your reports working fine now?
Re: Report generates empty page
Posted: Thu Dec 26, 2013 10:26 pm
by johnbertell
Yes, thank you Max. With this fix they work fine.
John
Re: Report generates empty page
Posted: Fri Dec 27, 2013 12:29 am
by massiws
.