Advertisement:

Author Topic: Update SMF 1.1.21 to 2.0.14  (Read 4040 times)

Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Update SMF 1.1.21 to 2.0.14
« on: October 26, 2017, 01:43:50 PM »
Hi everyone!

I have bought a forum with the SMF version 1.1.21 and I have made the upgrade to 2.0.14.
The upgrade seems to be successful, but I get this error:
Unknown column 'c.cat_order' in 'field list'
File: /var/www/vhosts/coding4you.de/httpdocs/Sources/Subs-Boards.php
Line: 1047

I don't know what to do know. :(

Thanks!!!

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,050
    • Arantor on GitHub
Re: Update SMF 1.1.21 to 2.0.14
« Reply #1 on: October 26, 2017, 01:47:32 PM »
How did you make the upgrade exactly?
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Re: Update SMF 1.1.21 to 2.0.14
« Reply #2 on: October 26, 2017, 01:58:15 PM »
I have load the large upgrade SMF 2.0.14.

I uploaded the files. I got a database connection error, so I run repair_settings.php and after the repair upgrade.php. Everything was fine but after the upgrade I got the error.

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,076
Re: Update SMF 1.1.21 to 2.0.14
« Reply #3 on: October 26, 2017, 02:08:47 PM »
did you actually run the upgrade.php script?

Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Re: Update SMF 1.1.21 to 2.0.14
« Reply #4 on: October 26, 2017, 02:17:42 PM »
Yes, the I got this error:

Unknown column 'c.cat_order' in 'field list'
File: /var/www/vhosts/coding4you.de/httpdocs/Sources/Subs-Boards.php
Line: 1047

Know I resettet back to 1.1.21

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,050
    • Arantor on GitHub
Re: Update SMF 1.1.21 to 2.0.14
« Reply #5 on: October 26, 2017, 02:31:21 PM »
That doesn't sound like you actually ran upgrade.php because that should have done the conversion for you and made cat_order.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,076
Re: Update SMF 1.1.21 to 2.0.14
« Reply #6 on: October 26, 2017, 02:31:46 PM »
so you are running which version for files and which for the database?

Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Re: Update SMF 1.1.21 to 2.0.14
« Reply #7 on: October 26, 2017, 02:37:24 PM »
the upgrade I have started and ran through. an error was reported only because of the language pack.

@illori Do you mean the sql and php version?

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,076
Re: Update SMF 1.1.21 to 2.0.14
« Reply #8 on: October 26, 2017, 02:44:38 PM »
no, i mean exactly what i said.

Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Re: Update SMF 1.1.21 to 2.0.14
« Reply #9 on: October 26, 2017, 02:51:32 PM »
Now both with 1.1.21 and I tried to upgrade both to 2.0.14

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,076
Re: Update SMF 1.1.21 to 2.0.14
« Reply #10 on: October 26, 2017, 02:52:37 PM »

Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Re: Update SMF 1.1.21 to 2.0.14
« Reply #11 on: October 26, 2017, 02:55:28 PM »
Yes, just like this.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,100
  • 'Tis the gift to be simple
Re: Update SMF 1.1.21 to 2.0.14
« Reply #12 on: October 26, 2017, 04:49:49 PM »
Your forum is working fine in 1.1.21.  You should not lose the database connection when you upload upgrade package and run upgrade.php.  If you can pm FTP access (server/username/password) I'll have a look.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,050
    • Arantor on GitHub
Re: Update SMF 1.1.21 to 2.0.14
« Reply #13 on: October 26, 2017, 05:32:49 PM »
If it's working fine in 1.1.21, that means the upgrade process could not have been run.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,100
  • 'Tis the gift to be simple
Re: Update SMF 1.1.21 to 2.0.14
« Reply #14 on: October 26, 2017, 05:41:48 PM »
Unless backups were restored (some people actually do back up).  Bet OP uploaded install package first and overwrote Settings.php.

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,076
Re: Update SMF 1.1.21 to 2.0.14
« Reply #15 on: October 26, 2017, 05:52:51 PM »
if they did then they would have gotten a very different error message.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,100
  • 'Tis the gift to be simple
Re: Update SMF 1.1.21 to 2.0.14
« Reply #16 on: October 26, 2017, 06:02:09 PM »
Looks like initially he got db connection error, which means db credentials were lost.  To get to upgrade.php, upgrade package would have had to be uploaded.  At that point anything could have happened, causing unknown column error.  But forum is running in 1.1.21, so no harm done (so far).  Appears to be a clean install, upgrade should be no problem.


Offline Impagnatiello

  • Semi-Newbie
  • *
  • Posts: 14
Re: Update SMF 1.1.21 to 2.0.14
« Reply #17 on: October 27, 2017, 03:19:06 AM »
I have made a clean install, but the same error was shown.

Now I installed the version 1.1.21 new and load the db backup.

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 48,076
Re: Update SMF 1.1.21 to 2.0.14
« Reply #18 on: October 27, 2017, 05:03:17 AM »
what steps have you done? tell us step by step.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 7,100
  • 'Tis the gift to be simple
Re: Update SMF 1.1.21 to 2.0.14
« Reply #19 on: October 27, 2017, 01:12:01 PM »
Ok, up and running in 2.0.14.  upgrade.php ran normally.  You'll need to change default theme to Curve.  Access forum with this link.  Check everything.  Will be back on tonight.