Suddenly the BackLinks plugin is reporting each referring page 4 times (and the corresponding tally is 4x the true value).
I've recently been going through a painful process of upgrading mysql to 4.1.1 without fallout onto the applications. That's the only thing I've done recently, though I don't know if the upgrade or process caused this.
Looking in the 'page' table, I see only one row for each page, not 4.
Any page created or edited after the mysql upgrade comes up only once.
I suppose I can go ahead and make minor edits to each of the old pages... but does anyone have a better explanation/solution?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Non-urgent question:
Suddenly the BackLinks plugin is reporting each referring page 4 times (and the corresponding tally is 4x the true value).
I've recently been going through a painful process of upgrading mysql to 4.1.1 without fallout onto the applications. That's the only thing I've done recently, though I don't know if the upgrade or process caused this.
Looking in the 'page' table, I see only one row for each page, not 4.
Any page created or edited after the mysql upgrade comes up only once.
I suppose I can go ahead and make minor edits to each of the old pages... but does anyone have a better explanation/solution?
Never mind... Apparently I must have tried to restore the db backup multiple times... the 'link' table had multiple duplicate rows.
Solved it by creating a copy of 'link', performing an "insert...select unique" from 'link' into it, and replacing 'link' with the new table.
I suggest that some kind of uniqueness constraint on 'link' (e.g. "... primary key (linkfrom,linkto)") be added to the table def for 'link'.