Advertisement:

Author Topic: 2.0.14 to 2.0.15 upgrade, database different version error  (Read 2293 times)

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
2.0.14 to 2.0.15 upgrade, database different version error
« on: November 22, 2017, 08:53:12 AM »
Ran the update from 2.0.14 to 2.0.15 and I am getting the following error:

Unknown system variable 'version_comment'
File: /var/....../73-87chevytrucks.com/smforum/Sources/Subs-Admin.php
Line: 80

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

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 49,743
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #1 on: November 22, 2017, 08:54:32 AM »
how are you doing the upgrade?

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #2 on: November 22, 2017, 11:32:03 AM »
It was installed via Package Manager as I have done for all the 2.0 updates.

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #3 on: November 23, 2017, 11:25:32 AM »
Any ideas?  I no longer have access to the Admin portion of the site due to this error?
Should I be posting this somewhere else?

Offline Sh@mbles

  • SMF Hero
  • ******
  • Posts: 4,895
  • Gender: Male
    • i30 Owners Club
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #4 on: November 23, 2017, 12:09:19 PM »
Quote from: Captkaos
Unknown system variable 'version_comment'
File: /var/....../73-87chevytrucks.com/smforum/Sources/Subs-Admin.php
Line: 80

What's on line 80 of that file? Perhaps you could attach it in your next post.

I just checked my 2.0.14 & .15 installations and do not have that system variable (or index) anywhere.

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 903
    • sbulen on GitHub
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #5 on: November 23, 2017, 12:28:29 PM »
Please list your mods also. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #6 on: November 24, 2017, 10:39:49 AM »
This is the function from the file below.  I attached  a list of mods installed.

Code: [Select]
// Now lets check for the Database.
if (in_array('db_server', $checkFor))
{
db_extend();
if (!isset($db_connection) || $db_connection === false)
trigger_error('getServerVersions(): you need to be connected to the database in order to get its server version', E_USER_NOTICE);
else
{
$versions['db_engine'] = array('title' => sprintf($txt['database_server'], $smcFunc['db_title']), 'version' => '');
80 $versions['db_engine']['version'] = $smcFunc['db_get_engine']();

$versions['db_server'] = array('title' => sprintf($txt['support_versions_db'], $smcFunc['db_title']), 'version' => '');
$versions['db_server']['version'] = $smcFunc['db_get_version']();
}
}


Edit: please use code tags when posting code. Thanks. ~ Steve
« Last Edit: November 24, 2017, 03:19:58 PM by Steve »

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 903
    • sbulen on GitHub
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #7 on: November 24, 2017, 01:34:00 PM »
What version of MySQL are you running?

You can view this under Admin | Support & credits. 

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #8 on: November 24, 2017, 01:51:09 PM »
I cannot get to the setting on the server.  When I go to my hosting is shows:  Database client version: libmysql - 5.0.83

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 903
    • sbulen on GitHub
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #9 on: November 24, 2017, 01:54:23 PM »
I believe the proper fix is to patch/upgrade your MySQL version.  Is this feasible?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #10 on: November 24, 2017, 02:13:19 PM »
I could have the hosting company upgrade it.  What would be the min required.  I am on a share hosting server.

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 903
    • sbulen on GitHub
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #11 on: November 24, 2017, 02:17:32 PM »
Note there may be no rush - ONLY THE FIRST TWO admin functions make this call - things like administration center, support & credits. 

Package manager and News/Newsletters will work, and I believe everything else under Configuration, Forum, Members & Maintenance. 

Give it a shot.  This may not be very limiting at all... 

(edit - made some corrections above - news works...)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #12 on: November 25, 2017, 12:31:49 AM »
Yes only the top 2 functions will not work from what I have found.  Waiting on the hosting company to stop putting me through a round of questions and just upgrade.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 17,286
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #13 on: December 21, 2017, 06:11:53 AM »
Hi, have you been able to sort this out? The database version error most commonly does not mean there is anything wrong with the database actually, but with that large a gap it might be worth to try running the latest upgrade.php to get rid of that part of the error message ( of course, back up first when ever about to mess with anything related to the database. )
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #14 on: December 21, 2017, 04:37:12 PM »
Not yet, My hosting company won't allow me to run the update on the existing server so I need to somehow put it in maint mode to make it so nothing new shows up and then migrate and then upgrade.
Hoping to do this over the holidays.  Will report back when successful or if I have other issues.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 17,286
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #15 on: December 21, 2017, 04:41:58 PM »
Ok, thanks for the update. Let us know how it goes. :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline rawbert

  • Semi-Newbie
  • *
  • Posts: 18
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #16 on: January 06, 2018, 08:37:24 AM »
Hi, have you been able to sort this out? The database version error most commonly does not mean there is anything wrong with the database actually, but with that large a gap it might be worth to try running the latest upgrade.php to get rid of that part of the error message ( of course, back up first when ever about to mess with anything related to the database. )

Where can I find the latest upgrade.php?
I've been searching all over but can't find it anywhere.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,123
    • StoryBB/StoryBB on GitHub
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #17 on: January 06, 2018, 08:55:33 AM »
You don't need to run upgrade.php if you're going from SMF 2.0.14 to SMF 2.0.15 - there are no database changes to make.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

Nothing turns to hate so bitter as what once was love.

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 17,286
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #18 on: January 06, 2018, 09:19:45 AM »
Yeah, I wasn't sure when the last DB changes were made when I made my last reply, but I have also since learned that there haven't been any in 2.0.X :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 21
Re: 2.0.14 to 2.0.15 upgrade, database different version error
« Reply #19 on: January 08, 2018, 07:39:00 AM »
Hosting company copied the database to the Upgraded server/db over the vacation holiday and everything appears to be functioning fine.