View Issue Details

IDProjectCategoryView StatusLast Update
0000426XMB1Bugspublic2011-02-11 09:45
Reportermiqrogroove Assigned Tomiqrogroove  
PrioritynormalSeveritymajorReproducibilityrandom
Status closedResolutionfixed 
Target Version1.9.11.11Fixed in Version1.9.11.11 
Summary0000426: Strange db.php Errors When Posting Replies
DescriptionI've seen this error on two different servers now, but I have no idea what the underlying cause is yet:

MySQL encountered the following error: mysql_result(): Unable to jump to row 0 on MySQL result index 49 in $db->result() called by post.php on line 569
TagsNo tags attached.
MySQL Version
PHP Version
Web Server
Browser
Flags
Original Reporter
SVN Revision2441

Relationships

child of 0000408 closedmiqrogroove MySQL 5.5 Compatibility 

Activities

miqrogroove

2011-01-28 14:24

administrator   ~0000290

Well now this is getting really weird. I stubbed in a line to record the actual query, and this is what XMB generated:

SELECT dateline FROM xmb_posts WHERE tid='11' AND pid < 0 ORDER BY dateline DESC LIMIT 1

o_O

miqrogroove

2011-01-28 14:53

administrator   ~0000291

This was caused by revision 2411. It does not affect any releases.

Issue History

Date Modified Username Field Change
2011-01-28 14:20 miqrogroove New Issue
2011-01-28 14:24 miqrogroove Note Added: 0000290
2011-01-28 14:53 miqrogroove SVN Revision => 2441
2011-01-28 14:53 miqrogroove Note Added: 0000291
2011-01-28 14:53 miqrogroove Status new => resolved
2011-01-28 14:53 miqrogroove Fixed in Version => 1.9.11.11
2011-01-28 14:53 miqrogroove Resolution open => fixed
2011-01-28 14:53 miqrogroove Assigned To => miqrogroove
2011-01-28 14:53 miqrogroove Relationship added child of 0000408
2011-02-11 09:45 miqrogroove Status resolved => closed