[Dev-flock] new fixture error
Mike Eggar
eggar at hotmail.com
Tue Oct 9 22:01:38 EDT 2007
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