Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Reports missing table info
Reports missing table info
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???
-
- nuBuilder Team
- Posts: 4416
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 74 times
- Been thanked: 472 times
- Contact:
Re: Reports missing table info
Are there any errors?
Please also provide a screenshot.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
Re: Reports missing table info
No errors shown on the console and here's a screen shot.
You do not have the required permissions to view the files attached to this post.
Re: Reports missing table info
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
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'WCBBQ_DB.zzzzsys_report_data' doesn't exist
Re: Reports missing table info
I seem to have fixed it by recreating the views for object_list and report_data.