I copied an existing report using the extension common reports copy function, as per picture:
Then I tried to delete the report and, accounts that are members of the report's access group, get the following database error:
Accounts that are not part of the report's access group are not affected.
The issue is also linked to the dashboard. If the original report was displayed in the dashboard the error comes up. In my case, the original report display a counter in the dashboard and also as a notification in the header.
I restored the database from a backup and deleted the original report instead of the copy and still had the same problem.
I restored the database from a backup again also tried modifying the report's configuration before deleting it. I removed the ticks from the header and dashboard but still had the same database error problem.
If I copy and then delete a report that was not originally shown in the dashboard the error doesn't happen.
Please let me know if further details are required.
System:
PHP Version 7.2.19-0ubuntu0.18.04.1
Apache 2.0
Rukovoditel 2.5.1
Extension 2.5.1
Database error after deleting copied report
Re: Database error after deleting copied report
Hi Sergey
I am wondering if this is an issue related to my database configuration (selection of tables and fields). I have tried several things but haven't managed to fix it and honestly don't think that I did something to corrupt the database. My guess is that the delete method is not completing successfully.
If it helps I can provide a copy of my database for debugging purposes via private message, together with instructions of what I am doing to reproduce the error message. Will it help?
Thanks
I am wondering if this is an issue related to my database configuration (selection of tables and fields). I have tried several things but haven't managed to fix it and honestly don't think that I did something to corrupt the database. My guess is that the delete method is not completing successfully.
If it helps I can provide a copy of my database for debugging purposes via private message, together with instructions of what I am doing to reproduce the error message. Will it help?
Thanks
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database error after deleting copied report
Can you provide screenshot with error, please?
Re: Database error after deleting copied report
This is the error. I have tried twice to load more pictures with the steps but the forum GUI says that the attachment is not available
Re: Database error after deleting copied report
What I am doing is deleting a copy of the plan cut-off report
Re: Database error after deleting copied report
Users members of the original report access groups also get the same error
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database error after deleting copied report
Can you show me full page with error. I need to see where it placed.
Or can you send me backup of your database in PM. I will check it. It will be faster to fix I think.
Or can you send me backup of your database in PM. I will check it. It will be faster to fix I think.
Re: Database error after deleting copied report
I sent you the database in a PM and here is also the full screen picture.
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database error after deleting copied report
File from archive replace to includes\classes\reports\
This should fix problem. Let me know.
This should fix problem. Let me know.
- Attachments
-
- reports.zip
- (8.04 KiB) Downloaded 145 times
Re: Database error after deleting copied report
All sorted... It works okay.