search

praekelt / jmbo-foundry

Jmbo generic behaviour/templates app.
http://www.jmbo.org
Other
1 stars 3 forks source link

DatabaseError #26

Closed ratt closed 11 years ago

ratt commented 11 years ago

Environment:

Request Method: GET Request URL: http://jacaranda.beta-site.co.za/chart/jacaranda-fm-top-20/

Django Version: 1.4 Python Version: 2.6.2 Installed Applications: ('jacaranda', 'foundry', 'downloads', 'friends', 'section', 'gallery', 'googlesearch', 'export', 'snippetscream', 'generate', 'jmbo_calendar', 'jmbo', 'photologue', 'captcha', 'secretballot', 'publisher', 'category', 'post', 'likes', 'gizmo', 'object_tools', 'registration', 'event', 'preferences', 'banner', 'competition', 'ckeditor', 'contact', 'poll', 'simple_autocomplete', 'pagination', 'south', 'compressor', 'jmbo_analytics', 'analytics', 'gunicorn', 'sites_groups', 'atlas', 'tastypie', 'django.contrib.auth', 'django.contrib.comments', 'django.contrib.contenttypes', 'django.contrib.humanize', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.staticfiles', 'django.contrib.gis', 'django.contrib.admin', 'music', 'chart', 'jmbo_twitter') Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'foundry.middleware.AgeGateway', 'django.contrib.messages.middleware.MessageMiddleware', 'likes.middleware.SecretBallotUserIpUseragentMiddleware', 'foundry.middleware.PaginationMiddleware', 'foundry.middleware.VerboseRequestMeta', 'django.middleware.transaction.TransactionMiddleware')

Traceback: File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/core/handlers/base.py" in get_response

  1. response = middleware_method(request, response) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/jmbo_foundry-1.1-py2.6.egg/foundry/middleware.py" in process_response
  2. private_site = preferences.GeneralPreferences.private_site File "/var/www/html/praekelt/kagiso-jacaranda/eggs/django_preferences-0.0.6-py2.6.egg/preferences/models.py" in
  3. property(lambda x: cls.singleton.get())) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/manager.py" in get
  4. return self.get_query_set().get(_args, *_kwargs) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/django_preferences-0.0.6-py2.6.egg/preferences/managers.py" in get_query_set
  5. queryset.get() File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/query.py" in get
  6. num = len(clone) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/query.py" in len
  7. self._result_cache = list(self.iterator()) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/query.py" in iterator
  8. for row in compiler.results_iter(): File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/sql/compiler.py" in results_iter
  9. for rows in self.execute_sql(MULTI): File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/sql/compiler.py" in execute_sql
  10. cursor.execute(sql, params) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/backends/util.py" in execute
  11. return self.cursor.execute(sql, params) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/backends/postgresql_psycopg2/base.py" in execute
  12. return self.cursor.execute(query, args)

Exception Type: DatabaseError at /chart/jacaranda-fm-top-20/ Exception Value: current transaction is aborted, commands ignored until end of transaction block

hedleyroos commented 11 years ago

Can you up jmbo-music and jmbo-chart to the latest versions on pypi please? I have seen this error before but cannot remember the solution offhand. Upgrading may solve the ussue for you.

ratt commented 11 years ago

chart updated to 0.1 and music to 0.1.1 still no change

ratt commented 11 years ago

as a note: I also bumped jmbo to 1.0.1

Environment:

Request Method: GET Request URL: http://jacaranda.beta-site.co.za/chart/jacaranda-fm-top-20/

Django Version: 1.4 Python Version: 2.6.2 Installed Applications: ('jacaranda', 'foundry', 'downloads', 'friends', 'section', 'gallery', 'googlesearch', 'export', 'snippetscream', 'generate', 'jmbo_calendar', 'jmbo', 'photologue', 'captcha', 'secretballot', 'publisher', 'category', 'post', 'likes', 'gizmo', 'object_tools', 'registration', 'event', 'preferences', 'banner', 'competition', 'ckeditor', 'contact', 'poll', 'simple_autocomplete', 'pagination', 'south', 'compressor', 'jmbo_analytics', 'analytics', 'gunicorn', 'sites_groups', 'atlas', 'tastypie', 'django.contrib.auth', 'django.contrib.comments', 'django.contrib.contenttypes', 'django.contrib.humanize', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.staticfiles', 'django.contrib.gis', 'django.contrib.admin', 'music', 'chart', 'jmbo_twitter') Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'foundry.middleware.AgeGateway', 'django.contrib.messages.middleware.MessageMiddleware', 'likes.middleware.SecretBallotUserIpUseragentMiddleware', 'foundry.middleware.PaginationMiddleware', 'foundry.middleware.VerboseRequestMeta', 'django.middleware.transaction.TransactionMiddleware')

Traceback: File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/core/handlers/base.py" in get_response

  1. response = middleware_method(request, response) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/jmbo_foundry-1.1-py2.6.egg/foundry/middleware.py" in process_response
  2. private_site = preferences.GeneralPreferences.private_site File "/var/www/html/praekelt/kagiso-jacaranda/eggs/django_preferences-0.0.6-py2.6.egg/preferences/models.py" in
  3. property(lambda x: cls.singleton.get())) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/manager.py" in get
  4. return self.get_query_set().get(_args, *_kwargs) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/django_preferences-0.0.6-py2.6.egg/preferences/managers.py" in get_query_set
  5. queryset.get() File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/query.py" in get
  6. num = len(clone) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/query.py" in len
  7. self._result_cache = list(self.iterator()) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/query.py" in iterator
  8. for row in compiler.results_iter(): File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/sql/compiler.py" in results_iter
  9. for rows in self.execute_sql(MULTI): File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/models/sql/compiler.py" in execute_sql
  10. cursor.execute(sql, params) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/backends/util.py" in execute
  11. return self.cursor.execute(sql, params) File "/var/www/html/praekelt/kagiso-jacaranda/eggs/Django-1.4-py2.6.egg/django/db/backends/postgresql_psycopg2/base.py" in execute
  12. return self.cursor.execute(query, args)

Exception Type: DatabaseError at /chart/jacaranda-fm-top-20/ Exception Value: current transaction is aborted, commands ignored until end of transaction block

ratt commented 11 years ago

Never mind i have traced the issue, upgrading the jmbo_music worked but on the upgrade the migration fails to correctly update the table. I have manually added the missing audo_embed text field and all is good