Advertisement:

Author Topic: Upgrade error  (Read 7211 times)

Offline sparkster666

  • Semi-Newbie
  • *
  • Posts: 19
Upgrade error
« on: March 22, 2008, 11:15:37 AM »
I am trying to upgrade my forum from SMF 1.1.2 to smf2 beta 3.

the upgrade.php says Upgrading from YaBB SE! what is YaBB SE!??

when I run upgrade.php I get this error

Code: [Select]
Database Changes
Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 3.
Executing: "Converting activity logs..." (2 of 8 - of this script).

Database Updates Complete! Click Continue to Proceed.
!!
Error!
Unknown column 'lb.logTime' in 'where clause'

I tried upgrading to 1.1.4 but when I run the upgrade.php it is a blank page

I tried to search the error but most hits were not in english  :-\

thanks
Longisland Game Servers
www.ligs.us [nofollow]

Offline Jade Elizabeth

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,647
  • Gender: Female
  • Keep your enemies close and your friends closer ;)
    • jadetrainor on LinkedIn
    • @alundra on Twitter
    • Jades-World
Re: Upgrade error
« Reply #1 on: March 22, 2008, 12:16:32 PM »
Did you backup your database?
Once proud Documentation Writer and Help Squad Leader | Check out my new adult coloring career: Color With Jade/Patreon.

Offline sparkster666

  • Semi-Newbie
  • *
  • Posts: 19
Re: Upgrade error
« Reply #2 on: March 22, 2008, 12:18:34 PM »
yes i backup everything is there a way to fix it so if I try it again it will not fail?
Longisland Game Servers
www.ligs.us [nofollow]

Offline Jade Elizabeth

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,647
  • Gender: Female
  • Keep your enemies close and your friends closer ;)
    • jadetrainor on LinkedIn
    • @alundra on Twitter
    • Jades-World
Re: Upgrade error
« Reply #3 on: March 22, 2008, 12:23:23 PM »
Well I'd advise restoring your backup, and then trying to upgrade to 1.1.4 before the 2.0 beta.
Once proud Documentation Writer and Help Squad Leader | Check out my new adult coloring career: Color With Jade/Patreon.

Offline sparkster666

  • Semi-Newbie
  • *
  • Posts: 19
Re: Upgrade error
« Reply #4 on: March 22, 2008, 12:27:22 PM »
will do   ;)
Longisland Game Servers
www.ligs.us [nofollow]

Offline Jade Elizabeth

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,647
  • Gender: Female
  • Keep your enemies close and your friends closer ;)
    • jadetrainor on LinkedIn
    • @alundra on Twitter
    • Jades-World
Re: Upgrade error
« Reply #5 on: March 22, 2008, 12:38:58 PM »
Let me know how it goes :D
Once proud Documentation Writer and Help Squad Leader | Check out my new adult coloring career: Color With Jade/Patreon.

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: Upgrade error
« Reply #6 on: March 22, 2008, 05:42:12 PM »
It shouldn't matter.  There were not any changes to the database in 1.1.2, 1.1.3, or 1.1.4.

what is your mysql version?

Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

Quote
Microsoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"

Useful Links:
Online Manual!
How to Help us Help you   
Search
Settings Repair Tool
     

Offline sparkster666

  • Semi-Newbie
  • *
  • Posts: 19
Re: Upgrade error
« Reply #7 on: March 22, 2008, 09:13:19 PM »
Well here is the problem I have the site was running on version 4.1.22-standard

I backed it up and up loaded it to Server version: 5.0.45  ;(

Now I am trying to update it to 1.14 and I get this error

Code: [Select]
Upgrading...
Updating and creating indexes... Unsuccessful!
This query:

    ALTER TABLE smf_smileys
    ORDER BY LENGTH(code) DESC;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2


Is the different mysql server versions going to make this impossible??



Longisland Game Servers
www.ligs.us [nofollow]

Offline Jade Elizabeth

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,647
  • Gender: Female
  • Keep your enemies close and your friends closer ;)
    • jadetrainor on LinkedIn
    • @alundra on Twitter
    • Jades-World
Re: Upgrade error
« Reply #8 on: March 22, 2008, 10:20:07 PM »
Do you have a .php file with this in it?

Code: [Select]
<?php
phpinfo
();
?>

That will tell you the SQL versions, and if you link us to it we can check and see if there is anything that could be causing errors.
Once proud Documentation Writer and Help Squad Leader | Check out my new adult coloring career: Color With Jade/Patreon.

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: Upgrade error
« Reply #9 on: March 23, 2008, 05:40:39 AM »
Ahh, see that gives us the crucial piece of information we need to answer this topic ;)

see this doc.  It should get you straigtened out
http://docs.simplemachines.org/index.php?topic=1079.msg2548#msg2548
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

Quote
Microsoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"

Useful Links:
Online Manual!
How to Help us Help you   
Search
Settings Repair Tool
     

Offline sparkster666

  • Semi-Newbie
  • *
  • Posts: 19
Re: Upgrade error
« Reply #10 on: March 23, 2008, 10:00:26 AM »
Thanks so much that did the trick  ;)

Longisland Game Servers
www.ligs.us [nofollow]

Offline Jade Elizabeth

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,647
  • Gender: Female
  • Keep your enemies close and your friends closer ;)
    • jadetrainor on LinkedIn
    • @alundra on Twitter
    • Jades-World
Re: Upgrade error
« Reply #11 on: March 23, 2008, 01:42:56 PM »
* Alundra smacks her head
Shoulda known it would be in the manual
Once proud Documentation Writer and Help Squad Leader | Check out my new adult coloring career: Color With Jade/Patreon.

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: Upgrade error
« Reply #12 on: March 23, 2008, 03:09:33 PM »
kinda ironic huh? glad to hear that worked out for you. seems to be a bug in some mysql versions
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

Quote
Microsoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"

Useful Links:
Online Manual!
How to Help us Help you   
Search
Settings Repair Tool