Database error

[Chroder]

I recently had some database issues and I cleared a lot of stuff up by repairing the tables. But I try to repair one and I get an error -- what can I do to fix this? I don't want this same mysql error to come up everyday.

Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM vb_attachmentviews GROUP BY attachmentid mysql error: Can't find file: 'vb_attachmentviews.MYD' (errno: 2)

mysql error number: 1017

[noppid]

I think that means the table 'vb_attachmentviews' is missing from your database completely.

[Chroder]

When I view the database with phpMyAdmin, it just says its 'in use'. I'm guessing something got corrupt somewhere... But I'm not sure, if I just drop it will vB just reset attachment views or will it throw more errors?

[Steve Machol]

Any table showing 'in use' is corrputed. You need to repair those tables.

As for the attachmentviews table, do a search for 'attachmentviews.MYD' on these forums. There have been some issues with this.

[Chroder]

Thanks Steve :) Searched and found :cool:

FWIW, just drop the table and remake it by looking in the install/mysql-schema.php file for the sql.