Adlago Posted May 6, 2023 Posted May 6, 2023 Once you swim in that stream, it will happen in a moment 🙂 CannonFolly 1
Adlago Posted May 6, 2023 Posted May 6, 2023 Apparently there are more "bugs" here and there...One by one remove and you will see a finish. CannonFolly 1
CannonFolly Posted May 6, 2023 Author Posted May 6, 2023 This particular table has like 10,000 rows. Am I looking at the word_app column and editing values It says from 'ibf_core_applications' to 'core_applications Most of the items in that column 'word_app' just say 'core'
Adlago Posted May 7, 2023 Posted May 7, 2023 15 hours ago, CannonFolly said: This particular table has like 10,000 rows. Am I looking at the word_app column and editing values It says from 'ibf_core_applications' to 'core_applications Most of the items in that column 'word_app' just say 'core' This table describes a language. You probably also use a second language. It might be a good idea to uninstall your second language. This may also bypass this update error. After the update is complete, you will reinstall your language pack.
CannonFolly Posted May 7, 2023 Author Posted May 7, 2023 No, I don't have a second language installed. Just whatever comes default in the board
Adlago Posted May 7, 2023 Posted May 7, 2023 Have you tried this: In a list of tables in your database, select this table. Scroll to the bottom, under a list of tables in the drop-down menu With selected, select Repair table. Miss_B and CannonFolly 2
Miss_B Posted May 7, 2023 Posted May 7, 2023 (edited) Regarding the error mentioned in your screenshot: "Incorrect Key File for Table", it usually happens because of either a disk space issue or a corruption in the aforementioned table. The disk space issue is caused when the sql query is fetching data greater than the /tmp folder 's size. That 's the folder used for storing temporary tables btw. To fix this, you must change the folder location to a disk having enough free space The corruption issue can be be fixed with the query posted above. If that won't help, you can drop the table altogether from the dataabse then re create it and re insert the data. But if it is related to the disc space issue, it is best if you talked to your host about this, unless you manage your own vps/dedicated box. Edited May 7, 2023 by Miss_B Adlago and CannonFolly 2
CannonFolly Posted May 7, 2023 Author Posted May 7, 2023 OMG, that did it! IT COMPLETED THE UPGRADE!!!! Don't take this the wrong way, but I could kiss you right now lol. 6 minutes ago, Miss_B said: Regarding the error mentioned in your screenshot: "Incorrect Key File for Table", it usually happens because of either a disk space issue or a corruption in the aforementioned table. The disk space issue is caused when the sql query is fetching data greater than the /tmp folder 's size. That 's the folder used for storing temporary tables btw. To fix this, you must change the folder location to a disk having enough free space The corruption issue can be be fixed with the query posted above. If that won't help, you can drop the table altogether from the dataabse then re create it and re insert the data. But if it is related to the disc space issue, it is best if you talked to your host about this, unless you manage your own vps/dedicated box. Thanks for the reply. My host does have me on a MySQL VPS. Apparently this database was originally checking in at over 6GB for some reason, but all of the recent file checks have been varying between 20 to 200 MB. It looks like Adlago's query fixed it, so fingers crossed it was just corrupted and not a disk space issue. Adlago and Miss_B 2
Miss_B Posted May 7, 2023 Posted May 7, 2023 5 minutes ago, CannonFolly said: It looks like Adlago's query fixed it, so fingers crossed it was just corrupted and not a disk space issue. If the repair query fixed it, you have nothing to worry about it being a disc space issue.
Recommended Posts