Announcement

Collapse
No announcement yet.

MYSQL error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trevor Hannant
    replied
    Disable them all then turn one on at a time until you see which one causes the problem.

    Leave a comment:


  • sahareto
    replied
    I think the error will not appear (because this error happened recently and not happened before)

    But I don't know which one make this error
    because that error happened 2 time per day

    is there any way to know which one make this error ?

    Leave a comment:


  • Zachery
    replied
    What happens when you disable all of those addons?

    Leave a comment:


  • sahareto
    replied
    yes and that is what I use

    Anti Bump old Threads plugin-DE 1.0
    CT second_post_Ads 2.0.8
    Digital Point Analytics 1.1.1
    Forum Runner 4.2.0
    LancerForHire, LLC. - Bot Blocker 1.2
    Links and Downloads Manager 3.0.2
    Links and Downloads Manager Extras 3.0.2
    Make Prefixes Clickable to Filter Forumdisplay 1.1
    No Logout for Banned Users 2.0.0
    Post Thank You Hack 7.82
    Quick Auto Image-Resize (Posts & Signature) 1.0.0
    Recent Thanks 2.6.2
    Separate Sticky and Normal Threads 1.1
    Skimlinks Plugin 4.2.0
    Threads Auto Close advanced (by Usergroup) 0.5
    Threads notifications 3.0
    Usergroup Color Bar 2.1.1
    vBSEO :: Sitemap Generator 3.0
    VSa - Login To User Account
    VSa - Sub-Forum Manager
    [APM] Advanced Product Management
    [CKEditor] MARCO1 Advanced Quick Reply And Edit

    Leave a comment:


  • Hartmut
    replied
    Look like there is a postid missing in the query. Are you using third party addons? That could be an explanation.

    Leave a comment:


  • sahareto
    started a topic [Forum] MYSQL error

    MYSQL error

    I recevied this error 3 time at the day

    PHP Code:
    Database error in vBulletin 4.2.0:

    Invalid SQL:

                            
    SELECT post.*,userfield.*, usertextfield.*,  user.*, IF(displaygroupid=0user.usergroupiddisplaygroupid) AS  displaygroupid,avatar.avatarpathNOT ISNULL(customavatar.userid) AS hascustomavatar,
                                                    
    customavatar.dateline AS  avatardatelinecustomavatar.width AS widthcustomavatar.height AS  height,
                                                     
    customavatar.height_thumb AS height_thumbcustomavatar.width_thumb AS  width_thumbcustomavatar.filedata_thumb
                            FROM post 
    AS post
                                    LEFT JOIN user 
    AS user ON (user.userid post.userid)
    LEFT JOIN userfield AS userfield ON (user.userid userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (user.userid usertextfield.userid)
    LEFT JOIN avatar AS avatar ON (avatar.avatarid user.avatarid)
    LEFT JOIN customavatar AS customavatar ON (customavatar.userid post.userid)
                            
    WHERE post.postid IN (.,.,.,.,.,.);

    MySQL Error   You have an error in your SQL syntaxcheck the manual  that corresponds to your MySQL server version for the right syntax to  use near '.,.,.,.,.)' at line 10
    Error Number  
    1064
    Request Date  
    ThursdayNovember 22nd 2012 03:39:13 PM
    Error Date    
    ThursdayNovember 22nd 2012 03:39:13 PM
    Script        
    http://www.mysite.com/vb/search.php?searchid=415575
    Referrer      http://www.mysite.com/vb/search.php?do=process
    IP Address    41.254.2.247
    Username      
    username
    Classname     
    vB_Database
    MySQL Version 

    how to know from where the problem
    and how to solve it

    thanks
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X