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.

Sign up for GitHub

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

Jump to bottom

Ef Migration gives error on npgsql. #352

Closed
alperencaliskan opened this issue Jul 27, 2018 · 1 comment
Closed

Ef Migration gives error on npgsql. #352

alperencaliskan opened this issue Jul 27, 2018 · 1 comment
Labels
bug core
Milestone
Version 5.1.2

Comments

@alperencaliskan
Copy link
Contributor

Upgrading from 5.0.0 to 5.1.1,

Ef migration fails because of raw query, postgresql is case insensitive for object names. Needs quotation marks.

piranha.core/core/Piranha/Migrations/20180531092411_AddMediaVersionExtension.cs

Line 17 in 131e23f

migrationBuilder.Sql("UPDATE Piranha_MediaVersions SET FileExtension='.jpg' WHERE FileExtension IS NULL");

UPDATE "Piranha_MediaVersions" SET "FileExtension"='.jpg' WHERE "FileExtension" IS NULL
@alperencaliskan alperencaliskan mentioned this issue Jul 30, 2018
Merged
@tidyui tidyui closed this as completed Aug 2, 2018
@tidyui tidyui added this to the Version 5.1.2 milestone Aug 10, 2018
@tidyui
Copy link
Member

tidyui commented Aug 10, 2018

This has now been released and is available in Piranha 5.1.2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug core
Projects
None yet
Milestone
Version 5.1.2
Development

No branches or pull requests
2 participants
@tidyui @alperencaliskan