Announcement

Collapse
No announcement yet.

keep getting error messages + 3 users can't use the forums

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

  • keep getting error messages + 3 users can't use the forums

    Forums URL: www.thecatsite.com/forums
    vBulletin 2.2.9
    Apache Dedicated Server
    · mySQL Database (version 3.23.43)
    · PHP 4.2.3



    All the above data I copied from my host's feature page - not 100% sure about them.

    Here goes the story -
    Yesterday the forums got stuck. We contacted tech support and they said the account had reached its quota of disk space and that caused the problem. So we removed the disk space limitation (with over 30 giga of free disk space on the server it wasn't necessary).

    The forums are now working except for some glitches which I don't know how to fix-

    1. Two threads seem to have been caught up in some black hole loop and can't be accessed. When you click on them you get an error message. Here's the link to one of them - http://www.thecatsite.com/forums/sho...threadid=19461.

    This is the error message -
    Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/www/thecatsite/forums/admin/db_mysql.php on line 93

    Database error in vBulletin 2.2.9:
    Invalid SQL: SELECT COUNT(*) AS posts FROM post WHERE post.threadid='19461' AND post.visible=1
    mysql error: Got error 134 from table handler
    mysql error number: 1030
    Date: Monday 02nd of June 2003 03:39:25 AM
    Script: http://www.thecatsite.com/forums/for...threadid=19461
    Referer: http://www.thecatsite.com/forums/for...0&pagenumber=2

    I have no idea how to delete them as they can't be accessed.

    2. Several of our members (3 that I know of for sure) can't access the forums. They get an error message when they do. When I click on their username from the control panel to view their profile, I also get an error message which says:
    Database error in vBulletin 2.2.9:
    Invalid SQL: SELECT thread.title,thread.threadid,thread.forumid,postid,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='1954' ORDER BY post.dateline DESC LIMIT 20
    mysql error: Got error 134 from table handler
    mysql error number: 1030
    Date: Monday 02nd of June 2003 03:40:49 AM
    Script: http://www.thecatsite.com/forums/for...fo&userid=1954
    Referer: http://www.thecatsite.com/forums/adm...it&userid=1954


    3. Other than that there are members who say they get occasional error messages - I'm not sure who gets what. I get a few dozens of error messages today - here are a couple of examples:

    Database error in vBulletin 2.2.9:

    Invalid SQL:
    SELECT DISTINCT post.userid,
    thread.threadid,thread.threadid AS postid,thread.title AS threadtitle,thread.iconid AS threadiconid,thread.replycount,
    thread.views,thread.pollid,thread.open,thread.lastpost AS postdateline,thread.lastpost,thread.lastposter,
    forum.forumid,forum.title AS forumtitle,forum.allowicons,attach,
    thread.postusername AS usrname,
    user.userid AS postuserid,
    threadicon.iconpath AS threadiconpath,threadicon.title AS threadicontitle
    FROM
    thread,forum
    LEFT JOIN user ON user.username=thread.postusername
    LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
    LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '3725' AND post.visible = 1)
    WHERE
    thread.forumid=forum.forumid AND thread.threadid IN (0,19506,19508,19485,19510,19509,19481,15085,6465,17477)
    ORDER BY
    thread.lastpost DESC,thread.lastpost DESC
    mysql error: Can't find record in 'post'

    mysql error number: 1032

    Date: Sunday 01st of June 2003 10:24:26 PM
    Script: http://www.thecatsite.com/forums/forums/search.php?s=&action=showresults&getnew=true&searchid=61937
    Referer:

    -------------------------------------------------------------------

    Database error in vBulletin 2.2.9:

    Invalid SQL: SELECT DISTINCT post.userid, icon.title as icontitle,icon.iconpath,thread.threadid,thread.title,
    lastpost,forumid,pollid,open,replycount,postusername,postuserid,lastposter,thread.dateline ,views,
    thread.iconid,notes,thread.visible
    FROM thread
    LEFT JOIN icon ON (icon.iconid = thread.iconid)
    LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '3776' AND post.visible = 1)
    WHERE thread.threadid IN (0,6465,15085,18567,18959,19510)
    ORDER BY lastpost DESC

    mysql error: Can't find record in 'post'

    mysql error number: 1032

    Date: Sunday 01st of June 2003 10:00:31 PM
    Script: http://www.thecatsite.com/forums/forums/usercp.php?s=
    Referer: http://thecatsite.com/forums/showthread.php?s=&postid=218903
    CatForums
    Verdant Gardening Forums
    If you have pets/home and family related forums, hit me up for a link exchange!

  • #2
    Try uploading repair.php to your admin directory and running it from your browser. Repair.php is in the extras folder of the vBulletin zip file. Run it like this:

    http://www.yoursite.com/forum/admin/repair.php?html=1&check=1

    Comment


    • #3
      Originally posted by Jakeman
      Try uploading repair.php to your admin directory and running it from your browser. Repair.php is in the extras folder of the vBulletin zip file. Run it like this:

      http://www.yoursite.com/forum/admin/...html=1&check=1

      I did what you said. It produced a long list (in table format) which says for nearly all tables -
      This table does not support check/repair/optimize

      For a few tables it said OK

      I didn't see any errors or problems reported and the error messages (at least for the profiles of those members) are still there...
      CatForums
      Verdant Gardening Forums
      If you have pets/home and family related forums, hit me up for a link exchange!

      Comment


      • #4
        You are running older ISAM tables instead of MyISAM - which is strange for that version of MySQL. Using phpMyAdmin, you need to change all your tables - except session - to MyISAM. Make sure session is HEAP. Then run repair.php again.
        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


        • #5
          Originally posted by Steve Machol
          You are running older ISAM tables instead of MyISAM - which is strange for that version of MySQL. Using phpMyAdmin, you need to change all your tables - except session - to MyISAM. Make sure session is HEAP. Then run repair.php again.
          Thanks Steve, though you might as well have written in Chinsese (and I'm from Israel) - I have no idea what ISAM is, session or HEAP... and where is phpMyAdmin or what it is...
          CatForums
          Verdant Gardening Forums
          If you have pets/home and family related forums, hit me up for a link exchange!

          Comment


          • #6
            PhpMyAdmin is a MySQL database management tool. Most web hosts provide this as part of the web site management tools such as CPanel, Plesk or Ensim. Look for a link to SQL or MySQL Databases. If you can't find it I suggest you ask your host about this.

            If for some reason they do not provide phpMyAdmin or an equivalent MySQL manager, then you can download and install phpMyAdmin yourself from this location:

            http://www.phpmyadmin.net/
            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

            Loading...
            Working...
            X