Some problems when upgrading since IPB 3.4 to IPB 4.7

[Seirei]

Hello, I want to upgrade my forum from IPB 3.4 to IPB 4.7. I have some problems with upgrading. I have error:

Unknown column 'field_' in 'field list'
/var/www/animeforum/applications/core/setup/upg_40000/upgrade.php::724

INSERT INTO `an_core_pfields_content` ( `member_id`, `field_` ) VALUES ( ?, ? ) ON DUPLICATE KEY UPDATE `member_id`=VALUES(`member_id`), `field_`=VALUES(`field_`)

 

I don't have this column:

 

 

What should I do?

[Seirei]

\IPS\Db::i()->insert( 'core_pfields_content', array( 'member_id' => $row['member_id'], 'field_' . $_SESSION['aboutMe_Field'] => $aboutMe ), TRUE );

This string causes the issue. 

[teraßyte]

Upgrades from 3.4 aren't directly supported anymore by IPS (unless I remember wrongly).

 

That said, I did plenty of upgrades from 3.4 in the past, but I never encountered this specific error.

Which PHP version are you using?

[Marc]

5 hours ago, teraßyte said:

Upgrades from 3.4 aren't directly supported anymore by IPS (unless I remember wrongly).

This is indeed correct. I would suggest having a look through the provider directory to see if there is someone you can perhaps employ to assist with this if you are having issues. 

https://invisioncommunity.com/third-party/providers-directory/

[Seirei]

5 hours ago, teraßyte said:

Which PHP version are you using?

PHP 8.2

5 hours ago, teraßyte said:

Upgrades from 3.4 aren't directly supported anymore by IPS (unless I remember wrongly).

Are you sure that my structure of table correct? Maybe it has missing of About Me field?

[Marc]

12 minutes ago, Seirei said:

PHP 8.2

We do not yet support PHP 8.2. You need to be on 8.1

[Seirei]

1 hour ago, Marc Stridgen said:

We do not yet support PHP 8.2. You need to be on 8.1

Then Check requirements php was wrong:

[Seirei]

I've switched PHP 8.2 to PHP 8.1. Same error. I suppose that I Have missed fields. My fields starting since 4. Maybe I Must create some fields in the table?

[Seirei]

Or maybe I need PHP 7.4?

[Marc]

1 hour ago, Seirei said:

Or maybe I need PHP 7.4?

No, as I mentioned you need 8.1. I would advise if you are unsure, you employ someone who can assist you with the upgrade there really

[Seirei]

I think I have found the problem:

Field "About Me" didn't create in the table core_pfields_data

Any suggest why?

59 minutes ago, Marc Stridgen said:

. I would advise if you are unsure, you employ someone who can assist you with the upgrade there really

You think this problem cannot be solve by myself?

[Marc]

1 hour ago, Seirei said:

You think this problem cannot be solve by myself?

I feel you misread what I wrote there. I said you should be employing someone to assist 'if' you are unsure

[Seirei]

Tell me optimal configuration my server fo upgrading. PHP 8.1. Ок. What else? OS, web-service, database?

[Jim M]

10 minutes ago, Seirei said:

Tell me optimal configuration my server fo upgrading. PHP 8.1. Ок. What else? OS, web-service, database?

We would only provide recommendations for PHP 8.1, MySQL 8 and only provide support for Apache. We would not provide any further recommendations to OS, etc..

[Seirei]

Where are writing log upgrading process?

I want to go through it

Edited May 2 by Seirei

[Stuart Silvester]

These are just some thoughts I've dug up from the back of my mind from a while ago. This isn't official support but you may find something here useful.

• It looks like you're continuing the upgrade when you're retrying it, this won't really work with the early 4.0.0 steps due to the amount of processing they have to do. Any failures here and really you want to start again from scratch.
• I would suggest using the earliest supported version of PHP which is currently 8.0. these upgrade steps were written a decade ago.
• Looking at the code, I would suggest checking the upgrade log this is either in the database in core_log of on the file system in uploads/logs.

[Seirei]

Thanks for hints. I found out the problem. Table pfields_data didn't have correct structure. Colums pf_title and pf_desc must have default values. In my case they haven't. I changed default value to NULL and this error didn't pop up.

I will continue upgrading process evening.

Edited May 3 by Seirei

[Marc]

Glad to hear you are getting further with your upgrade

[Seirei]

I finished my upgrading. Now I fix some bugs. I have issue with sending e-mail:

Creation of dynamic property IPS\Email\Outgoing\Php::$language is deprecated

[Jim M]

Just now, Seirei said:

I finished my upgrading. Now I fix some bugs. I have issue with sending e-mail:

Creation of dynamic property IPS\Email\Outgoing\Php::$language is deprecated

Check that you have all files up to date. You disabled any third-party applications/plugins. You are on PHP 8.0 or 8.1.

[Seirei]

Thanks for helping. I've switched PHP from 8.2 to 8.1, but now I have other error:

Function strftime() is deprecated

[Seirei]

What exactly PHP version is required for IPB 4? I believe that my PHP 8.1.27 is too new

[Stuart Silvester]

The minimum PHP version in 4.7 is 8.0, PHP 8.1 is recommended.

[Seirei]

4 hours ago, Stuart Silvester said:

The minimum PHP version in 4.7 is 8.0, PHP 8.1 is recommended.

PHP 8.1 has strftime() function as deprecated. So IPB 4 doesn't send e-mail. New users cannot sign up, old users cannot recover passwords. Thant's bad. What I should do?

[Seirei]

I fiiled access information, maybe Invision Community Team can see by themselves.