Announcement

Collapse
No announcement yet.

Another Database Error

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

  • #16
    Originally posted by Steve Machol
    What's the complete error messages?
    Just what Morpheus3 had - but, it's moot - - my host was able to fix it after all. Sorry for the false concern.

    Comment


    • #17
      How to drop and re-create a table

      Okay, I checked the mysql directory on my server and there is really no attachmentview.MYD and attachmentviews.MYI-File (the same for threadviews...).

      Anyway, you explained, that I have to drop and recreate that table for myself. The problem is, that I am a mySQL noob and therefore wanted to ask, if someone can give me the exact mysql command to do this in the vBulletin Control Panel... Thanks.

      Morpheus



      This is what I found in the mysql-schema.php File:

      $schema['CREATE']['query']['attachmentviews'] = "
      CREATE TABLE " . TABLE_PREFIX . "attachmentviews (
      attachmentid int unsigned NOT NULL DEFAULT '0',
      KEY postid (attachmentid)
      )
      ";


      $schema['CREATE']['query']['threadviews'] = "
      CREATE TABLE " . TABLE_PREFIX . "threadviews (
      threadid int unsigned NOT NULL DEFAULT '0',
      KEY threadid (threadid)
      )
      ";

      Comment


      • #18
        Assuming you did not use a table prefix:

        CREATE TABLE attachmentviews (
        attachmentid int unsigned NOT NULL DEFAULT '0',
        KEY postid (attachmentid)
        )
        ;

        CREATE TABLE threadviews (
        threadid int unsigned NOT NULL DEFAULT '0',
        KEY threadid (threadid)
        )
        ;
        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


        • #19
          Hi Steve,

          I'm having the same problem & would like to know what role these 2 tables play:
          'attachmentviews' and 'threadviews'.

          http://www.vbulletin.com/forum/showthread.php?t=139366

          Thanks,
          Andy

          Comment

          Loading...
          Working...
          X