Seirei Posted May 1 Share Posted May 1 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? Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 \IPS\Db::i()->insert( 'core_pfields_content', array( 'member_id' => $row['member_id'], 'field_' . $_SESSION['aboutMe_Field'] => $aboutMe ), TRUE ); This string causes the issue. Link to comment Share on other sites More sharing options...
teraßyte Posted May 2 Share Posted May 2 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? AndyF 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 2 Share Posted May 2 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/ DawPi 1 Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 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? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 2 Share Posted May 2 12 minutes ago, Seirei said: PHP 8.2 We do not yet support PHP 8.2. You need to be on 8.1 SeNioR- 1 Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 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: Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 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? Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 Or maybe I need PHP 7.4? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 2 Share Posted May 2 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 Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 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? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 2 Share Posted May 2 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 G17 Media 1 Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 Tell me optimal configuration my server fo upgrading. PHP 8.1. Ок. What else? OS, web-service, database? Link to comment Share on other sites More sharing options...
Jim M Posted May 2 Share Posted May 2 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.. G17 Media 1 Link to comment Share on other sites More sharing options...
Seirei Posted May 2 Author Share Posted May 2 (edited) Where are writing log upgrading process? I want to go through it Edited May 2 by Seirei Link to comment Share on other sites More sharing options...
Stuart Silvester Posted May 2 Share Posted May 2 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, Marc Stridgen and SeNioR- 3 Link to comment Share on other sites More sharing options...
Seirei Posted May 3 Author Share Posted May 3 (edited) 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 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 3 Share Posted May 3 Glad to hear you are getting further with your upgrade Link to comment Share on other sites More sharing options...
Seirei Posted May 4 Author Share Posted May 4 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 Link to comment Share on other sites More sharing options...
Jim M Posted May 4 Share Posted May 4 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. Link to comment Share on other sites More sharing options...
Seirei Posted May 4 Author Share Posted May 4 Thanks for helping. I've switched PHP from 8.2 to 8.1, but now I have other error: Function strftime() is deprecated Link to comment Share on other sites More sharing options...
Seirei Posted May 5 Author Share Posted May 5 What exactly PHP version is required for IPB 4? I believe that my PHP 8.1.27 is too new Link to comment Share on other sites More sharing options...
Stuart Silvester Posted May 5 Share Posted May 5 The minimum PHP version in 4.7 is 8.0, PHP 8.1 is recommended. SeNioR- 1 Link to comment Share on other sites More sharing options...
Seirei Posted May 5 Author Share Posted May 5 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? Link to comment Share on other sites More sharing options...
Seirei Posted May 5 Author Share Posted May 5 I fiiled access information, maybe Invision Community Team can see by themselves. Link to comment Share on other sites More sharing options...
Recommended Posts