Skip to content

Remove SQL syntax that's incompatible with 2012#5568

Merged
david-poindexter merged 1 commit intodnnsoftware:developfrom
bdukes:fix-sql-incompatibility
Mar 10, 2023
Merged

Remove SQL syntax that's incompatible with 2012#5568
david-poindexter merged 1 commit intodnnsoftware:developfrom
bdukes:fix-sql-incompatibility

Conversation

@bdukes
Copy link
Copy Markdown
Contributor

@bdukes bdukes commented Mar 10, 2023

DROP PROCEDURE IF EXISTS requires SQL 2016, DNN's current minimum requirements include SQL 2012

Also adjust the column existence check to be consistent with other checks

Fixes #5554

DROP PROCEDURE IF EXISTS requires SQL 2016, DNN's current minimum
requirements include SQL 2012

Also adjust the column existence check to be consistent with other
checks

Fixes dnnsoftware#5554
@bdukes bdukes added this to the 9.11.2 milestone Mar 10, 2023
Copy link
Copy Markdown
Contributor

@david-poindexter david-poindexter left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

PR looks good but build is failing. 🤷

@bdukes bdukes mentioned this pull request Mar 10, 2023
Copy link
Copy Markdown
Contributor

@valadas valadas left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Looks good to me

The build issue is unrelated:
I had to put a workaround in place due to Webpack4 having an issue with a breaking change in Node v18

I added --openssl-legacy-provider to the environment variables which worked in many other projects where Webpack could not be quickly upgraded to v5. It worked earlier in this project (like last week or so), not sure what has changed but it is now saying it is not allowed in NODE_OPTIONS... I'll try to take a look at that this weekend...

Copy link
Copy Markdown
Contributor

@david-poindexter david-poindexter left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Marking as approved and treating build issue separately.

@david-poindexter david-poindexter merged commit 5221366 into dnnsoftware:develop Mar 10, 2023
@david-poindexter david-poindexter deleted the fix-sql-incompatibility branch March 10, 2023 18:37
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

DNN 09.11.01 upgrade issue on SQL 2012

4 participants