Stefan Pantu
New Poster
Posts:8
 | | 09/19/2007 10:43 PM |
| I understand that I should ignore the following error during upgrade: 00:00:01.656 - Executing Script: 04.04.00.SqlDataProvider Error! (see 04.04.00.log for more information)
However, my website does not come up. I am running the site using VS 2005 Professional. The site ran great before the upgrade.
When I click on the link
Click Here To Access Your Portal
I get a "The page cannot be found" error in the IE browser.
The URL displayed in the IE browser is incorrect: http://southfloridakiteboarding.com/wwwroot
The URL should be http://localhost:1269/wwwroot/default.aspx.
When I enter the correct URL into the address bar, the URL reverts back to http://southfloridakiteboarding.com/wwwroot. This is the URL of my hosted web site. Any troubleshooting advice you can provide is appreciated. Thanks, Stefan CSC Inc. | | | |
|
Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 09/19/2007 11:06 PM |
| Stefan,
Thank you for migrating this question to the forum!
It appears that you have migrated your site to your local PC for testing, you will need to add a portal alias to your database to be able to use that URL.
In the PortalAlias table just make an entry for the localhost, I believe you will want to include the port number so it should be like the following
localhost:1269/wwwroot
That should get you going, once you add the database value be sure to re-save your web.config to recycle the application. | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
|
Stefan Pantu
New Poster
Posts:8
| | 09/19/2007 11:31 PM |
| The entry localhost:1269/wwwroot has always existed in the PortalAlias table. That is how I was able to run the DNN 4.3.5 version of the website before the upgrade to 4.5.5. Any other ideas? Thanks, Stefan CSC Inc. | | | |
|
Stefan Pantu
New Poster
Posts:8
| | 09/19/2007 11:36 PM |
| The PortalAlias Table contains three records:
southfloridakiteboarding.com/wwwroot
www.southfloridakiteboarding.com
localhost:1269/wwwroot
It seems that for some reason, the site always comes up under the link southfloridakiteboarding.com/wwwroot. | | | |
|
Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 09/19/2007 11:41 PM |
| I would ensure that you have the "UsePortNumber" appsetting set to true
Otherwise I am not 100% sure. I do not use non-standard port numbers on my environments. | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
|
Stefan Pantu
New Poster
Posts:8
| | 09/20/2007 12:20 AM |
| I see that you have already had a similar recent discussion here
http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/108/threadid/168204/threadpage/0/scope/posts/Default.aspx
I guessed that the change to web.config is:
.
.
.
This partially brought up the site. Several (but not all) modules display the error:
[!] An error has occurred.
Error: XXX is currently unavailable.
This error occurs in the Survey Module and FAQ modules among others. See error details below. Could it be that Database.mdf is hard coded somewhere? I use sfkb.mdf as the DNN local SQL Server database name.
Also, should I change the port to 7070 from 1269 (per your previous post on the subject)?
Thanks,
Stefan
=============================================
DotNetNuke.Services.Exceptions.ModuleLoadException: An attempt to attach an auto-named database for file C:\Documents and Settings\Stefan\My Documents\Visual Studio 2005\Web Sites\wwwroot\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. ---> System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Documents and Settings\Stefan\My Documents\Visual Studio 2005\Web Sites\wwwroot\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.IFrame.SqlDataProvider.GetParameters(Int32 ModuleID) at DotNetNuke.Modules.IFrame.IFrame.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
| | | |
|
Stefan Pantu
New Poster
Posts:8
| | 09/20/2007 12:29 AM |
| For some reason, this code was automatically removed from the post.
I guessed that the change to web.config is:
''
.
.
.
''
''
| | | |
|
Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 09/20/2007 8:44 AM |
| Stefan,
It appears that the forum is stripping out your code, I will have to look into that issue, but to address your concerns.
1.) You can use whatever port number you are trying to work with, 1269 is just fine, if that is how you have IIS setup, I wouldn't mess with it!
2.) Regarding the change, it appears that your connectionstring within the section of the web.config is not set to the same as your connectionstring within the section. Ensure that you have modifed both of them to point to your proper DB location. | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
|
Stefan Pantu
New Poster
Posts:8
| | 09/20/2007 8:55 AM |
| Your answers were right on, my site is now back up. Thanks for all the great advice!
Stefan
CSC Inc. | | | |
|
Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 09/20/2007 8:57 AM |
| Stefan,
No problem! Glad you are up and running! | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
|