[Dev-flock] new fixture error

Mike Eggar eggar at hotmail.com
Tue Oct 9 18:57:43 EDT 2007 

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

More information about the Dev-flock mailing list