Problem encountered during site upgrade from 1.5 to 1.5.5

2011-07-08 Thread Dan Brook
The problem at hand is this error when upgrading a site:

$ sudo rb-site upgrade /path/to/site
Rebuilding directory structure
Updating database. This may take a while.
There are unapplied evolutions for diffviewer.
There are unapplied evolutions for reviews.
There are unapplied evolutions for scmtools.
Project signature has changed - an evolution is required
No fixtures found.
/usr/lib/python2.4/site-packages/pycrypto-2.3-py2.4-linux-i686.egg/
Crypto/Util/randpool.py:40: RandomPool_DeprecationWarning: This
application uses RandomPool, which is BROKEN in older releases.  See
http://www.pycrypto.org/randpool-broken
Error: Error applying evolution: column basedir of relation
diffviewer_diffset already exists

I had already updated ReviewBoard with easy_install from 1.5 to 1.5.3
and then 1.5.3 to 1.5.5 (IIRC) but had forgotten to upgrade the site
during those updates which I suspect is the cause of the problem.

Doing the naive thing and dropping the diffviewer_diffset.basedir
column results in this error:

Error: Error applying evolution: cannot ALTER TABLE
diffviewer_diffset because it has pending trigger events

So I feel like I'm rather stuck between a rock and a hard place of my
own making. Any advice on how I might proceed would be very much
appreciated.

Cheers,
Dan Brook

-- 
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


Re: Problem encountered during site upgrade from 1.5 to 1.5.5

2011-07-08 Thread Christian Hammond
Did you back up before dropping the table?

If you dropped the table, with no backup, you're basically screwed. That
table represents the diffs.

If you have a backup to come back to, then one thing to try first is to
upgrade django_evolution using easy_install -U. Then try the upgrade again.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com


On Fri, Jul 8, 2011 at 7:01 AM, Dan Brook mr.daniel.br...@gmail.com wrote:

 The problem at hand is this error when upgrading a site:

 $ sudo rb-site upgrade /path/to/site
 Rebuilding directory structure
 Updating database. This may take a while.
 There are unapplied evolutions for diffviewer.
 There are unapplied evolutions for reviews.
 There are unapplied evolutions for scmtools.
 Project signature has changed - an evolution is required
 No fixtures found.
 /usr/lib/python2.4/site-packages/pycrypto-2.3-py2.4-linux-i686.egg/
 Crypto/Util/randpool.py:40: RandomPool_DeprecationWarning: This
 application uses RandomPool, which is BROKEN in older releases.  See
 http://www.pycrypto.org/randpool-broken
 Error: Error applying evolution: column basedir of relation
 diffviewer_diffset already exists

 I had already updated ReviewBoard with easy_install from 1.5 to 1.5.3
 and then 1.5.3 to 1.5.5 (IIRC) but had forgotten to upgrade the site
 during those updates which I suspect is the cause of the problem.

 Doing the naive thing and dropping the diffviewer_diffset.basedir
 column results in this error:

 Error: Error applying evolution: cannot ALTER TABLE
 diffviewer_diffset because it has pending trigger events

 So I feel like I'm rather stuck between a rock and a hard place of my
 own making. Any advice on how I might proceed would be very much
 appreciated.

 Cheers,
 Dan Brook

 --
 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

Re: Problem encountered during site upgrade from 1.5 to 1.5.5

2011-07-08 Thread Dan Brook
On Fri, Jul 8, 2011 at 8:03 PM, Christian Hammond chip...@chipx86.com wrote:
 Did you back up before dropping the table?

Indeed, that was the first thing I did before touching the DB.

 If you have a backup to come back to, then one thing to try first is to
 upgrade django_evolution using easy_install -U. Then try the upgrade again.

I gave that a try and django_evolution was upgraded from 0.6.2 -
0.6.4 but to no avail unfortunately - I'm still seeing the same error
on rb-site upgrade: column basedir of relation diffviewer_diffset
already exists.

Any other suggestions? :)

Cheers,
Dan Brook

-- 
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