MYI and MYD files being 'corrupted' by SA 50 2013 and 2014 running under Windows 8

Every time Sage 50 opens a company database under Windows 8 or 8.1 (64-bit), one or more files in the mysql directory have (presumably extraneous) text notes appended to them. This does not occur when opening databases in Windows 7 (32 bit). The files affected vary but most often include HOST.MYI and USER.MYI, though other MYI and MYD files are changed on occasion as well. The binary data in these files above the appended notes is remains unchanged.

In version 2013, the text message (coded in binary) is appended to the end of the file as follows:

5383.SQL_NoteVer2013.3..txt


and an example of the appended note when using Ver 2014 :

3343.SQL_NoteVer2014.1..txt

These examples show that  the affected files increase in size by 800 bytes to 2.3 Kb in size every time the database is opened with no apparent limit to how large these files will grow.  More disturbing, however, is the fact that this only happens when running Win 8 or 8.1.

Does someone have any insight into what is happening here?

Parents
  • 0

    Just a clarification, I am assuming that this only happens when the MySQL files are hosted on the MS 8.0/8.1 machine as opposed to on a server.  Are there any error messages in either of the errorlog.txt or SimplyError.log files that might relate to what you are observing?

  • 0 in reply to Ginkgo Bike

    Hi Bruce,

    Thanks for responding.

    Yes, the database is hosted on the local machines.

    I just ran the same database file on the Win7 and Win8 machines with the usual result:

    On the Win7 machine the files in the mysql directory are left untouched while on the Win 8.1 machine the User.MYI file had a note appended to it:

    Win8.1_User.MYI_Note.txt


    The errorlog.txt files generated by each machine are shown here in comparison. The Win 7 machine wins as far as length goes Confused

    The Win 8 errorlog.txt is here more legibly:

    Win8.1_errorlog.txt

Reply
  • 0 in reply to Ginkgo Bike

    Hi Bruce,

    Thanks for responding.

    Yes, the database is hosted on the local machines.

    I just ran the same database file on the Win7 and Win8 machines with the usual result:

    On the Win7 machine the files in the mysql directory are left untouched while on the Win 8.1 machine the User.MYI file had a note appended to it:

    Win8.1_User.MYI_Note.txt


    The errorlog.txt files generated by each machine are shown here in comparison. The Win 7 machine wins as far as length goes Confused

    The Win 8 errorlog.txt is here more legibly:

    Win8.1_errorlog.txt

Children
No Data