Fed up...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • OrionGraphix
    Member
    • Aug 2002
    • 46

    Fed up...

    4 months ago my forum was fine. A while ago our site was hacked. I recovered the website's database, moved to a new server, and imported the database. Since then the site is extremely slow (perhaps it's the server) and I am getting more vBulletin errors than I know what to do with. I'm just tired of it, I need a fast forum with no errors. My site is too big to have these problems.

    Can I pay someone to make these errors go away and move my website to a new server? I've just been going nuts these past few days. I had 700 emails in my inbox today say 'vBulletin Database Error!

    Can a vBulletin staff member do this? Anyone?

    The site is www.FloridaCarClub.com

    Some errors include:
    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , threadread.readtime AS threadread

    FROM thread AS thread

    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 699 AND canview = 1)
    LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 699)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


    WHERE thread.threadid IN (0,7552,7546,7524,7540,7538,7529,7534,7517,7497,7502,7510,7455,7511,7484,7485,7459,7480,74 75,7473,7461,68)
    ORDER BY sticky DESC, thread.lastpost DESC;

    MySQL Error : Table './oriongra_vbulletin/post' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Date : Thursday, October 5th 2006 @ 02:10:28 PM
    Script : http://floridacarclub.com/forum/f23-videos.html
    Referrer : http://floridacarclub.com/forum/
    IP Address : 71.251.102.180
    Username : cleanabprsxtype-s
    Classname : vB_Database
    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount
    , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
    , threadread.readtime AS threadread

    FROM thread AS thread

    LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 699 AND canview = 1)
    LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 699)
    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


    WHERE thread.threadid IN (0,7474,7470,7406,7316,7292,7297,7178,7237,7262,7168,6562,7101,7169,7156,6534,7009,6796,70 27,6535,6657)
    ORDER BY sticky DESC, thread.lastpost DESC;

    MySQL Error : Table './oriongra_vbulletin/post' is marked as crashed and last (automatic?) repair failed
    Error Number : 144
    Date : Thursday, October 5th 2006 @ 02:10:01 PM
    Script : http://floridacarclub.com/forum/f17-...-relatedb.html
    Referrer : http://floridacarclub.com/forum/
    IP Address : 71.251.102.180
    Username : cleanabprsxtype-s
    Classname : vB_Database
    If vB staff can't do it someone please PM me pricing to move this slow site to a new server, and get rid of all these errors.

  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    The table has crashed and the repair failed. Try running another repair for the heck of it. Do you get any other errors that might indicate the reason why the repair failed? No space? No permission?

    We can take a look if you submit a trouble ticket with your forum and server info.

    Comment

    • OrionGraphix
      Member
      • Aug 2002
      • 46

      #3
      Thank you for the reply, I appreciate it.

      Submitting a ticket now.

      Here are some more errors:
      Database error in vBulletin 3.5.4:

      Invalid SQL:

      SELECT postid
      FROM post AS post

      WHERE threadid = 1732
      AND visible = 1

      ORDER BY dateline
      LIMIT 0, 10;

      MySQL Error : Table './oriongra_vbulletin/post' is marked as crashed and last (automatic?) repair failed
      Error Number : 144
      Date : Thursday, October 5th 2006 @ 03:01:53 PM
      Script : http://floridacarclub.com/forum/t173...ls-on-arm.html
      Referrer :
      IP Address : 66.249.66.74
      Username : Unregistered
      Classname : vB_Database
      Database error in vBulletin 3.5.4:

      Invalid SQL:

      SELECT MIN(postid) AS postid
      FROM post
      WHERE threadid = 7537
      AND visible = 1
      AND dateline > 1160009617
      LIMIT 1;

      MySQL Error : Table './oriongra_vbulletin/post' is marked as crashed and last (automatic?) repair failed
      Error Number : 144
      Date : Thursday, October 5th 2006 @ 03:15:04 PM
      Script : http://floridacarclub.com/forum/show...newpost&t=7537
      Referrer : http://floridacarclub.com/forum/
      IP Address : 67.8.54.104
      Username : AEG82
      Classname : vB_Database
      Database error in vBulletin 3.5.4:

      Invalid SQL:

      SELECT
      IF(votenum >= 1, votenum, 0) AS votenum,
      IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
      post.pagetext AS preview,
      thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
      thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
      hiddencount
      , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
      , threadread.readtime AS threadread

      FROM thread AS thread

      LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 699 AND canview = 1)
      LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 699)
      LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


      WHERE thread.threadid IN (0,7500,7501,7423)
      ORDER BY sticky DESC, thread.lastpost DESC;

      MySQL Error : Table './oriongra_vbulletin/post' is marked as crashed and last (automatic?) repair failed
      Error Number : 144
      Date : Thursday, October 5th 2006 @ 02:10:06 PM
      Script : http://floridacarclub.com/forum/f42-...nt-to-buy.html
      Referrer : http://floridacarclub.com/forum/
      IP Address : 71.251.102.180
      Username : cleanabprsxtype-s
      Classname : vB_Database

      Comment

      • Jake Bunce
        Senior Member
        • Dec 2000
        • 46598
        • 3.6.x

        #4
        Those are all the same errors. When some one picks up your ticket we will be able to see why the repair failed.

        Comment

        • SNN
          Senior Member
          • Jul 2006
          • 856
          • 4.0.0

          #5
          Seems like the HTML file(s) in the threads/posts are messed up.
          Maybe trying to do http://floridacarclub.com/forum/install/upgrade.php (saw part of url in post ) will do something, have you tried it?

          Comment

          • OrionGraphix
            Member
            • Aug 2002
            • 46

            #6
            Originally posted by SNN
            Seems like the HTML file(s) in the threads/posts are messed up.
            Maybe trying to do http://floridacarclub.com/forum/install/upgrade.php (saw part of url in post ) will do something, have you tried it?
            Haven't tried it yet...thank you for the suggestion, I appreciate it. I will see what vBulletin says.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            😀
            😂
            🥰
            😘
            🤢
            😎
            😞
            😡
            👍
            👎