Install Permissions issue?

[rfeltham]

Having installed nuBuilder Forte, I am having some issues that make me wonder if I am doing it wrong, or my install is suffering a permissions issue.
I have watched the videos, and read the forums, been through the wiki, and feel that I am missing some intended portion of the overall design.

I can connect to the database, the browse works and brings up the edit form.

The issue is that the reports comes up as a blank screen.
(Other possible symptoms are that Clone works on about half the items.)

I have been testing my nuSQL procedures by creating them and then making a fast report; unless my SQL code is "SELECT patients.* from patients" with no JOIN, no WHERE, I do not even get a list of fields the "Available Fields" window. If I create that Fast reports (with the simplified SELECT) with a bunch of fields, and Run Report, that page is still blank.



Some things I think I am missing:
On the Report editor, there is a Launch From. I am uncertain what the purpose is. nuBlank blank? patient browse form?

I need to be able to email reports (hopefully automatically from an email field?) but have not been able to test this since my reports screen is blank, so I don't know how that works.

I would like to have a form with a SQL query window that updates the contents of a browse subform. I have tried putting code on a button, but it does not seem to work.

I would like to be able to use that browse subform as the data for a report. I assume I should be able to use a button to launch that (set the report as the Run item), but how does the data transfer?

Are there any examples of buttons that update a text field, or update a browse field from the SQL query in a ext field?

Is it possible to download a copy of the Invoices example from the video, so I can verify that my install is functioning right?

Current install:
WAMP - Apache 2.4.35, MySQL 5.7.23, PHP 5.5.38 (Had issues with 7.0.32, .1.22, .2.10), myPHPadmin4.8.3
Latest nuBuilder (did an update)

Having been poking at this for 3 weeks, I feel I have made great progress, but the reports thing is a deal breaker, email might be as well.

Thanks in advance for any advice or suggestions.

Richard F.

[kev1n]

Hi,

Do you see an error message in nuDebug Results or in the PHP log files?

You could try the solutions suggested in these threads:
https://forums.nubuilder.cloud/viewtopic.php?f=21&t=9507

[rfeltham]

there is nothing in the PHP logs, nor in nuDebug.

I spun up an AMPP install on a Mac, and installed nuBuilder on there. I created a simple form, simple select all s=query, simple report to use that query. It also generates a blank page, no nuDebug errors, no PHP errors.
(AMPPS Version 4.9.3
PHP Version 5.6.31)

This would indicate it is not a Windows install version issue.


Is there a way to import the Inventory example from the video to see if that works, and if so, see what the difference is?

Richard F.

[kev1n]

Sample Applications can be downloaded here:
https://www.nubuilder.com/downloads

[rfeltham]

It appears that my issues resolved down to the browser blocking popups.

I was still interested in downloading a sample application.
There are 4 at https://www.nubuilder.com/downloads
CRM System
Invoicing System
User Guide Tables
Browse Screen Example.

I tried all but the User Guide Table.
Only the Browse Screen Example shows a form Off the Home screen.
I looked at the SQL files in the ZIP for CRM and Invoicing, and there does not aPPEr to be any tables other than the standard nuBuilder tables, where the Browse added a 'product' table.
I did not see any php code, forms or buttons that would relate to invoicing or CRM for the other 2.

Is that expected behaviour?

R