Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Reports missing table info
-
- Posts: 155
- Joined: Mon May 18, 2020 12:02 am
- Contact:
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: 3114
- Joined: Sun Oct 14, 2018 6:43 pm
- nuBuilder Version: 4.5
- Been thanked: 4 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
If you like nuBuilder, please leave a review on SourceForge
How to support nuBuilder?
nuBuilder 4.5. Code Library
Installation Guides
Updating nuBuilder
How to support nuBuilder?
nuBuilder 4.5. Code Library
Installation Guides
Updating nuBuilder
-
- Posts: 155
- Joined: Mon May 18, 2020 12:02 am
- Contact:
-
- Posts: 155
- Joined: Mon May 18, 2020 12:02 am
- Contact:
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
-
- Posts: 155
- Joined: Mon May 18, 2020 12:02 am
- Contact:
Re: Reports missing table info
I seem to have fixed it by recreating the views for object_list and report_data.