146: syntax_highlighting not found in my db

philippe********@gmai***** (Google Code) (Is this you? Claim this profile.)
June 28, 2007
I did svn update this morning.. There seems to be a new field in a db table
called syntax_highlighting.. How can i update my db without loosing data?

So i tried the db backup script:

Traceback (most recent call last):
  File "./manage.py", line 90, in <module>
    execute_manager(settings)
  File "/home/phil/reviewboard/django/django/core/management.py", line
1736, in execute_manager
    execute_from_command_line(action_mapping, argv)
  File "/home/phil/reviewboard/django/django/core/management.py", line
1653, in execute_from_command_line
    print action_mapping[action](args[1:], options.format, options.indent)
  File "/home/phil/reviewboard/django/django/core/management.py", line
1505, in dump_data
    objects.extend(model.objects.all())
  File "/home/phil/reviewboard/django/django/db/models/query.py", line 110,
in __iter__
    return iter(self._get_data())
  File "/home/phil/reviewboard/django/django/db/models/query.py", line 477,
in _get_data
    self._result_cache = list(self.iterator())
  File "/home/phil/reviewboard/django/django/db/models/query.py", line 185,
in iterator
    cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "") +
",".join(select) + sql, params)
  File "/home/phil/reviewboard/django/django/db/backends/util.py", line 18,
in execute
    return self.cursor.execute(sql, params)
  File "/home/phil/reviewboard/django/django/db/backends/sqlite3/base.py",
line 101, in execute
    return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: no such column: accounts_profile.syntax_highlighting

No way
chipx86
#1 chipx86
You have to make sure you backup your database before updates and then load it back
if any models.py file changes. Take a look at the DatabaseSchemaUpgrades wiki page
for more information.
  • +Invalid