webERP Forum
Data issue with table reportlinks - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Development Discussion & Specification (http://www.weberp.org/forum/forumdisplay.php?fid=10)
+--- Thread: Data issue with table reportlinks (/showthread.php?tid=8168)



Data issue with table reportlinks - TurboPT - 05-29-2018

During install, investigating why the inserts to reportlinks took so long (or at least why there were so many)...

Not sure how/when this potentially started, but I've discovered that there are 226 unique entries in the reportlinks table that are duplicated 12 times. So, instead of only 226 inserts during install, there are 2,712 insertions.

This can be verified with this SQL:
Code:
SELECT * FROM reportlinks GROUP BY table1, table2, equation;
or this SQL:
Code:
SELECT table1, table2, equation, count(*) as '#entries' FROM reportlinks GROUP BY 1, 2, 3;

Part of the problem is that there is not any unique index on this table, so that is how this could easily happen. I can fix this with the 4.15.1 update, unless there is some other reason the table is this way that I might not be aware?