Announcement

Collapse
No announcement yet.

Data base error evry time ,

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

  • Data base error evry time ,

    Hello ,

    There is message Data base error i recievd it evry day by the email , but i don't know how can i solve it ,

    PHP Code:
    Database error in vBulletin 3.8.0 Release Candidate 2:
    Invalid SQL:
           
    SELECT thread.threadidthread.titlethread.lastpostthread.forumidthread.replycount
           
    thread.lastposterthread.datelinethread.postusernamethread.postuseridthread.iconid,
           IF(
    views<=replycountreplycount+1views) AS viewsthread.visiblethread.open
           
    user.usernameuser.useriduser.usergroupid
           IF(
    displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupid
           FROM thread 
    AS thread
           LEFT JOIN user 
    AS user ON (user.username thread.lastposter)
           
    WHERE NOT ISNULL(thread.threadid)  AND thread.visible '1' AND thread.open != '10' 
           
    AND thread.forumid NOT IN(95,2,114,85,70,71,86,145,96,20,,19,110,145,96,20)
           
    ORDER BY lastpost DESC 
           LIMIT 0
    10;
    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 '19,110,145,96,20)
           ORDER BY lastpost DESC 
           LIMIT 0, 10' 
    at line 9
    Error Number  
    1064
    Request Date  
    FridayDecember 26th 2008 03:53:37 PM
    Error Date    
    FridayDecember 26th 2008 03:53:38 PM
    Script        
    http://www.dardasha.ps/montada/forumdisplay.php?f=119
    Referrer      
    IP Address    2.11.64.97
    Username      
    admin
    Classname     
    vB_Database
    MySQL Version 


    that mean if the member or vistor click on missing forum he will show Db's Error , but if the link correct and the forum number still on there is no problem and no data base error ,


    Please help me to solve this problem ,

    Regards

  • #2
    Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-party hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Hello ,

      The error just come when the members click on this link

      http://www.dardasha.ps/montada/f119

      but is the members click on this link there is no error come ,
      http://www.dardasha.ps/montada/f52/

      becuse the first link is error forum# but the seconed is correct !!

      How can i solve it am sure there is no problem in files and style and there is no alot of hacks ,

      Comment


      • #4
        Make sure your addons are compatable with the latest version of vbulletin. Additionally you'll need to disable them to get support.

        Comment

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