Error Number : 1017 from upgrade script ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vNovice
    Senior Member
    • Oct 2002
    • 148

    Error Number : 1017 from upgrade script ?

    I'm trying to upgrade from 3.0.7 to 3.5.4. I had my ISP duplicate and rename the database, so that part should be correct. When I try to run install/upgrade I get the following:

    Invalid SQL:

    SELECT title, data
    FROM datastore
    WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','prod ucts','pluginlist','cron');

    MySQL Error : Can't find file: './mine_month35/datastore.frm' (errno: 13)
    Error Number : 1017
    Date : Wednesday, May 17th 2006 @ 12:32:12 AM
    Script : http://mine.com/forum_35/install/upgrade.php
    Referrer :
    IP Address : XXXXXXXXXX
    Username :
    Classname : vb_database
  • Colin F
    Senior Member
    • May 2004
    • 17689

    #2
    Try running the 'Repair / Optimize Tables' function in your AdminCP -> Maintenance menu.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

    • vNovice
      Senior Member
      • Oct 2002
      • 148

      #3
      This is the duplicated database from my 3.0.7 forum and I understood that I needed to run install/upgrade.php instead of install.php. So there is no admin CP to work from. No board exists yet with this database.

      Before I stared on this upgrade I did a search and found this thread:



      Am I missing something or is this the right approach ?
      Last edited by vNovice; Wed 17 May '06, 1:48am.

      Comment

      • Colin F
        Senior Member
        • May 2004
        • 17689

        #4
        In that case, run this function on your old forum, and then duplicate the database again.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment

        • vNovice
          Senior Member
          • Oct 2002
          • 148

          #5
          I just got this reply from my support ticket with my WHP saying that the databases appear identical:


          Here is a rundown of each database and what is in it, comparing them by size and file, they both appear identical (along with the permissions and ownership).

          db_namehere

          drw-rw---- 2 mysql mysql 8192 May 17 00:19 ./
          drwxr-x--x 143 mysql mysql 12288 May 16 21:37 ../
          -rw-rw---- 1 mysql mysql 8624 May 17 00:19 access.frm
          -rw-rw---- 1 mysql mysql 135 May 17 00:19 access.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 access.MYI
          -rw-rw---- 1 mysql mysql 8732 May 17 00:19 adminhelp.frm
          -rw-rw---- 1 mysql mysql 47272 May 17 00:19 adminhelp.MYD
          -rw-rw---- 1 mysql mysql 57344 May 17 00:19 adminhelp.MYI
          -rw-rw---- 1 mysql mysql 8696 May 17 00:19 administrator.frm
          -rw-rw---- 1 mysql mysql 20 May 17 00:19 administrator.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 administrator.MYI
          -rw-rw---- 1 mysql mysql 8750 May 17 00:19 adminlog.frm
          -rw-rw---- 1 mysql mysql 597004 May 17 00:19 adminlog.MYD
          -rw-rw---- 1 mysql mysql 88064 May 17 00:19 adminlog.MYI
          -rw-rw---- 1 mysql mysql 8580 May 17 00:19 adminutil.frm
          -rw-rw---- 1 mysql mysql 20 May 17 00:19 adminutil.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 adminutil.MYI
          -rw-rw---- 1 mysql mysql 8892 May 17 00:19 announcement.frm
          -rw-rw---- 1 mysql mysql 1516 May 17 00:19 announcement.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 announcement.MYI
          -rw-rw---- 1 mysql mysql 9016 May 17 00:19 attachment.frm
          -rw-rw---- 1 mysql mysql 37623608 May 17 00:19 attachment.MYD
          -rw-rw---- 1 mysql mysql 97280 May 17 00:19 attachment.MYI
          -rw-rw---- 1 mysql mysql 8734 May 17 00:19 attachmenttype.frm
          -rw-rw---- 1 mysql mysql 712 May 17 00:19 attachmenttype.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 attachmenttype.MYI
          -rw-rw---- 1 mysql mysql 8570 May 17 00:19 attachmentviews.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 attachmentviews.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 attachmentviews.MYI
          -rw-rw---- 1 mysql mysql 8750 May 17 00:19 avatar.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 avatar.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 avatar.MYI
          -rw-rw---- 1 mysql mysql 8836 May 17 00:19 bbcode.frm
          -rw-rw---- 1 mysql mysql 884 May 17 00:19 bbcode.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 bbcode.MYI
          -rw-rw---- 1 mysql mysql 8814 May 17 00:19 calendarcustomfield.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 calendarcustomfield.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 calendarcustomfield.MYI
          -rw-rw---- 1 mysql mysql 9020 May 17 00:19 calendar.frm
          -rw-rw---- 1 mysql mysql 8728 May 17 00:19 calendarmoderator.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 calendarmoderator.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 calendarmoderator.MYI
          -rw-rw---- 1 mysql mysql 148 May 17 00:19 calendar.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 calendar.MYI
          -rw-rw---- 1 mysql mysql 8714 May 17 00:19 calendarpermission.frm
          -rw-rw---- 1 mysql mysql 255 May 17 00:19 calendarpermission.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 calendarpermission.MYI
          -rw-rw---- 1 mysql mysql 8614 May 17 00:19 cpsession.frm
          -rw-rw---- 1 mysql mysql 8782 May 17 00:19 cron.frm
          -rw-rw---- 1 mysql mysql 8662 May 17 00:19 cronlog.frm
          -rw-rw---- 1 mysql mysql 32888 May 17 00:19 cronlog.MYD
          -rw-rw---- 1 mysql mysql 18432 May 17 00:19 cronlog.MYI
          -rw-rw---- 1 mysql mysql 1044 May 17 00:19 cron.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 cron.MYI
          -rw-rw---- 1 mysql mysql 8720 May 17 00:19 customavatar.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 customavatar.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 customavatar.MYI
          -rw-rw---- 1 mysql mysql 8728 May 17 00:19 customprofilepic.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 customprofilepic.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 customprofilepic.MYI
          -rw-rw---- 1 mysql mysql 8580 May 17 00:19 datastore.frm
          -rw-rw---- 1 mysql mysql 111724 May 17 00:19 datastore.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 datastore.MYI
          -rw-rw---- 1 mysql mysql 8690 May 17 00:19 deletionlog.frm
          -rw-rw---- 1 mysql mysql 1868 May 17 00:19 deletionlog.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 deletionlog.MYI
          -rw-rw---- 1 mysql mysql 8678 May 17 00:19 editlog.frm
          -rw-rw---- 1 mysql mysql 25516 May 17 00:19 editlog.MYD
          -rw-rw---- 1 mysql mysql 10240 May 17 00:19 editlog.MYI
          -rw-rw---- 1 mysql mysql 8992 May 17 00:19 event.frm
          -rw-rw---- 1 mysql mysql 72 May 17 00:19 event.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 event.MYI
          -rw-rw---- 1 mysql mysql 8666 May 17 00:19 faq.frm
          -rw-rw---- 1 mysql mysql 1368 May 17 00:19 faq.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 faq.MYI
          -rw-rw---- 1 mysql mysql 9302 May 17 00:19 forum.frm
          -rw-rw---- 1 mysql mysql 206724 May 17 00:19 forum.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 forum.MYI
          -rw-rw---- 1 mysql mysql 8696 May 17 00:19 forumpermission.frm
          -rw-rw---- 1 mysql mysql 2816 May 17 00:19 forumpermission.MYD
          -rw-rw---- 1 mysql mysql 8192 May 17 00:19 forumpermission.MYI
          -rw-rw---- 1 mysql mysql 8706 May 17 00:19 holiday.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 holiday.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 holiday.MYI
          -rw-rw---- 1 mysql mysql 8702 May 17 00:19 icon.frm
          -rw-rw---- 1 mysql mysql 2898 May 17 00:19 icon.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 icon.MYI
          -rw-rw---- 1 mysql mysql 8676 May 17 00:19 imagecategory.frm
          -rw-rw---- 1 mysql mysql 84 May 17 00:19 imagecategory.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 imagecategory.MYI
          -rw-rw---- 1 mysql mysql 8614 May 17 00:19 imagecategorypermission. frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 imagecategorypermission. MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 imagecategorypermission. MYI
          -rw-rw---- 1 mysql mysql 11752 May 17 00:19 language.frm
          -rw-rw---- 1 mysql mysql 251888 May 17 00:19 language.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 language.MYI
          -rw-rw---- 1 mysql mysql 8718 May 17 00:19 mailqueue.frm
          -rw-rw---- 1 mysql mysql 2480 May 17 00:19 mailqueue.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 mailqueue.MYI
          -rw-rw---- 1 mysql mysql 8629 May 17 00:19 moderation.frm
          -rw-rw---- 1 mysql mysql 20 May 17 00:19 moderation.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 moderation.MYI
          -rw-rw---- 1 mysql mysql 8664 May 17 00:19 moderator.frm
          -rw-rw---- 1 mysql mysql 8780 May 17 00:19 moderatorlog.frm
          -rw-rw---- 1 mysql mysql 7532 May 17 00:19 moderatorlog.MYD
          -rw-rw---- 1 mysql mysql 7168 May 17 00:19 moderatorlog.MYI
          -rw-rw---- 1 mysql mysql 624 May 17 00:19 moderator.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 moderator.MYI
          -rw-rw---- 1 mysql mysql 8630 May 17 00:19 passwordhistory.frm
          -rw-rw---- 1 mysql mysql 2772 May 17 00:19 passwordhistory.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 passwordhistory.MYI
          -rw-rw---- 1 mysql mysql 8692 May 17 00:19 phrase.frm
          -rw-rw---- 1 mysql mysql 2278664 May 17 00:19 phrase.MYD
          -rw-rw---- 1 mysql mysql 614400 May 17 00:19 phrase.MYI
          -rw-rw---- 1 mysql mysql 8662 May 17 00:19 phrasetype.frm
          -rw-rw---- 1 mysql mysql 11925 May 17 00:19 phrasetype.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 phrasetype.MYI
          -rw-rw---- 1 mysql mysql 8684 May 17 00:19 pm.frm
          -rw-rw---- 1 mysql mysql 20400 May 17 00:19 pm.MYD
          -rw-rw---- 1 mysql mysql 56320 May 17 00:19 pm.MYI
          -rw-rw---- 1 mysql mysql 8768 May 17 00:19 pmreceipt.frm
          -rw-rw---- 1 mysql mysql 7988 May 17 00:19 pmreceipt.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 pmreceipt.MYI
          -rw-rw---- 1 mysql mysql 8872 May 17 00:19 pmtext.frm
          -rw-rw---- 1 mysql mysql 400188 May 17 00:19 pmtext.MYD
          -rw-rw---- 1 mysql mysql 19456 May 17 00:19 pmtext.MYI
          -rw-rw---- 1 mysql mysql 8898 May 17 00:19 poll.frm
          -rw-rw---- 1 mysql mysql 524 May 17 00:19 poll.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 poll.MYI
          -rw-rw---- 1 mysql mysql 8690 May 17 00:19 pollvote.frm
          -rw-rw---- 1 mysql mysql 714 May 17 00:19 pollvote.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 pollvote.MYI
          -rw-rw---- 1 mysql mysql 8972 May 17 00:19 post.frm
          -rw-rw---- 1 mysql mysql 8682 May 17 00:19 posthash.frm
          -rw-rw---- 1 mysql mysql 539 May 17 00:19 posthash.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 posthash.MYI
          -rw-rw---- 1 mysql mysql 8642 May 17 00:19 postindex.frm
          -rw-rw---- 1 mysql mysql 2453180 May 17 00:19 postindex.MYD
          -rw-rw---- 1 mysql mysql 3290112 May 17 00:19 postindex.MYI
          -rw-rw---- 1 mysql mysql 10307168 May 17 00:19 post.MYD
          -rw-rw---- 1 mysql mysql 361472 May 17 00:19 post.MYI
          -rw-rw---- 1 mysql mysql 8666 May 17 00:19 post_parsed.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 post_parsed.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 post_parsed.MYI
          -rw-rw---- 1 mysql mysql 9159 May 17 00:19 profilefield.frm
          -rw-rw---- 1 mysql mysql 204 May 17 00:19 profilefield.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 profilefield.MYI
          -rw-rw---- 1 mysql mysql 8716 May 17 00:19 ranks.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 ranks.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 ranks.MYI
          -rw-rw---- 1 mysql mysql 8638 May 17 00:19 regimage.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 regimage.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 regimage.MYI
          -rw-rw---- 1 mysql mysql 8788 May 17 00:19 reminder.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 reminder.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 reminder.MYI
          -rw-rw---- 1 mysql mysql 8754 May 17 00:19 reputation.frm
          -rw-rw---- 1 mysql mysql 8656 May 17 00:19 reputationlevel.frm
          -rw-rw---- 1 mysql mysql 640 May 17 00:19 reputationlevel.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 reputationlevel.MYI
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 reputation.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 reputation.MYI
          -rw-rw---- 1 mysql mysql 9070 May 17 00:19 search.frm
          -rw-rw---- 1 mysql mysql 9464 May 17 00:19 search.MYD
          -rw-rw---- 1 mysql mysql 5120 May 17 00:19 search.MYI
          -rw-rw---- 1 mysql mysql 9010 May 17 00:19 session.frm
          -rw-rw---- 1 mysql mysql 8802 May 17 00:19 setting.frm
          -rw-rw---- 1 mysql mysql 8638 May 17 00:19 settinggroup.frm
          -rw-rw---- 1 mysql mysql 1980 May 17 00:19 settinggroup.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 settinggroup.MYI
          -rw-rw---- 1 mysql mysql 44696 May 17 00:19 setting.MYD
          -rw-rw---- 1 mysql mysql 8192 May 17 00:19 setting.MYI
          -rw-rw---- 1 mysql mysql 8746 May 17 00:19 smilie.frm
          -rw-rw---- 1 mysql mysql 2387 May 17 00:19 smilie.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 smilie.MYI
          -rw-rw---- 1 mysql mysql 8672 May 17 00:19 stats.frm
          -rw-rw---- 1 mysql mysql 5406 May 17 00:19 stats.MYD
          -rw-rw---- 1 mysql mysql 5120 May 17 00:19 stats.MYI
          -rw-rw---- 1 mysql mysql 8630 May 17 00:19 strikes.frm
          -rw-rw---- 1 mysql mysql 700 May 17 00:19 strikes.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 strikes.MYI
          -rw-rw---- 1 mysql mysql 8940 May 17 00:19 style.frm
          -rw-rw---- 1 mysql mysql 87924 May 17 00:19 style.MYD
          -rw-rw---- 1 mysql mysql 2048 May 17 00:19 style.MYI
          -rw-rw---- 1 mysql mysql 8588 May 17 00:19 subscribeevent.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 subscribeevent.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 subscribeevent.MYI
          -rw-rw---- 1 mysql mysql 8674 May 17 00:19 subscribeforum.frm
          -rw-rw---- 1 mysql mysql 676 May 17 00:19 subscribeforum.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 subscribeforum.MYI
          -rw-rw---- 1 mysql mysql 8710 May 17 00:19 subscribethread.frm
          -rw-rw---- 1 mysql mysql 89547 May 17 00:19 subscribethread.MYD
          -rw-rw---- 1 mysql mysql 162816 May 17 00:19 subscribethread.MYI
          -rw-rw---- 1 mysql mysql 8856 May 17 00:19 subscription.frm
          -rw-rw---- 1 mysql mysql 8786 May 17 00:19 subscriptionlog.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 subscriptionlog.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 subscriptionlog.MYI
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 subscription.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 subscription.MYI
          -rw-rw---- 1 mysql mysql 8862 May 17 00:19 template.frm
          -rw-rw---- 1 mysql mysql 2447416 May 17 00:19 template.MYD
          -rw-rw---- 1 mysql mysql 23552 May 17 00:19 template.MYI
          -rw-rw---- 1 mysql mysql 9228 May 17 00:19 thread.frm
          -rw-rw---- 1 mysql mysql 230784 May 17 00:19 thread.MYD
          -rw-rw---- 1 mysql mysql 144384 May 17 00:19 thread.MYI
          -rw-rw---- 1 mysql mysql 8688 May 17 00:19 threadrate.frm
          -rw-rw---- 1 mysql mysql 90 May 17 00:19 threadrate.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 threadrate.MYI
          -rw-rw---- 1 mysql mysql 8562 May 17 00:19 threadviews.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 threadviews.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 threadviews.MYI
          -rw-rw---- 1 mysql mysql 8748 May 17 00:19 upgradelog.frm
          -rw-rw---- 1 mysql mysql 9276 May 17 00:19 upgradelog.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 upgradelog.MYI
          -rw-rw---- 1 mysql mysql 8740 May 17 00:19 useractivation.frm
          -rw-rw---- 1 mysql mysql 903 May 17 00:19 useractivation.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 useractivation.MYI
          -rw-rw---- 1 mysql mysql 8804 May 17 00:19 userban.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 userban.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 userban.MYI
          -rw-rw---- 1 mysql mysql 8694 May 17 00:19 userfield.frm
          -rw-rw---- 1 mysql mysql 20408 May 17 00:19 userfield.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 userfield.MYI
          -rw-rw---- 1 mysql mysql 10132 May 17 00:19 user.frm
          -rw-rw---- 1 mysql mysql 9758 May 17 00:19 usergroup.frm
          -rw-rw---- 1 mysql mysql 8646 May 17 00:19 usergroupleader.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 usergroupleader.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 usergroupleader.MYI
          -rw-rw---- 1 mysql mysql 12906 May 17 00:19 usergroup.MYD
          -rw-rw---- 1 mysql mysql 3072 May 17 00:19 usergroup.MYI
          -rw-rw---- 1 mysql mysql 8708 May 17 00:19 usergrouprequest.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 usergrouprequest.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 usergrouprequest.MYI
          -rw-rw---- 1 mysql mysql 39852 May 17 00:19 user.MYD
          -rw-rw---- 1 mysql mysql 23552 May 17 00:19 user.MYI
          -rw-rw---- 1 mysql mysql 8786 May 17 00:19 usernote.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 usernote.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 usernote.MYI
          -rw-rw---- 1 mysql mysql 8802 May 17 00:19 userpromotion.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 userpromotion.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 userpromotion.MYI
          -rw-rw---- 1 mysql mysql 8770 May 17 00:19 usertextfield.frm
          -rw-rw---- 1 mysql mysql 8076 May 17 00:19 usertextfield.MYD
          -rw-rw---- 1 mysql mysql 4096 May 17 00:19 usertextfield.MYI
          -rw-rw---- 1 mysql mysql 8626 May 17 00:19 usertitle.frm
          -rw-rw---- 1 mysql mysql 0 May 17 00:19 usertitle.MYD
          -rw-rw---- 1 mysql mysql 1024 May 17 00:19 usertitle.MYI
          -rw-rw---- 1 mysql mysql 8584 May 17 00:19 word.frm
          -rw-rw---- 1 mysql mysql 1578258 May 17 00:19 word.MYD
          -rw-rw---- 1 mysql mysql 618496 May 17 00:19 word.MYI

          And now sbgiedu_month,

          sbgiedu_month

          drwx------ 2 mysql mysql 8192 Jul 2 2005 ./
          drwxr-x--x 143 mysql mysql 12288 May 16 21:37 ../
          -rw-rw---- 1 mysql mysql 8624 Jul 2 2005 access.frm
          -rw-rw---- 1 mysql mysql 135 Jul 2 2005 access.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 3 2005 access.MYI
          -rw-rw---- 1 mysql mysql 8732 Jul 2 2005 adminhelp.frm
          -rw-rw---- 1 mysql mysql 47272 Jul 2 2005 adminhelp.MYD
          -rw-rw---- 1 mysql mysql 57344 Jul 3 2005 adminhelp.MYI
          -rw-rw---- 1 mysql mysql 8696 Jul 2 2005 administrator.frm
          -rw-rw---- 1 mysql mysql 20 Jul 2 2005 administrator.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 2 2005 administrator.MYI
          -rw-rw---- 1 mysql mysql 8750 Jul 2 2005 adminlog.frm
          -rw-rw---- 1 mysql mysql 597004 May 16 11:13 adminlog.MYD
          -rw-rw---- 1 mysql mysql 88064 May 16 11:13 adminlog.MYI
          -rw-rw---- 1 mysql mysql 8580 Jul 2 2005 adminutil.frm
          -rw-rw---- 1 mysql mysql 20 Jul 2 2005 adminutil.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 2 2005 adminutil.MYI
          -rw-rw---- 1 mysql mysql 8892 Jul 2 2005 announcement.frm
          -rw-rw---- 1 mysql mysql 1516 Dec 22 01:34 announcement.MYD
          -rw-rw---- 1 mysql mysql 3072 Dec 23 00:09 announcement.MYI
          -rw-rw---- 1 mysql mysql 9016 Jul 2 2005 attachment.frm
          -rw-rw---- 1 mysql mysql 37623608 May 15 21:10 attachment.MYD
          -rw-rw---- 1 mysql mysql 97280 May 15 16:21 attachment.MYI
          -rw-rw---- 1 mysql mysql 8734 Jul 2 2005 attachmenttype.frm
          -rw-rw---- 1 mysql mysql 712 Jul 2 2005 attachmenttype.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 2 2005 attachmenttype.MYI
          -rw-rw---- 1 mysql mysql 8570 Jul 2 2005 attachmentviews.frm
          -rw-rw---- 1 mysql mysql 0 May 15 21:10 attachmentviews.MYD
          -rw-rw---- 1 mysql mysql 1024 May 16 11:18 attachmentviews.MYI
          -rw-rw---- 1 mysql mysql 8750 Jul 2 2005 avatar.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 avatar.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 avatar.MYI
          -rw-rw---- 1 mysql mysql 8836 Jul 2 2005 bbcode.frm
          -rw-rw---- 1 mysql mysql 884 Jul 2 2005 bbcode.MYD
          -rw-rw---- 1 mysql mysql 3072 Jul 3 2005 bbcode.MYI
          -rw-rw---- 1 mysql mysql 8814 Jul 2 2005 calendarcustomfield.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 calendarcustomfield.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 calendarcustomfield.MYI
          -rw-rw---- 1 mysql mysql 9020 Jul 2 2005 calendar.frm
          -rw-rw---- 1 mysql mysql 8728 Jul 2 2005 calendarmoderator.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 calendarmoderator.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 calendarmoderator.MYI
          -rw-rw---- 1 mysql mysql 148 Jul 2 2005 calendar.MYD
          -rw-rw---- 1 mysql mysql 3072 Jul 3 2005 calendar.MYI
          -rw-rw---- 1 mysql mysql 8714 Jul 2 2005 calendarpermission.frm
          -rw-rw---- 1 mysql mysql 255 Jul 2 2005 calendarpermission.MYD
          -rw-rw---- 1 mysql mysql 4096 Jul 3 2005 calendarpermission.MYI
          -rw-rw---- 1 mysql mysql 8614 Jul 2 2005 cpsession.frm
          -rw-rw---- 1 mysql mysql 8782 Jul 2 2005 cron.frm
          -rw-rw---- 1 mysql mysql 8662 Jul 2 2005 cronlog.frm
          -rw-rw---- 1 mysql mysql 32888 May 16 07:53 cronlog.MYD
          -rw-rw---- 1 mysql mysql 18432 May 16 07:53 cronlog.MYI
          -rw-rw---- 1 mysql mysql 1044 May 16 15:20 cron.MYD
          -rw-rw---- 1 mysql mysql 3072 May 16 15:20 cron.MYI
          -rw-rw---- 1 mysql mysql 8720 Jul 2 2005 customavatar.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 customavatar.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 customavatar.MYI
          -rw-rw---- 1 mysql mysql 8728 Jul 2 2005 customprofilepic.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 customprofilepic.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 customprofilepic.MYI
          -rw-rw---- 1 mysql mysql 8580 Jul 2 2005 datastore.frm
          -rw-rw---- 1 mysql mysql 111724 May 16 15:20 datastore.MYD
          -rw-rw---- 1 mysql mysql 2048 May 16 15:20 datastore.MYI
          -rw-rw---- 1 mysql mysql 8690 Jul 2 2005 deletionlog.frm
          -rw-rw---- 1 mysql mysql 1868 Apr 17 15:06 deletionlog.MYD
          -rw-rw---- 1 mysql mysql 2048 Apr 18 00:17 deletionlog.MYI
          -rw-rw---- 1 mysql mysql 8678 Jul 2 2005 editlog.frm
          -rw-rw---- 1 mysql mysql 25516 May 15 22:50 editlog.MYD
          -rw-rw---- 1 mysql mysql 10240 May 15 22:50 editlog.MYI
          -rw-rw---- 1 mysql mysql 8992 Jul 2 2005 event.frm
          -rw-rw---- 1 mysql mysql 72 Jul 2 2005 event.MYD
          -rw-rw---- 1 mysql mysql 4096 Jul 2 2005 event.MYI
          -rw-rw---- 1 mysql mysql 8666 Jul 2 2005 faq.frm
          -rw-rw---- 1 mysql mysql 1368 Jul 2 2005 faq.MYD
          -rw-rw---- 1 mysql mysql 3072 Jul 3 2005 faq.MYI
          -rw-rw---- 1 mysql mysql 9302 Jul 2 2005 forum.frm
          -rw-rw---- 1 mysql mysql 206724 May 16 09:50 forum.MYD
          -rw-rw---- 1 mysql mysql 2048 May 7 08:50 forum.MYI
          -rw-rw---- 1 mysql mysql 8696 Jul 2 2005 forumpermission.frm
          -rw-rw---- 1 mysql mysql 2816 Feb 16 02:38 forumpermission.MYD
          -rw-rw---- 1 mysql mysql 8192 Feb 16 22:03 forumpermission.MYI
          -rw-rw---- 1 mysql mysql 8706 Jul 2 2005 holiday.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 holiday.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 holiday.MYI
          -rw-rw---- 1 mysql mysql 8702 Jul 2 2005 icon.frm
          -rw-rw---- 1 mysql mysql 2898 Jul 2 2005 icon.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 3 2005 icon.MYI
          -rw-rw---- 1 mysql mysql 8676 Jul 2 2005 imagecategory.frm
          -rw-rw---- 1 mysql mysql 84 Jul 2 2005 imagecategory.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 3 2005 imagecategory.MYI
          -rw-rw---- 1 mysql mysql 8614 Jul 2 2005 imagecategorypermission.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 imagecategorypermission.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 imagecategorypermission.MYI
          -rw-rw---- 1 mysql mysql 11752 Jul 2 2005 language.frm
          -rw-rw---- 1 mysql mysql 251888 Jul 3 2005 language.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 4 2005 language.MYI
          -rw-rw---- 1 mysql mysql 8718 Jul 2 2005 mailqueue.frm
          -rw-rw---- 1 mysql mysql 2480 May 15 16:29 mailqueue.MYD
          -rw-rw---- 1 mysql mysql 2048 May 15 16:29 mailqueue.MYI
          -rw-rw---- 1 mysql mysql 8629 Jul 2 2005 moderation.frm
          -rw-rw---- 1 mysql mysql 20 Oct 26 2005 moderation.MYD
          -rw-rw---- 1 mysql mysql 3072 Oct 27 2005 moderation.MYI
          -rw-rw---- 1 mysql mysql 8664 Jul 2 2005 moderator.frm
          -rw-rw---- 1 mysql mysql 8780 Jul 2 2005 moderatorlog.frm
          -rw-rw---- 1 mysql mysql 7532 Mar 3 15:00 moderatorlog.MYD
          -rw-rw---- 1 mysql mysql 7168 Mar 4 00:05 moderatorlog.MYI
          -rw-rw---- 1 mysql mysql 624 Jul 3 2005 moderator.MYD
          -rw-rw---- 1 mysql mysql 3072 Jul 4 2005 moderator.MYI
          -rw-rw---- 1 mysql mysql 8630 Jul 2 2005 passwordhistory.frm
          -rw-rw---- 1 mysql mysql 2772 Apr 23 18:20 passwordhistory.MYD
          -rw-rw---- 1 mysql mysql 2048 Apr 24 00:04 passwordhistory.MYI
          -rw-rw---- 1 mysql mysql 8692 Jul 2 2005 phrase.frm
          -rw-rw---- 1 mysql mysql 2278664 Jul 17 2005 phrase.MYD
          -rw-rw---- 1 mysql mysql 614400 Jul 18 2005 phrase.MYI
          -rw-rw---- 1 mysql mysql 8662 Jul 2 2005 phrasetype.frm
          -rw-rw---- 1 mysql mysql 11925 Jul 2 2005 phrasetype.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 3 2005 phrasetype.MYI
          -rw-rw---- 1 mysql mysql 8684 Jul 2 2005 pm.frm
          -rw-rw---- 1 mysql mysql 20400 May 15 17:13 pm.MYD
          -rw-rw---- 1 mysql mysql 56320 May 15 17:13 pm.MYI
          -rw-rw---- 1 mysql mysql 8768 Jul 2 2005 pmreceipt.frm
          -rw-rw---- 1 mysql mysql 7988 May 15 17:13 pmreceipt.MYD
          -rw-rw---- 1 mysql mysql 4096 May 15 17:13 pmreceipt.MYI
          -rw-rw---- 1 mysql mysql 8872 Jul 2 2005 pmtext.frm
          -rw-rw---- 1 mysql mysql 400188 May 15 17:13 pmtext.MYD
          -rw-rw---- 1 mysql mysql 19456 May 15 17:13 pmtext.MYI
          -rw-rw---- 1 mysql mysql 8898 Jul 2 2005 poll.frm
          -rw-rw---- 1 mysql mysql 524 Apr 17 18:16 poll.MYD
          -rw-rw---- 1 mysql mysql 2048 Apr 18 00:05 poll.MYI
          -rw-rw---- 1 mysql mysql 8690 Jul 2 2005 pollvote.frm
          -rw-rw---- 1 mysql mysql 714 Apr 17 18:16 pollvote.MYD
          -rw-rw---- 1 mysql mysql 3072 Apr 18 00:05 pollvote.MYI
          -rw-rw---- 1 mysql mysql 8972 Jul 2 2005 post.frm
          -rw-rw---- 1 mysql mysql 8682 Jul 2 2005 posthash.frm
          -rw-rw---- 1 mysql mysql 539 May 16 11:10 posthash.MYD
          -rw-rw---- 1 mysql mysql 3072 May 16 11:10 posthash.MYI
          -rw-rw---- 1 mysql mysql 8642 Jul 2 2005 postindex.frm
          -rw-rw---- 1 mysql mysql 2453180 May 16 09:50 postindex.MYD
          -rw-rw---- 1 mysql mysql 3290112 May 16 09:50 postindex.MYI
          -rw-rw---- 1 mysql mysql 10307168 May 16 09:50 post.MYD
          -rw-rw---- 1 mysql mysql 361472 May 16 09:50 post.MYI
          -rw-rw---- 1 mysql mysql 8666 Jul 2 2005 post_parsed.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 post_parsed.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 3 2005 post_parsed.MYI
          -rw-rw---- 1 mysql mysql 9159 Jul 2 2005 profilefield.frm
          -rw-rw---- 1 mysql mysql 204 Jul 2 2005 profilefield.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 2 2005 profilefield.MYI
          -rw-rw---- 1 mysql mysql 8716 Jul 2 2005 ranks.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 ranks.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 ranks.MYI
          -rw-rw---- 1 mysql mysql 8638 Jul 2 2005 regimage.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 regimage.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 regimage.MYI
          -rw-rw---- 1 mysql mysql 8788 Jul 2 2005 reminder.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 reminder.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 reminder.MYI
          -rw-rw---- 1 mysql mysql 8754 Jul 2 2005 reputation.frm
          -rw-rw---- 1 mysql mysql 8656 Jul 2 2005 reputationlevel.frm
          -rw-rw---- 1 mysql mysql 640 Jul 2 2005 reputationlevel.MYD
          -rw-rw---- 1 mysql mysql 3072 Jul 3 2005 reputationlevel.MYI
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 reputation.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 reputation.MYI
          -rw-rw---- 1 mysql mysql 9070 Jul 2 2005 search.frm
          -rw-rw---- 1 mysql mysql 9464 May 16 09:35 search.MYD
          -rw-rw---- 1 mysql mysql 5120 May 16 09:35 search.MYI
          -rw-rw---- 1 mysql mysql 9010 Jul 2 2005 session.frm
          -rw-rw---- 1 mysql mysql 8802 Jul 2 2005 setting.frm
          -rw-rw---- 1 mysql mysql 8638 Jul 2 2005 settinggroup.frm
          -rw-rw---- 1 mysql mysql 1980 Jul 2 2005 settinggroup.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 3 2005 settinggroup.MYI
          -rw-rw---- 1 mysql mysql 44696 May 16 09:58 setting.MYD
          -rw-rw---- 1 mysql mysql 8192 May 16 09:58 setting.MYI
          -rw-rw---- 1 mysql mysql 8746 Jul 2 2005 smilie.frm
          -rw-rw---- 1 mysql mysql 2387 Jul 2 2005 smilie.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 3 2005 smilie.MYI
          -rw-rw---- 1 mysql mysql 8672 Jul 2 2005 stats.frm
          -rw-rw---- 1 mysql mysql 5406 May 16 00:27 stats.MYD
          -rw-rw---- 1 mysql mysql 5120 May 16 00:27 stats.MYI
          -rw-rw---- 1 mysql mysql 8630 Jul 2 2005 strikes.frm
          -rw-rw---- 1 mysql mysql 700 May 15 17:40 strikes.MYD
          -rw-rw---- 1 mysql mysql 3072 May 15 17:40 strikes.MYI
          -rw-rw---- 1 mysql mysql 8940 Jul 2 2005 style.frm
          -rw-rw---- 1 mysql mysql 87924 Jul 18 2005 style.MYD
          -rw-rw---- 1 mysql mysql 2048 Jul 19 2005 style.MYI
          -rw-rw---- 1 mysql mysql 8588 Jul 2 2005 subscribeevent.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 subscribeevent.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 subscribeevent.MYI
          -rw-rw---- 1 mysql mysql 8674 Jul 2 2005 subscribeforum.frm
          -rw-rw---- 1 mysql mysql 676 Dec 12 11:08 subscribeforum.MYD
          -rw-rw---- 1 mysql mysql 4096 Dec 13 00:05 subscribeforum.MYI
          -rw-rw---- 1 mysql mysql 8710 Jul 2 2005 subscribethread.frm
          -rw-rw---- 1 mysql mysql 89547 May 16 09:50 subscribethread.MYD
          -rw-rw---- 1 mysql mysql 162816 May 16 09:50 subscribethread.MYI
          -rw-rw---- 1 mysql mysql 8856 Jul 2 2005 subscription.frm
          -rw-rw---- 1 mysql mysql 8786 Jul 2 2005 subscriptionlog.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 subscriptionlog.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 subscriptionlog.MYI
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 subscription.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 subscription.MYI
          -rw-rw---- 1 mysql mysql 8862 Jul 2 2005 template.frm
          -rw-rw---- 1 mysql mysql 2447416 Jul 18 2005 template.MYD
          -rw-rw---- 1 mysql mysql 23552 Jul 19 2005 template.MYI
          -rw-rw---- 1 mysql mysql 9228 Jul 2 2005 thread.frm
          -rw-rw---- 1 mysql mysql 230784 May 16 09:58 thread.MYD
          -rw-rw---- 1 mysql mysql 144384 May 16 09:50 thread.MYI
          -rw-rw---- 1 mysql mysql 8688 Jul 2 2005 threadrate.frm
          -rw-rw---- 1 mysql mysql 90 Jul 2 2005 threadrate.MYD
          -rw-rw---- 1 mysql mysql 3072 Jul 2 2005 threadrate.MYI
          -rw-rw---- 1 mysql mysql 8562 Jul 2 2005 threadviews.frm
          -rw-rw---- 1 mysql mysql 0 May 16 09:58 threadviews.MYD
          -rw-rw---- 1 mysql mysql 1024 May 16 11:15 threadviews.MYI
          -rw-rw---- 1 mysql mysql 8748 Jul 2 2005 upgradelog.frm
          -rw-rw---- 1 mysql mysql 9276 Jul 2 2005 upgradelog.MYD
          -rw-rw---- 1 mysql mysql 4096 Jul 3 2005 upgradelog.MYI
          -rw-rw---- 1 mysql mysql 8740 Jul 2 2005 useractivation.frm
          -rw-rw---- 1 mysql mysql 903 May 15 16:26 useractivation.MYD
          -rw-rw---- 1 mysql mysql 3072 May 15 16:26 useractivation.MYI
          -rw-rw---- 1 mysql mysql 8804 Jul 2 2005 userban.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 userban.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 userban.MYI
          -rw-rw---- 1 mysql mysql 8694 Jul 2 2005 userfield.frm
          -rw-rw---- 1 mysql mysql 20408 May 14 21:43 userfield.MYD
          -rw-rw---- 1 mysql mysql 4096 May 14 21:43 userfield.MYI
          -rw-rw---- 1 mysql mysql 10132 Jul 2 2005 user.frm
          -rw-rw---- 1 mysql mysql 9758 Jul 2 2005 usergroup.frm
          -rw-rw---- 1 mysql mysql 8646 Jul 2 2005 usergroupleader.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 usergroupleader.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 usergroupleader.MYI
          -rw-rw---- 1 mysql mysql 12906 May 16 10:05 usergroup.MYD
          -rw-rw---- 1 mysql mysql 3072 May 16 10:00 usergroup.MYI
          -rw-rw---- 1 mysql mysql 8708 Jul 2 2005 usergrouprequest.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 usergrouprequest.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 usergrouprequest.MYI
          -rw-rw---- 1 mysql mysql 39852 May 17 00:14 user.MYD
          -rw-rw---- 1 mysql mysql 23552 May 15 16:51 user.MYI
          -rw-rw---- 1 mysql mysql 8786 Jul 2 2005 usernote.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 usernote.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 usernote.MYI
          -rw-rw---- 1 mysql mysql 8802 Jul 2 2005 userpromotion.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 userpromotion.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 userpromotion.MYI
          -rw-rw---- 1 mysql mysql 8770 Jul 2 2005 usertextfield.frm
          -rw-rw---- 1 mysql mysql 8076 May 14 21:44 usertextfield.MYD
          -rw-rw---- 1 mysql mysql 4096 May 14 21:44 usertextfield.MYI
          -rw-rw---- 1 mysql mysql 8626 Jul 2 2005 usertitle.frm
          -rw-rw---- 1 mysql mysql 0 Jul 2 2005 usertitle.MYD
          -rw-rw---- 1 mysql mysql 1024 Jul 2 2005 usertitle.MYI
          -rw-rw---- 1 mysql mysql 8584 Jul 2 2005 word.frm
          -rw-rw---- 1 mysql mysql 1578258 May 16 09:50 word.MYD
          -rw-rw---- 1 mysql mysql 618496 May 16 09:50 word.MYI

          Essentially, these databases should work properly.

          Could you try running a query in the same manner on the original and see what happens.

          Comment

          • Colin F
            Senior Member
            • May 2004
            • 17689

            #6
            It could be that the original database was corrupt already too.
            Best Regards
            Colin Frei

            Please don't contact me per PM.

            Comment

            • vNovice
              Senior Member
              • Oct 2002
              • 148

              #7
              The original database is still running the 3.0.7 board without issues. That can't be the problem can it ?
              Last edited by vNovice; Wed 17 May '06, 7:29am.

              Comment

              • Scott MacVicar
                Former vBulletin Developer
                • Dec 2000
                • 13286

                #8
                The error is
                [scott@devbox scott]$ perror 13
                OS error code 13: Permission denied

                Get your host to check the directory has the same owner + permissions.
                Scott MacVicar

                My Blog | Twitter

                Comment

                • vNovice
                  Senior Member
                  • Oct 2002
                  • 148

                  #9
                  Here are the results of running the repair/optimize tables function. The board is closed and the only one who has access is me. How do I repair the problems so that the database can be duplicated/updated to 3.5.4 ?

                  access Check Status: OK
                  access Optimize Status: OK
                  adminhelp Check Status: OK
                  adminhelp Optimize Status: OK
                  administrator Check Status: OK
                  administrator Optimize Status: OK
                  adminlog Check Status: OK
                  adminlog Optimize Status: OK
                  adminutil Check Status: OK
                  adminutil Optimize Status: OK
                  announcement Check Status: OK
                  announcement Optimize Status: OK
                  attachment Check Warning: 2 clients are using or haven't closed the table properly
                  attachment Check Status: OK
                  attachment Optimize Status: OK
                  attachmenttype Check Status: OK
                  attachmenttype Optimize Status: OK
                  attachmentviews Check Warning: 3 clients are using or haven't closed the table properly
                  attachmentviews Check Status: OK
                  attachmentviews Optimize Status: OK
                  avatar Check Status: OK
                  avatar Optimize Status: Table is already up to date
                  bbcode Check Status: OK
                  bbcode Optimize Status: OK
                  calendar Check Status: OK
                  calendar Optimize Status: OK
                  calendarcustomfield Check Status: OK
                  calendarcustomfield Optimize Status: OK
                  calendarmoderator Check Status: OK
                  calendarmoderator Optimize Status: Table is already up to date
                  calendarpermission Check Status: OK
                  calendarpermission Optimize Status: OK
                  cron Check Warning: 3 clients are using or haven't closed the table properly
                  cron Check Status: OK
                  cron Optimize Status: OK
                  cronlog Check Status: OK
                  cronlog Optimize Status: OK
                  customavatar Check Status: OK
                  customavatar Optimize Status: Table is already up to date
                  customprofilepic Check Status: OK
                  customprofilepic Optimize Status: Table is already up to date
                  datastore Check Warning: 3 clients are using or haven't closed the table properly
                  datastore Check Status: OK
                  datastore Optimize Status: OK
                  deletionlog Check Status: OK
                  deletionlog Optimize Status: OK
                  editlog Check Warning: 2 clients are using or haven't closed the table properly
                  editlog Check Status: OK
                  editlog Optimize Status: OK
                  event Check Status: OK
                  event Optimize Status: OK
                  faq Check Status: OK
                  faq Optimize Status: OK
                  forum Check Warning: 2 clients are using or haven't closed the table properly
                  forum Check Status: OK
                  forum Optimize Status: Table is already up to date
                  forumpermission Check Status: OK
                  forumpermission Optimize Status: OK
                  holiday Check Status: OK
                  holiday Optimize Status: Table is already up to date
                  icon Check Status: OK
                  icon Optimize Status: Table is already up to date
                  imagecategory Check Status: OK
                  imagecategory Optimize Status: OK
                  imagecategorypermission Check Status: OK
                  imagecategorypermission Optimize Status: Table is already up to date
                  language Check Status: OK
                  language Optimize Status: OK
                  mailqueue Check Status: OK
                  mailqueue Optimize Status: OK
                  moderation Check Status: OK
                  moderation Optimize Status: OK
                  moderator Check Status: OK
                  moderator Optimize Status: OK
                  moderatorlog Check Status: OK
                  moderatorlog Optimize Status: OK
                  passwordhistory Check Status: OK
                  passwordhistory Optimize Status: OK
                  phrase Check Status: OK
                  phrase Optimize Status: OK
                  phrasetype Check Status: OK
                  phrasetype Optimize Status: OK
                  pm Check Status: OK
                  pm Optimize Status: OK
                  pmreceipt Check Status: OK
                  pmreceipt Optimize Status: OK
                  pmtext Check Status: OK
                  pmtext Optimize Status: OK
                  poll Check Status: OK
                  poll Optimize Status: Table is already up to date
                  pollvote Check Status: OK
                  pollvote Optimize Status: OK
                  post Check Warning: 2 clients are using or haven't closed the table properly
                  post Check Status: OK
                  post Optimize Status: OK
                  post_parsed Check Status: OK
                  post_parsed Optimize Status: Table is already up to date
                  posthash Check Warning: 2 clients are using or haven't closed the table properly
                  posthash Check Status: OK
                  posthash Optimize Status: OK
                  postindex Check Warning: 2 clients are using or haven't closed the table properly
                  postindex Check Status: OK
                  postindex Optimize Status: OK
                  profilefield Check Status: OK
                  profilefield Optimize Status: OK
                  ranks Check Status: OK
                  ranks Optimize Status: OK
                  regimage Check Status: OK
                  regimage Optimize Status: Table is already up to date
                  reminder Check Status: OK
                  reminder Optimize Status: Table is already up to date
                  reputation Check Status: OK
                  reputation Optimize Status: OK
                  reputationlevel Check Status: OK
                  reputationlevel Optimize Status: OK
                  search Check Warning: 3 clients are using or haven't closed the table properly
                  search Check Status: OK
                  search Optimize Status: OK
                  setting Check Status: OK
                  setting Optimize Status: OK
                  settinggroup Check Status: OK
                  settinggroup Optimize Status: OK
                  smilie Check Status: OK
                  smilie Optimize Status: Table is already up to date
                  stats Check Status: OK
                  stats Optimize Status: OK
                  strikes Check Warning: 2 clients are using or haven't closed the table properly
                  strikes Check Status: OK
                  strikes Optimize Status: OK
                  style Check Status: OK
                  style Optimize Status: OK
                  subscribeevent Check Status: OK
                  subscribeevent Optimize Status: Table is already up to date
                  subscribeforum Check Status: OK
                  subscribeforum Optimize Status: OK
                  subscribethread Check Warning: 2 clients are using or haven't closed the table properly
                  subscribethread Check Status: OK
                  subscribethread Optimize Status: OK
                  subscription Check Status: OK
                  subscription Optimize Status: Table is already up to date
                  subscriptionlog Check Status: OK
                  subscriptionlog Optimize Status: Table is already up to date
                  template Check Status: OK
                  template Optimize Status: OK
                  thread Check Warning: 2 clients are using or haven't closed the table properly
                  thread Check Status: OK
                  thread Optimize Status: OK
                  threadrate Check Status: OK
                  threadrate Optimize Status: OK
                  threadviews Check Warning: 3 clients are using or haven't closed the table properly
                  threadviews Check Status: OK
                  threadviews Optimize Status: OK
                  upgradelog Check Status: OK
                  upgradelog Optimize Status: OK
                  user Check Warning: 3 clients are using or haven't closed the table properly
                  user Check Status: OK
                  user Optimize Status: OK
                  useractivation Check Warning: 2 clients are using or haven't closed the table properly
                  useractivation Check Status: OK
                  useractivation Optimize Status: OK
                  userban Check Status: OK
                  userban Optimize Status: OK
                  userfield Check Status: OK
                  userfield Optimize Status: OK
                  usergroup Check Status: OK
                  usergroup Optimize Status: Table is already up to date
                  usergroupleader Check Status: OK
                  usergroupleader Optimize Status: OK
                  usergrouprequest Check Status: OK
                  usergrouprequest Optimize Status: Table is already up to date
                  usernote Check Status: OK
                  usernote Optimize Status: Table is already up to date
                  userpromotion Check Status: OK
                  userpromotion Optimize Status: OK
                  usertextfield Check Status: OK
                  usertextfield Optimize Status: OK
                  usertitle Check Status: OK
                  usertitle Optimize Status: Table is already up to date
                  word Check Warning: 2 clients are using or haven't closed the table properly
                  word Check Status: OK
                  word Optimize Status: OK

                  Comment

                  • vNovice
                    Senior Member
                    • Oct 2002
                    • 148

                    #10
                    Originally posted by Scott MacVicar
                    The error is
                    [scott@devbox scott]$ perror 13
                    OS error code 13: Permission denied

                    Get your host to check the directory has the same owner + permissions.
                    Scott I was posting the above and didn't see you reply until now. I'll have the host check on the permissions.

                    Comment

                    • vNovice
                      Senior Member
                      • Oct 2002
                      • 148

                      #11
                      Yes, permissions were wrong. I just ran the upgrade and it appears I'm ready to go now.

                      Thank you Scott !!!!

                      Thank you Colin for trying to help.

                      Comment

                      • Silver_2000
                        Senior Member
                        • Mar 2002
                        • 555
                        • 4.2.X

                        #12
                        Getting the same error

                        Its not during an upgrade though

                        just a random error

                        Invalid SQL:

                        SELECT *
                        FROM datastore
                        WHERE title IN ('options','bitfields','forumcache','usergroupcache','stylecache','languagecache','product s','pluginlist','attachmentcache','cron','profilefield','userstats','birthdaycache','maxlo ggedin','iconcache','eventcache','mailqueue');

                        MySQL Error : Can't find file: './XXXXX_vbulletin/datastore.frm' (errno: 13) Error Number : 1017
                        Date : Friday, December 1st 2006 @ 10:23:40 PM
                        Script : http://www.XXXlub.com/forum/index.php
                        Referrer :
                        IP Address : 76.185.150.XXX
                        Username :
                        Classname : vb_database


                        Where do I look for the permissions problem ?

                        The forum is working
                        http://www.TALONClub.com/forum
                        http://www.prowltalk.com
                        http://www.nloc.net
                        http://www.nhtoc.com

                        Comment

                        Related Topics

                        Collapse

                        Working...