Announcement

Collapse
No announcement yet.

showthread.php (replace)

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

  • showthread.php (replace)

    I get the following message when I want to view a thread:
    There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience

    I only get this message when I want to view a thread, so I thought maybe showthread.php is damaged. Can I replace that file? (without any damage ato any other file)

    Could anyone help me out?

  • #2
    Could you tell us the URL of your website please. Also, view the HTML source of that error page, and you will see the error message - could you post that here.

    John
    John Percival

    Artificial intelligence usually beats real stupidity ;)

    Comment


    • #3
      http://www.spites.com/~extremedivx/forum/index.php

      use the following :
      username: vbulletin
      password: test

      view source:
      <!-- Database error in vBulletin: Invalid SQL:
      SELECT
      session.userid AS sessionuserid,
      post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title AS icontitle,icon.iconpath,
      attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
      ,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
      FROM
      post
      LEFT JOIN icon ON icon.iconid=post.iconid
      LEFT JOIN user ON user.userid=post.userid
      LEFT JOIN userfield ON userfield.userid=user.userid
      LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=user.userid
      LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
      LEFT JOIN session ON (session.userid = post.userid
      AND session.userid <> 0
      AND user.invisible = 0
      AND session.lastactivity>991722502)
      WHERE
      post.postid IN (0,484)
      ORDER BY dateline

      mysql error: Got error 28 from table handler
      mysql error number: 1030
      Date: Tuesday 05th of June 2001 02:43:22 AM
      Script: /~extremedivx/forum/showthread.php?threadid=87
      Referer: http://www.spites.com/~extremedivx/f....php?forumid=4
      -->
      </td></tr></table>
      <p>There seems to have been a slight problem with the database.
      Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

      Please help me...

      Comment


      • #4
        Originally posted by extreme83
        mysql error: Got error 28 from table handler
        mysql error number: 1030
        This looks to me like database corruption. Do a search around these forums for database corruption and repairing it, and you will find the solution.

        This page may also be useful:
        http://www.mysql.com/doc/R/e/Repair.html

        Comment


        • #5
          I made a backup yesterday through using the cp of vbulletin 2

          Can I delete the current database and add a new one, so I can use the backup? If yes, are all the threads, posts and users saved in this backup?

          Please reply asap...

          Thanks in advance

          Comment


          • #6
            I would just use isamchk or myisamchk to repair the database files, or use REPAIR tablename; from MySQL.

            Comment


            • #7
              I can't install these programs because it's not my server.

              If I recover my backup.sql, will there be a loss of data?
              Because that's the possible option...

              please help me...

              PS. I have phpMyAdmin, maybe there's something I can do using phpMyAdmin

              Comment


              • #8
                can't anyone help me?

                Comment


                • #9
                  Thank your for bumping while I was asleep...

                  Just run

                  REPAIR TABLE post;

                  from phpMyAdmin.

                  If that doesn't work, you'll have to use (my)isamchk or revert to a backup.

                  Comment

                  Loading...
                  Working...
                  X