[Dev-flock] new fixture error
Lucy R Mendel
lmendel at MIT.EDU
Tue Oct 9 22:58:31 EDT 2007
I think you just need to loaddata:
lucy at snoopy ~/Projects/Workspace/ThoughtAndMemory/trunk/web/src
$ ./manage.py loaddata database/db/fixtures/santa.json
but I get this error:
Loading 'database/db/fixtures/santa' fixtures...
Installing json fixture 'database/db/fixtures/santa' from absolute path.
Problem installing fixture 'database/db/fixtures/santa.json': Article
matching query does not exist.
after doing a reset and sync first.
On Wed, 10 Oct 2007, Mike Eggar wrote:
>
> build_fixtures with santa.json is giving me some errors,
> "'gen_pfk_for_row' : Invalid information for behaviorargumentlink (runtime
> error) "
>
>
>>
>> Santa data is up in latest commit. It's in
>> database/db/fixtures/santa.json. Let me know if you have any problems.
>>
>> Dan
>>
>> Lucy R Mendel wrote:
>> > I think this is because the database is empty.
>> > Dan, can you get the santa demo data committed (or buildable)?
>> > Word!
>> >
>> > On Tue, 9 Oct 2007, Mike Eggar wrote:
>> >
>> >> I get a different error now...
>> >>
>> >>
>> >> DoesNotExist at /Main/node/41/
>> >> Node matching query does not exist.
>> >> Request Method: GET
>> >> Request URL: http://127.0.0.1:8000/Main/node/41/
>> >> Exception Type: DoesNotExist
>> >> Exception Value: Node matching query does not exist.
>> >> Exception Location:
>> >> C:\django\huginmunin\web\src\web_app\Main\views\views.py in
>> >> node_centric, line 128
>> >> Python Executable: C:\django\Python25\python.exe
>> >> Python Version: 2.5.1
>> >> Traceback (innermost last)
>> >>
>> >>
>> >> * C:\django\huginmunin\web\src\web_app\Main\views\views.py in
>> >> node_centric
>> >> 121.
>> >> 122. # convert to int else
>> >> 123. nid = int(node_id)
>> >> 124.
>> >> 125. # select node; nid==0 means no node selected
>> >> 126. if nid > 0:
>> >> 127. node_selected = True
>> >> 128. node = Node.objects.select_related(depth=2).get(id=nid) ...
>> >> 129. # get all behaviors attached to node
>> >> 130. dict['behaviors']=node.behaviors
>> >> 131. # get parents and children
>> >> 132. dict['parents']=node.parents#.select_related().filter()
>> >> 133. dict['children']=node.children#.select_related().filter()
>> >> 134. #dict['dimensions']=Dimension.objects.all()
>> >> ¢º Local vars
>> >>
>> >>
>> >> The output from sqlreset looks like this:
>> >>
>> >> BEGIN;
>> >> DROP TABLE "db_tagging";
>> >> DROP TABLE "db_dimension";
>> >> DROP TABLE "db_tag";
>> >> DROP TABLE "db_article";
>> >> DROP TABLE "db_action";
>> >> DROP TABLE "db_aggregaterating";
>> >> DROP TABLE "db_behavior";
>> >> DROP TABLE "db_state";
>> >> DROP TABLE "db_edge";
>> >> DROP TABLE "db_userextended";
>> >> DROP TABLE "db_source";
>> >> DROP TABLE "db_upc";
>> >> DROP TABLE "db_argument";
>> >> DROP TABLE "db_visit";
>> >> DROP TABLE "db_citation";
>> >> DROP TABLE "db_author";
>> >> DROP TABLE "db_slug";
>> >> DROP TABLE "db_rating";
>> >> DROP TABLE "db_node";
>> >> CREATE TABLE "db_node" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "label" varchar(200) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_rating" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "score" integer NOT NULL,
>> >> "item_type_id" integer NOT NULL REFERENCES "django_content_type"
>> >> ("id"),
>> >> "item_id" integer unsigned NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_slug" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "slug" varchar(255) NOT NULL,
>> >> "item_type_id" integer NOT NULL REFERENCES "django_content_type"
>> >> ("id"),
>> >> "item_id" integer unsigned NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_author" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "name" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_citation" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "article_id" integer NOT NULL,
>> >> "passage" varchar(255) NOT NULL,
>> >> "argument_id" integer NOT NULL,
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_visit" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "path" varchar(255) NOT NULL,
>> >> "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),
>> >> "time" datetime NOT NULL,
>> >> "duration" real NOT NULL,
>> >> "sql_duration" real NOT NULL,
>> >> "ip" char(15) NOT NULL,
>> >> "remote_host" varchar(255) NOT NULL,
>> >> "user_agent" varchar(255) NOT NULL,
>> >> "referer" varchar(255) NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_argument" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "label" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "sign" smallint NOT NULL,
>> >> "behavior_id" integer NULL,
>> >> "argument_id" integer NULL,
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_upc" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "upc_code" varchar(255) NOT NULL,
>> >> "upc_image" varchar(100) NULL,
>> >> "node_id" integer NOT NULL REFERENCES "db_node" ("id"),
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_source" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "name" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_userextended" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "user_id" integer NOT NULL UNIQUE REFERENCES "auth_user" ("id"),
>> >> "name" varchar(255) NOT NULL,
>> >> "level" integer NOT NULL,
>> >> "feathers" real NOT NULL,
>> >> "points" real NOT NULL,
>> >> "status" real NOT NULL,
>> >> "vote_weight" integer NULL,
>> >> "eval_weight" integer NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_edge" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "label" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "src_id" integer NOT NULL REFERENCES "db_node" ("id"),
>> >> "dest_id" integer NOT NULL REFERENCES "db_node" ("id"),
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_state" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "label" varchar(255) NOT NULL,
>> >> "text" varchar(255) NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_behavior" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "label" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "dimension_id" integer NOT NULL,
>> >> "node_id" integer NOT NULL REFERENCES "db_node" ("id"),
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_aggregaterating" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "score" real NOT NULL,
>> >> "time" datetime NOT NULL,
>> >> "item_type_id" integer NOT NULL REFERENCES "django_content_type"
>> >> ("id"),
>> >> "item_id" integer unsigned NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_action" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "type" integer unsigned NOT NULL,
>> >> "label" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "user_id" integer NOT NULL REFERENCES "auth_user" ("id"),
>> >> "ip" char(15) NOT NULL,
>> >> "time" datetime NOT NULL,
>> >> "item_type_id" integer NOT NULL REFERENCES "django_content_type"
>> >> ("id"),
>> >> "item_id" integer unsigned NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_article" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "title" varchar(255) NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "source_id" integer NOT NULL REFERENCES "db_source" ("id"),
>> >> "author_id" integer NOT NULL REFERENCES "db_author" ("id"),
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_tag" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "tag" varchar(255) NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_dimension" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "label" varchar(255) NOT NULL,
>> >> "description" text NOT NULL,
>> >> "url" varchar(200) NOT NULL,
>> >> "parent_id" integer NULL,
>> >> "state" smallint UNSIGNED NOT NULL
>> >> )
>> >> ;
>> >> CREATE TABLE "db_tagging" (
>> >> "id" integer NOT NULL PRIMARY KEY,
>> >> "tag_id" integer NOT NULL REFERENCES "db_tag" ("id"),
>> >> "item_type_id" integer NOT NULL REFERENCES "django_content_type"
>> >> ("id"),
>> >> "item_id" integer unsigned NOT NULL
>> >> )
>> >> ;
>> >> CREATE INDEX "db_rating_item_type_id" ON "db_rating" ("item_type_id");
>> >> CREATE INDEX "db_slug_slug" ON "db_slug" ("slug");
>> >> CREATE INDEX "db_slug_item_type_id" ON "db_slug" ("item_type_id");
>> >> CREATE INDEX "db_citation_article_id" ON "db_citation" ("article_id");
>> >> CREATE INDEX "db_citation_argument_id" ON "db_citation" ("argument_id");
>> >> CREATE INDEX "db_visit_user_id" ON "db_visit" ("user_id");
>> >> CREATE INDEX "db_argument_behavior_id" ON "db_argument" ("behavior_id");
>> >> CREATE INDEX "db_argument_argument_id" ON "db_argument" ("argument_id");
>> >> CREATE INDEX "db_upc_node_id" ON "db_upc" ("node_id");
>> >> CREATE INDEX "db_edge_src_id" ON "db_edge" ("src_id");
>> >> CREATE INDEX "db_edge_dest_id" ON "db_edge" ("dest_id");
>> >> CREATE INDEX "db_behavior_dimension_id" ON "db_behavior"
>> >> ("dimension_id");
>> >> CREATE INDEX "db_behavior_node_id" ON "db_behavior" ("node_id");
>> >> CREATE INDEX "db_aggregaterating_item_type_id" ON "db_aggregaterating"
>> >> ("item_type_id");
>> >> CREATE INDEX "db_action_user_id" ON "db_action" ("user_id");
>> >> CREATE INDEX "db_action_item_type_id" ON "db_action" ("item_type_id");
>> >> CREATE INDEX "db_article_source_id" ON "db_article" ("source_id");
>> >> CREATE INDEX "db_article_author_id" ON "db_article" ("author_id");
>> >> CREATE INDEX "db_tag_tag" ON "db_tag" ("tag");
>> >> CREATE INDEX "db_dimension_parent_id" ON "db_dimension" ("parent_id");
>> >> CREATE INDEX "db_tagging_tag_id" ON "db_tagging" ("tag_id");
>> >> CREATE INDEX "db_tagging_item_type_id" ON "db_tagging" ("item_type_id");
>> >> COMMIT;
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>>
>> >>> Try "./manage.py reset db"
>> >>> Django is unable to make some column changes to existing tables - I
>> >>> haven't really figured out when or why this happens, but usually "reset
>> >>> db" works. If there's data in your database you want to keep, you can
>> >>> save it with "./manage dumpdata db" or something like that. (Just so
>> >>> you know, 'db' means our app 'db', rather than databases in general -
>> >>> resetting db should not reset 'auth', the user and permissions
>> >>> settings.)
>> >>>
>> >>> If you still get errors, send me the output as well as the output to
>> >>> "./manage.py sqlreset db".
>> >>>
>> >>> Dan
>> >>>
>> >>> Lucy R Mendel wrote:
>> >>> > I get the same error when I runserver and try to get a page.
>> >>> >
>> >>> > OperationalError
>> >>> > no such column: db_node.state
>> >>> >
>> >>> >
>> >>>
>> /Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/backends/util.py
>> >>>
>> >>> > in execute
>> >>> >
>> >>> > 19# return self.cursor.execute(sql, params)
>> >>> >
>> >>> >
>> >>> >
>> >>> > On Mon, 8 Oct 2007, Lucy R Mendel wrote:
>> >>> >
>> >>> >> $ ./manage.py syncdb
>> >>> >> Creating table db_visit
>> >>> >> Creating table db_state
>> >>> >> Creating table db_aggregaterating
>> >>> >> Traceback (most recent call last):
>> >>> >> File "./manage.py", line 11, in <module>
>> >>> >> execute_manager(settings)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/__init__.py",
>> >>>
>> >>> >> line 264, in execute_manager
>> >>> >> utility.execute()
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/__init__.py",
>> >>>
>> >>> >> line 215, in execute
>> >>> >> self.fetch_command(subcommand).run_from_argv(self.argv)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/base.py",
>> >>>
>> >>> >> line 70, in run_from_argv
>> >>> >> self.execute(*args, **options.__dict__)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/base.py",
>> >>>
>> >>> >> line 84, in execute
>> >>> >> output = self.handle(*args, **options)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/base.py",
>> >>>
>> >>> >> line 168, in handle
>> >>> >> return self.handle_noargs(**options)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/commands/syncdb.py",
>> >>>
>> >>> >> line 94, in handle_noargs
>> >>> >> emit_post_sync_signal(created_models, verbosity, interactive)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/core/management/sql.py",
>> >>>
>> >>> >> line 457, in emit_post_sync_signal
>> >>> >> verbosity=verbosity, interactive=interactive)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/badbills/src/badcoopsite/django/dispatch/dispatcher.py",
>> >>>
>> >>> >> line 360, in send
>> >>> >> **named
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/badbills/src/badcoopsite/django/dispatch/robustapply.py",
>> >>>
>> >>> >> line 47, in robustApply
>> >>> >> return receiver(*arguments, **named)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/contrib/contenttypes/management.py",
>> >>>
>> >>> >> line 34, in update_contenttypes
>> >>> >> ct.delete()
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/models/base.py",
>> >>>
>> >>> >> line 327, in delete
>> >>> >> self._collect_sub_objects(seen_objs)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/models/base.py",
>> >>>
>> >>> >> line 319, in _collect_sub_objects
>> >>> >> for sub_obj in getattr(self, rel_opts_name).all():
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/models/query.py",
>> >>>
>> >>> >> line 114, in __iter__
>> >>> >> return iter(self._get_data())
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/models/query.py",
>> >>>
>> >>> >> line 482, in _get_data
>> >>> >> self._result_cache = list(self.iterator())
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/models/query.py",
>> >>>
>> >>> >> line 189, in iterator
>> >>> >> cursor.execute("SELECT " + (self._distinct and "DISTINCT " or
>> >>> "") +
>> >>> >> ",".join(select) + sql, params)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/backends/util.py",
>> >>>
>> >>> >> line 19, in execute
>> >>> >> return self.cursor.execute(sql, params)
>> >>> >> File
>> >>> >>
>> >>>
>> "/Users/lucy/Projects/Workspace/ThoughtAndMemory/trunk/web/src/django/db/backends/sqlite3/base.py",
>> >>>
>> >>> >> line 133, in execute
>> >>> >> return Database.Cursor.execute(self, query, params)
>> >>> >> sqlite3.OperationalError: no such column: db_slug.slug
>> >>> >>
>> >>> >> On Mon, 8 Oct 2007, Mike Eggar wrote:
>> >>> >>
>> >>> >>>
>> >>> >>> OK, I built the fixtures but now I get "no such column:
>> >>> >>> db_node.state" error for prototype and main
>> >>> >>>
>> >>> >>>
>> >>> >>>> From: Lucy R Mendel <lmendel at mit.edu>
>> >>> >>>> To: Daniel Ring <danring at mit.edu>
>> >>> >>>> CC: dev-flock at mit.edu
>> >>> >>>> Subject: Re: [Dev-flock] New fixtures
>> >>> >>>> Date: Mon, 8 Oct 2007 11:11:14 -0400 (EDT)
>> >>> >>>>
>> >>> >>>> to build you need ruby and a ruby json lib (debian packages: ruby;
>> >>> >>>> libjson-ruby)
>> >>> >>>>
>> >>> >>>> Prototype on the web server should be up and running soon...
>> >>> >>>>
>> >>> >>>> On Mon, 8 Oct
>> >>> >>>> 2007, Daniel Ring wrote:
>> >>> >>>>
>> >>> >>>> > ...can be built by running './build_fixtures.rb fixtures.json'
>> in
>> >>> >>>> > src/database/db/fixtures. Beware, this takes a while. If you
>> >>> don't
>> >>> >>>> > have ruby or don't want to bother, download them from:
>> >>> >>>> > http://danring.net/temp/fixtures.json (~20meg)
>> >>> >>>> >
>> >>> >>>> > These are again just random-text fixtures. I'll get the
>> >>> >>>> > real-live-fake-Santa-fixtures out soon.
>> >>> >>>> >
>> >>> >>>> > Dan
>> >>> >>>> > _______________________________________________
>> >>> >>>> > Dev-flock mailing list
>> >>> >>>> > Dev-flock at mit.edu
>> >>> >>>> > http://mailman.mit.edu/mailman/listinfo/dev-flock
>> >>> >>>> >
>> >>> >>>> _______________________________________________
>> >>> >>>> Dev-flock mailing list
>> >>> >>>> Dev-flock at mit.edu
>> >>> >>>> http://mailman.mit.edu/mailman/listinfo/dev-flock
>> >>> >>>
>> >>> >>> _________________________________________________________________
>> >>> >>> i'm making a difference.?Make every IM count for the cause of your
>> >>> >>> choice. Join Now.
>> http://im.live.com/messenger/im/home/?source=TAGHM
>> >>> >>>
>> >>> >>
>> >>> >
>> >>> >
>> >>>
>> ------------------------------------------------------------------------
>> >>> >
>> >>> > _______________________________________________
>> >>> > Dev-flock mailing list
>> >>> > Dev-flock at mit.edu
>> >>> > http://mailman.mit.edu/mailman/listinfo/dev-flock
>> >>
>> >> _________________________________________________________________
>> >> More photos; more messages; more storage?get 5GB with Windows Live
>> >> Hotmail.
>> >>
>> http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507
>> >>
>> >>
>> >>
>
> _________________________________________________________________
> Help yourself to FREE treats served up daily at the Messenger Café. Stop by
> today!
> http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGHM_OctHMtagline
>
>
More information about the Dev-flock
mailing list