Hi, Deleted that column, and a few more that came up, then got stuck at this one: Evolution could not be simulated, possibly due to raw SQL mutations Error: Error applying evolution: (1091, "Can't DROP 'name'; check that column/key exists") Regarding exactly what I did, cant say exactly, but I just followed the usual upgrade procedures, it worked fine when I did 1.5 to 1.5.5. The difference with this one is that I had just done an 'do-release-upgrade' on the underlying OS, this then broke reviewboard as it wanted me to then upgrade which I did, then these issues came up. This is getting urgent now so if I cant recolve it today I may have to just wipe it and start again. Thanks for your help. Gav...
On Sunday, June 10, 2012 1:26:38 PM UTC+9:30, Christian Hammond wrote: > No, that should never have been reached. That shows you're in some > half-modified database state, which shouldn't have happened, given that > database transactions are used during the evolution and the earlier error > should have prevented the other modifications. > > At this point, I really wish you had a database upgrade, because things > are kind of messed up. Make one now, just in case. > > Once you have a full backup (SQL dump is best), try deleting that column. > You might get a few more like this. > > Can you tel me exactly what you did, every step of the way, prior to and > after the initial rb-site upgrade? > > Christian > > -- > Christian Hammond - [email protected] > Review Board - http://www.reviewboard.org > VMware, Inc. - http://www.vmware.com > > > On Sat, Jun 9, 2012 at 8:47 PM, Gav... <[email protected]> wrote: > >> >> On Sunday, June 10, 2012 1:04:30 PM UTC+9:30, Christian Hammond wrote: >>> >>> Your upgrade apparently also upgraded to Review Board 1.6.7, which has >>> many significant changes. And that upgrade failed, because of the >>> django_session issue. >>> >>> I've seen that django_session error before. Not sure what the cause is, >>> but basically, that's a database index that was created, and Django is >>> trying to re-create it now. You can try dropping it and see if that helps. >>> You'll need to connect to your MySQL database and do: >>> >>> drop index django_session_c25c2c28 on django_session; >>> >>> Then re-run the rb-site upgrade command on your site. Hopefully this >>> will work. >>> >>> Christian >>> >>> >> Thanks for the reply, done that, now I get: >> >> Error: Error applying evolution: (1060, "Duplicate column name >> 'is_private'") >> >> Drop that too? from where? >> >> Thanks >> >> Gav... >> >> >>> -- >>> On Sat, Jun 9, 2012 at 7:43 PM, Gav... <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> I was on RB 1.5.5 , then an upgrade of the Ubuntu OS to 12.04 LTS then >>>> broke reviewboard (so it wanted to upgrade) so I ran an upgrade which has >>>> not been successful. (Note I believe Python was upgraded from 2.6 to 2.7) >>>> >>>> It seems to work until you go to the /admin/ areas. >>>> >>>> Rebuilding directory structure >>>> Updating database. This may take a while. >>>> Creating tables ... >>>> There are unapplied evolutions for sessions. >>>> There are unapplied evolutions for accounts. >>>> There are unapplied evolutions for changedescs. >>>> There are unapplied evolutions for reviews. >>>> There are unapplied evolutions for scmtools. >>>> Project signature has changed - an evolution is required >>>> Installing custom SQL ... >>>> Installing indexes ... >>>> No fixtures found. >>>> Evolution could not be simulated, possibly due to raw SQL mutations >>>> Error: Error applying evolution: (1061, "Duplicate key name >>>> 'django_session_c25c2c28'") >>>> >>>> Tried this with the latest version 1.6.7.1 >>>> >>>> I also get emails with: >>>> >>>> OperationalError: (1054, "Unknown column >>>> 'scmtools_repository.extra_**data' >>>> in 'field list'") >>>> >>>> Any clues as to what to try next.? >>>> >>>> As I was not expecting an OS upgrade to interfere with reviewboard, >>>> there is no pre-upgrade db dump, and a rb-site manage . dbdump now fails >>>> with : >>>> >>>> _mysql_exceptions.**OperationalError: (1054, "Unknown column >>>> 'scmtools_repository.extra_**data' in 'field list'") >>>> Thanks >>>> >>>> Gav... >>>> >>>> -- >>>> Want to help the Review Board project? Donate today at >>>> http://www.reviewboard.org/**donate/<http://www.reviewboard.org/donate/> >>>> Happy user? Let us know at >>>> http://www.reviewboard.org/**users/<http://www.reviewboard.org/users/> >>>> -~----------~----~----~----~--**----~----~------~--~--- >>>> To unsubscribe from this group, send email to reviewboard+unsubscribe@* >>>> *googlegroups.com <reviewboard%[email protected]> >>>> For more options, visit this group at http://groups.google.com/** >>>> group/reviewboard?hl=en<http://groups.google.com/group/reviewboard?hl=en> >>> >>> >>> -- >> Want to help the Review Board project? Donate today at >> http://www.reviewboard.org/donate/ >> Happy user? Let us know at http://www.reviewboard.org/users/ >> -~----------~----~----~----~------~----~------~--~--- >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/reviewboard?hl=en >> > > -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
