pdf invoice printing empty page with 'no record to display' [URGENT]

Hi guys,

I just deployed my new application on windows 2008 server, after run the pdf invoice printing, its showing the empty pdf file with top error message ‘no record to display’ :frowning:

its working fine on SC server, but not working on deployment server,
please help
thanks in advance…

environment:
windows server 2008
xampp windows server
installed jre

ahmer

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

Check directory rights where you are creating the PDF. (tmp, _libs, etc)

Regards,
Scott.

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

thanks scott,

its windows server 2008, and all the folders are writable also I did the double check in tmp folder its saving the .pdf file but the .pdf file its self empty, and only 1 message its showing “no record found to display”

also this is my first pdf-report, might I’m missing something else… is there any other tip, how to solve this issue, I also send the request to support and don’t know how will take to resolve this issue :frowning:

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

The only reason that I know of that will cause a blank report is:

-DIR Rights
-Wrong connection info to DB
-Bad SQL call

Regards,
Scott.

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

thanks scott;

I tested many times on my development server, after upload on client server its getting blank page

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

its something on your environment, check the configuration of your connection on your production environment

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

you are right, when I logged in through _lib and click on edit connection I got bunch of code top of the mysql icon

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\poss\_lib\prod\lib\php\devel\lib\php\base_ini.inc.php on line 78

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\poss\_lib\prod\lib\php\devel\lib\php\base_ini.inc.php on line 79

Deprecated: Function session_is_registered() is deprecated in D:\xampp\htdocs\poss\_lib\prod\lib\php\devel\lib\php\base_ini.inc.php on line 8

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\poss\_lib\prod\lib\php\devel\class\page
mPageAdminSysAllConectionsCreateWizard.class.php on line 115

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\poss\_lib\prod\lib\php\devel\class\page
mPageAdminSysAllConectionsCreateWizard.class.php on line 324

Deprecated: Assigning the return value of new by reference is deprecated in D:\xampp\htdocs\poss\_lib\prod\lib\php\devel\class\interface
mConnection.class.php on line 287

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

My development server I’m using php version 5.2.9 and MySQL version 5.1.33
and my deployment server I’m using php version 5.3.5 and MySQL version 5.5.8

what do you think, is this is the problem coz. I’m using higher version on deployment server.

I need very *** URGENT HELP *** is anyone can help about…
thank

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

I re-installed the web server with php ver 5.2, now my database connection error is gone, but still I’m not able to print the pdf invoice report, its showing me “no record found to display”

any clue…

tia
ahmer

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

-Turn on debugging in SC in your main app
-Check the mySQL error log.
-Create a simple app that executes the same SQL to a grid
-Create a simple app that executes the PDF report

Regards,
Scott

Re: pdf invoice printing empty page with ‘no record to display’ [URGENT]

thanks Mr. Martin,

I redesign the report, with simple SQL before I was using join condition, and thats the reason I was loosing the record and pdf-report was displaying the blank pdf file without the background image…

thanks a lot…
ahmer