Database error after deleting copied report

Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Database error after deleting copied report

Post by Eddy »

I copied an existing report using the extension common reports copy function, as per picture:
The attachment Annotation 2019-07-17 135025.png is no longer available
Then I tried to delete the report and, accounts that are members of the report's access group, get the following database error:
Annotation 2019-07-17 135025.png
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
Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Re: Database error after deleting copied report

Post by Eddy »

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
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database error after deleting copied report

Post by support »

Can you provide screenshot with error, please?
Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Re: Database error after deleting copied report

Post by Eddy »

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
Attachments
Annotation 2019-07-17 093344.png
Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Re: Database error after deleting copied report

Post by Eddy »

What I am doing is deleting a copy of the plan cut-off report
figure2.png
Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Re: Database error after deleting copied report

Post by Eddy »

Users members of the original report access groups also get the same error
figure5.png
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database error after deleting copied report

Post by support »

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.
Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Re: Database error after deleting copied report

Post by Eddy »

I sent you the database in a PM and here is also the full screen picture.
screen.png
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database error after deleting copied report

Post by support »

File from archive replace to includes\classes\reports\
This should fix problem. Let me know.
Attachments
reports.zip
(8.04 KiB) Downloaded 145 times
Eddy
Posts: 121
Joined: 28 Dec 2017, 03:38
Name: Eduardo
Location: UK

Re: Database error after deleting copied report

Post by Eddy »

All sorted... It works okay.
Post Reply