How to upgrade DB upon Mantis Update

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
pdario
Posts: 10
Joined: 03 Feb 2021, 14:55

How to upgrade DB upon Mantis Update

Post by pdario »

Hello!

I am running an old MantisBT installation from a Bitnami VM.

No I installed a new VM with latest Mantis; I exported the old MySQL DB and put it in the new Mantis installation.

When I go the Mantis page it says:
  • I have to update the DB; it sends me to admin/install.php but that file does not exist! What can I do??
  • I should delete or limit access to "admin" folder, what does this mean?
Thank you very much!
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to upgrade DB upon Mantis Update

Post by atrol »

Please use Search before posting and read the Manual
pdario
Posts: 10
Joined: 03 Feb 2021, 14:55

Re: How to upgrade DB upon Mantis Update

Post by pdario »

Hello!! I did as you suggested, I downloaded the packaged and added index.php back!

I thought it was missing by error.

Now, the checks says:

Version of MySQL being used is within the Premier Support period (GA + 5 years)
Premier Support for the release of MySQL you are using (5.6.36) ended on 2018-02-05. The release is in its Extended support period, which ends on 2021-02-05. You should upgrade to a newer version of MySQL which is still within its Premier support period to benefit from bug fixes and security patches.

Can you help with this?
pdario
Posts: 10
Joined: 03 Feb 2021, 14:55

Re: How to upgrade DB upon Mantis Update

Post by pdario »

Oh no! I copied from the old installation!!

The correct message is:
MySQL Lifecycle and Release Support data availability
Release information for MySQL 8.0 series is not available, unable to perform the lifecycle checks.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to upgrade DB upon Mantis Update

Post by atrol »

pdario wrote: 03 Feb 2021, 16:12 The correct message is:
MySQL Lifecycle and Release Support data availability
Release information for MySQL 8.0 series is not available, unable to perform the lifecycle checks.
This is just a warning when runninhg admin/check/index.php

You have to run admin/install.php to upgrade the DB.
Please use Search before posting and read the Manual
pdario
Posts: 10
Joined: 03 Feb 2021, 14:55

Re: How to upgrade DB upon Mantis Update

Post by pdario »

But that's the last thing I did!
Do I have to run it again?

I'll do it tomorrow, thanks!
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to upgrade DB upon Mantis Update

Post by atrol »

pdario wrote: 03 Feb 2021, 16:12 Oh no! I copied from the old installation!!
That confused me.
I thought you copied the admin folder from the old installation, but what you mean is that you copied the warning message.
pdario wrote: 03 Feb 2021, 20:18 But that's the last thing I did!
Do I have to run it again?
No, then all should be fine now.
Please use Search before posting and read the Manual
pdario
Posts: 10
Joined: 03 Feb 2021, 14:55

Re: How to upgrade DB upon Mantis Update

Post by pdario »

Ok, but why warning for this?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to upgrade DB upon Mantis Update

Post by atrol »

Maybe the wording of the warning is not clear.

Do you understand it, if it's changed to this?

Code: Select all

Release information for MySQL 8.0 series is not available in MantisBT, unable to perform the lifecycle checks. 
Please use Search before posting and read the Manual
pdario
Posts: 10
Joined: 03 Feb 2021, 14:55

Re: How to upgrade DB upon Mantis Update

Post by pdario »

Well, my question is: why warn me if there's nothing I can do?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: How to upgrade DB upon Mantis Update

Post by atrol »

The warning tells that MantisBT is not able to check the lifecycle.
The administrator gets the warning and should check himself, if the used version is still supported.
Please use Search before posting and read the Manual
Post Reply