It's really hard to say without knowing what that ID is, but it's probably a
Django issue. We don't seem to have any code hooking in there.

Christian

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


On Fri, May 14, 2010 at 3:44 PM, Dan Savilonis <d...@n-cube.org> wrote:

> I tried this out and didn't have much luck. Any thoughts on whether
> this is a django issue or reviewboard issue?
>
> $ rb-site manage /home/reviewboard_head dumpdata -- --verbosity=2 --
> traceback --format=xml > dump                                    .xml
> Traceback (most recent call last):
>  File "/usr/bin/rb-site", line 9, in <module>
>    load_entry_point('ReviewBoard==1.5beta2.dev-20100422',
> 'console_scripts', 'rb-site')()
>  File "/usr/lib/python2.5/site-packages/
> ReviewBoard-1.5beta2.dev_20100422-py2.5.egg/reviewboard/cmdline/
> rbsite.py", line 1583, in main
>    command.run()
>  File "/usr/lib/python2.5/site-packages/
> ReviewBoard-1.5beta2.dev_20100422-py2.5.egg/reviewboard/cmdline/
> rbsite.py", line 1517, in run
>    site.run_manage_command(args[0], args[1:])
>  File "/usr/lib/python2.5/site-packages/
> ReviewBoard-1.5beta2.dev_20100422-py2.5.egg/reviewboard/cmdline/
> rbsite.py", line 377, in run_manage_command
>    execute_manager(reviewboard.settings, [__file__, cmd] + params)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/management/__init__.py", line 362, in execute_manager
>    utility.execute()
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/management/__init__.py", line 303, in execute
>    self.fetch_command(subcommand).run_from_argv(self.argv)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/management/base.py", line 195, in run_from_argv
>    self.execute(*args, **options.__dict__)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/management/base.py", line 222, in execute
>    output = self.handle(*args, **options)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/management/commands/dumpdata.py", line 80, in handle
>    return serializers.serialize(format, objects, indent=indent)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/serializers/__init__.py", line 87, in serialize
>    s.serialize(queryset, **options)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/serializers/base.py", line 47, in serialize
>    self.handle_fk_field(obj, field)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> core/serializers/xml_serializer.py", line 82, in handle_fk_field
>    related = getattr(obj, field.name)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/fields/related.py", line 257, in __get__
>    rel_obj = QuerySet(self.field.rel.to).get(**params)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/query.py", line 299, in get
>    clone = self.filter(*args, **kwargs)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/query.py", line 498, in filter
>    return self._filter_or_exclude(False, *args, **kwargs)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/query.py", line 516, in _filter_or_exclude
>    clone.query.add_q(Q(*args, **kwargs))
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/sql/query.py", line 1675, in add_q
>    can_reuse=used_aliases)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/sql/query.py", line 1614, in add_filter
>    connector)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/sql/where.py", line 56, in add
>    obj, params = obj.process(lookup_type, value)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/sql/where.py", line 269, in process
>    params = self.field.get_db_prep_lookup(lookup_type, value)
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/fields/__init__.py", line 210, in get_db_prep_lookup
>    return [self.get_db_prep_value(value)]
>  File "/usr/lib/python2.5/site-packages/Django-1.1.1-py2.5.egg/django/
> db/models/fields/__init__.py", line 361, in get_db_prep_value
>    return int(value)
> ValueError: invalid literal for int() with base 10: 'changedesc_id'
>
> Dan
>
>
> On May 5, 4:44 am, Christian Hammond <chip...@chipx86.com> wrote:
> > Hi,
> >
> > The SQL dump formats are different between sqlite3 and MySQL. There's no
> > great way to transition between these. This is something that has come up
> a
> > lot lately, so we may have to look into reviving our old DB migration
> > scripts which dump to a common format and then load back in.
> >
> > Depending on the size of your database, you may be able to use Django's
> > dumping/loading logic. I seem to recall that it didn't handle large
> > databases well, but you can give it a try.
> >
> > On the old server, do:
> >
> >     rb-site manage /path/to/site dumpdata --format=xml >
> > reviewboard-dump.xml
> >
> > On the new server:
> >
> >     rb-site manage /path/to/site loaddata reviewboard-dump.xml
> >
> > You will need to do this with the same version of Review Board on the new
> > server as on the old. So, first install the old version, attempt that
> dump,
> > and make sure the site comes back up. Then attempt a Review Board and
> site
> > upgrade.
> >
> > I don't know for sure that this will work, but it's worth a try.
> >
> > Christian
> >
> > --
> > Christian Hammond - chip...@chipx86.com
> > Review Board -http://www.reviewboard.org
> > VMware, Inc. -http://www.vmware.com
> >
> >
> >
> >
> >
> > On Tue, May 4, 2010 at 11:50 PM, WANG Yanchao <yanchaow...@gmail.com>
> wrote:
> > > Hi, there:
> > > I have a problem: How to migrate a reviewboard site to another
> reviewboard
> > > site.
> > > *Background:* We have been using reviewboard+sqlite on one server for a
> > > long time(2 years). And recently we have been have performance issues.
> So we
> > > bought a new server and set up a new instance of reviewboard, we are
> > > planning to use mysql instead of sqlite.
> > > *Versions and OS:* The old one review board
> > > is ReviewBoard-1.0alpha2.dev_20090120-py2.5.egg on debian, and the new
> one
> > > is ReviewBoard-1.0.7-py2.5.egg/ on redhat
> > > *My question:* is how to move all the users/review groups and review
> > > requests data from the old review board to the new one. Can I use
> sqlite3 to
> > > dump the database and then import to the new reviewboard database(
> mysql)
> >
> > > Thanks!
> > > -Yanchao
> >
> > >  --
> > > Want to help the Review Board project? Donate today at
> > >http://www.reviewboard.org/donate/
> > > Happy user? Let us know athttp://www.reviewboard.org/users/
> > > -~----------~----~----~----~------~----~------~--~---
> > > To unsubscribe from this group, send email to
> > > reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com>
> <reviewboard%2bunsubscr...@googlegr oups.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 athttp://
> www.reviewboard.org/donate/
> > Happy user? Let us know athttp://www.reviewboard.org/users/
> > -~----------~----~----~----~------~----~------~--~---
> > To unsubscribe from this group, send email to
> reviewboard+unsubscr...@googlegroups.com<reviewboard%2bunsubscr...@googlegroups.com>
> > For more options, visit this group athttp://
> 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<reviewboard%2bunsubscr...@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

Reply via email to