A few years back we built a website based on DNN 4.7 (WEBSITE) with the help of this forum and Mitchell Sellers. It was painfull, but we finally got it running. It has always been a hair slow, but acceptable. Oer the last year, the site has gotten slower, and more Critical Error pages come up, and we are getting a lot of complaints from the members of our car club. This website is an information and bragging site (mostly pictures of members cars and local events). The two bigest modules we use are YAF 1.9.1.8 and we bought BizModules UltraPhotoGallery. We also set up a sub page using Luca's store SDN Store module several years back to allow members to update their membership and buy shirts and whatnot. Unfortunately, when my wife passed away we no longer knew how to update the store, so we are interested in replacing it. It is very complicated, and has been difficult to use.

Here is the question: Should we consider updating to a more recent version of DNN? What pitfalls will we run into? Is the DNN forum module good enough to use now? Is it possible to save all the info from our YAF module? and of course, why is our site so slow and always popping errors?

Now, I am an Engineer, but I am barely able to keep up with the website as it is, and am still amazed I got the thing hosted and running, software isn't my favorite. I think I need to backup the site and somehow backup the database (I will start reading on this stuff again) since it has been a few years since we messed with this. If I can remember how, I will try and get it re-installed on my laptop.  If I can figure this out again (did it years ago) I will try to update the DNN locally. Advice?

---

Visit our Website at www.northstarcamaroclub.com

It is good to be back working on the hobby stuff, but it is frustrating when you are not a programmer!!!!!! I may have screwed up on trying to back this up as a local install. I thought I got the database backed up from crystaltech and I thought I restored it onto the old database from my local install a few years back. I copied the files from the site over to the old location in inetpub, and tried to update the web.config. I thought all this should work, but this comes up: ________________________________________________________________________ Server Error in '/DNN_4_7' Application. Cannot open user default database. Login failed. Login failed for user 'ARCHER\ASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'ARCHER\ASPNET'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Cannot open user default database. Login failed. Login failed for user 'ARCHER\ASPNET'.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117 System.Data.SqlClient.SqlConnection.Open() +122 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +233 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +343 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +175 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +45 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +207 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo() +71 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo() +101 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID) +65 DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo) +75 DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo) +175 Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618 ________________________________________________________________________ Note exactly sure what calls this, and where to go from here. Thought I had things going well, but I just don't remember how I got all this working before!!!!!

---

Visit our Website at www.northstarcamaroclub.com

 
If you haven't backed up for a few years and now you have performance problems, a good tip is to check the size of the transaction log file (in the SQL server's DATA folder). You may need the help of your host to truncate the transaction log file. Also check the size of  the event viewer and the site log in the Admin section of your site. Bringing these files to reasonable sizes can have a huge impact on the performance of your web portal.

If you are looking to upgrade and your focus is on performance, my understamding is that version 4.9.5 is a stable and fast one (from what I read in these forums). You will have to make the upgrade to 4.9.5 first anyway, even if you want to upgrade to DNN 5. The next stable version would be 5.4.4 imho but I'm not sure about its performance.

---

____________________________________
The one-eyed in the land of the blind.