frunzila Posted February 25, 2018 Share Posted February 25, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
kindermix Posted April 13, 2018 Share Posted April 13, 2018 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 Link to comment Share on other sites More sharing options...
Woodsman Posted April 14, 2018 Author Share Posted April 14, 2018 Have you tried 4.2.8 with its converter? I tried here on my local and it worked for me..... Link to comment Share on other sites More sharing options...
dwm.specops Posted June 9, 2018 Share Posted June 9, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
Faqole Posted June 9, 2018 Share Posted June 9, 2018 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? Link to comment Share on other sites More sharing options...
dwm.specops Posted June 9, 2018 Share Posted June 9, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
Faqole Posted June 9, 2018 Share Posted June 9, 2018 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? Link to comment Share on other sites More sharing options...
dwm.specops Posted June 9, 2018 Share Posted June 9, 2018 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/ Link to comment Share on other sites More sharing options...
Nathan Explosion Posted June 9, 2018 Share Posted June 9, 2018 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. Link to comment Share on other sites More sharing options...
dwm.specops Posted June 9, 2018 Share Posted June 9, 2018 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? Link to comment Share on other sites More sharing options...
Nathan Explosion Posted June 9, 2018 Share Posted June 9, 2018 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. Link to comment Share on other sites More sharing options...
Woodsman Posted June 9, 2018 Author Share Posted June 9, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
dwm.specops Posted June 9, 2018 Share Posted June 9, 2018 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 :) Link to comment Share on other sites More sharing options...
Woodsman Posted June 9, 2018 Author Share Posted June 9, 2018 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 ? Link to comment Share on other sites More sharing options...
dwm.specops Posted June 10, 2018 Share Posted June 10, 2018 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? Link to comment Share on other sites More sharing options...
Woodsman Posted June 10, 2018 Author Share Posted June 10, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
dwm.specops Posted June 10, 2018 Share Posted June 10, 2018 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. Link to comment Share on other sites More sharing options...
Woodsman Posted June 10, 2018 Author Share Posted June 10, 2018 try the 2nd method without the "href" Link to comment Share on other sites More sharing options...
Woodsman Posted June 10, 2018 Author Share Posted June 10, 2018 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 /> Link to comment Share on other sites More sharing options...
dwm.specops Posted June 10, 2018 Share Posted June 10, 2018 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. Link to comment Share on other sites More sharing options...
dwm.specops Posted June 10, 2018 Share Posted June 10, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
Large Scale Planes Posted July 1, 2018 Share Posted July 1, 2018 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 Link to comment Share on other sites More sharing options...
Large Scale Planes Posted July 1, 2018 Share Posted July 1, 2018 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 AndyF 1 Link to comment Share on other sites More sharing options...
wegorz23 Posted July 2, 2018 Share Posted July 2, 2018 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' Link to comment Share on other sites More sharing options...
Daniel F Posted July 2, 2018 Share Posted July 2, 2018 Please submit a ticket so that we can take a look at this ? Link to comment Share on other sites More sharing options...
Recommended Posts