News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Update SMF 1.1.21 to 2.0.14

Started by Impagnatiello, October 26, 2017, 01:43:50 PM

Previous topic - Next topic

Impagnatiello

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!!!

Arantor

How did you make the upgrade exactly?

Impagnatiello

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.

Illori

did you actually run the upgrade.php script?

Impagnatiello

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

Arantor

That doesn't sound like you actually ran upgrade.php because that should have done the conversion for you and made cat_order.

Illori

so you are running which version for files and which for the database?

Impagnatiello

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?

Illori


Impagnatiello

Now both with 1.1.21 and I tried to upgrade both to 2.0.14

Illori


Impagnatiello


Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Arantor

If it's working fine in 1.1.21, that means the upgrade process could not have been run.

Sir Osis of Liver

Unless backups were restored (some people actually do back up).  Bet OP uploaded install package first and overwrote Settings.php.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Illori

if they did then they would have gotten a very different error message.

Sir Osis of Liver

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.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Impagnatiello

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.

Illori

what steps have you done? tell us step by step.

Sir Osis of Liver

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.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Advertisement: