Advertisement:

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

Offline Captkaos

  • Semi-Newbie
  • *
  • Posts: 19
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: 48,063
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: 19
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: 19
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 sǝๅqɯɐɥS

  • SMF Hero
  • ******
  • Posts: 4,510
  • 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
  • Full Member
  • *
  • Posts: 508
    • 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: 19
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
  • Full Member
  • *
  • Posts: 508
    • 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: 19
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
  • Full Member
  • *
  • Posts: 508
    • 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: 19
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
  • Full Member
  • *
  • Posts: 508
    • 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: 19
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.