leah / django-elsewhere

Edit and display links to your online social network profiles. — Read more

Sort by: Priority | Votes | Last Updated

Loading…

1.

1 vote

database
x

elsewhere and postgresql issue
5 comments Created 8 months ago by hayley

Title

Body
Granted, I found this while trying to deploy mightylemon, but I figured it belonged here. I get an error when trying to syncdb on mightylemon using postgresql. If I comment out "elsewhere", it syncs fine. I've just now started trying out postgresql so I have no real background in troubleshooting it, but I don't have this problem if I switch to a sqlite database. django error: psycopg2.ProgrammingError: current transaction is aborted, commands ignored until end of transaction block postgresql error: <pre> 2009-04-19 06:26:18 UTC ERROR: relation "elsewhere_socialnetwork" does not exist 2009-04-19 06:26:18 UTC STATEMENT: SELECT "elsewhere_socialnetwork"."id", "elsewhere_socialnetwork"."name", "elsewhere_socialnetwork"."url", "elsewhere_socialnetwork"."identifier", "elsewhere_socialnetwork"."icon" FROM "elsewhere_socialnetwork" 2009-04-19 06:26:18 UTC ERROR: current transaction is aborted, commands ignored until end of transaction block 2009-04-19 06:26:18 UTC STATEMENT: SELECT "elsewhere_instantmessenger"."id", "elsewhere_instantmessenger"."name", "elsewhere_instantmessenger"."url", "elsewhere_instantmessenger"."identifier", "elsewhere_instantmessenger"."icon" FROM "elsewhere_instantmessenger" 2009-04-19 06:26:18 UTC ERROR: current transaction is aborted, commands ignored until end of transaction block 2009-04-19 06:26:18 UTC STATEMENT: SELECT c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r', 'v', '') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) 2009-04-19 06:26:18 UTC LOG: unexpected EOF on client connection </pre>
or cancel
Granted, I found this while trying to deploy mightylemon, but I figured it belonged here.

I get an error when trying to syncdb on mightylemon using postgresql. If I comment out "elsewhere", it syncs fine. I've just now started trying out postgresql so I have no real background in troubleshooting it, but I don't have this problem if I switch to a sqlite database.

django error:
psycopg2.ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

postgresql error:
```
2009-04-19 06:26:18 UTC ERROR:  relation "elsewhere_socialnetwork" does not exist
2009-04-19 06:26:18 UTC STATEMENT:  SELECT "elsewhere_socialnetwork"."id", "elsewhere_socialnetwork"."name", "elsewhere_socialnetwork"."url", "elsewhere_socialnetwork"."identifier", "elsewhere_socialnetwork"."icon" FROM "elsewhere_socialnetwork"
2009-04-19 06:26:18 UTC ERROR:  current transaction is aborted, commands ignored until end of transaction block
2009-04-19 06:26:18 UTC STATEMENT:  SELECT "elsewhere_instantmessenger"."id", "elsewhere_instantmessenger"."name", "elsewhere_instantmessenger"."url", "elsewhere_instantmessenger"."identifier", "elsewhere_instantmessenger"."icon" FROM "elsewhere_instantmessenger"
2009-04-19 06:26:18 UTC ERROR:  current transaction is aborted, commands ignored until end of transaction block
2009-04-19 06:26:18 UTC STATEMENT:  
                    SELECT c.relname
                    FROM pg_catalog.pg_class c
                    LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
                    WHERE c.relkind IN ('r', 'v', '')
                        AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
                        AND pg_catalog.pg_table_is_visible(c.oid)
2009-04-19 06:26:18 UTC LOG:  unexpected EOF on client connection
```
Comments
chrisdrackett Tue Apr 21 14:31:55 -0700 2009 | link

I've never used postgresql, and suck at sql in general so I'm not sure what is going on.. maybe leah has a better idea...

Comment
I've never used postgresql, and suck at sql in general so I'm not sure what is going on.. maybe leah has a better idea...
or cancel

hayley Tue Apr 21 18:36:19 -0700 2009 | link

Leah,
If it helps at all, here is a link to django code wiki's take on what might be the problem:

http://code.djangoproject.com/wiki/BetterErrorMessages#django.db

This pyscopg2 (PostgreSQL) error usually signifies that some previous database query was incorrect (e.g., you tried to order_by() a field that doesn't exist, or put a string in an integer column, etc.). That previous error aborted the transaction, causing all subsequent database access to fail with this message.

[...]

If you get this from a view, it probably means the immediately previous query had a problem (but was caught by an over-eager exception handler).

Comment
Leah, If it helps at all, here is a link to django code wiki's take on what might be the problem: http://code.djangoproject.com/wiki/BetterErrorMessages#django.db >This pyscopg2 (PostgreSQL) error usually signifies that some previous database query was incorrect (e.g., you tried to order_by() a field that doesn't exist, or put a string in an integer column, etc.). That previous error aborted the transaction, causing all subsequent database access to fail with this message. >[...] >If you get this from a view, it probably means the immediately previous query had a problem (but was caught by an over-eager exception handler).
or cancel
restless Mon Jun 01 04:09:17 -0700 2009 | link
A quick fix for this is to add to elsewhere.models the folowing:

from django.db import connection

and then in function definition for SocialNetworkData:

seen_model = connection.introspection.installed_models(['elsewhere_socialnetwork'])
if seen_model:

for network in SocialNetwork.objects.all(): ....

instead of try - except block which is used there now.

Then do the same for InstantMessengerData, just changing a model name:
seen_model = connection.introspection.installed_models(['elsewhere_instantmessenger'])
...
Comment
A quick fix for this is to add to elsewhere.models the folowing: from django.db import connection and then in function definition for SocialNetworkData: seen_model = connection.introspection.installed_models(['elsewhere_socialnetwork']) if seen_model: for network in SocialNetwork.objects.all(): .... instead of try - except block which is used there now. Then do the same for InstantMessengerData, just changing a model name: seen_model = connection.introspection.installed_models(['elsewhere_instantmessenger']) ...
or cancel
ericholscher Tue Jul 14 14:07:59 -0700 2009 | link

@restless Thanks for that! Worked like a charm.

Comment
@restless Thanks for that! Worked like a charm.
or cancel

daonb Sun Jul 19 22:45:33 -0700 2009 | link

@restless thanks! worked for me.

Comment
@restless thanks! worked for me.
or cancel

Parsed with GitHub Flavored Markdown
3.

0 votes

import settings, but not from django.conf import settings
1 comment Created 6 months ago by newmaniese

Title

Body
In elsewhere.urls line 1, the import statement is "import settings". I believe this should be from django.conf import settings to save me when I don't have settings on my python path directly.
or cancel

In elsewhere.urls line 1, the import statement is "import settings". I believe this should be from django.conf import settings to save me when I don't have settings on my python path directly.

Comments

newmaniese Wed Jun 17 09:39:30 -0700 2009 | link

Link to a branch commit where I fixed this: http://github.com/newmaniese/django-elsewhere/commit/c02cb494f3d11ae010635ba70002ca454ee33b53

Comment
Link to a branch commit where I fixed this: http://github.com/newmaniese/django-elsewhere/commit/c02cb494f3d11ae010635ba70002ca454ee33b53
or cancel

Parsed with GitHub Flavored Markdown