Announcement

Collapse
No announcement yet.

Another Database Error

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

  • T&H
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    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)
    )
    ;

    Leave a comment:


  • Morpheus3
    replied
    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)
    )
    ";

    Leave a comment:


  • netshrine
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    What's the complete error messages?

    Leave a comment:


  • netshrine
    replied
    I am experiencing the same exact issue after my upgrade to v3. I shared this thread info with my host and he pulled the information out of mysql-schema and recreated the table manually - - but, I'm still getting the same error messages. Is there something else to do? Thanks in advance for any help.

    Leave a comment:


  • Steve Machol
    replied
    You''ll need to look in the install/mysql-schema.php file and locate the specific queries.

    Leave a comment:


  • GULFBOY
    replied
    OK
    TELL ME HOW TOre-create it in phpMyAdmin
    FOR
    the
    'threadviews table
    and
    'attachmentviews table

    Leave a comment:


  • GULFBOY
    replied
    Originally posted by Scott MacVicar
    backup file?

    path is usually
    /path/to/mysql/data/databasename/attachmentviews.MYD

    Find your directory and go into the folder and look and see if the file exists. it could be incorrect permissions. Else look for a backup you made and restore that single file.

    Else you might have to just drop that table and re-create it in phpMyAdmin.
    i have drop that table and need to re-create it in phpMyAdmin.

    Leave a comment:


  • Scott MacVicar
    replied
    you can't recreate it in phpMyAdmin the files have actually been removed and will have to be restored by the host.

    Leave a comment:


  • GULFBOY
    replied
    Originally posted by Scott MacVicar
    backup file?

    path is usually
    /path/to/mysql/data/databasename/attachmentviews.MYD

    Find your directory and go into the folder and look and see if the file exists. it could be incorrect permissions. Else look for a backup you made and restore that single file.

    Else you might have to just drop that table and re-create it in phpMyAdmin.
    how to re-create it in phpMyAdmin
    the
    'threadviews.MYD'
    and
    'attachmentviews.MYD'
    tell me how?

    Leave a comment:


  • GULFBOY
    replied
    how to re-create it in phpMyAdmin
    the
    'threadviews.MYD'
    and
    'attachmentviews.MYD'
    tell me how?

    Leave a comment:


  • Scott MacVicar
    replied
    backup file?

    path is usually
    /path/to/mysql/data/databasename/attachmentviews.MYD

    Find your directory and go into the folder and look and see if the file exists. it could be incorrect permissions. Else look for a backup you made and restore that single file.

    Else you might have to just drop that table and re-create it in phpMyAdmin.

    Leave a comment:


  • Morpheus3
    replied
    I am my host...

    Could you possibly give me any advice, how to solve this problem? Thanks in advance.

    Morpheus

    Leave a comment:


  • Scott MacVicar
    replied
    no the entry for the table is there, it would show a different error if the table didn't exist.

    The file has actually been physically removed from the filesystem after it was created. Speak to your host for more information.

    Leave a comment:

Loading...
Working...
X