Re: Project page broken in master?

[Michael Wood <michael.g.wood@intel.com>]

On 15/05/15 14:51, Damian, Alexandru wrote:
> The easiest way to do this is to stop and start toaster - the script 
> will take care to update the database.

Yeah unfortunately it was a reverse migration which needed to happen as 
Belen had tested a branch which then migrated the database forward, then 
she wanted to testing another branch which doesn't have that migration 
so wasn't able to reverse it, by which point the database was fairly 
messy so we started a fresh database.

>
> On Fri, May 15, 2015 at 11:08 AM, Michael Wood 
> <michael.g.wood@intel.com <mailto:michael.g.wood@intel.com>> wrote:
>
>     It means you've got un-applied migrations run ./manage.py migrate
>     to apply them.
>
>     Generally If you see "Exception Value: no such column" that very
>     often means that your database has an out of date database schema.
>     i.e. it's been altered by a commit but your local "toaster.sqlite"
>     database hasn't been updated to match.
>
>     Michael
>
>
>
>     On 15/05/15 11:00, Barros Pena, Belen wrote:
>
>         The project page seems to throw an error in
>         master:fab7da4f8030a4067db0522f77eaa6d3b501c68f
>
>         Is it just me? Do your want me to open a bug? Error trace below:
>
>         Environment:
>
>
>         Request Method: GET
>         Request URL: http://127.0.0.1:8000/toastergui/project/23/
>
>         Django Version: 1.6
>         Python Version: 2.7.6
>         Installed Applications:
>         ('django.contrib.auth',
>         'django.contrib.contenttypes',
>         'django.contrib.messages',
>         'django.contrib.sessions',
>         'django.contrib.admin',
>         'django.contrib.staticfiles',
>         'django.contrib.humanize',
>         'orm',
>         'toastermain',
>         'south',
>         'bldcontrol',
>         'toastergui')
>         Installed Middleware:
>         ('django.middleware.common.CommonMiddleware',
>         'django.contrib.sessions.middleware.SessionMiddleware',
>         'django.middleware.csrf.CsrfViewMiddleware',
>         'django.contrib.auth.middleware.AuthenticationMiddleware',
>         'django.contrib.messages.middleware.MessageMiddleware')
>
>
>         Traceback:
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py"
>         in get_response
>            114.                     response = wrapped_callback(request,
>         *callback_args, **callback_kwargs)
>         File
>         "/home/yocto/master/bitbake/lib/toaster/toastergui/views.py" in
>         project
>            2175.  prj.projectlayer_set.all().order_by("id")),
>         File
>         "/home/yocto/master/bitbake/lib/toaster/toastergui/views.py" in
>         <lambda>
>            2169.                         "name" :
>         x.layercommit.layer.name <http://x.layercommit.layer.name>,
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/fields/related.py"
>         in __get__
>            308.                 rel_obj = qs.get()
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py"
>         in
>         get
>            301.         num = len(clone)
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py"
>         in __len__
>            77.         self._fetch_all()
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py"
>         in _fetch_all
>            854.             self._result_cache = list(self.iterator())
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py"
>         in iterator
>            220.         for row in compiler.results_iter():
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
>         in results_iter
>            710.         for rows in self.execute_sql(MULTI):
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
>         in execute_sql
>            781.         cursor.execute(sql, params)
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py"
>         in execute
>            69.             return super(CursorDebugWrapper,
>         self).execute(sql,
>         params)
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py"
>         in execute
>            53.                 return self.cursor.execute(sql, params)
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/utils.py" in
>         __exit__
>            99.                 six.reraise(dj_exc_type, dj_exc_value,
>         traceback)
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py"
>         in execute
>            53.                 return self.cursor.execute(sql, params)
>         File
>         "/usr/local/lib/python2.7/dist-packages/django/db/backends/sqlite3/base.py"
>         in execute
>            450.         return Database.Cursor.execute(self, query,
>         params)
>
>         Exception Type: OperationalError at /toastergui/project/23/
>         Exception Value: no such column: orm_layer.local_path
>
>
>
>
>
>
>     -- 
>     _______________________________________________
>     toaster mailing list
>     toaster@yoctoproject.org <mailto:toaster@yoctoproject.org>
>     https://lists.yoctoproject.org/listinfo/toaster
>
>
>
>
> -- 
> Alex Damian
> Yocto Project
> SSG / OTC
>
> ---------------------------------------------------------------------
> Intel Corporation (UK) Limited
> Registered No. 1134945 (England)
> Registered Office: Pipers Way, Swindon SN3 1RJ
> VAT No: 860 2173 47
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
>