Hi, I saved the entire aspx project under wwwroot on the server that was hosting my website, when the account with that hosting service was terminated.

Now, it's being re-installed (DNN 6 Community Edition), but the technician has sent me this email in response to my request to set the start page to 'default.aspx':

"That under construction page is being displayed because the site can not find the database.
The database name was 'dnndb', user 'xxxxx' and password 'xxxxxx'
We can recreate that as an empty database for you, but your site is going to be missing its content if you didnt make a backup of that database."

Can you help me to understand what database he's referring to? I thought that the db was embedded in the project under App_Data in Database.mdf ???

A bit of education about the DNN database would be welcome. thanks

Andre,

Your DotNetNuke database is normally hosted in a MS SQL Server installation. If you look in web.config, you'll see the details of that server in the Connection Strings section.

Besides saving the contents of the website's directory, you should also have gotten a copy of the database. Hopefully, you will be able to get that from the host, even if your account has ended, if they maintain backups.

If you can't get a copy of that database, I'm afraid that you have lost your site's content.

Feel free to contact me privately using the contact form at patapscorg.com with details of the hosting provider where your site was located. I may be able to offer some advice knowing the details.

Just a bit more, the connection string settings will tell exactly where the database was stored.

OK, I've had to start with a new empty dnn db. By naming the 'new' pages the same as the old ones, and hooking up the appropriate skins from the 'old' project, I've been able to recover something of the previous site, so it could be worse.

However, the Modules pop up screen doesn't show any module list under the default 'Common' title, only under the 'Admin' and 'All Categories' title. I can see modules in the 'DesktopModules' folder, but the 'Extensions' page isn't showing them as 'installed' or even available.

Any ideas ?
Cheers

How did you "start with a new empty dnn db"?

Normally as part of the install process, DotNetNuke installs a number of tables and stored procedures to the database and then installs DotNetNuke components which add data to the database. Did you go through this install procedure?

Hi Joe. Arvixe support staff installed the new dnn db so I need to ask them. Will reply when I get some info from them. Cheers

OK, got a reply from Arvixe support:

"We have manually installed the script, by downloading the application from http://dotnetnuke.codeplex.com/ ( 6.2.2 - New Install ), uploaded the extracted files to the wwwroot folder, Created the empty database from control panel and access the installation page via the browser URL.

>>On the installation menu,
Step 1: Select Installation Method : Typcal
Step 3 : Select Database : SQL Server 2005/2008 Database
Leave Server option as it is
Enter the already created Database name
Uncheck the Integrated security option
Enter the Database user name and password
Uncheck Run as database owner and complete the steps.

Please let us know if you need any further assistance.



Simon M
Jr. Technical Operations Officer"


What to make of that?
Cheers

By the way, I copied into the folders under wwwroot from my original backed up project: Skins, and other stuff under the Portal folders of _default and 0 (my skins were under the _default folder, available to other sites should I set any up.

If they installed a new database, presumably with mostly empty tables, I'm surprised that you got any old pages back.

So could be further complications down the line? Any advice about this gratefully received.

That's very hard to say, as I don't know how they recovered data, "rebuilt" what is there, etc.

The good news is that you have something running. Make sure to keep good backups -- both the database and the web directory -- and you'll probably be ok.

Hi, I'm getting a message when logging in as 'host' user:

"...An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid object name 'CoreMessaging_Messages'. ---> System.Data.SqlClient.SqlException: Invalid object name 'CoreMessaging_Messages'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) ..."

Also, if I need to create this Table (using the SQL module) could you point me in the direction of a good tutorial that explains the {databaseOwner} and {ObjectQualifier} variables that could be used.

Thanks

Does this happen only for the host user? Do other users have that problem?

Which Version of DotNetNuke?

I get a different: "An error has occurred. An error has occurred." message when signing in with the admin user (the only other user). And admin id fails to get a DNN ribbon toolbar at the top of the screen, whereas host has one.

Installing latest DNN Community Edition 06.02.03 now, as I see there may be issues with the Core messaging functions. Will confirm solved.

I'm also not seeing modules that should be displayed in the drop down under the 'Common' category. I see them in the 'All' Category though. I installed a new HTML module and that showed in the common category (the only one).

When you install a module, you must put it in a category or categories. You do this from the Edit Module functionality on the Extensions page.

Hi, I can't add new pages to my site (history of problem in messages above). It's showing this message:

"Error: is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot find either column "andredec_dnndb" or the user-defined function or aggregate "andredec_dnndb.RemoveStringCharacters", or the name is ambiguous. "

It's to do with the naming of the new DNN system database and the substitution of my user name 'andredec' and 'dnndb' specified in web.config connection string.

Any help appreciated.

It seems like you are referring to the database's ObjectQualifier.

"The Object Qualifier is a configuration setting within the DataProvider section of the web.config available in DotNetNuke that allows you to set an optional qualifier that will be prefixed to any and all SQL Server objects that are created as part of the DotNetNuke and module installation process."

So, if you have created an object qualifier, it's name has been prepended to all of the DotNetNuke objects in your database.

You need to have the same ObjectQualifier specified in DotNetNuke's web.config file. You will need to edit web.config so that they match.

Manyy thanks for the advice. Looks like it's the 'other' variable that is being substituted in ie. databaseowner. Here's the relevant part of the string:

"... \Providers\DataProviders\SqlDataProvider\" objectQualifier="" databaseOwner="andredec_dnndb" ..."

I have the suspicion that since the database was re created from scratch (see above chain) some of the SQL objects may havce a different (or no?) prefix, whereas newer objects will have this prefix.

So I'm hoping to be able to identify and rename those 'old' objects.

Can you advise on the means to SHOW stored procedure contents. From DNN SQL module, it doesn't accept the MySQL command 'SHOW'.

I know for certain that one of the errors I'm getting is due to a simple typo error in a stored procedure that I modified. But i can't find out which one without being able to see the contents.

Thanks ahead for any assistance.

It will be much easier if you are able to use Microsoft SQL Server Management Studio (or the Express version). You can download the Express version here:

http://www.microsoft.com/en-us/down...x?id=29062

SSMS is the last item on the list.


This runs on your computer and connects to the website's SQL server. Hopefully your host will permit that. SSMS provides a complete IDE for interacting with your database and the objects in it. You can open, edit, and update stored procedures, tables, data, etc.