1.25 to 1.1.0 to 1.2.0

Hi everybody,

I am having a problem with upgrading, I have piler 0.1.25-rc3, build 881, and tried to upgrade to 1.1.0 using the db-upgrade-0.1.24-vs-1.1.0.sql, I got some errors and when I run it again now I only get: ERROR 1060 (42S21) at line 2: Duplicate column name 'ga_enabled'

Then I started to have lot's of problems (search only working once, then when clicked some email I had to logout and logon for it to work again)

So I hoped that the new 1.2.0 fixed this, and I did the mysql -u piler -p piler < util/db-upgrade-1.1.0-vs-1.2.0.sql

And got the following error: ERROR 1064 (42000) at line 6: 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 '--drop index entry on archiving_rule' at line 1

Running it again gave me the error: ERROR 1060 (42S21) at line 3: Duplicate column name 'body'

Today I realised that my piler still states version 0.1.25-rc3, build 881 on the health monitor, so I guess things are really messed up :(

What's the best way to solve this?

Thanks

Cassio

Comments (2)