Hello,
I've been working on a portfolio website that includes an app called
projects. Within this app are the models WebProject and ScreenShot for
project info and related screenshots for display on the portfolio
page. Everything has been working fine up until now, when I try to add
another project. I'm able to add the project and related screenshots
without error but the images for the new project are not being found
when the page is displayed, while the two previous projects display
fine.
When I view the postgresql db tables all the info is there, however,
when I query the tables from within the django interactive shell I'm
getting errors when I try to do a simple select. I tried running
syncdb but that didn't help. I don't have a ton of data in the db yet
so I've been considering dumping the tables but what if this happens a
year down the road, any ideas?
>>> wp = WebProject.objects.get(id=1)
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/usr/lib/python2.6/dist-packages/django/db/models/manager.py",
line 120, in get
return self.get_query_set().get(*args, **kwargs)
File "/usr/lib/python2.6/dist-packages/django/db/models/query.py",
line 300, in get
num = len(clone)
File "/usr/lib/python2.6/dist-packages/django/db/models/query.py",
line 81, in __len__
self._result_cache = list(self.iterator())
File "/usr/lib/python2.6/dist-packages/django/db/models/query.py",
line 238, in iterator
for row in self.query.results_iter():
File "/usr/lib/python2.6/dist-packages/django/db/models/sql/
query.py", line 287, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/lib/python2.6/dist-packages/django/db/models/sql/
query.py", line 2369, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/python2.6/dist-packages/django/db/backends/util.py",
line 19, in execute
return self.cursor.execute(sql, params)
ProgrammingError: relation "project_webproject" does not exist
or...
>>> e = Entry.objects.get(id=1)
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/usr/lib/python2.6/dist-packages/django/db/models/manager.py",
line 120, in get
return self.get_query_set().get(*args, **kwargs)
File "/usr/lib/python2.6/dist-packages/django/db/models/query.py",
line 300, in get
num = len(clone)
File "/usr/lib/python2.6/dist-packages/django/db/models/query.py",
line 81, in __len__
self._result_cache = list(self.iterator())
File "/usr/lib/python2.6/dist-packages/django/db/models/query.py",
line 238, in iterator
for row in self.query.results_iter():
File "/usr/lib/python2.6/dist-packages/django/db/models/sql/
query.py", line 287, in results_iter
for rows in self.execute_sql(MULTI):
File "/usr/lib/python2.6/dist-packages/django/db/models/sql/
query.py", line 2369, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/python2.6/dist-packages/django/db/backends/util.py",
line 19, in execute
return self.cursor.execute(sql, params)
InternalError: current transaction is aborted, commands ignored until
end of transaction block
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
