Issue: AJAX Reply SQL Error 1064

Issue Tools
- View Changes

August 8, 2008 12:44 PM

pegasus

VaultWiki Team

AJAX Reply SQL Error 1064

It's still happening.

The page refresh on AJAX Quick Reply that then displays the double post error redirect.

This error is even more obscure than the Auto Link one. We know why it happens: $threadinfo['threadid'] turns NULL between newpost_complete and newreply_post_ajax. The culprit, however, is elusive, because we made sure for the stable release to only replace values with non-NULL values.

The main problem with being able to locate the exact source of the problem is that the error does not occur consistently, but seemingly randomly. One can use AJAX Quick Reply many times without a problem.

Issue Details

Issue Number 165

Issue Type Bug

Project VaultWiki 3.x Series

Category Editing / Posting Articles

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 2.1.2

Fixed Version 2.1.3

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 9, 2008 3:55 PM

pegasus

VaultWiki Team

So after all this time: http://www.vbulletin.com/forum/proje...?issueid=26026

In our tests we determined that $threadinfo['threadid'] turns NULL when the hook newpost_complete finishes. Since $threadinfo['threadid'] is valid on the line before this, we can assume that this may even be a PHP or memory bug, where the server just randomly forgets the value.

Reply
September 1, 2008 2:23 PM

pegasus

VaultWiki Team

Since vBulletin 3.7.3, this bug has been suppressed further by an additional check in vB's code. It is invisible to a forum user, and until more information becomes available regarding the exact cause, it should just be ignored.

Reply
December 7, 2008 2:29 PM

pegasus

VaultWiki Team

After almost two months of happy 3.7.3/4 usage, we upgraded to vBulletin 3.8 and had to deal with this again. It seemed to happen when making the first reply to a thread when I last encountered it. I will try some more, and I think I may have thought of a workaround.

Reply
December 7, 2008 11:01 PM

pegasus

VaultWiki Team

Okay, I implemented a workaround where newpost_complete will re-fetch_threadinfo() when it detects that it has become corrupted. Hopefully this will work.

Reply

+ Reply

All times are GMT -4. The time now is 5:12 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: AJAX Reply SQL Error 1064

Issue Tools