Release 1.7.1 of pretix

Sept. 5, 2017

If you already upgraded to today's release 1.7.0, you might have run into the following error on MySQL:

django.db.utils.OperationalError: (1072, "Key column 'payment_fee_tax_rule_id' doesn't exist in table")

Or on PostgreSQL:

psycopg2.ProgrammingError: column "payment_fee_tax_rule_id" does not exist

On PostgreSQL

On PostgreSQL, you can just upgrade to version 1.7.1 directly and run migrations like you normally would.

On MysQL

On MySQL, if you created a backup before the upgrade, please revert to it and upgrade to 1.7.1 directly. If you do not have a current backup, please proceed with the following steps:

First, create a full backup of your database. Then, upgrade to pretix 1.7.1 without running migrations.

Now execute the following command:

python3 -m pretix migrate --fake pretixbase 0077_auto_20170829_1126

And the following SQL commands on your database:

ALTER TABLE `pretixbase_taxrule`
    ADD CONSTRAINT `pretixbase_taxrule_event_id_178a74ee_fk_pretixbase_event_id`
    FOREIGN KEY (`event_id`) REFERENCES `pretixbase_event` (`id`);
ALTER TABLE `pretixbase_item`
    ADD CONSTRAINT `pretixbase_item_tax_rule_id_f501b784_fk_pretixbase_taxrule_id`
    FOREIGN KEY (`tax_rule_id`) REFERENCES `pretixbase_taxrule` (`id`);
ALTER TABLE `pretixbase_orderposition`
    ADD CONSTRAINT `pretixbase_orderposi_tax_rule_id_6564b2f1_fk_pretixbas`
    FOREIGN KEY (`tax_rule_id`) REFERENCES `pretixbase_taxrule` (`id`);
ALTER TABLE `pretixbase_eventmetaproperty`
    ADD CONSTRAINT `pretixbase_eventmeta_organizer_id_595552fd_fk_pretixbas`
    FOREIGN KEY (`organizer_id`) REFERENCES `pretixbase_organizer` (`id`);
CREATE INDEX `pretixbase_eventmetaproperty_name_c3ddda49`
    ON `pretixbase_eventmetaproperty` (`name`);
ALTER TABLE `pretixbase_eventmetavalue`
    ADD CONSTRAINT `pretixbase_eventmeta_event_id_567f5820_fk_pretixbas`
    FOREIGN KEY (`event_id`) REFERENCES `pretixbase_event` (`id`);
ALTER TABLE `pretixbase_eventmetavalue`
    ADD CONSTRAINT `pretixbase_eventmeta_property_id_28f8ebf7_fk_pretixbas`
    FOREIGN KEY (`property_id`) REFERENCES `pretixbase_eventmetaproperty` (`id`);
ALTER TABLE `pretixbase_subeventmetavalue`
    ADD CONSTRAINT `pretixbase_subeventm_property_id_bda97d56_fk_pretixbas`
    FOREIGN KEY (`property_id`) REFERENCES `pretixbase_eventmetaproperty` (`id`);
ALTER TABLE `pretixbase_subeventmetavalue`
    ADD CONSTRAINT `pretixbase_subeventm_subevent_id_b97a87d2_fk_pretixbas`
    FOREIGN KEY (`subevent_id`) REFERENCES `pretixbase_subevent` (`id`);
ALTER TABLE `pretixbase_orderfee`
    ADD CONSTRAINT `pretixbase_orderfee_order_id_b8c4a186_fk_pretixbase_order_id`
    FOREIGN KEY (`order_id`) REFERENCES `pretixbase_order` (`id`);
ALTER TABLE `pretixbase_orderfee`
    ADD CONSTRAINT `pretixbase_orderfee_tax_rule_id_082755a4_fk_pretixbas`
    FOREIGN KEY (`tax_rule_id`) REFERENCES `pretixbase_taxrule` (`id`);

You can then complete upgrade to 1.7.1.

We are sorry for any inconvenience caused by this.

Raphael Michel

Raphael is the founder and main developer of pretix. He is passionate about user-friendly, elegant software, and when he's not busy building software for conference organizers, he enjoys co-organizing conferences himself.