Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...delete from dnn_packages = ables without a clustered index are not supported in this version of SQL delete from dnn_packages = ables without a clustered index are not supported in this version of SQL
Previous
 
Next
New Post
9/22/2014 5:22 AM
 

Hello DNN experts,

I am trying to delete a line in the table dnn_packages due to a misconfiguration in one of the loaded skins

as I run :: delete from dnn_packages where PackageID = 144

I get the error :  Msg 40054, Level 16, State 1, Line 2
            Tables without a clustered index are not supported in this version of SQL Server.
            Please create a clustered index and try again.

Of course, table dnn_packages have index, therefore if I try to recreate them, SQL reply so. 

I have try with both :
      
CREATE UNIQUE CLUSTERED INDEX Idx_dnn_packages ON dnn_packages(PackageID);
       ALTER TABLE [dbo].[dnn_packages] ADD PRIMARY KEY ([PackageID]);

obviously, in both cases, the system respond:
     Cannot create more than one clustered index on table 'dnn_packages'.
           Drop the existing clustered index 'PK_Dnn_Packages' before creating another.
     Table 'dnn_packages' already has a primary key defined on it.

Is there any dependency, or reason, by design, becouse DELETES form Dnn_Packages are not allow ??

Note:
I got inspired from the following post, to try to delete the line in dnn_packages:
http://www.dnnsoftware.com/forums/forumid/109/threadid/289839/scope/posts



 
New Post
9/22/2014 5:41 AM
 
it sounds, like you are on Azure SQL, which always requires a clustered index - delete might affect table PackageDependencies, which might be missing a clustered index.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/22/2014 6:27 AM
 

Hello Sebastian, 

Indeed I am on Azure, sorry I did not specify

Get a look on Dnn_PackageDependencies, Field PackageDependencyID is set as Identity, Required and PrimaryKey

Try to run : CREATE UNIQUE CLUSTERED INDEX Idx_Dnn_PackageDependencies ON Dnn_PackageDependencies(PackageDependencyID);

and so I get: Cannot create more than one clustered index on table 'Dnn_PackageDependencies'.

So it seems it has the clustered index on place 

I give a look to the other dependant tables and only Dnn_PackageTypes is missing a key as Identity, PackageType, which is a nvarchar100 is set to Required and PrimaryKey, but not Identity

Should I run : CREATE UNIQUE CLUSTERED INDEX Idx_Dnn_PackageTypes ON Dnn_PackageTypes(PackageType);
???


 
New Post
9/22/2014 6:35 AM
 
I suggest running "CREATE UNIQUE CLUSTERED INDEX PK_Dnn_PackageTypes ON Dnn_PackageTypes (PackageType);

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/22/2014 7:45 AM
 

it seems there is already a PK, even there is not set as identity when looking trough the management portal

Msg 1902, Level 16, State 3, Line 1

Cannot create more than one clustered index on table 'Dnn_PackageTypes'. Drop the existing clustered index 'PK_Dnn_PackageTypes_1' before creating another.

 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...delete from dnn_packages = ables without a clustered index are not supported in this version of SQL delete from dnn_packages = ables without a clustered index are not supported in this version of SQL


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

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

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out