View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000454 | XMB1 | Bugs | public | 2011-04-08 18:02 | 2012-03-03 09:36 |
| Reporter | miqrogroove | Assigned To | miqrogroove | ||
| Priority | normal | Severity | minor | Reproducibility | random |
| Status | closed | Resolution | fixed | ||
| Product Version | 1.9.8 SP2 | ||||
| Target Version | 1.9.11.13 | Fixed in Version | 1.9.11.13 | ||
| Summary | 0000454: Rare but persistent errors in post.php | ||||
| Description | One of our big boards, Exhale, throws this error about once every day on average: [10-Mar-2011 21:41:17] MySQL encountered the following error: mysql_result() Unable to jump to row 0 on MySQL result index 27 in $db->result() called by post.php on line 608 Line 608 on this board corresponds to: $date = $db->result($db->query("SELECT dateline FROM ".X_PREFIX."posts WHERE tid='$tid' AND pid < $pid ORDER BY dateline DESC LIMIT 1"), 0); | ||||
| Steps To Reproduce | Create a new thread, say tid = 999. Run custom SQL: DELETE FROM xmb_posts WHERE tid = 999; View the new thread and try to reply to it. | ||||
| Tags | No tags attached. | ||||
| MySQL Version | |||||
| PHP Version | |||||
| Web Server | |||||
| Browser | |||||
| Flags | |||||
| Original Reporter | |||||
| SVN Revision | 2640 | ||||
|
|
It looks like this problem went away after running MySQL optimize. |
|
|
This error can be triggered by flooding the SQL layer. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-04-08 18:02 | miqrogroove | New Issue | |
| 2011-04-15 12:17 | miqrogroove | Note Added: 0000307 | |
| 2011-04-15 12:17 | miqrogroove | Status | new => resolved |
| 2011-04-15 12:17 | miqrogroove | Resolution | open => unable to reproduce |
| 2011-04-15 12:17 | miqrogroove | Assigned To | => miqrogroove |
| 2011-05-29 14:05 | miqrogroove | Status | resolved => closed |
| 2011-09-15 10:58 | miqrogroove | Note Added: 0000323 | |
| 2011-09-15 10:58 | miqrogroove | Status | closed => feedback |
| 2011-09-15 10:58 | miqrogroove | Resolution | unable to reproduce => reopened |
| 2011-09-15 11:58 | miqrogroove | Status | feedback => confirmed |
| 2011-09-15 11:58 | miqrogroove | Product Version | 1.9.11.11 => 1.9.8 SP2 |
| 2011-09-15 11:58 | miqrogroove | Target Version | => 1.9.11.13 |
| 2011-09-15 11:58 | miqrogroove | Steps to Reproduce Updated | |
| 2011-09-20 18:19 | miqrogroove | SVN Revision | => 2640 |
| 2011-09-20 18:19 | miqrogroove | Status | confirmed => resolved |
| 2011-09-20 18:19 | miqrogroove | Fixed in Version | => 1.9.11.13 |
| 2011-09-20 18:19 | miqrogroove | Resolution | reopened => fixed |
| 2012-03-03 09:36 | miqrogroove | Status | resolved => closed |
