Django 0.96, Python 2.4, Linux, development webserver
I have a with clicking certain column headings for sorting in the contrib
Admin lists. I think I brought this on myself. The class reseller below used
to be simply a CHOICES list, but that got unwieldy, so I created the class
and gave fuel_release a foreign key to it. I also recreated the table
fuel_release so it has ids to the reseller table where the reseller names
used to be. It all seems to be working OK except that if I click on the
'reseller' column in the admin listing for fuel_releases, I get a MySQL
error:
(1054, "Unknown column 'fuel_reseller.reseller_id' in 'order clause'")
To recreate the tables and populate with ids instead of strings, I saved the
table data, edited it, dropped the tables, and did a syncdb.
I'll be grateful for any ideas you've got. Thanks, and
Cheers!
--
David Hancock | [EMAIL PROTECTED]
Here is some relevant model code:
class reseller(models.Model):
reseller = models.CharField(maxlength=30)
def __str__(self):
return self.reseller
class Admin:
pass
class Meta:
ordering = ['reseller',]
class fuel_release(models.Model):
tail = models.CharField(maxlength=10, blank=True)
iata = models.CharField('IATA', maxlength=4, blank=True)
...
reseller = models.ForeignKey(reseller, default=1,)
...
class Meta:
ordering = ['-release_datetime', 'company', 'tail',]
class Admin:
list_display = ['tail', 'iata', 'reseller', 'fbo', 'eta_date',
'quoted_gallons',]
list_filter = ['eta_date',]
search_fields = ['tail', 'iata',]
And in case it's helpful, here's the output from sqlall:
BEGIN;
CREATE TABLE `fuel_fuel_release` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`company_id` integer NOT NULL REFERENCES `trips_company` (`id`),
`tail` varchar(10) NOT NULL,
`iata` varchar(4) NOT NULL,
`eta_date` date NOT NULL,
`arinc_invoice_number` varchar(20) NOT NULL,
`actual_gallons` integer NULL,
`actual_cost` numeric(5, 2) NULL,
`actual_price` numeric(5, 2) NULL,
`retail_price` numeric(5, 2) NULL,
`comments` longtext NOT NULL,
`quoted_gallons` integer NULL,
`quoted_cost` numeric(5, 2) NULL,
`quoted_price` numeric(5, 2) NULL,
`reseller_id` integer NOT NULL,
`reseller_invoice_number` varchar(30) NOT NULL,
`reseller_invoice_date` date NOT NULL,
`reseller_order_number` varchar(20) NOT NULL,
`fbo` varchar(100) NOT NULL,
`margin_per_gallon` numeric(4, 3) NULL,
`revenue` numeric(8, 2) NULL,
`margin_percentage` integer NULL,
`margin_dollars` numeric(8, 2) NULL,
`rebate_per_gallon` numeric(4, 2) NULL,
`rebate_dollars` numeric(8, 2) NULL,
`release_datetime` datetime NOT NULL
);
CREATE TABLE `fuel_reseller` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`reseller` varchar(30) NOT NULL
);
ALTER TABLE `fuel_fuel_release` ADD CONSTRAINT reseller_id_refs_id_78d693b
FOREIGN KEY (`reseller_id`) REFERENCES `fuel_reseller` (`id`);
CREATE INDEX fuel_fuel_release_company_id ON `fuel_fuel_release`
(`company_id`);
CREATE INDEX fuel_fuel_release_reseller_id ON `fuel_fuel_release`
(`reseller_id`);
COMMIT;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
