"mysql error number: 1017"

[T&H]

Hello,

I have received (via email) the following error message from my web server:

[size=2]-----Original Message----- 
 
Date: 05/19/2005 09:17 pm (Thursday) 
 
Subject: vBulletin (Forum) Database error!
 
Database error in vBulletin 3.0.3:
 
Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid mysql error: Can't find file: 'attachmentviews.MYD' (errno: 2)
 
mysql error number: 1017
 
Date: Thursday 19th of May 2005 08:17:25 PM
 
Script: [/size][url="http://thinet/theread/cron.php?&rand=237345"][u][size=2][color=#0000ff]http://thinet/theread/cron.php?&rand=237345[/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]
 
[size=2]Referer: [/size][url="http://thinet/theread/forumdisplay.php?s=&forumid=41"][u][size=2][color=#0000ff]http://thinet/theread/forumdisplay.php?s=&forumid=41[/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]
 
[size=2]Username: Unregistered
 
IP Address: 100.2.52.192
 
[/size]

Does anyone recognise what this might be relating to please?

Thanks,
Andy

[Steve Machol]

The first thing I recommend is that you reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

[T&H]

It would appear that it was an issue with disk space.

Many thanks for a quick response.

[T&H]

Think I jumped the gun a bit!

There WAS an issue with disk space however I suspect the real problem is due to there now being zero rows in the 'attachmentviews' table!!

Same can be said for the 'threadviews' table!!

1. What sort of info. do these 2 tables contain please?
2. Can I just re-upload some of the original vB non-image files?
3. Any suggestions how this could have happened/what might cause this?

FYI: a d'base dump was performed on Friday but I've been assured that that was all that was performed.

Thanks,
Andy

[George L]

You seem to be showing up unlicensed..

could you please enter your vBulletin.com forum registered email address on the form on this page to receive support for this issue: http://www.vbulletin.com/members/mem...t_priority.php
- you will need your vB license customer number and password to access this form.

how was the database dump done ? mysqldump command or you touched the actual database *.myi, *.myd, and *.frm data files during the backup ?

[T&H]

Hopefully we're now showing up licensed again(?).

I 'believe' that a mysqldump command was used.

Please can you expand on what sort of info. these 2 tables contain - thanks.

Andy

[Steve Machol]

These tables contain the attachment and thread view counts.

[T&H]

Hi,

They appear to be dynamic, incrementing/decrementing as & when users access threads/attachments - does that sound about right?

Andy

[Steve Machol]

One of the Devs will need to answer this.