View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000236 | XMB1 | Bugs | public | 2008-12-31 11:52 | 2009-02-05 07:13 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.11 Beta 3 | ||||
| Target Version | 1.9.11 | Fixed in Version | 1.9.11 | ||
| Summary | 0000236: tools.php?action=fixlastposts Doesn't Fix All Threads | ||||
| Description | The reply count gets reset to -1 and the lastpost value to '||'. tools.php?action=fixttotals is also affected. | ||||
| Additional Information | Official Schema Change: ALTER TABLE `xmb_logs` ADD INDEX ( `tid` ), ADD INDEX ( `date` ) | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | Schema Updates | ||||
| Original Reporter | |||||
| SVN Revision | 1671 | ||||
| Git Commit | |||||
|
|
False alarm. This behavior only occurs if the post created during the move becomes orphaned. |
|
|
Something still seems screwy here. Even with a corrupted lastpost value, the fixlastpost tool should be able to fix this. |
|
|
I confirmed there is a problem with the join between threads and logs. When I ran EXPLAIN on even a simplified version of the fixlastposts query, MySQL barfed this up every time: "Impossible WHERE noticed after reading const table..." Also, the query is using filesort and all sorts of other crazy things. I suspect a schema change is needed to optimize the sub-queries we are using on the logs table in 1.9.11. |
|
|
Next problem: Topicadmin is setting a zero value in the dateline field for the post it inserts when redirecting a thread. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2008-12-31 11:52 | miqrogroove | New Issue | |
| 2008-12-31 11:52 | miqrogroove | Status | new => assigned |
| 2008-12-31 11:52 | miqrogroove | Assigned To | => miqrogroove |
| 2008-12-31 12:24 | miqrogroove | Note Added: 0000119 | |
| 2008-12-31 12:24 | miqrogroove | Status | assigned => resolved |
| 2008-12-31 12:24 | miqrogroove | Resolution | open => unable to reproduce |
| 2009-01-07 21:51 | miqrogroove | Status | resolved => closed |
| 2009-01-16 23:26 | miqrogroove | Note Added: 0000131 | |
| 2009-01-16 23:26 | miqrogroove | Status | closed => feedback |
| 2009-01-16 23:26 | miqrogroove | Resolution | unable to reproduce => reopened |
| 2009-01-17 01:16 | miqrogroove | Flags | => Schema Updates |
| 2009-01-17 01:16 | miqrogroove | Note Added: 0000132 | |
| 2009-01-17 01:16 | miqrogroove | Status | feedback => assigned |
| 2009-01-17 01:16 | miqrogroove | Projection | none => minor fix |
| 2009-01-17 01:16 | miqrogroove | ETA | none => < 1 day |
| 2009-01-17 01:16 | miqrogroove | Summary | updatethreadcount() Corrupts Moved Threads => tools.php?action=fixlastposts Doesn't Fix All Threads |
| 2009-01-17 01:21 | miqrogroove | Product Version | 1.9.8 SP2 => 1.9.11 Beta 3 |
| 2009-01-17 01:33 | miqrogroove | Note Added: 0000133 | |
| 2009-01-17 02:00 | miqrogroove | Additional Information Updated | |
| 2009-01-17 05:29 | miqrogroove | SVN Revision | => 1671 |
| 2009-01-17 05:29 | miqrogroove | Status | assigned => resolved |
| 2009-01-17 05:29 | miqrogroove | Fixed in Version | => 1.9.11 |
| 2009-01-17 05:29 | miqrogroove | Resolution | reopened => fixed |
| 2009-02-05 07:13 | miqrogroove | Status | resolved => closed |
