Opened 18 months ago

Closed 18 months ago

Last modified 17 months ago

#1488255 closed Bugs (fixed)

0.7 sqlite SQL upgrade has broken syntax

Reported by: mrjoel Owned by:
Priority: 5 Milestone: 0.7.1
Component: Database Version: 0.7
Severity: major Keywords:
Cc:

Description

The 0.7 release sql for sqlite upgrade is missing the table reference for the index. The change required is included below.

Also, updating the DB schema via the installer presents a list of versions from which to update, but the latest option was 0.5.1 instead of 0.6 which I was running. Not sure if it's related to the broken schema syntax.

Apply to both sqlite.initial.sql and sqlite.update.sql

-CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
+CREATE UNIQUE INDEX ix_searches_user_type_name on searches (user_id, type, name);

Change History (3)

comment:1 Changed 18 months ago by mrjoel

  • Priority changed from 3 to 5
  • Severity changed from normal to major

comment:2 Changed 18 months ago by alec

  • Milestone changed from later to 0.8-beta
  • Resolution set to fixed
  • Status changed from new to closed

Fixed in [7177b521]:[bd9190a6].

comment:3 Changed 17 months ago by alec

  • Milestone changed from 0.8-beta to 0.7.1
Note: See TracTickets for help on using tickets.