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?

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?

 

No idea how you upgrade from 3.x to 4.x, but my guess is the part where you said /admin/install/

Perhaps this should have been /admin/upgrade?

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".

 

Maybe do the upgrade on the old server then, and then move everything to the new server.

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. 

Edited February 13, 20214 yr by acarlsson

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. 

 

So this is MacOS presumably?

Some Google Fu: https://stackoverflow.com/questions/41872645/updating-php-version-on-mac/56942162

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. 

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...? 😩

Edited March 18, 20214 yr by acarlsson

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

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.

😅

Edited March 19, 20214 yr by acarlsson