Yes. DNN Platform is a free, open-source CMS under the MIT License.

What is the tech stack for DNN?

DNN runs on ASP.NET (.NET Framework 4.8+) with Microsoft SQL Server (2017+ or Azure SQL).

DNN Platform is community-led and a member project of the .NET Foundation.

What’s the difference between DNN and Evoq?

DNN Platform is the open-source core that's been wildly popular and adopted for over 20 years. Evoq is a commercial offering maintained by DNN Software (IgniteTech) that builds on DNN.

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Upgrade issue going from 9.13.9 to 10.0.0

7 Replies

0 Subscribed to this topic

33 Subscribed to this forum

Sort:

Author

Messages

shph_itmanager

New Around Here

Posts: 2

5/14/2025 1:40 PM

Hello,

I have attempted to upgrade a fresh install of 9.13.9 (no issues during the installation) to 10.0.0 twice now and I continue to receive the following error during the upgrade process;

21% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'IF'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:9bb5416e-fdee-462e-adae-99df0486216d Error Number:156,State:1,Class:15 DROP VIEW IF EXISTS dbo.[vw_ApiTokens]

Tim

David Lee

Advanced Member

Posts: 207

Helpful Replier

MVP

New Poster

5/14/2025 9:54 PM

DROP VIEW IF EXISTS {databaseOwner}[{objectQualifier}vw_ApiTokens]

is in the 10.00.00.SqlDataProvider. And is a valid statement. However, this format of DROP VIEW is only valid from SQL 2016 and above. What version of SQL do you have?

David Lee

Advanced Member

Posts: 207

Helpful Replier

MVP

New Poster

5/14/2025 10:10 PM

I have created an issue in GitHub for this.

https://github.com/dnnsof...Platform/issues/6547

David Lee

Advanced Member

Posts: 207

Helpful Replier

MVP

New Poster

5/14/2025 10:37 PM

I decided to do the pull request to fix this issue.

David Lee

Advanced Member

Posts: 207

Helpful Replier

MVP

New Poster

5/14/2025 10:44 PM

Sorry about all the comments!!

If you want to fix this problem you can edit the 10.00.00.SqlDataProvider file in the upgrade package before you run it. See the issue for the required SQL command.

As for the installations already upgraded, check for the "vw_ApiTokens" view in the database. If it's there I think it will be OK. If not you can try running the rest of the SQL command required. lines: 425 to the end. Although in this situation I would opt for a restore of the installation, a SQL upgrade and redo the upgrade of the DNN installation. If you cannot upgrade SQL, restore the DNN installation, change the SQL command in the upgrade package and redo the upgrade.

shph_itmanager

New Around Here

Posts: 2

5/15/2025 3:03 PM

Sorry for the late response David. I'm using SQL Express 2012. I may upgrade SQL if need be. I'll try your suggestions first though.

Thanks

shph_itmanager

New Around Here

Posts: 2

5/16/2025 10:18 AM

I upgraded from SQL Express 2012 to 2019 and that solved the issue. I was able to upgrade to 10.0.0 with no issue.

Marco Alvarado

Veteran Member

Posts: 367

Helpful Replier

New Poster

Engaged Reader

Avid Reader

Most Liked

5/19/2025 9:56 AM

Nice catch guys! Thanks shph_itmanager for sharing the solution.

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy.
No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved