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.hayw...@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 <mjlin...@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.hayw...@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.hayw...@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.hayw...@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.hayw...@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-us...@googlegroups.com. >>> To unsubscribe from this group, send email to >>> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@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-us...@googlegroups.com. >> To unsubscribe from this group, send email to >> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com> >> . >> For more options, visit this group at >> http://groups.google.com/group/django-users?hl=en. >> > > > > -- > → Jonathan Hayward, christos.jonathan.hayw...@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.hayw...@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-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.
