Hi, Yeah, this is sounding very messed up, and I don't understand how you're in this state.
One last-ditch effort would be to restore whatever SQL dump you have on the appropriate version (previous version of RB would be best), then try to create a brand new database with that version, load in the database, delete the tables starting with "django_evolution_", and then try an upgrade. That may not work, but I don't know what else to recommend, since I have no idea what caused this to get so inconsistent. It's possible we could help restore this, but we'd need the whole database dump and would need to charge for the time under our company, Beanbag. There wouldn't be any guarantees, but if you're completely stuck and want to explore that, let me know. Christian On Jun 15, 2012, at 15:59, "Gav..." <ipv6g...@gmail.com> wrote: > 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 - chip...@chipx86.com > Review Board - http://www.reviewboard.org > VMware, Inc. - http://www.vmware.com > > > On Sat, Jun 9, 2012 at 8:47 PM, Gav... <ipv6g...@gmail.com> 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... <ipv6g...@gmail.com> 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/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com > 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 > reviewboard+unsubscr...@googlegroups.com > 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 > reviewboard+unsubscr...@googlegroups.com > 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 reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
