Thread Rating:
  • 0 Vote(s) - 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.)
#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?
Reply


Messages In This Thread
Data issue with table reportlinks - by TurboPT - 05-29-2018, 10:58 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)