I am trying to run reports for my inventory, however, every time I do, I get an error message.
"An unexpected error occured. The current Tab/Window needs to close. If the error keeps happening please report it to firstname.lastname@example.org
Incorrect key file for table '/tmp/#sql_ffe_1.MYI'; try to repair it"
Can anyone help me?
Posted on: Jul 31 2020 at 01:40:37 PM
Only occurs when MiniMROP is using old (very old and small) MySQL Servers usually old NAS storage devices with limited memory.
This is caused when the connecting to an old MySQL server where the /tmp/ directory is configured to a very small size.
Although that or a similar error might suggest there's a corrupt table it is in fact just a temporary table created by mysql and not actually part of your data. So no data is lost.
Having said that we are in the process of rewriting some of our queries to make them less reliant on the mysql /tmp/ table. In the meantime though you could increase the size of the mysql /tmp/
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.