Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Problem running report on web site

Locked
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Problem running report on web site

Unread post 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
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Problem running report on web site

Unread post by admin »

John,
Capture.PNG
Capture.PNG (4.99 KiB) Viewed 9211 times
Line 3 of your php code has a problem.

Steven
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Re: Problem running report on web site

Unread post 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
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Problem running report on web site

Unread post by admin »

JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Re: Problem running report on web site

Unread post 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
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Problem running report on web site

Unread post by admin »

John,

I don't know, maybe give it a go.

Steven
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Re: Problem running report on web site

Unread post by JohnKlassen »

Steven,

I deleted the report and recreated it. It works fine now.

You can close this entry.

Thanks for your help.

John
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Problem running report on web site

Unread post by admin »

.
Locked