Django admin tools new version model changes

Question

I upgraded Django admin_tools to the latest version 0.5 . And I'm using Django 1.3

Now I am getting this error when I go to admin pages:

OperationalError: (1054, "Unknown column 'admin_tools_dashboard_preferences.dashboard_id' in 'field list'")

There are no instructions mentioned in the documentation for fixing this. What ALTER TABLE should I fire without letting go of the old data?

PS: I do not use South.

score 2 · Accepted Answer · answered Aug 20 '13 at 14:27

If you compare the tables formed before and after upgradation, then you can find the column which is missing and its definition. Just add it by using Alter table.

alter table admin_tools_dashboard_preferences add column `dashboard_id` varchar(100) NOT NULL;

Using this, the previous data will not only be retained, but the functionality will work too.

score 0 · Answer 2 · answered Aug 18 '13 at 16:02

After upgrading django admin tools I faced the same problem and ended up dropping tables admin_tools_dashboard_preferences and admin_tools_menu_bookmark and recreating them using python manage.py syncdb. Obviously, it will erase all custom parameters you may set before so make sure you made a backup.

Django admin tools new version model changes

2 Answers2