View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000227 | WackoWiki | core | public | 2008-09-08 12:12 | 2009-08-19 09:38 |
| Reporter | Tann San | Assigned To | Tann San | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.2 | ||||
| Target Version | 4.3.rc | Fixed in Version | 4.3.rc | ||
| Summary | 0000227: Wanted Pages list has wrong count for referrers | ||||
| Description | Say it lists pages like: Dogs (20) Cats (30) Fishies (10) Those counts will be wrong. Something is funky in the SQL code. | ||||
| Tags | No tags attached. | ||||
|
|
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: GROUP BY tag 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. |
| 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 |
