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.

No, I don't have a second language installed. Just whatever comes default in the board

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'

Yeah the moment was short lived 😞

Ok I have a quick update. I went thru that table all the rows and got to the very end. I deleted the favicon row (bye my little icon) and then it threw another one for a favicon share one. I deleted that too. Then the favicon error message came back and I deleted it again. This has let the upgrade proceed a little more. It's currently going thru "Upgrading Database" so fingers crossed. Well that success was rather short lived... now I'm just sad 😞

Ok, I may have briefly clicked into the wrong table and got into "ibf_core_acp_notifications" instead of ibf_core_acp_notifications_preferences" briefly Would you mind double checking your ibf_core_acp_notifications and comparing it to mine to make sure I didn't remove anything I shouldn't? I went back and made my table look like yours for the Preferences version and it got rid of that error and moved onto another one. This table looks like this for me:

Row deleted, but same message still

Yes, unfortunately the same message:

Error persists, I also tried to change "core_NewVersion" to something like "core_4.7" and the error also persisted

I went to that upgrade file and then found those lines around 160 foreach ( array( 'new_reg_notify' => 'core_NewRegComplete', 'spm_notify' => 'core_Spammer', 'error_notify_level' => 'core_Error' ) as $settingKey => $notificationKey ) { if ( \IPS\Settings::i()->$settingKey ) { $member = \IPS\Member::load( \IPS\Settings::i()->email_in, 'email' ); if ( $member->member_id ) { \IPS\Db::i()->insert( 'core_acp_notifications_preferences', array( 'member' => $member->member_id, 'type' => $notificationKey, 'view' => 1, 'email' => 'always' ) ); } } }

The command went thru and inserted 1 row, but the same error persists Table after query:

Oh dear, it's evolving further. So that query worked and then that specific error went away on the upgrade, but it brought up a new one now. How screwed up is my database!?!?? Don't really get it since it was working fine on php7.4 This one says there is a duplicate entry. I don't see this specific table in phpmyadmin. I see the table, but without the "PRIMARY" at the end. Forgot the error message

Something about my syntax is wrong: ALTER TABLE `ibf_core_pfields_data` ADD COLUMN `pf_admin_only`; Reports: Error SQL query: Copy ALTER TABLE `ibf_core_pfields_data` ADD COLUMN `pf_admin_only`; MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 I tried changing the apostrophes as well

I get the following error in phpmyadmin Edit: Also, not sure if this is related, but any reason why my database backups vary in size so much? There were no additional posts/uplaods/etc... to my knowledge. I haven't restored any of those backups btw. Also after query failed same error persists between some of those dates.