Advertisement:

Author Topic: Upgrade fron 1.1.21 to latest version  (Read 859 times)

Offline DaveM59

  • Newbie
  • *
  • Posts: 2
Upgrade fron 1.1.21 to latest version
« on: December 30, 2020, 07:48:41 AM »
I am a complete beginner here, no previous programming experience so I need simple help please.
I admin a forum I was handed down when the previous admin went awol, it is V1.1.21 and is working very well but a few things like the recaptcha has failed as the version has been expired and I cannot find where the scripts have been patched to remove it and install a later version, so I'd like to start afresh with the latest smf version.
I have uploaded all the large upgrade files, run the upgrade.php and it either fails with errors about the php version isn't high enough or the SQL is not compatible.
Our host WebHostingUK gives these specs...

Database server
    Server: Localhost via UNIX socket
    Server type: MariaDB
    Server connection: SSL is not being used Documentation
    Server version: 10.0.38-MariaDB - MariaDB Server
    Protocol version: 10
    User: XXXXXXXX@localhost
    Server charset: cp1252 West European (latin1)

Web server
    cpsrvd 11.90.0.17
    Database client version: libmysql - 5.6.43
    PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
    PHP version: 7.3.6

phpMyAdmin
    Version information: 4.9.5

What an I not doing?

I have also installed all the files into a separate directory, edited as many instances of the addresses to the new folder in an attaempt to at least get a forum page to display but all I get when I browse to the index.php is an error "Unknown column 'a.attachment_type' in 'field list' " which I am guessing is something in the database, so do I need to upgrade the database in some way and if so how, and also can I do it in parallel with the existing one so I can play in the new forum before releasing it to the users. I have put the current one into maintenance mode.
Sorry for the long ramble!

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,583
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Upgrade fron 1.1.21 to latest version
« Reply #1 on: December 30, 2020, 08:42:14 AM »
If you are trying to get from 1.1 to 2.0, yes you do need to update the database - that is what the upgrade.php script is for. And no, you can't run 1.1 and 2.0 from the same database side by side.
If your 1.1 install is working perfectly, the server is NOT running PHP 7.3 - that is for sure. So perhaps ask your host to confirm what the specs used atually are, and not what they should be?

https://wiki.simplemachines.org/smf/Upgrading
« Last Edit: December 30, 2020, 08:52:56 AM by Aleksi "Lex" Kilpinen »
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


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

Online shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,043
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Upgrade fron 1.1.21 to latest version
« Reply #2 on: December 30, 2020, 02:14:12 PM »
yes you can run the 2 at the same time but they would be in different locations and different databases, this is common to make an entire copy (files and dbs) of a site then upload it elsewhere for testing and updating purposes....that way your live site is still live

it's always a good idea to take a full backup of the site before starting anything as well

and as aleksi stated, if you are running 1.x of smf there's no way that your php is 7.3, 1.x is so outdated it was never designed to work with 7+ php

I don't think that you can just straight upgrade from 1.1.21 to 2.0.17, I could be wrong but pretty sure that you have to go one by one

1.1.21 to 2.0
2.0 to 2.0.1
2.0.1 to 2.0.2
ect ect ect

https://custom.simplemachines.org/upgrades/

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,583
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Upgrade fron 1.1.21 to latest version
« Reply #3 on: December 30, 2020, 02:30:35 PM »
The large upgrade package should actually be able to handle a straight 1.1.x to 2.0.17.
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


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


Online shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 2,950
    • sbulen on GitHub
Re: Upgrade fron 1.1.21 to latest version
« Reply #5 on: December 30, 2020, 04:14:58 PM »
FYI, both the 2.0 & 2.1 upgraders will upgrade straight from 2.0, 1.1, 1.0 & even YaBBSE 1.5.5.

When they have problems, the issues tend to be due to database-level customizations, or failed/partial utf8 conversions. 

Both upgraders can be run via CLI, as well. In fact, going forward, I'd probably recommend CLI over browser upgrades for large or very old forums.  CLI is much better at reporting errors.
https://wiki.simplemachines.org/smf/Upgrading



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

Offline DaveM59

  • Newbie
  • *
  • Posts: 2
Re: Upgrade fron 1.1.21 to latest version
« Reply #6 on: February 02, 2021, 03:03:23 AM »
utf8 conversion? The admin section asks if I want to convert so does this mean the database is still in an older format? Should I run the conversion first?

Offline GigaWatt

  • The Smiley Guy
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,341
  • Gender: Male
    • MechDR on GitHub
    • Macedonian electronics forum
Re: Upgrade fron 1.1.21 to latest version
« Reply #7 on: February 02, 2021, 07:07:05 AM »
First, make a backup of the old database, then yes, convert it to UTF-8 ;).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Sir Osis of Liver

  • SMF Super Hero
  • *******
  • Posts: 10,809
  • We were all equal in the end.
Re: Upgrade fron 1.1.21 to latest version
« Reply #8 on: February 02, 2021, 11:29:36 AM »
If your 1.1 install is working perfectly, the server is NOT running PHP 7.3 - that is for sure. So perhaps ask your host to confirm what the specs used atually are, and not what they should be?

I've seen this once or twice, where host was reporting incorrect php version.  Run phpinfo (attached), that will give you accurate versions.

Wouldn't make any changes to database until upgrade is successful.
“The best laid schemes o' mice an' men / Gang aft a-gley.” - Robert Burns