Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data issue with table reportlinks
05-29-2018, 10:58 AM (This post was last modified: 05-29-2018 12:17 PM by TurboPT.)
Post: #1
Data issue with table reportlinks
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?
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)