After upgrading from 4.9.5 to 5.5 I noticed that the Stored Procedure GetSkins is pointing to a column named PortalID. This column no longer exists in the Skins table. Is there a list somewhere that shows the schema for DNN 5.5? Is the Stored Proc wrong or the Table wrong? Or are these just not used anymore?

The only columns are SkinID, SkinPackageID, and SkinSrc.

Thanks

I happened to run into that same issue last evening when attempting to publish via scripting an upgraded datbase to GoDaddy via their SQL Data Publishing Web Service. The Skins table was modified in DNN 5.00.00 and both the GetSkins and GetSkin stored procedures which reference the PortalID column of the "old" Skins table were replaced by stored proceedures of different name. For some reason, they were never deleted in the 5.00.00.SqlDataProvider script nor in any later version scripts. You can safely delete both GetSkins and GetSkin from the database.

Normally, having those stored procedures left over in the database would not be an issue as they are never executed by code. However, when publishing the datbase via scripting, they will cause the publishing to fail.

Let me know if you will be logging the issue to Gemini or if you want me to.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner