View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000308 | XMB1 | Bugs | public | 2009-03-19 09:37 | 2010-01-23 18:18 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | random |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.11 | ||||
| Target Version | 1.9.11.05 | Fixed in Version | 1.9.11.05 | ||
| Summary | 0000308: Fix Last Posts Still Not Working Right | ||||
| Description | Urghhh. I don't know what the problem is yet, but there are still some forum values not being reset by this tool when they should be. | ||||
| Steps To Reproduce | Edit the lastpost value for a forum that has populated subforums but no posts at the top forum level. Then try to restore the lastpost value using Fix Last Posts. | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 1819 | ||||
| related to | 0000317 | closed | miqrogroove | Zero Count Flaws in fixftotals and fixmposts |
|
|
It appears that although the "Update all threads" query tolerates xmb_threads INNER JOIN xmb_posts nicely, the "Update all forums" query does not. It needs to return all forums so that all forums can be updated. Therefore, the table joins need to be nested 4-deep for accuracy and efficiency. I know this could be treated as only 2 unique domains in Jet SQL, but those tricks don't seem to be available here. As long as I'm monkeying around in there, I think it's a good opportunity to reduce this entire mess to a single SELECT query. |
|
|
It might have been possible to eliminate one of the subqueries by using a RIGHT JOIN syntax, but at this point it is more important for the code to make sense and be easy to maintain. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-03-19 09:37 | miqrogroove | New Issue | |
| 2009-03-19 09:37 | miqrogroove | Status | new => assigned |
| 2009-03-19 09:37 | miqrogroove | Assigned To | => miqrogroove |
| 2009-03-19 10:26 | miqrogroove | Note Added: 0000185 | |
| 2009-03-19 10:26 | miqrogroove | Projection | none => minor fix |
| 2009-03-19 10:26 | miqrogroove | ETA | none => < 1 day |
| 2009-03-19 10:26 | miqrogroove | Steps to Reproduce Updated | |
| 2009-03-19 11:47 | miqrogroove | SVN Revision | => 1819 |
| 2009-03-19 11:47 | miqrogroove | Note Added: 0000186 | |
| 2009-03-19 11:47 | miqrogroove | Status | assigned => resolved |
| 2009-03-19 11:47 | miqrogroove | Fixed in Version | => 1.9.11.05 |
| 2009-03-19 11:47 | miqrogroove | Resolution | open => fixed |
| 2009-03-23 04:17 | miqrogroove | Relationship added | related to 0000317 |
| 2010-01-23 18:18 | miqrogroove | Status | resolved => closed |
