Database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rocky777
    Senior Member
    • May 2009
    • 125
    • 4.0.x

    [Forum] Database error

    In the last days I got many database errors like this one bellow. Can someone told me how to fix this?

    Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    /home/domain/public_html/domain.com/forum/includes/class_core.php on line 314

    MySQL Error :
    Error Number :
    Request Date : Thursday, January 6th 2011 @ 11:34:17 AM
    Error Date : Thursday, January 6th 2011 @ 11:34:17 AM
    Script : http://www.domanin.comforum/css.php?styleid=12&langid=2&d=1293718035&td=ltr&sheet=sidebar.css,forumbits.css,postbit.cs s,postbit-lite.css,showthread.css,member.css,user,1708
    Referrer :
    IP Address : 65.55.3.191
    Username :
    Classname : vB_Database
    MySQL Version :
    Last edited by Rocky777; Fri 7 Jan '11, 4:35am.
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    MySQL can't connect (through socket):

    See this page for the causes of this error: http://www.vbulletin.com/docs/html/cantconnect

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment

    • Rocky777
      Senior Member
      • May 2009
      • 125
      • 4.0.x

      #3
      Ok I will contact my host regarding that issue. I found another email with a database error, do you know for this a solution ?


      Database error in vBulletin 4.1.0:

      Invalid SQL:

      REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
      VALUES (0, '85.186.196.190', 1, 'Gabriel', '', 'post.dateline', 'DESC', 0.00199, 1, '18218,18172,16230', 1294062276, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{ i:1;s:7:\"Gabriel\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11 :\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', '329c75e035aa1d54e19832b12ff62dcd');

      MySQL Error : Table 'xxxx_xxxxx.search' doesn't exist
      Error Number : 1146
      Request Date : Monday, January 3rd 2011 @ 03:44:36 PM
      Error Date : Monday, January 3rd 2011 @ 03:44:36 PM
      Script : http://www.domain.com/forum/post_thanks.php?do=findthanks_user_gave&u=1
      Referrer : http://www.domanin.com/forum/
      IP Address : 85.186.196.190
      Username : NeƮnregistrat
      Classname : vB_Database
      MySQL Version :

      Comment

      • Trevor Hannant
        vBulletin Support
        • Aug 2002
        • 24326
        • 5.7.X

        #4
        That error comes from a plugin (Post thanks) - you will need to seek support from the author
        Vote for:

        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

        Comment

        • Rocky777
          Senior Member
          • May 2009
          • 125
          • 4.0.x

          #5
          Yes, you're right Trevor Hannant. I uninstalled the plugin, I hope now I will not have this kind of probblems

          Comment

          • Rocky777
            Senior Member
            • May 2009
            • 125
            • 4.0.x

            #6
            Again probblems with this even I uninstalled that plugin . What should I do to stop this ?


            Database error in vBulletin 4.1.0:

            Invalid SQL:

            SELECT post_thanks.postid AS postid
            FROM post_thanks AS post_thanks
            LEFT JOIN post AS post USING (postid)
            INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
            WHERE post_thanks.userid = 1
            AND thread.forumid IN(399,89,245,42,11,461,401,446,445,447,448,460,452,454,451,427,403,188,423,424,241,400,45 0,464,439,437,456,455,435,438,463,440,218,404,219,367,365,369,371,374,381,379,366,370,372, 368,378,377,392,383,384,373,382,387,388,429,386,393,376,375,380,391,394,390,364,385,449,45 9,260,462,152,443,441,442)
            ORDER BY post.dateline DESC
            LIMIT 1000;

            MySQL Error : Table 'xxxxxx.post_thanks' doesn't exist
            Error Number : 1146
            Request Date : Friday, January 7th 2011 @ 05:21:46 PM
            Error Date : Friday, January 7th 2011 @ 05:21:46 PM
            Script : http://www.domain.com/forum/post_thanks.php?do=findthanks_user_gave&u=1
            Referrer :
            IP Address : 66.249.66.2
            Username : NeƮnregistrat
            Classname : vB_Database
            MySQL Version :

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24326
              • 5.7.X

              #7
              Make sure you remove all files relating to that plugin including any XML files in the includes directory.
              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              • Rocky777
                Senior Member
                • May 2009
                • 125
                • 4.0.x

                #8
                Got it now. Thank you

                Comment

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