I've got a working site, but I made a copy of the database in order to do some development work. I've hit a snag that looks like a problem in the data.
Ive written a management command to show the problem: from django.core.management.base import BaseCommand, CommandError # Stuff for the library from oil.models import Packet, Signature, Log, Voter class Command(BaseCommand): help = 'Shows a quick count of validations' BaseCommand.requires_migrations_checks = True def handle(self, *args, **options): voters = Log.objects.all() self.stdout.write(repr(voters[0])) I'm suspecting a problem has crept into my Log table, because it works fine if I change Log on the second line of handle() to any of the other tables. If it runs as shown here however, I get kevin@camelot-x:/build/comprosloco$ manage oiltest Traceback (most recent call last): File "./manage", line 22, in <module> execute_from_command_line(sys.argv) File "/build/django/django/core/management/__init__.py", line 364, in execute_from_command_line utility.execute() File "/build/django/django/core/management/__init__.py", line 356, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/build/django/django/core/management/base.py", line 283, in run_from_argv self.execute(*args, **cmd_options) File "/build/django/django/core/management/base.py", line 330, in execute output = self.handle(*args, **options) File "/raid3/build/comprosloco/oil/management/commands/oiltest.py", line 15, in handle self.stdout.write(repr(voters[0])) File "/build/django/django/db/models/base.py", line 590, in __repr__ u = six.text_type(self) File "/raid3/build/comprosloco/oil/models.py", line 172, in __str__ self.accepted TypeError: sequence item 0: expected str instance, datetime.datetime found kevin@camelot-x:/build/comprosloco$ And I have no idea how to debug it further. The schema of Log is sqlite> .schema oil_log CREATE TABLE "oil_log" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "packet" integer NOT NULL, "signature" integer NOT NULL, "action" varchar(20) NOT NULL, "criteria" varchar(150) NOT NULL, "candidates" varchar(100) NOT NULL, "accepted" varchar(10) NOT NULL, "user_id" integer NOT NULL REFERENCES "auth_user" ("id"), "timestamp" datetime NOT NULL); CREATE INDEX "oil_log_packet_ecd59bc4" ON "oil_log" ("packet"); CREATE INDEX "oil_log_user_id_7f26e501" ON "oil_log" ("user_id"); sqlite> Help??? -- Dictionary.com's word of the year: *complicit* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users