Welcome to the nuBuilder forums!

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

Transaction Error in Report builder

Post Reply
chrisb
Posts: 12
Joined: Mon Oct 29, 2012 5:18 am

Transaction Error in Report builder

Unread post by chrisb »

I'm trying to create a report. I've got the forms put together and created an SQL query that works. However, when I try to run the report, I get the following:
SELECT ``.* FROM `` WHERE = '150d680184d5bf'
The SQL query looks like this:
$s = "CREATE TABLE #dataTable# SELECT * ";
$s .= "FROM result ";
$s .= "LEFT JOIN team ON res_team_id = team_id ";
$s .= "LEFT JOIN wl ON res_winloss_wl_id = wl_id ";
$s .= "LEFT JOIN location ON res_homeVist = loc_id ";
$s .= "ORDER BY res_date ASC , res_gameNumber ASC ";

nuRunQuery ($s);
Any help would be great. (Also, if there is a more indepth tutorial on the report, I'd love that.)
chrisb
Posts: 12
Joined: Mon Oct 29, 2012 5:18 am

Re: Transaction Error in Report builder

Unread post by chrisb »

Sorry to double post. I'm new at PHP, but love the possibilities of this app. Revised my SQL query to make it only select * from one table. Now I get this error:
Fatal error: Class 'Reporting' not found in /Applications/AMPPS/www/nubuilder/productionnu2/runreport.php on line 33
.
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Transaction Error in Report builder

Unread post by admin »

chrisb,

Have you designed the look for the report?

It sounds like there is some field in the report builder it doesn't like.

I suggest cloning the report and removing a field at at time until works.

Let us know if you find the answer so I can stop it happening in future versions.

Steven
Post Reply