Hello,

after some time I want to update from version 4.2.7.

Immediately after opening /admin/upgrade/ and clicking the "Start Upgrade" button, the following error message appears:

 

Unknown column 'app_requires_manual_intervention' in 'field list' EX1054

UPDATE ibf_core_applications core_applications SET app_enabled=0,app_requires_manual_intervention=1 WHERE ( app_directory NOT IN('blog','calendar','cloud','cms','core','downloads','forums','gallery','nexus','convert','courses') )

IPS\Db\Exception: Unknown column 'app_requires_manual_intervention' in 'field list' (1054)

#0 /home/XXX/www.XXX.de/system/Db/Db.php(1232): IPS\Db->preparedQuery()

#1 /home/XXX/www.XXX.de/system/Dispatcher/Setup.php(129): IPS\Db->update()

#2 /home/XXX/www.XXX.de/admin/upgrade/index.php(38): IPS\Dispatcher\Setup->setLocation()

#3 {main}

PHP version 8.4.4.

MySQL version 8.0.41.

The "Invision Community Requirements Checker" says:

You are ready to install Invision Community 5.x!

 

IPS\Db\Exception: Unknown column 'app_requires_manual_intervention' in 'field list' (1054)

It looks like that field is missing from the core_applications table. You can try to re add it manually and see if it would help.

What version are you upgrading to here?

• If you are upgrading to 5, you need to update to the latest release of 4 first

• If you are upgrading to the latest 4, you need to downgrade PHP to 8.1. It doesnt support PHP 8.4

 

• If you are upgrading to 5, you need to update to the latest release of 4 first

Okay, thanks - that was new to me.

 

Okay, thanks - that was new to me.

Yeah, its way too early a release to upgrade to 5.

So far, so good.

In step 7 (update to the latest version 4) the following error appears:

 

Specified key was too long; max key length is 1000 bytes 1071

/home/XXX/www.XXX.de/system/Db/Db.php::2187

For others who encounter the same problem:

Many of the ibf_ tables were still in MyISAM format and must first be changed/convertet to InnoDB format (e.g. using phpMyAdmin -> ALTER TABLE TABLENAME ENGINE=INNODB;).

@Marc
I now run in the next error:

 

Class IPS\core\setup\upg_500001\Upgrade could not be loaded. Ensure it has been properly prefixed with an underscore and is in the correct namespace. 256

/home/XXX/www.XXX.de/init.php::786

Still step 7 of the upgrade (to the latest version 4).

have you downgraded to PHP 8.1 as mentioned?

 

have you downgraded to PHP 8.1 as mentioned?

Yes, of course - now running 8.1.31.

Also tested PHP 8.0.30 - same error.

 

Class IPS\core\setup\upg_500001\Upgrade could not be loaded. Ensure it has been properly prefixed with an underscore and is in the correct namespace. 256

/home/XXX/www.XXX.de/init.php::786

It can be that the files haven't been overwritten/uploaded. Can you try to reupload the folder mentioned in the error message and see if that would help?

I would agree with the above. You appear to be missing files there

Thanks for the tip!

I found the problem (on my site :D): There were still folders in the /applications/ folder from the update attempt to version 5.x, which were attempted to be loaded here on the 4.x update.

I uploaded my backup and then merged the applications folder from the 4.x download, now everything works.

Step 7 of the upgrade to version 4 should NOT reference any upg_500001 class/folder because that's the 5.0.0 Alpha 1 upgrade step.

Did you upload the v5 files, and then upload the v4 files above them to redo the upgrade?

Your best option here in order is to:

1. Restore a 4.2.7 backup (remove any new files too, don't restore just the database)

2. Upgrade to 4.7.20

3. Upgrade to 5.0.3

EDIT:

Looks like it's already resolved. The reply didn't load until I submitted mine. Isn't this site supposed to auto-load the replies? 5 minutes is a long time without loading it. 🤨

Edited March 4Mar 4 by teraßyte

 

Looks like it's already resolved. The reply didn't load until I submitted mine. Isn't this site supposed to auto-load the replies? 5 minutes is a long time without loading it. 🤨

Same here.

I run in the next error after fixing the file problems:

 

Unknown column 'word_plugin' in 'field list'

/home/XXX/www.XXX.de/system/Lang/Lang.php::350

REPLACE INTO ibf_core_sys_lang_words ( lang_id, word_app, word_plugin, word_key, word_default, word_custom, word_js, word_export ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )

 

Same here.

I run in the next error after fixing the file problems:

Its not clear here which point you are at. I would highly advise, as mentioned above, restoring properly and starting this again. Previously you hadnt restored to your previous state as you had 5 files in there still

The update from 4.x to 5.x had not even started yet, so the MySQL database was still on the old version.

But to be on the safe side, I will now restore another backup (files + database) and start over again.

Just for the full explanation for those who find this via the search function:

- Restoring Database
- Restoring Files
- Checkes PHP-Version: 8.1.31
- Uploading newest 4.x files (merged all folders, replaced all files)

Upgrade to the newest 4.x version works fine.

- Changed PHP-Version to 8.4.4
- Uploading newest 5.x files (merged all folders, replaced all files)

Upgrade to 5.x also works fine.

During the first attempt (4.x -> 5.x) I tried not to keep any old files and deletet almost all folders (except /uploads/ etc.). I didn't do that this time, and even though I'm not entirely happy with it, everything is working again for now.

Thank you for help! ✌🏻

Edited March 4Mar 4 by Husumer

 

- Changed PHP-Version to 8.4.4

Php 8.4..x isn't officially supported for Ipb 5. That's something to keep in mind in case you might run into incompatibility errors down the road.

Glad to see that you managed to upgrade your forum successfully. What method did you use to upload the files? Did you use a ftp program or extracted them from the File Manager section of the cPanel? I'm asking because the latter method is known for not being very reliable.

Edited March 4Mar 4 by Miss_B

 

Php 8.4..x isn't officially supported for Ipb 5. SO keep that in mind should you run into incompatibility errors.

I haven't found any problems so far. The "Requirements Checker" hasn't shown any problems or incompatibilities either.

@Mark Are there any (big) known issues with PHP 8.4?

 

Glad to see that you managed to upgrade your forum successfully. What method you used to upload the files? Did you use a ftp program or extracted them from the File Manager section of the cPanel? I'm asking because the latter method is known for not being very reliable.

I don't use cPanel, I use pd-admin (not really used in english-speaking countries).

However, I upload the files via FTP, of course.

 

Are there any (big) known issues with PHP 8.4?

Not that Im aware of. If you find any, feel free to log as a bug of course. 8.4 had only just been released when we started releasing 5