Text only | Text with Images

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: sparkster666 on March 22, 2008, 11:15:37 AM

Title: Upgrade error
Post by: sparkster666 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
Title: Re: Upgrade error
Post by: Jade Elizabeth on March 22, 2008, 12:16:32 PM
Did you backup your database?
Title: Re: Upgrade error
Post by: sparkster666 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?
Title: Re: Upgrade error
Post by: Jade Elizabeth 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.
Title: Re: Upgrade error
Post by: sparkster666 on March 22, 2008, 12:27:22 PM
will do   ;)
Title: Re: Upgrade error
Post by: Jade Elizabeth on March 22, 2008, 12:38:58 PM
Let me know how it goes :D
Title: Re: Upgrade error
Post by: metallica48423 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?

Title: Re: Upgrade error
Post by: sparkster666 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??



Title: Re: Upgrade error
Post by: Jade Elizabeth 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.
Title: Re: Upgrade error
Post by: metallica48423 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
Title: Re: Upgrade error
Post by: sparkster666 on March 23, 2008, 10:00:26 AM
Thanks so much that did the trick  ;)

Title: Re: Upgrade error
Post by: Jade Elizabeth on March 23, 2008, 01:42:56 PM
/me smacks her head
Shoulda known it would be in the manual
Title: Re: Upgrade error
Post by: metallica48423 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
Text only | Text with Images