Announcement

Collapse
No announcement yet.

"mysql error number: 1017"

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

  • "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

  • #2
    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.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


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

      Many thanks for a quick response.

      Comment


      • #4
        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

        Comment


        • #5
          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 ?
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment


          • #6
            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

            Comment


            • #7
              These tables contain the attachment and thread view counts.
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                Hi,

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

                Andy

                Comment


                • #9
                  One of the Devs will need to answer this.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

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