Upgrade from IP. 3.4.x to IPS4.0 (updated)

[frunzila]

I got error 

Table 'elforumi_1.members' doesn't exist 
/home/elforumi/public_html/applications/core/setup/upg_40000/upgrade.php::42
RENAME TABLE `core_members` TO `core_members_DROP`, `members` TO `core_members`

Edited February 25, 2018 by frunzila

[kindermix]

On 2/18/2015 at 8:55 PM, Woodsman said:

Download and run IPS UTF8 Database Converter 1.1.13 you can get it here. http://community.invisionpower.com/files/file/6823-ips-utf8-database-converter/
Run the converter and let it do its thing, it will take a while.

This tool give error:

Error: Declaration of IPSUtf8\Db::query($query) should be compatible with mysqli::query($query, $resultmode = NULL)
File: /system/Db/Db.php
Line: 1550

on PHP 7.2.4

[Woodsman]

Have you tried 4.2.8 with its converter? I tried here on my local and it worked for me.....

[dwm.specops]

Hi there

I am trying to upgrade from v3.3.0 to 4.3.3. 

I have managed to get through setting up a test instance, passed all the IPS4.php requirements, also successfully ran the utf8conversion tools.

I have just copied all the IP4 files overwriting the current ones, try to navigate to /admin/upgrade and get the following error:

Quote

Fatal error: require(): Failed opening required '/home1/specopsadmin/test-forum/admin-dir/upgrade/lang.php' (include_path='.:/opt/php56/lib/php') in /home1/specopsadmin/test-forum/system/Lang/Lang.phpon line 185

Has anyone encountered this issue before?

Edited June 9, 2018 by nanotek

[Faqole]

1 hour ago, nanotek said:

Hi there

I am trying to upgrade from v3.3.0 to 4.3.3. 

I have managed to get through setting up a test instance, passed all the IPS4.php requirements, also successfully ran the utf8conversion tools.

I have just copied all the IP4 files overwriting the current ones, try to navigate to /admin/upgrade and get the following error:

Has anyone encountered this issue before?

This error means the file it is looking for does not exist in the mentioned location. Can you upload the Lang.php file once again and see if it would help?

[dwm.specops]

32 minutes ago, Faqole said:

This error means the file it is looking for does not exist in the mentioned location. Can you upload the Lang.php file once again and see if it would help?

Thanks. So I went looking for the file and found that the upgrade and install folders were prefixed with an under score. Also they only contain an index.php file

I'm not sure what else I can do, because it looks like the site has always been like this

I went looking here /home1/specopsadmin/test-forum/admin-dir/upgrade/lang.php

and found /home1/specopsadmin/test-forum/admin-dir/_upgrade/

 

I did a search for lang.php and found it in /home1/specopsadmin/test-forum/admin/upgrade/lang.php and /home1/specopsadmin/test-forum/admin/install/lang.php

Edited June 9, 2018 by nanotek

[Faqole]

5 minutes ago, nanotek said:

Thanks. So I went looking for the file and found that the upgrade and install folders were prefixed with an under score. Also they only contain an index.php file

I'm not sure what else I can do, because it looks like the site has always been like this

I went looking here /home1/specopsadmin/test-forum/admin-dir/upgrade/lang.php

and found /home1/specopsadmin/test-forum/admin-dir/_upgrade/

Can you remove the prefix underscores and see if it would help? The folders from the latest version, were they prefixed too?

[dwm.specops]

3 minutes ago, Faqole said:

Can you remove the prefix underscores and see if it would help? The folders from the latest version, were they prefixed too?

I removed the underscores, but there's no lang.php in there so it continues to error. Sorry I had the locations wrong in the previous post:

I went looking here  and found it in /home1/specopsadmin/test-forum/admin/upgrade/lang.php

I would like to know if the installer is looking at the wrong directory. It is referencing admin-dir/upgrade/ whereas the installer and lang.php is in admin/upgrade/

[Nathan Explosion]

So at some point in the past you have used the functionality to rename the admin directory?

Open the conf_global.php file, remove the reference to 'admin-dir', and then go to admin/upgrade.

[dwm.specops]

2 minutes ago, Nathan Explosion said:

So at some point in the past you have used the functionality to rename the admin directory?

Open the conf_global.php file, remove the reference to 'admin-dir', and then go to admin/upgrade.

Hi and thanks. I looked at the confirmation_global.php file and there is no reference to admin-dir there. I inherited this board so have no idea what may or may not have been done and unfortunately the person who set it all up has since passed on. It's an interesting conundrum 

 

Should the $INFO['sql_utf8mb4']            =    true; still be in there?

[Nathan Explosion]

3 minutes ago, nanotek said:

Hi and thanks. I looked at the confirmation_global.php file and there is no reference to admin-dir there. I inherited this board so have no idea what may or may not have been done and unfortunately the person who set it all up has since passed on. It's an interesting conundrum 

 

Should the $INFO['sql_utf8mb4']            =    true; still be in there? 

Deal with one issue at a time....leave that setting there.

If you want to send me FTP credentials for your site, I can take a closer look.

[Woodsman]

As Nathan has pointed out start out by verifying that the admin directory is still intact in your old 3.3 version. If not you will need to locate the changed file. 

Then try reversing these steps

Quote

Renaming the ACP "admin" directory

IP.Board has a dedicated directory for the administration center. To further enhance security, you can rename this ACP directory. Step 1: First, you'll need to physically rename the directory. Connect to your server via FTP and then browse to your IP.Board directory (this is the one that has your index.php file in it). Locate the 'admin' directory. Choose 'rename' from your FTP client menu and rename it to whatever you like. Step 2: Create a file called 'constants.php'. Download it, open it in a text editor, and paste the following contents.   <?php define( 'CP_DIRECTORY', 'admin' ); Replacing the admin with your directory name. Your ACP directory has now been renamed.

 Now I have never had to do this but it may work for you...

From the main directory locate the new directory and rename it back to admin then rename the constants.php file to contants-old.php to disable it for now. 
At this point I would then go back to the front end and see if everything was working correctly. If so then retry the upgrade.

Edited June 9, 2018 by Woodsman

[dwm.specops]

5 hours ago, Woodsman said:

As Nathan has pointed out start out by verifying that the admin directory is still intact in your old 3.3 version. If not you will need to locate the changed file. 

Then try reversing these steps

 Now I have never had to do this but it may work for you...

From the main directory locate the new directory and rename it back to admin then rename the constants.php file to contants-old.php to disable it for now. 
At this point I would then go back to the front end and see if everything was working correctly. If so then retry the upgrade.

Hi guys, thanks so much for the help! Support also confirmed this: It so happened that there was a 'constants.php' file in the main directory that had the 'admin-dir' reference. I replaced it with 'admin' and everything went smoothly! The upgrade from v3.3.0 to 4.3.3 worked! Again thanks :)

[Woodsman]

21 minutes ago, nanotek said:

Hi guys, thanks so much for the help! Support also confirmed this: It so happened that there was a 'constants.php' file in the main directory that had the 'admin-dir' reference. I replaced it with 'admin' and everything went smoothly! The upgrade from v3.3.0 to 4.3.3 worked! Again thanks ?

Glad to see you got it going ?

[dwm.specops]

10 minutes ago, Woodsman said:

Glad to see you got it going ?

Me too, now I am figuring out why custom profile field images are not showing. It seems there is configuration under custom profile fields where an option can be selected say:

option 1
option 2
option 3

and the Display Format is

<center><img src='/images/option_{key}.png'></center>

Where I imagine that {key} would be replaced with 'option 1' if option 1 was selected, and so an image called 'whatever_option 1.png' would display

Has this custom behaviour been deprecated?

[Woodsman]

Try something on this example.

<center><img src='href="http://localhost/your-install/images/option_{key}.png'></center>

I think I did this wrong....

try it this way instead....

<center><img src="http://localhost/your-install/images/option_{key}.png" alt=""></center>

 

Edited June 10, 2018 by Woodsman

[dwm.specops]

1 minute ago, Woodsman said:

Try something on this example.

<center><img src='href="http://localhost/your-install/images/option_{key}.png'></center>

 

I'll give it a go, but what is happening is that the {key} part is not being picked up. So when I inspect the broken image link, it is 

images/option_{key}.png

So it doesn't populate the {key} part. This was working prior to upgrade with all custom themes, hooks etc removed. 

[Woodsman]

try the 2nd method without the "href"

[Woodsman]

 If you are using a drop down box you can also do it this way.

<span class="ft">{title}:</span><span class="fc">{content}</span><br />

 

[dwm.specops]

5 minutes ago, Woodsman said:

try the 2nd method without the "href"

Yeah, doesn't matter about the link ref, it's the {key} value that is not populating.

Please note the attached images.

[dwm.specops]

14 minutes ago, Woodsman said:

 If you are using a drop down box you can also do it this way.

<span class="ft">{title}:</span><span class="fc">{content}</span><br />

 

THANKS!!! It was the {content} tag I was after! woohoo! Is there documentation on that somewhere?

I changed from:

<center><img src='/images/ImpDragsShields_{key}.png'></center>

To:

<center><img src='/images/ImpDragsShields_{content}.png'></center>

And it now works

Edited June 10, 2018 by nanotek

[Large Scale Planes]

So, I'm just attempting to (finally) upgrade my test environment from 3.4.9 to 4.3.4, but it fails the File Check stage of the System Check, with the following errors:

Quote

Some source files are not correct for the latest version. If you uploaded the files to your server manually, the process may have failed or not completed yet, or a new version may have been released since you downloaded. Download latest version from your client area and upload the files again in order to continue.

If you are sure the files have been uploaded correctly, make sure the permissions are set correctly on them.

• /path/to/the/forums/applications/calendar/sources/Event/Event.php
• /path/to/the/forums/applications/core/extensions/core/GroupForm/GroupSettings.php
• /path/to/the/forums/applications/core/modules/admin/members/members.php
• /path/to/the/forums/applications/core/modules/admin/overview/dashboard.php
• /path/to/the/forums/applications/core/modules/admin/settings/posting.php
• /path/to/the/forums/applications/core/modules/front/members/profile.php
• /path/to/the/forums/applications/core/modules/front/system/register.php
• /path/to/the/forums/system/Session/Front.php

I'm using MAMP, and all the files are present, and permissions seem OK. To test, I took the first file in the list above and gave read/write permissions to 'everyone', but it didn't make a difference. Either I'm not understanding the issue with the permissions, or there's something weird going on.

Any ideas?

Kev

[Large Scale Planes]

Ah, it turns out I really was using the wrong versions of the files. No idea how that came about, as I downloaded the correct update, and took care to rename it properly, but when I downloaded a new version of 4.3.4 and applied it, I was able to get past the System Check. Now I'm just waiting for the UTF-8 conversion to finish!

Kev

[wegorz23]

I got error - I include screen with error. I am removing the column but the error appears all the time over and over again. The same error also appears with the column 'record_comments'

[Daniel F]

Please submit a ticket so that we can take a look at this ?