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

Fresh install 2.3.X / SQL Server 2019 #821

Open
m3ct0n opened this issue May 11, 2023 · 1 comment
Open

Fresh install 2.3.X / SQL Server 2019 #821

m3ct0n opened this issue May 11, 2023 · 1 comment
Assignees
Labels

Comments

@m3ct0n
Copy link

m3ct0n commented May 11, 2023

In the install step "creating database schema" I get an error.

The logs say "An exception occurred while executing a query: SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Cannot drop the index 'addresses.primary', because it does not exist or you do not have permission."

To Reproduce
PHP 8.1.18
SQL Server 2019 / driver msodbcsql17 (same on 2012 version)

Logs:
++ migrating "DoctrineMigrations\Version20200"
Executing query: "ALTER TABLE user_invitations ADD CONSTRAINT FK_8A3CD93B979B1AD6 FOREIGN KEY (company_id) REFERENCES companies (id)"
Executing query: "ALTER TABLE user_invitations ADD CONSTRAINT FK_8A3CD93BA7B4A7E3 FOREIGN KEY (invited_by_id) REFERENCES users (id)"
Executing query: "DROP INDEX [primary] ON addresses"

Migration "DoctrineMigrations\Version20200" failed during "Execution". Error: "An exception occurred while executing a query: SQLSTATE[42S02]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot drop the index 'addresses.primary', because it does not exist or you do not have permission."

@pierredup
Copy link
Member

@m3ct0n Thanks for the report. I don't have access to a SQL Server instance, so this might take some time to fix as I need to get access to an instance first.

@pierredup pierredup self-assigned this May 11, 2023
@pierredup pierredup added the bug label May 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants