Another Database Error

[T&H]

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

[Steve Machol]

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)
)
;

[Morpheus3]

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)
)
";

[netshrine]

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.

[Steve Machol]

What's the complete error messages?

[netshrine]

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.

[Steve Machol]

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

[GULFBOY]

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

[GULFBOY]

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.

[Scott MacVicar]

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

[GULFBOY]

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?

[GULFBOY]

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

[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.

[Morpheus3]

I am my host...

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

Morpheus

[Scott MacVicar]

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.