Welcome to the nuBuilder forums!

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

Reports missing table info

Questions related to installing, updating, setting up and configuring
Post Reply
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Reports missing table info

Unread post by treed »

After upgrading the system, now all my reports in the report designer are missing the table info. The add function does not show the SQL queries that are setup in the system. When creating a new query it is not saved with the report. Existing reports still work, but can't be modified. Ideas???
kev1n
nuBuilder Team
Posts: 3801
Joined: Sun Oct 14, 2018 6:43 pm
nuBuilder Version: 4.5
Has thanked: 2 times
Been thanked: 9 times
Contact:

Re: Reports missing table info

Unread post by kev1n »

Are there any errors?
If you encounter an issue, be sure to check the developer console for errors by clicking the `F12` key on most browsers.
Also open nuDebug results (CTRL+SHIFT+D) and check your (Apache) server logs
Please also provide a screenshot.
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: Reports missing table info

Unread post by treed »

No errors shown on the console and here's a screen shot.
screen.png
screen.png (36.92 KiB) Viewed 3308 times
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: Reports missing table info

Unread post by treed »

Didn't think to look on the debug window, but here's the issue.
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'WCBBQ_DB.zzzzsys_report_data' doesn't exist
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: Reports missing table info

Unread post by treed »

I seem to have fixed it by recreating the views for object_list and report_data.
Post Reply