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.
how are you doing the upgrade?
It was installed via Package Manager as I have done for all the 2.0 updates.
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?
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.
Please list your mods also.
This is the function from the file below. I attached a list of mods installed.
// 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
What version of MySQL are you running?
You can view this under Admin | Support & credits.
I cannot get to the setting on the server. When I go to my hosting is shows: Database client version: libmysql - 5.0.83
I believe the proper fix is to patch/upgrade your MySQL version. Is this feasible?
I could have the hosting company upgrade it. What would be the min required. I am on a share hosting server.
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...)
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.
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. )
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.
Ok, thanks for the update. Let us know how it goes. :)
Quote from: Aleksi "Lex" Kilpinen 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. )
Where can I find the latest upgrade.php?
I've been searching all over but can't find it anywhere.
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.
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 :)
Hosting company copied the database to the Upgraded server/db over the vacation holiday and everything appears to be functioning fine.