Upgrade Error: Table reviews_reviewrequest_changedesc already exists
Hi, I'm trying to upgrade to the latest and greatest reviewboard svn code base as I routinely do but, when I run the database evolution I get the following error: Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) Full error below... [reviewboard]$ sudo ./manage.py syncdb There are unapplied evolutions for reviews. There are unapplied evolutions for reviews. There are unapplied evolutions for scmtools. There are unapplied evolutions for scmtools. Adding baseline version for new models Project signature has changed - an evolution is required Project signature has changed - an evolution is required Installing json fixture 'initial_data' from '/usr/lib/python2.4/site- packages/reviewboard/scmtools/fixtures'. Installed 6 object(s) from 1 fixture(s) [reviewboard]$ sudo ./manage.py evolve --execute You have requested a database evolution. This will alter tables and data currently in the 'reviewboard' database, and may result in IRREVERSABLE DATA LOSS. Evolutions should be *thoroughly* reviewed prior to execution. Are you sure you want to execute the evolutions? Type 'yes' to continue, or 'no' to cancel: yes Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) I updated to revision #1668. I have Django 1.0 installed. Any help? Thanks! Mary --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups reviewboard group. To post to this group, send email to reviewboard@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Upgrade Error: Table reviews_reviewrequest_changedesc already exists
How old was your previous install? That table was added to the database many months ago, and I haven't heard of it causing any problems. Did you at any point upgrade, then downgrade to an older version? Christian -- Christian Hammond - chip...@chipx86.com VMware, Inc. On Thu, Jan 8, 2009 at 4:54 PM, mary ciaom...@gmail.com wrote: Hi, I'm trying to upgrade to the latest and greatest reviewboard svn code base as I routinely do but, when I run the database evolution I get the following error: Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) Full error below... [reviewboard]$ sudo ./manage.py syncdb There are unapplied evolutions for reviews. There are unapplied evolutions for reviews. There are unapplied evolutions for scmtools. There are unapplied evolutions for scmtools. Adding baseline version for new models Project signature has changed - an evolution is required Project signature has changed - an evolution is required Installing json fixture 'initial_data' from '/usr/lib/python2.4/site- packages/reviewboard/scmtools/fixtures'. Installed 6 object(s) from 1 fixture(s) [reviewboard]$ sudo ./manage.py evolve --execute You have requested a database evolution. This will alter tables and data currently in the 'reviewboard' database, and may result in IRREVERSABLE DATA LOSS. Evolutions should be *thoroughly* reviewed prior to execution. Are you sure you want to execute the evolutions? Type 'yes' to continue, or 'no' to cancel: yes Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) I updated to revision #1668. I have Django 1.0 installed. Any help? Thanks! Mary --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups reviewboard group. To post to this group, send email to reviewboard@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Upgrade Error: Table reviews_reviewrequest_changedesc already exists
Previously I was at revision #1556 (2008-10-27) I have never downgraded. I do have this table already as the error message states. Is there anyway to move on past this error? On Jan 8, 4:56 pm, Christian Hammond chip...@chipx86.com wrote: How old was your previous install? That table was added to the database many months ago, and I haven't heard of it causing any problems. Did you at any point upgrade, then downgrade to an older version? Christian -- Christian Hammond - chip...@chipx86.com VMware, Inc. On Thu, Jan 8, 2009 at 4:54 PM, mary ciaom...@gmail.com wrote: Hi, I'm trying to upgrade to the latest and greatest reviewboard svn code base as I routinely do but, when I run the database evolution I get the following error: Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) Full error below... [reviewboard]$ sudo ./manage.py syncdb There are unapplied evolutions for reviews. There are unapplied evolutions for reviews. There are unapplied evolutions for scmtools. There are unapplied evolutions for scmtools. Adding baseline version for new models Project signature has changed - an evolution is required Project signature has changed - an evolution is required Installing json fixture 'initial_data' from '/usr/lib/python2.4/site- packages/reviewboard/scmtools/fixtures'. Installed 6 object(s) from 1 fixture(s) [reviewboard]$ sudo ./manage.py evolve --execute You have requested a database evolution. This will alter tables and data currently in the 'reviewboard' database, and may result in IRREVERSABLE DATA LOSS. Evolutions should be *thoroughly* reviewed prior to execution. Are you sure you want to execute the evolutions? Type 'yes' to continue, or 'no' to cancel: yes Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) I updated to revision #1668. I have Django 1.0 installed. Any help? Thanks! Mary --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups reviewboard group. To post to this group, send email to reviewboard@googlegroups.com 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 -~--~~~~--~~--~--~---
Re: Upgrade Error: Table reviews_reviewrequest_changedesc already exists
It sounds like something was hand-modified in the database enough to break things then. Basically, Django-Evolution keeps track of all changes to the structure of the database, and something surprised it. Is there any data in that table in your database? The only things I can think of are: 1) Drop that table (very dangerous. You might lose data. Back up first!) 2) Trick Django-Evolution into thinking your entire database is up-to-date (not sure how to do this just yet) Christian -- Christian Hammond - chip...@chipx86.com VMware, Inc. On Thu, Jan 8, 2009 at 5:00 PM, mary ciaom...@gmail.com wrote: Previously I was at revision #1556 (2008-10-27) I have never downgraded. I do have this table already as the error message states. Is there anyway to move on past this error? On Jan 8, 4:56 pm, Christian Hammond chip...@chipx86.com wrote: How old was your previous install? That table was added to the database many months ago, and I haven't heard of it causing any problems. Did you at any point upgrade, then downgrade to an older version? Christian -- Christian Hammond - chip...@chipx86.com VMware, Inc. On Thu, Jan 8, 2009 at 4:54 PM, mary ciaom...@gmail.com wrote: Hi, I'm trying to upgrade to the latest and greatest reviewboard svn code base as I routinely do but, when I run the database evolution I get the following error: Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) Full error below... [reviewboard]$ sudo ./manage.py syncdb There are unapplied evolutions for reviews. There are unapplied evolutions for reviews. There are unapplied evolutions for scmtools. There are unapplied evolutions for scmtools. Adding baseline version for new models Project signature has changed - an evolution is required Project signature has changed - an evolution is required Installing json fixture 'initial_data' from '/usr/lib/python2.4/site- packages/reviewboard/scmtools/fixtures'. Installed 6 object(s) from 1 fixture(s) [reviewboard]$ sudo ./manage.py evolve --execute You have requested a database evolution. This will alter tables and data currently in the 'reviewboard' database, and may result in IRREVERSABLE DATA LOSS. Evolutions should be *thoroughly* reviewed prior to execution. Are you sure you want to execute the evolutions? Type 'yes' to continue, or 'no' to cancel: yes Error applying evolution: (1050, Table 'reviews_reviewrequest_changedescs' already exists) I updated to revision #1668. I have Django 1.0 installed. Any help? Thanks! Mary --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups reviewboard group. To post to this group, send email to reviewboard@googlegroups.com 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 -~--~~~~--~~--~--~---
