subject:"problem with spatial data in sqlite"

Re: problem with spatial data in sqlite

2010-01-31 Thread Vladimir Sidorenko

Hi

You have to reinstall pysqlite2 with specific flag:
http://geodjango.org/docs/install.html#pysqlite2

31 янв. 2010, в 09:48, Alexis Selves написал(а):

> Hello,
> I have serious problem with my geodjango and spatial data in DB. I
> create my models and then I want to sync my db and  it doesn't work.
> I have following output on terminal:
> traceback (most recent call last):
>  File "manage.py", line 11, in 
>execute_manager(settings)
>  File "/usr/lib/pymodules/python2.6/django/core/management/
> __init__.py", line 362, in execute_manager
>utility.execute()
>  File "/usr/lib/pymodules/python2.6/django/core/management/
> __init__.py", line 303, in execute
>self.fetch_command(subcommand).run_from_argv(self.argv)
>  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
> line 195, in run_from_argv
>self.execute(*args, **options.__dict__)
>  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
> line 222, in execute
>output = self.handle(*args, **options)
>  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
> line 286, in handle
>app_output = self.handle_app(app, **options)
>  File "/usr/lib/pymodules/python2.6/django/core/management/commands/
> sqlall.py", line 10, in handle_app
>return u'\n'.join(sql_all(app, self.style)).encode('utf-8')
>  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
> line 157, in sql_all
>return sql_create(app, style) + sql_custom(app, style) +
> sql_indexes(app, style)
>  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
> line 28, in sql_create
>tables = connection.introspection.table_names()
>  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
> line 490, in table_names
>cursor = self.connection.cursor()
>  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
> line 81, in cursor
>cursor = self._cursor()
>  File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/
> base.py", line 175, in _cursor
>connection_created.send(sender=self.__class__)
>  File "/usr/lib/pymodules/python2.6/django/dispatch/dispatcher.py",
> line 166, in send
>response = receiver(signal=self, sender=sender, **named)
>  File "/usr/lib/pymodules/python2.6/django/contrib/gis/db/backend/
> spatialite/__init__.py", line 26, in initialize_spatialite
>connection.connection.enable_load_extension(True)
> AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute
> 'enable_load_extension'
> peta...@petarda-desktop:~/Skola/Django/mysite$ python manage.py sqlall
> maps
> Traceback (most recent call last):
>  File "manage.py", line 11, in 
>execute_manager(settings)
>  File "/usr/lib/pymodules/python2.6/django/core/management/
> __init__.py", line 362, in execute_manager
>utility.execute()
>  File "/usr/lib/pymodules/python2.6/django/core/management/
> __init__.py", line 303, in execute
>self.fetch_command(subcommand).run_from_argv(self.argv)
>  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
> line 195, in run_from_argv
>self.execute(*args, **options.__dict__)
>  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
> line 222, in execute
>output = self.handle(*args, **options)
>  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
> line 286, in handle
>app_output = self.handle_app(app, **options)
>  File "/usr/lib/pymodules/python2.6/django/core/management/commands/
> sqlall.py", line 10, in handle_app
>return u'\n'.join(sql_all(app, self.style)).encode('utf-8')
>  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
> line 157, in sql_all
>return sql_create(app, style) + sql_custom(app, style) +
> sql_indexes(app, style)
>  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
> line 28, in sql_create
>tables = connection.introspection.table_names()
>  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
> line 490, in table_names
>cursor = self.connection.cursor()
>  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
> line 81, in cursor
>cursor = self._cursor()
>  File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/
> base.py", line 175, in _cursor
>connection_created.send(sender=self.__class__)
>  File "/usr/lib/pymodules/python2.6/django/dispatch/dispatcher.py",
> line 166, in send
>response = receiver(signal=self, sender=sender, **named)
>  File "/usr/lib/pymodules/python2.6/django/contrib/gis/db/backend/
> spatialite/__init__.py", line 26, in initialize_spatialite
>connection.connection.enable_load_extension(True)
> AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute
> 'enable_load_extension'
> 
> I guess I need to compile my sqlite, but I don't know how..
> 
> Please help me..
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Django developers" group.
> To post to this group, send email to

Re: problem with spatial data in sqlite

2010-01-31 Thread Karen Tracey

Please post questions about using Django to django-users.  django-developers
is for discussion of developing Django itself.

Karen

-- 
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to django-develop...@googlegroups.com.
To unsubscribe from this group, send email to 
django-developers+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-developers?hl=en.

problem with spatial data in sqlite

2010-01-31 Thread Alexis Selves

Hello,
I have serious problem with my geodjango and spatial data in DB. I
create my models and then I want to sync my db and  it doesn't work.
I have following output on terminal:
traceback (most recent call last):
  File "manage.py", line 11, in 
execute_manager(settings)
  File "/usr/lib/pymodules/python2.6/django/core/management/
__init__.py", line 362, in execute_manager
utility.execute()
  File "/usr/lib/pymodules/python2.6/django/core/management/
__init__.py", line 303, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 195, in run_from_argv
self.execute(*args, **options.__dict__)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 222, in execute
output = self.handle(*args, **options)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 286, in handle
app_output = self.handle_app(app, **options)
  File "/usr/lib/pymodules/python2.6/django/core/management/commands/
sqlall.py", line 10, in handle_app
return u'\n'.join(sql_all(app, self.style)).encode('utf-8')
  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
line 157, in sql_all
return sql_create(app, style) + sql_custom(app, style) +
sql_indexes(app, style)
  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
line 28, in sql_create
tables = connection.introspection.table_names()
  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
line 490, in table_names
cursor = self.connection.cursor()
  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
line 81, in cursor
cursor = self._cursor()
  File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/
base.py", line 175, in _cursor
connection_created.send(sender=self.__class__)
  File "/usr/lib/pymodules/python2.6/django/dispatch/dispatcher.py",
line 166, in send
response = receiver(signal=self, sender=sender, **named)
  File "/usr/lib/pymodules/python2.6/django/contrib/gis/db/backend/
spatialite/__init__.py", line 26, in initialize_spatialite
connection.connection.enable_load_extension(True)
AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute
'enable_load_extension'
peta...@petarda-desktop:~/Skola/Django/mysite$ python manage.py sqlall
maps
Traceback (most recent call last):
  File "manage.py", line 11, in 
execute_manager(settings)
  File "/usr/lib/pymodules/python2.6/django/core/management/
__init__.py", line 362, in execute_manager
utility.execute()
  File "/usr/lib/pymodules/python2.6/django/core/management/
__init__.py", line 303, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 195, in run_from_argv
self.execute(*args, **options.__dict__)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 222, in execute
output = self.handle(*args, **options)
  File "/usr/lib/pymodules/python2.6/django/core/management/base.py",
line 286, in handle
app_output = self.handle_app(app, **options)
  File "/usr/lib/pymodules/python2.6/django/core/management/commands/
sqlall.py", line 10, in handle_app
return u'\n'.join(sql_all(app, self.style)).encode('utf-8')
  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
line 157, in sql_all
return sql_create(app, style) + sql_custom(app, style) +
sql_indexes(app, style)
  File "/usr/lib/pymodules/python2.6/django/core/management/sql.py",
line 28, in sql_create
tables = connection.introspection.table_names()
  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
line 490, in table_names
cursor = self.connection.cursor()
  File "/usr/lib/pymodules/python2.6/django/db/backends/__init__.py",
line 81, in cursor
cursor = self._cursor()
  File "/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/
base.py", line 175, in _cursor
connection_created.send(sender=self.__class__)
  File "/usr/lib/pymodules/python2.6/django/dispatch/dispatcher.py",
line 166, in send
response = receiver(signal=self, sender=sender, **named)
  File "/usr/lib/pymodules/python2.6/django/contrib/gis/db/backend/
spatialite/__init__.py", line 26, in initialize_spatialite
connection.connection.enable_load_extension(True)
AttributeError: 'pysqlite2.dbapi2.Connection' object has no attribute
'enable_load_extension'

I guess I need to compile my sqlite, but I don't know how..

Please help me..

-- 
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to django-develop...@googlegroups.com.
To unsubscribe from this group, send email to 
django-developers+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-developers?hl=en.

Re: problem with spatial data in sqlite

Re: problem with spatial data in sqlite

problem with spatial data in sqlite

3 matches

Site Navigation

Mail list logo

Footer information