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: 205
- 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: 3858
- 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
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
-
- Posts: 205
- Joined: Mon May 18, 2020 12:02 am
- Contact:
-
- Posts: 205
- 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: 205
- 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.