Posted By Agency3 on 05 Jul 2019 03:55 PM

Thanks for the help. I'm still not sure how I fixed this. All I did was install a new theme and now the new version of 40FINGERS Style Helper Skin Object works.

There is a lot of 'residual' javavscript code and objects left in the custom skin because I upgraded from DNN 6 straight to 9 so perhaps that has something to do with it. There are also permission problems with my account that won't let me rename directories or use the Digital Assets module so it not exactly a fresh install of a site!

If it is still possible, I would restore a backup and follow the recommended upgrade path https://www.dnnsoftware.c...ggested-upgrade-path

Thanks! The last 2 seem to okay but the first query does say the size is huge: 3097.06 MB. with only about 10MB left

Posted By Agency3 on 07 Jul 2019 04:30 PM

Thanks! The last 2 seem to okay but the first query does say the size is huge: 3097.06 MB. with only about 10MB left

That looks like you are running into some kind of hosting limit.

Try this SQL to find what table is causing the DB to be this large.

SELECT
    t.NAME AS TableName,
    i.name as indexName,
    sum(p.rows) as RowCounts,
    sum(a.total_pages) as TotalPages,
    sum(a.used_pages) as UsedPages,
    sum(a.data_pages) as DataPages,
    (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,
    (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,
    (sum(a.data_pages) * 8) / 1024 as DataSpaceMB
FROM
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
    sys.allocation_units a ON p.partition_id = a.container_id
WHERE
    t.NAME NOT LIKE 'dt%' AND
    i.OBJECT_ID > 255 AND   
    i.index_id <= 1
GROUP BY
    t.NAME, i.object_id, i.index_id, i.name
ORDER BY
     (sum(a.used_pages) * 8) / 1024  DESC

Yea the log is huge!

Table name: SiteLog

2675 MB total space
2675 MB Used space
2665 Dataspace

Posted By Agency3 on 08 Jul 2019 10:27 AM

Yea the log is huge!

Table name: SiteLog

2675 MB total space
2675 MB Used space
2665 Dataspace

First backup your database.
Then run this SQL command:

TRUNCATE TABLE SiteLog

Okay that shrank it down quite a bit. I haven't had any problems since switching to a new theme so I don't know if it was your module or not. I'll keep you posted if I have any more trouble. Thanks for the help

(update: Almost everything wrong with my site turned out to be a corrupted web.config. See this thread https://dnncommunity.org/forums/aft/128 )