acarlsson

Yey! The forum is up an running! Couldn't have done it without the help from you splendid people! 👍🍻 I have some small issues, that I'll look into later. 🙂 Edit: Actually, I have two errors that I can't seem to solve: 1. Avatars are gone, and all embedded pictures are gone (replaced by question marks). The paths to these are set correctly, what have I missed? Edit: Example: Look at this page. Avatars and pictures are not there. If you hover the embedded pictures it says the URL should be /uploads/monthly... etc. I don't have any "monthly" folder in my uploads folder. And I didn't have it on the old forum either!? Edit 2: Ok, weird: The update package contains a folder called "Uploads". In the instructions it says you should upload the package and replace all files. Thusly, all Uploaded files was overwritten. I'm currently restore a backup, but *why* is this folder included in the update package!? 2. I have this error: "You have one or more InnoDB tables that are using the `Compact` row format. This may limit the amount of data that can be stored within the table. We recommend changing it to 'Dynamic'. If you are not sure how to do this, you should contact your hosting provider or system administrator for assistance." I have googled this but can't seem to find a correct solution. Edit: I found this thread and am awaiting answer. 😅

Actually, I installed an entirely new entity of mySQL... I have some errors reported on my IPB (how do you abbreviate Invision Community?) installment, I should fix those first. But that will be tomorrow, I am too tired now to think. I was so happy after the succeded update of macOS/PHP and IPB4, so i just wanted to move the stuff... Thanks CoffeCake, you are awesome!

Gaaah.... bash-3.2# mysqldump -u root -p aslsweden --default-character-set=utf8mb4 > /Users/admin/Desktop/aslsweden_backup.sql Enter password: mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'aslsweden' AND TABLE_NAME = 'ibf_bbcode_mediatag';': Unknown table 'column_statistics' in information_schema (1109)

Ah, I thought it was installed by deafult... 🤦

Thanks. I have tried taking a backup with phpMyAdmin, I get some errors and a backup is never taken. If I run mysqldump i get "command not found"... 😞 I did upgrade the character set during upgrade. Edit: Aha, the *backup* must be correctly encoded. Understood! Again, I am stuck. How the eff do I take an SQL backup if mysqldump don't work...? 😩

It's like putting up a sign saying "Don't touch this surface".... 😂 Actually, I'm stuck at taking a backup of the database. I wonder if I could use the backup I took before the upgrade? I guess not, but I'll figure it out....

FWIW: After countless tries of upgrading PHP to v7, I eventually moved all other services (email and web) on the server to other places, so it was only the forum left. After that I upgraded the Mac to High Sierra (that includes PHP 7.1). And after that I could do the upgrade from IPB 3 to 4. I don't know how many hours I have spent on trying to upgrade PHP manually. Brew, Xcode, manual installations, etc etc. Someone that is a Unix Wizard would probably solve this in 10 minutes, unfortunately I am not... 😝 Now I'm about to move v4 to the new server. Wish me luck! 👍😀

Thanks Paul. If I check the IPS4 checker it says that the php.ini file is located in /etc while the terminal says it's located in /usr/local.... So, how the eff do I upgrade THAT version to 7? ...or change what PHP version IPB (Apache I guess) will use? There's a reason I'm moving to Plesk and an own VPS, I haven't updated this machine in a couple of years, so when you ask me about Security upgrades I'm like "douh?" 😂 (sorry, that's the harsh truth.)

I have actually done the brew installation, but the result is as mentioned. But I will try it again, what could possibly go wrong? I also saw in your URL about "brew uninstall" which I haven't done. My guess though is that it will just sabotage my 7.2 installation and not the v5 installation.

Today I am on an old OS X 10.11 El Capitan server that is my own. So I can basically do whatever I want with it. I'm moving to a VPS at Digital Ocean, where everything is ready with PHP 7.2 etc etc. I am no expert on these things (as you probably have noticed 😂), but I am patient and I can do installations based on instructions. But now I am stuck – I don't know how I can update PHP that IPB uses.

Did that and it points of course to the old version. How do I install PHP 7 in this location, *or* get IPB to point to the new install?

Hmmm.... I am desperately trying to upgrade to PHP 7 on the old forum. macOS Terminal says that it is updated, but IPB refuses. See screenshot. I have restarted the Mac to no avail. How do I tell IPB to use the PHP v7, so I can do the upgrade? 🤔

That was my original plan. But IPB3 won’t work with a newer version of PHP, but that maybe doesn’t matter? However, I'm also afraid of doing that upgrade, after that I will be unable to reach my old forum no matter what. Later today I will read what Miss B included, now it’s time for my daughters birthday! 🥳 Thanks again everybody.

The problem is that I only have PHP 7 on my new server, and it seems like a real PITA to downgrade PHP... Catch 22 anyone? 😝 Thankyou for you insights and tips. I'll eventually get this to work.

I could outline what I did, but it sounds better if I do it again, correct this time. 😬 What I did: I installed IPB4 in an empty folder and ran the install function. What I should do now? Delete everything in the forum folder. Copy the old forum to the new folder. Copy the IPB4 files to the new forum, overwrite files if that happens. Run admin/upgrade 😬🤔

Browsing around all settings and stuff I realize one thing: When asked about the host, the default value was "localholst". When I look in phpMyAdmin for the server it says "localhost:3306", ie port 3306. Can that be the error? If so, where can I set that? Maybe. But I didn't have any working installation on the new server. This was a clean installation. Doing it now only gives me "There are no applications available to upgrade".

I just moved from IPB 3.4 to Invision Community 4.5.4 on a different server, and I can't see any content from my old database. I exported everything from the old installation, copied the .rar file to the new server and imported the SQL dump. Then I did the /admin/install and I hope I filled in everything as I should (at least I got no warning). I can see the data in phpMyAdmin, so I know that the database is up and running, but it feels that IPB can't "see" it – it's only the test site and an empty forum. In IPB3 you could do some SQL stuff, but I don't find those option in v4. What have I missed?

Thanks Nathan, Then the question is if I can upgrade to IPB4 without having the current site reachable? (I'm not particularly interested in downgrade just to upgrade 😝 )

I have moved all files, and the database, to the new server. I get an error 500 when I visit, and this in the error log: AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined function set_magic_quotes_runtime() in /var/www/vhosts/aslsweden.com/forum.aslsweden.com/initdata.php:382\nStack trace:\n#0 /var/www/vhosts/aslsweden.com/forum.aslsweden.com/index.php(21): require_once()\n#1 {main}\n thrown in /var/www/vhosts/aslsweden.com/forum.aslsweden.com/initdata.php on line 382' Here is where my experience is lacking... 😞 The old server had PHP 5.2, now I'm at 7.4.15. Can that be the cause? Edit: I commented out the "set_magic_quotes", but I also have a lot of other errors. It's obviously something else.

Yes, I saw that. However, paying $45 per month for a hobby site is not doable. I paid that amount per year before, to host it on my own servers... 😬 Since I already have a license (albeit old), I was hoping that Invision could give me a good deal.

(I have searched the community but it's too hard to find the relevant information. It's like looking for a needle in a haystack.) Background: I am the manager for a non profit hobby site called "aslsweden.com". We have had IPB since 2003 at forum.aslsweden.com. IPB was transformed to Invision Community 2016, but I never had the time to upgrade. IPB 3.4 have worked good since, even though the plan have been to upgrade eventually... Three weeks ago my current data center got bankrupt, so I had to move my servers. They are currently in a temporary location, but now it's time to move on. I rent a VPS on Digital Ocean, installed with Plesk. The main site is moved, but the forum is not. I started to move the forum site today, but quickly realized that it won't work. Due to SSL stuff and other things the IPB site is not reachable at the moment. The old site is installed on a Mac Mini and I have access to it, but my knowledge is somewhat limited. Once in a time I managed to setup the server and sites etc, but I am very uncertain about many things. And I don't know how to create databases with SQL on the new server for example... Even if I am quite techy, Websites, Apache servers and web is not my expertise. I am willing to try though, and could probably fix this with a written guide. (I did that 2003 at least 😝 ) MIssion: Move our forum to the new Plesk server, with IPB3.4 or Invision Community. Thoughts: What is the best way to proceed? - Move the IPB3.4 installation to the new server? - Move the IPB3.4 installation and also upgrade it to Invision Community? - Throw away internet and go back to using paper and pencil? 😉 I have mailed Invision and inquired them about the price for a Community license, but if that is too much money I must have the option to stay put with the 3.4 solution. My current thought is to move the IPB3.4 to the new server (following some guides I found), and fix the upgrade later. But that may be stupid? Thoughts? Ideas? Comments? Thanks, Andreas