Announcement

Collapse
No announcement yet.

"mysql error number: 1017"

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

  • Steve Machol
    replied
    One of the Devs will need to answer this.

    Leave a comment:


  • T&H
    replied
    Hi,

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

    Andy

    Leave a comment:


  • Steve Machol
    replied
    These tables contain the attachment and thread view counts.

    Leave a comment:


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

    Leave a comment:


  • George L
    replied
    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 ?

    Leave a comment:


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

    Leave a comment:


  • T&H
    replied
    It would appear that it was an issue with disk space.

    Many thanks for a quick response.

    Leave a comment:


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

    Leave a comment:


  • T&H
    started a topic "mysql error number: 1017"

    "mysql error number: 1017"

    Hello,

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

    Code:
    -----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: http://thinet/theread/cron.php?&rand=237345
     
    Referer: http://thinet/theread/forumdisplay.php?s=&forumid=41
     
    Username: Unregistered
     
    IP Address: 100.2.52.192
     
    
    Does anyone recognise what this might be relating to please?

    Thanks,
    Andy
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X