CannonFolly
Clients-
Posts
31 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Everything posted by 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.
-
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:
-
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' ) ); } } }
-
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.
-
Thanks for replying, Yes when I went back to php7.4 it was ok, no errors and functioning like normal. I then downloaded the files and manually uploaded them via SFTP. I also moved back to php8.1. After that I started the upgrade and this is when I encountered the message. I also checked that compatibility file again before starting the upgrade and everything was green as shown in the first image.
-
Error seems to be evolving. I left the page for a while, came back reloaded and went back thru. Did this several times eventually after some time it changed to the attached and is still stuck again. I also went and checked my database in phpmyadmin (I don't know what I'm doing, but trying to follow that log) The message reads like it is trying to modify the database and drop a column called pf_admin_only. However, that column does not exist in that specific table according to phpmyadmin
-
Webhost switched site to php8 from php7.4 which broke forums. Was running version 4.2 which was only compatible with php7 when I went to 8 just got a white screen. Switched back and it all worked fine. Reading around realized I needed a version of forums compatible with php8 so I upgraded and downloaded the files for a manual upgrade since I can't upgrade thru the admin panel. I ran the compatibility check and it reported no errors. Started manual upgrade and everything goes fine at first until I get the following error which seems to be related to the database? Need some help, I've tried retry and continue and both options reproduce this error and halt the upgrade. Edit: Also, I have no plugins