Upgrading SMF 2.0.12 to 2.1.4 or to 2.0.19

[RoamPT]

Alright so its been a while since I used SMF forums. I'm trying to bring back my forum which has a crazy amount of users (5k) and way too much information. Problem is I can't seem to be able to upgrade. At the moment I'm doing through WAMP before I go live.

Everytime I try to go now from 2.0.12 to 2.0.13 I get this error:

Code Select Expand

The upgrader found some old or outdated language files, for the forum default language
I cant straight update to 2.1.4 since my WAMP doesn't support php 7.4+ but either way I have a second WAMP server running the latest PHP and MYSQL but my database won't update successfully due to not be upgraded accordingly to the new MYSQL versions. So what can I do to fix this whole mess. I was able to upgrade from 2.0.2 to 2.0.12 so far. Thanks.

Version Information:

Forum version: SMF 2.0.12
Current SMF version: SMF 2.0.2

[Sir Osis of Liver]

https://wiki.simplemachines.org/smf/SMF2.1:Requirements_and_recommendations

[RoamPT]

Thanks. I'm having this issue trying to import it though.

Code Select Expand

SQL query: Copy


CREATE TABLE `smf_messages` (
 `id_msg` int(10) unsigned NOT NULL auto_increment,
 `id_topic` mediumint(8) unsigned NOT NULL default 0,
 `id_board` smallint(5) unsigned NOT NULL default 0,
 `poster_time` int(10) unsigned NOT NULL default 0,
 `id_member` mediumint(8) unsigned NOT NULL default 0,
 `id_msg_modified` int(10) unsigned NOT NULL default 0,
 `subject` varchar(255) NOT NULL default '',
 `poster_name` varchar(255) NOT NULL default '',
 `poster_email` varchar(255) NOT NULL default '',
 `poster_ip` varchar(255) NOT NULL default '',
 `smileys_enabled` tinyint(4) NOT NULL default 1,
 `modified_time` int(10) unsigned NOT NULL default 0,
 `modified_name` varchar(255) NOT NULL default '',
 `body` mediumtext NOT NULL,
 `icon` varchar(16) NOT NULL default 'xx',
 `approved` tinyint(3) NOT NULL default 1,
 `ua_os` tinytext NOT NULL,
 `ua_browser` tinytext NOT NULL,
 `ua_os_icon` tinytext NOT NULL,
 `ua_browser_icon` tinytext NOT NULL,
 PRIMARY KEY (`id_msg`),
 UNIQUE [...]
MySQL said: Documentation

#1071 - Specified key was too long; max key length is 1000 bytes

[RoamPT]

Okay so I did a new clean install of the 2.1.4 problem is my database wont work with it whatsoever. I imported my database manually and I get this:

Code Select Expand

( ! ) Warning: Trying to access array offset on value of type null in C:\wamp64\www\forum\Sources\Subs-Db-mysql.php on line 590
Call Stack
# Time Memory Function Location
1 0.0000 366560 {main}( ) ...\index.php:0
2 0.0019 388464 reloadSettings( ) ...\index.php:142
3 0.0020 389576 smf_db_query( $identifier = '', $db_string = '\n\t\t\tSELECT variable, value\n\t\t\tFROM {db_prefix}settings', $db_values = [], $connection = ??? ) ...\Load.php:47
4 0.0030 389736 smf_db_error( $db_string = '\n\t\t\tSELECT variable, value\n\t\t\tFROM smf_settings', $connection = class mysqli { public $affected_rows = -1; public $client_info = 'mysqlnd 8.2.13'; public $client_version = 80213; public $connect_errno = 0; public $connect_error = NULL; public $errno = 1812; public $error = 'Tablespace is missing for table `forum`.`smf_settings`.'; public $error_list = [0 => [...]]; public $field_count = 0; public $host_info = 'localhost via TCP/IP'; public $info = NULL; public $insert_id = 0; public $server_info = '8.2.0'; public $server_version = 80200; public $sqlstate = 'HY000'; public $protocol_version = 10; public $thread_id = 49; public $warning_count = 1 } ) ...\Subs-Db-mysql.php:494
Tablespace is missing for table `forum`.`smf_settings`.

[Kindred]

You can not import a 2.0.x database contents into a 2.1.x database

[RoamPT]

Fair enough so how do I go about upgrading properly from 2.0.12 to 2.1 4? I have wamp 2.2 with the php 5.3 since it runs the 2.0.12 smoothly. I tried to migrate the 2.0.12 to wamp 3 with 5.6 php and all I get is errors. So i'm at a loss trying to update everything to 2.1.4.

[Diego Andrés]

You'll need at least PHP 7.0

https://wiki.simplemachines.org/smf/SMF2.1:Requirements_and_recommendations

And then you can follow the steps for upgrading: https://wiki.simplemachines.org/smf/Upgrading

[Doug Heffernan]

Fair enough so how do I go about upgrading properly from 2.0.12 to 2.1 4?

Please see the link posted above by Diego for a detailed guide on how to do a large upgrade.

I have wamp 2.2 with the php 5.3 since it runs the 2.0.12 smoothly. I tried to migrate the 2.0.12 to wamp 3 with 5.6 php and all I get is errors. So i'm at a loss trying to update everything to 2.1.4.

Smf 2.1.4. will not work with that old version of php. You will need to upgrade your php version too in order to run smf 2.1.4.

Okay so I did a new clean install of the 2.1.4 problem is my database wont work with it whatsoever. I imported my database manually and I get this:

Provided you have upgraded your php to version 8.x, after you have imported your 2.0.x database on a 2.1.4. forum, you will have to upload the upgrade.php and .sql files from the large 2.1.4. upgrade package to your forum root and then run the upgrader in order to bring the database up to date. i.e. upgrading it.

[RoamPT]

Fair enough so how do I go about upgrading properly from 2.0.12 to 2.1 4?

Please see the link posted above by Diego for a detailed guide on how to do a large upgrade.

I have wamp 2.2 with the php 5.3 since it runs the 2.0.12 smoothly. I tried to migrate the 2.0.12 to wamp 3 with 5.6 php and all I get is errors. So i'm at a loss trying to update everything to 2.1.4.

Smf 2.1.4. will not work with that old version of php. You will need to upgrade your php version too in order to run smf 2.1.4.

Okay so I did a new clean install of the 2.1.4 problem is my database wont work with it whatsoever. I imported my database manually and I get this:

Provided you have upgraded your php to version 8.x, after you have imported your 2.0.x database on a 2.1.4. forum, you will have to upload the upgrade.php and .sql files from the large 2.1.4. upgrade package to your forum root and then run the upgrader in order to bring the database up to date. i.e. upgrading it.

Thanks a lot. That worked out, I was able to upload my old database and it converted. Problem is it seems to force convert it to utf8 when doing the upgrade.php. It messed up with my boards and topics using special characters. See here:

[Kindred]

yes, SMF 2.1 uses only UTF8

[RoamPT]

yes, SMF 2.1 uses only UTF8

So there's no way to fix that? Since the forum is in Portuguese that will end up killing the whole thing. Unless I just downgrade versions.

[Sir Osis of Liver]

Have you installed the 2.1 Portuguese language pack?

[RoamPT]

Have you installed the 2.1 Portuguese language pack?

Yes I did, the latest portuguese-pt utf-8 language pack. It still didn't fix it.

[RoamPT]

Since I couldn't edit my previous post I need to make a new post. I was able to fix the language by having the Portuguese language set by default as it converts the database and boom all is good now.

So my steps following what everyone said to sucessfully get this far was:

1 - Latest WAMP installed.
2 - Install a clean 2.1.4 forum software.
3 - Import old database to new one created for the step 2. I used MariaDB as MySQL didn't want to import my database properly.
4 - Make sure you use repair_settings.php to fix all the directories.
5 - Like Doug Heffernan mentioned do this:

Provided you have upgraded your php to version 8.x, after you have imported your 2.0.x database on a 2.1.4. forum, you will have to upload the upgrade.php and .sql files from the large 2.1.4. upgrade package to your forum root and then run the upgrader in order to bring the database up to date. i.e. upgrading it.

6- Enjoy your newly upgraded forum with your old database.

Thank you to everyone above that helped me out fixing this mess.

[Doug Heffernan]

Glad to see that you upgraded your forum successfully to 2.1.4.