Re: Looking for unavailable table?

P.S. This problem did not resurface after I made other changes discussed elsewhere in the thread; it seems to be secondary damage.

On Mon, Jun 28, 2010 at 2:46 PM, Jonathan Hayward <christos.jonathan.hayward@gmail.com> wrote:

Thanks for pointing me to South. I've glanced over it, but I did have one question:

My understanding is that Django will introduce tables for models that have been added on a syncdb, but not alter tables for models that have been changed. And from a glance at the documentation, it looks like South would provide more granularity.

However, it is my understanding that this should have the consequence that if you start with a fresh database and run syncdb, then that should result in appropriate tables. This might not be a first choice way to update the database as normally wiping the database when you implement a schema update is not desirable if you have any real data, but my understanding from the documentation is that this forceful solution should work. If I'm mistaken, I'd like to know both how I presently misunderstand, and what an appropriate way is to generate a fresh database with tables matching your models.

On Fri, Jun 25, 2010 at 5:25 PM, Mark Linsey <mjlinsey@gmail.com> wrote:

I don't quite understand what changes you made before producing this error, and I'm totally unfamiliar with sqllite. 

But I do know that for many (really, most) different model changes, just running syncdb will not make the appropriate changes to your tables.  You probably need to look into south migrations.

On Fri, Jun 25, 2010 at 2:09 PM, Jonathan Hayward <christos.jonathan.hayward@gmail.com> wrote:

P.S. Renaming the (SQLite) database file and running syncdb again produces (basically) the same behavior. I had to do some initialization things again, but outside of that I got equivalent behavior to what I pasted below.

What I am trying to do is create a few instances of the Entity model defined in my [directory/]models.py. So far I have managed to get them to show up as an option to manage in the admin interface, but not yet to save one.

Should it be looking for directory_models_entity instead of directory_entity? "entity" seems not to be populated; from the command line sqlite3:

sqlite> .tables

auth_group                  auth_user_user_permissions

auth_group_permissions      django_admin_log          

auth_message                django_content_type       

auth_permission             django_session            

auth_user                   django_site               

auth_user_groups  

On Fri, Jun 25, 2010 at 3:00 PM, Jonathan Hayward <christos.jonathan.hayward@gmail.com> wrote:

I received the error below from the admin interface; I thought it was because I needed to run a syncdb, but stopping the server, running a syncdb, and restarting has generated the same error:

OperationalError at /admin/directory/entity/

 no such table: directory_entity

Request Method:	GET
Request URL:	http://linux:8000/admin/directory/entity/
Exception Type:	OperationalError
Exception Value:	no such table: directory_entity
Exception Location:	/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/base.py in execute, line 193
Python Executable:	/usr/bin/python
Python Version:	2.6.5
Python Path:	['/home/jonathan/directory', '/usr/local/lib/python2.6/dist-packages/pip-0.6.3-py2.6.egg', '/home/jonathan/store/src/satchmo/satchmo/apps', '/usr/local/lib/python2.6/dist-packages/django_threaded_multihost-1.3_3-py2.6.egg', '/usr/local/lib/python2.6/dist-packages/django_signals_ahoy-0.1_1-py2.6.egg', '/usr/local/lib/python2.6/dist-packages/django_tagging-0.3.1-py2.6.egg', '/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2', '/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old', '/usr/lib/python2.6/lib-dynload', '/usr/lib/python2.6/dist-packages', '/usr/lib/python2.6/dist-packages/PIL', '/usr/lib/python2.6/dist-packages/gst-0.10', '/usr/lib/pymodules/python2.6', '/usr/lib/python2.6/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.6/gtk-2.0', '/usr/local/lib/python2.6/dist-packages']
Server time:	Fri, 25 Jun 2010 14:56:26 -0500

I have an Entity class/model defined in my models.py and want to manually create some dummy data in the table. Any suggestions?

--
→ Jonathan Hayward, christos.jonathan.hayward@gmail.com
→ An Orthodox Christian author: theology, literature, et cetera.
→ My award-winning collection is available for free reading online:
☩ I invite you to visit my main site at http://JonathansCorner.com/

--
→ Jonathan Hayward, christos.jonathan.hayward@gmail.com
→ An Orthodox Christian author: theology, literature, et cetera.
→ My award-winning collection is available for free reading online:
☩ I invite you to visit my main site at http://JonathansCorner.com/

--

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

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

--
→ Jonathan Hayward, christos.jonathan.hayward@gmail.com
→ An Orthodox Christian author: theology, literature, et cetera.
→ My award-winning collection is available for free reading online:
☩ I invite you to visit my main site at http://JonathansCorner.com/

--
→ Jonathan Hayward, christos.jonathan.hayward@gmail.com
→ An Orthodox Christian author: theology, literature, et cetera.
→ My award-winning collection is available for free reading online:
☩ I invite you to visit my main site at http://JonathansCorner.com/

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