Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

0.7 sqlite SQL upgrade has broken syntax #3607

Closed
rcubetrac opened this issue Dec 14, 2011 · 5 comments
Closed

0.7 sqlite SQL upgrade has broken syntax #3607

rcubetrac opened this issue Dec 14, 2011 · 5 comments
Labels
Milestone

Comments

@rcubetrac
Copy link

@rcubetrac rcubetrac commented Dec 14, 2011

Reported by mrjoel on 14 Dec 2011 18:02 UTC as Trac ticket #1488255

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);

Migrated-From: http://trac.roundcube.net/ticket/1488255

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Dec 14, 2011

Severity changed by mrjoel on 14 Dec 2011 18:03 UTC

normal => major

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Dec 14, 2011

Comment by @alecpl on 14 Dec 2011 18:29 UTC

Fixed in 7177b52:bd9190a6.

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Dec 14, 2011

Status changed by @alecpl on 14 Dec 2011 18:29 UTC

new => closed

@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Dec 14, 2011

Milestone changed by @alecpl on 14 Dec 2011 18:29 UTC

later => 0.8-beta

@rcubetrac rcubetrac closed this Dec 14, 2011
@rcubetrac

This comment has been minimized.

Copy link
Author

@rcubetrac rcubetrac commented Dec 21, 2011

Milestone changed by @alecpl on 21 Dec 2011 09:58 UTC

0.8-beta => 0.7.1

@rcubetrac rcubetrac added this to the 0.7.1 milestone Mar 20, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.