View Issue Details

IDProjectCategoryView StatusLast Update
0000227WackoWikicorepublic2009-08-19 09:38
ReporterTann San Assigned ToTann San  
Status resolvedResolutionfixed 
Product Version4.2 
Target Version4.3.rcFixed in Version4.3.rc 
Summary0000227: Wanted Pages list has wrong count for referrers
DescriptionSay it lists pages like:

Dogs (20)
Cats (30)
Fishies (10)

Those counts will be wrong. Something is funky in the SQL code.
TagsNo tags attached.


Tann San

2008-09-08 12:33

manager   ~0000501

The problem was that we did this:

SELECT DISTINCT wackos_links.to_tag AS tag

at the start of the SQL line. Then later on we did:


This caused a confused state in SQL where it would use the incorrect "tag" field from one of the tables and not our localised temp column name. The simple fix was to rename it in those two segments as well as on the actions/wanted.php file. Once that was done it showed a whole load of results wereas before I only saw one with a combined total count.

Issue History

Date Modified Username Field Change
2008-09-08 12:12 Tann San New Issue
2008-09-08 12:12 Tann San Legacy => NEW
2008-09-08 12:13 Tann San Target Version => 5.0.0
2008-09-08 12:31 Tann San Status new => assigned
2008-09-08 12:31 Tann San Assigned To => Tann San
2008-09-08 12:33 Tann San Note Added: 0000501
2008-09-08 12:33 Tann San Status assigned => resolved
2008-09-08 12:33 Tann San Fixed in Version => 5.0.0
2008-09-08 12:33 Tann San Resolution open => fixed
2009-08-19 09:25 administrator Fixed in Version 5.0.0 => 4.3.rc
2009-08-19 09:38 administrator Target Version 5.0.0 => 4.3.rc
2010-03-08 10:12 administrator Category Core => core