• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Another MySQL Error Message

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

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Another MySQL Error Message

    • Issue Tools
      • View Changes
    1. issueid=248 September 10, 2008 9:10 PM
      Home Alone Home Alone is offline
      Junior Member
      Another MySQL Error Message

      I receive the following error message since installing Vault Wiki:
      Code:
      Database error in vBulletin 3.7.3:
      
      Invalid SQL:
      
      			SELECT
      				post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
      				user.*, userfield.*, usertextfield.*,
      				
      				avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
      				
      				editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
      				editlog.reason AS edit_reason, editlog.hashistory,
      				postparsed.pagetext_html, postparsed.hasimages,
      				sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
      				sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
      				IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
      				
      				,blog_user.entries
      			FROM post AS post
      			LEFT JOIN user AS user ON(user.userid = post.userid)
      			LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
      			LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
      			
      			LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
      				
      			LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
      			LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 62 AND postparsed.languageid = 1)
      			LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 62 AND sigparsed.languageid = 1)
      			LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
      			LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = post.userid)
      			WHERE post.threadid =  AND post.dateline > 1221088867 AND (post.visible = 1 OR post.postid = 3196387)
      				
      			ORDER BY dateline;
      
      MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND post.dateline > 1221088867 AND (post.visible = 1 OR post.postid = 3196387)
      	' at line 27
      This looks to be some sort of forum or post marking error. I have the "who has read a thread" mod installed. Could there be a confilct between the two mods?
    Issue Details
    Issue Number 248
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Editing / Posting Articles
    Status Duplicate
    Priority 2 - Fatal / Database Errors
    Affected Version 2.0.4
    Fixed Version 2.1.0
    Milestone VaultWiki 2.1.0
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. September 10, 2008 9:25 PM
      pegasus pegasus is offline
      VaultWiki Team
      This error occurs naturally in vBulletin. No visitors can see it. Since 3.7.3 you would only know it happens by checking your error logs. Please ignore this error from now on. I have done extensive testing on this and determined that it occurs for no logical reason, that is a variable randomly changes its value between 1 line of code and the next.
      Reply Reply  
    2. September 10, 2008 10:24 PM
      Home Alone Home Alone is offline
      Junior Member
      Quote Originally Posted by pegasus View Post
      This error occurs naturally in vBulletin. No visitors can see it. Since 3.7.3 you would only know it happens by checking your error logs. Please ignore this error from now on. I have done extensive testing on this and determined that it occurs for no logical reason, that is a variable randomly changes its value between 1 line of code and the next.
      It happened before I upgraded to 3.7.3 and only after I installed Vault Wiki. If I change the Thread/Forum Read Marking Type to inactivity/cookie based the error goes away but the new posts link in the welcome panel disappears.
      Reply Reply  
    3. September 11, 2008 1:17 AM
      pegasus pegasus is offline
      VaultWiki Team
      Since the error does not occur consistently, and considering the line it occurs on, I highly doubt the Thread Marking Type has anything to do with it. It does not occur every time, no matter what settings are used. And it occurs with VaultWiki completely removed.

      While you may not have noticed until installing VaultWiki, this has been a confirmed vBulletin bug. For a long time we ourselves thought it was a problem with VaultWiki, until we noticed a number of threads on vBulletin.com trying to figure it out as well. It has always been a (potential -since it doesn't happen every time) vBulletin error (at least in the 3.5-3.7 families), but they attempted to mask it in 3.7.3 by preventing a double post message from appearing. Because of the way the build_new_post() code is written, it's likely this issue will not go away completely until vB4.0.
      Reply Reply  
    4. September 11, 2008 5:53 AM
      Home Alone Home Alone is offline
      Junior Member
      OK. It's just that I have operated this board for two years and never once received this error message. Since installing Vault Wiki I get about 400 per day on a forum that averages 3,000 posts per day.
      Reply Reply  
    5. September 11, 2008 11:06 AM
      pegasus pegasus is offline
      VaultWiki Team
      That said, we are always looking for the reason it occurs more often than before.
      Reply Reply  
    6. September 11, 2008 11:34 AM
      fxlr8 fxlr8 is offline
      Junior Member
      I also get the same errors and it only started occurring after installing the Wiki (bad timing or ??). I get about 20 errors a day but just ignore them.
      Reply Reply  
    7. September 11, 2008 12:13 PM
      pegasus pegasus is offline
      VaultWiki Team
      Again, this is a design flaw in vBulletin's code (at this time we believe it could be a scoping issue). This flaw is agitated once a mod is introduced, causing this error. This is triggered by a $threadinfo['threadid'] becoming NULL at random times, when VaultWiki never attempts to modify the thread ID in this way.
      Reply Reply  
    8. September 11, 2008 12:16 PM
      pegasus pegasus is offline
      VaultWiki Team
      For example, in the last 20 posts I made, the thread ID has not become NULL and the error was not triggered.
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 12:21 AM.
    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
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.