I have just downloaded and upzipped DNN 1.0.10 (never tried DNN before). I printed your white paper by shaun walker.
Followed the instructions and created localhost/DotNetNuke virtual directory and DotNetNuke SQL Server 2000 DB.
I opened the project in VS 1.1.
I updated the WEB.CONFIG to the proper DB connection.
I ran the application setting default.aspx as the initial page.
An error results indicating that the Portals table needs a proper domain. I changed the Domain field from .default to localhost/DotNetNuke.
I ran the program again and get the error: System.IndexOutOfRangeException: GUID

I identified the stored procedure that is being called and confirm that it doesn't SELECT this field from the table. After reviewing the Database\1.0.10.sql script file I realize it contains different (*new/updated*) stored procs which reflect new(?) table structures. I attempted to run this script file from SQL Query Analyzer, but it errors out with missing tables/fields!!!

I attempted a second clean installation with the same results! What gives? Should I go back to version 1.0.09?

Thanks for any assistance you can give me on this.

STeve

I don't think you want to run the application through VS.NET at first. I don't think it will function properly to execute the required scripts fully through VS.NET for the first hit to DotNetNuke.

After you create the DotNetNuke virtual directory and DB, open a browser window and navigate to http://localhost/dotnetnuke. This will execute all of the .sql script files in the database folder and setup the DB for you. Now you should be able to use the VS.NET to run the application.


Josh

Well, I reset the system and did what you sugggest with exactly the same results.

Note: After the first run (of default.aspx) it creates the tables. The Portals table contains ".default" in the domain field and the 404.htm Config Error page shows that the Domain Name: localhost/DotNetNuke doesn't exist. I update Portals table to "localhost/DotNetNuke" and then it gets to the next error: System.IndexOutOfRangeException: GUID

It doesn't appear to run all the sql scripts when first executed.

Ideas?
Steve

Steve try to do a recompile of the code before you ever open it up to have the scripts run. Then run it on a clean DB. I think this may have something to do with running this on 1.1 when it was built with 1.0. I've successfully run the upgrade and a new install on 1.1, but that does not mean you have a little something different in your install. I assume you have either the aspnet user or the Network Service in 1.1 set up for full permissions on the file folder DNN resides in, right?

Also there is a verison table that will tell you the last script to run. That information will be helpful in trying to determine what the cause of this may be. You should also have a log file showing any error encountered in the script runs in the database folder.


Bruce

Well, that must have done it. I did a rebuild and ran it from within vs.net and all worked! Checked the Version table and all scripts ran! Great.

Thanks,
Steve

Good to hear, Steve.


Bruce