CannonFolly

OMG, that did it!
IT COMPLETED THE UPGRADE!!!!
Don't take this the wrong way, but I could kiss you right now lol.
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.

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.

OMG, that did it!
IT COMPLETED THE UPGRADE!!!!
Don't take this the wrong way, but I could kiss you right now lol.
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.

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.

Once you swim in that stream, it will happen in a moment 🙂

Apparently there are more "bugs" here and there...One by one remove and you will see a finish.

This is my table

Create a row you are missing

Mark and delete 1_core_spammer row

Did you run an upgrader?

Try (1,core_NewVersion,1,always)

Replace ? with 0
 

Copy and Go this command in SQL

Try this
ALTER TABLE ibf_core_pfields_data ADD pf_admin_only varchar(255);  

Try this:
In this command, replace DROP with ADD
This will create the missing column, then upgrader will successfully remove it.
I.e. After successfully creating it, run upgrader

Open your PhPMyAdmin - your database, open menu SQL
Copy the last line in the red message, and paste in

Then Go.
Once done, repeat site/admin/upgrade