Advertisement:

Author Topic: "It appears that your database may require an upgrade"  (Read 2895 times)

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
"It appears that your database may require an upgrade"
« on: March 28, 2017, 08:07:45 PM »
On a forum I help administrating we couldn't upgrade from version 2.0.something to 2.0.12, so we installed a new forum at version 2.0.13 and pointed it to the old database. Now, when trying to delete inactive members we got this error:

Quote
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
File: /forum/Sources/PersonalMessage.php
Line: 2684

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.13, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php.

Would copying the upgrade.php and sql files and execute the upgrade.php solve the problem? Or is it more complicated than that?

Thanks in advance.
« Last Edit: March 30, 2017, 04:56:55 PM by br360 »

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,508
  • Gender: Male
    • Kindred-999 on GitHub
Re: "It appears that your database may require an upgrade"
« Reply #1 on: March 29, 2017, 12:09:58 AM »
Did you run repair_settings.php when you "pointed the new install at the old database"?

Did you have any mods installed?

As another note...   why couldn't you upgrade?   Instead of working out the issue, you went for the nuclear option?  That doesn't seem efficient
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #2 on: March 29, 2017, 03:57:06 AM »
Did you run repair_settings.php when you "pointed the new install at the old database"?
No, and I was wrong when I said that we pointed the install at the old database, we imported the old database to a new one and pointed the new install at that one.

Quote
Did you have any mods installed?
Simple Portal and Simple Video Audio Embedder.

Quote
As another note...   why couldn't you upgrade?   Instead of working out the issue, you went for the nuclear option?  That doesn't seem efficient
I would prefer to understand the problem and solve it, but I didn't have the opportunity.

PS: as everybody probably noticed I'm a newbie in these things and only do this on my spare time, if things were different I would read all the documentation first, as I usually do.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,508
  • Gender: Male
    • Kindred-999 on GitHub
Re: "It appears that your database may require an upgrade"
« Reply #3 on: March 29, 2017, 10:48:44 AM »
Even if you did an import, you still have to run reoair_settings.php
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #4 on: March 29, 2017, 05:06:37 PM »
I'll run the repair_settings.php file, but where can I find it?

Edit: never mind, I found it. :)

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #5 on: March 29, 2017, 07:14:01 PM »
I ran repair_settings.php but nothing changed.

Offline Steve

  • Freak
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,500
  • Gender: Male
  • I have not yet begun to procrastinate.
Re: "It appears that your database may require an upgrade"
« Reply #6 on: March 29, 2017, 10:56:03 PM »
Did it suggest changes and did you apply them?
Online Manual

Please do not PM me for support.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,314
Re: "It appears that your database may require an upgrade"
« Reply #7 on: March 29, 2017, 11:54:30 PM »
That looks like a database error, not a path problem.  Was 2.0.13 installed in the same directory as the original forum?

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #8 on: March 30, 2017, 04:16:12 AM »
Did it suggest changes and did you apply them?
Only for some paths, like the avatar's and attachment's folders.

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #9 on: March 30, 2017, 04:17:32 AM »
Was 2.0.13 installed in the same directory as the original forum?
No, it was installed in a new directory.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,314
Re: "It appears that your database may require an upgrade"
« Reply #10 on: March 30, 2017, 05:19:13 PM »
Did you run repair_settings twice?  Does everything else work normally?

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #11 on: March 30, 2017, 06:47:33 PM »
I run repair_settings twice, but, apparently, it didn't work.
A hour ago I tried to delete an user from the forum and it worked without any error message.

Could it be that it took some time for repair_settings to have some effect?

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,314
Re: "It appears that your database may require an upgrade"
« Reply #12 on: March 31, 2017, 01:27:30 PM »
repair_settings should have immediate effect.  Don't think this is a settings issue, the error you posted seems to be objecting to query syntax.  If the problem recurs, we can take another look.

Offline ArMaP

  • Semi-Newbie
  • *
  • Posts: 12
Re: "It appears that your database may require an upgrade"
« Reply #13 on: March 31, 2017, 05:05:35 PM »
Thanks everybody. :)

If it happens again I will return to this topic.