Hello,

I'm new. A friend told me about arkestra. I love its concept and i want to
try it but it impossible to syncdb on postgresql 9.1. Here is error message
:

someone can help me please?*

On django :*

$ python manage.py syncdb -v 3
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/core/management/__init__.py",
line 443, in execute_from_command_line
    utility.execute()
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/core/management/__init__.py",
line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/core/management/base.py",
line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/core/management/base.py",
line 232, in execute
    output = self.handle(*args, **options)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/core/management/base.py",
line 371, in handle
    return self.handle_noargs(**options)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/core/management/commands/syncdb.py",
line 60, in handle_noargs
    tables = connection.introspection.table_names()
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/db/backends/__init__.py",
line 904, in table_names
    return self.get_table_list(cursor)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/db/backends/postgresql_psycopg2/introspection.py",
line 33, in get_table_list
    AND pg_catalog.pg_table_is_visible(c.oid)""")
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/db/backends/util.py",
line 40, in execute
    return self.cursor.execute(sql, params)
  File
"/home/www/dev.lamaisondupere.com/venv/env01/local/lib/python2.7/site-packa ges/django/db/backends/postgresql_psycopg2/base.py",
line 52, in execute
    return self.cursor.execute(query, args)
django.db.utils.DatabaseError: current transaction is aborted, commands
ignored until end of transaction block

*
On postgresql 9.1 logs :*

2012-11-01 14:24:26 CET ERROR:  relation "contacts_and_people_entity" does
not exist at character 1400
2012-11-01 14:24:26 CET STATEMENT:  SELECT
"contacts_and_people_entitylite"."id",
"contacts_and_people_entitylite"."name",
"contacts_and_people_entity"."entitylite_ptr_id",
"contacts_and_people_entity"."url",
"contacts_and_people_entity"."external_url_id",
"contacts_and_people_entity"."slug",
"contacts_and_people_entity"."precise_location",
"contacts_and_people_entity"."access_note",
"contacts_and_people_entity"."email",
"contacts_and_people_entity"."image_id",
"contacts_and_people_entity"."short_name",
"contacts_and_people_entity"."abstract_entity",
"contacts_and_people_entity"."parent_id",
"contacts_and_people_entity"."display_parent",
"contacts_and_people_entity"."building_recapitulates_entity_name",
"contacts_and_people_entity"."building_id",
"contacts_and_people_entity"."website_id",
"contacts_and_people_entity"."auto_news_page",
"contacts_and_people_entity"."news_page_menu_title",
"contacts_and_people_entity"."news_page_intro_id",
"contacts_and_people_entity"."auto_contacts_page",
"contacts_and_people_entity"."contacts_page_menu_title",
"contacts_and_people_entity"."contacts_page_intro_id",
"contacts_and_people_entity"."auto_vacancies_page",
"contacts_and_people_entity"."vacancies_page_menu_title",
"contacts_and_people_entity"."vacancies_page_intro_id",
"contacts_and_people_entity"."lft", "contacts_and_people_entity"."rght",
"contacts_and_people_entity"."tree_id",
"contacts_and_people_entity"."level" FROM "contacts_and_people_entity"
INNER JOIN "contacts_and_people_entitylite" ON
("contacts_and_people_entity"."entitylite_ptr_id" =
"contacts_and_people_entitylite"."id") ORDER BY
"contacts_and_people_entity"."tree_id" ASC,
"contacts_and_people_entity"."lft" ASC
2012-11-01 14:24:27 CET ERROR:  current transaction is aborted, commands
ignored until end of transaction block
2012-11-01 14:24:27 CET 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)
2012-11-01 14:24:27 CET LOG:  unexpected EOF on client connection

Not sure what going on there. What version are you using? I would strongly suggest using <https://github.com/evildmp/Arkestra/tree/develop>, docs: <https://github.com/evildmp/Arkestra/blob/develop/docs/getting_started...>.

However I am just about to push a fix for some really stupid import-time code to that branch, related to the database.

I don't know if that's going to be relevant, but give it a try (give me 20 minutes to push the code first). If not, I will try myself with postgres.

Daniele

Daniele

ok, thanks

Le jeudi 1 novembre 2012 15:00:51 UTC+1, Daniele Procida a écrit :

Hi Daniele

Thank you very much. After update, it works very well now.

thanks

Le jeudi 1 novembre 2012 15:04:44 UTC+1, Justin Teliet a écrit :

Daniele