Page 1 of 1
Problem running report on web site
Posted: Thu Feb 14, 2013 4:19 am
by JohnKlassen
Hi,
I have a letter that I created as a report. When I run the report on my laptop, I have no problems. When I run the report on my client's web site, I get the following error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING in /home/content/08/10090408/html/productionnu2/runpdf.php(35) : eval()'d code on line 3
Fatal error: Class 'Reporting' not found in /home/content/08/10090408/html/productionnu2/runpdf.php on line 36
This is the only report (out of about 15) where I have this problem.
Any ideas what might be causing this?
Thanks,
John
Re: Problem running report on web site
Posted: Thu Feb 14, 2013 4:26 am
by admin
John,
Capture.PNG
Line 3 of your php code has a problem.
Steven
Re: Problem running report on web site
Posted: Sun Feb 17, 2013 11:48 pm
by JohnKlassen
Steven,
I am still getting the same error despite changing the code. This error is very simiiar to the original one.
Parse error: syntax error, unexpected T_NS_SEPARATOR, expecting T_STRING in /home/content/08/10090408/html/productionnu2/runreport.php(32) : eval()'d code on line 3
Fatal error: Class 'Reporting' not found in /home/content/08/10090408/html/productionnu2/runreport.php on line 33
The original code started with:
Code: Select all
/* Logic for Notice Letters */
nuRunQuery(
<<<EOSQL
CREATE TABLE #dataTable#
SELECT
violations.vio_building_unit,
violations.vio_printable_information,
people.people_id,
people.peo_building_unit,
I changed the code to the following 2 lines:
Code: Select all
$sql = "CREATE TABLE #dataTable# ";
nuRunQuery($sql);
Since I still got the same error, I removed ALL of the code from the PHP Code section for the report and got the error message at the top of today's post.
What is interesting is that when the only code I had was
Code: Select all
$sql = "CREATE TABLE #dataTable# ";
nuRunQuery($sql);
that after I saved it and looked at it again, there were slashes before each double quote as follows:
Code: Select all
$sql = \"CREATE TABLE #dataTable# \";
nuRunQuery($sql);
Since I have other reports that have similiar PHP code that don't have a problem, is it possible the problem is in the Report Builder? On the other hand this same report works fine when I run it on my laptop.
Any ideas?
John
Re: Problem running report on web site
Posted: Mon Feb 18, 2013 12:25 am
by admin
Re: Problem running report on web site
Posted: Tue Feb 19, 2013 5:36 am
by JohnKlassen
Steven,
After adding magic_quotes_gpc = off to php.ini on the web server, I get the following error when I use 'Add Activity' to access the report:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 15560434 bytes) in /home/content/08/10090408/html/productionnu2/common.php on line 847
. When I use 'Run Activity' against the report, I get the same errors as before:
Parse error: syntax error, unexpected T_NS_SEPARATOR, expecting T_STRING in /home/content/08/10090408/html/productionnu2/runreport.php(32) : eval()'d code on line 3
Fatal error: Class 'Reporting' not found in /home/content/08/10090408/html/productionnu2/runreport.php on line 33
I just tried 'Add Activity and 'Run Activity' on 4-5 other reports without any problems.
Since this only happens with this one report, I am tempted to just delete the report and recreate it unless you have another suggestion.
John
Re: Problem running report on web site
Posted: Fri Feb 22, 2013 7:00 am
by admin
John,
I don't know, maybe give it a go.
Steven
Re: Problem running report on web site
Posted: Mon Mar 04, 2013 5:25 am
by JohnKlassen
Steven,
I deleted the report and recreated it. It works fine now.
You can close this entry.
Thanks for your help.
John
Re: Problem running report on web site
Posted: Wed Mar 06, 2013 12:32 am
by admin
.