• Welcome to Simple Machines Community Forum. Please login or sign up.

Upgrade error

Started by sparkster666, March 22, 2008, 11:15:37 AM

Previous topic - Next topic

sparkster666

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

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

Jade Elizabeth

Did you backup your database?
Once proud Documentation Writer and Help Squad Leader | Check out my new adult coloring career: Color With Jade/Patreon.

sparkster666

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

Jade Elizabeth

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.

sparkster666

Longisland Game Servers
www.ligs.us

Jade Elizabeth

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.

metallica48423

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

QuoteMicrosoft 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
     

sparkster666

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

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

Jade Elizabeth

Do you have a .php file with this in it?

<?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.

metallica48423

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

QuoteMicrosoft 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
     

sparkster666

Thanks so much that did the trick  ;)

Longisland Game Servers
www.ligs.us

Jade Elizabeth

* 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.

metallica48423

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

QuoteMicrosoft 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
     

Advertisement: