hi
i created my first portal in my localhost and it's working good
i used version : DotNetNuke_Community_04.09.03
my database : Microsoft SQL Server 2005
and i here this tutorial
How to transfer a localhost DotNetNuke installation to a live website
http://www.dnncreative.com/Localhosttolivewebsite/tabid/348/Default.aspx
to know how i can upload it to live website and i did all steps
but after i finished and try to browse my web site i get this error message

Must declare the scalar variable "@PortalID".
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: Must declare the scalar variable "@PortalID".

you can check it from this page url
http://www.almny.com/Default.aspx
and you will see the error massage

after that i deleted my files from the live server and upload new web site without create any modules our pages it's only new refresh portal but it's also give me the same error message

 

hi john
thanks for your reply

1- Did you use a clean database for your new web site?
yes i used clean database and try mane time by new refresh database but the error still appear

2- start over with a new installation package and database to make sure all is good. You should be able to get the clean instance up and running, as long as DNS is configure correctly.
yes i did that , i forget my portal and say maybe i did some mistakes and i instal new website it's fresh instlation and try to upload it and did all configration like change conection string add alias and also i get the same error message

3-Did you remember to change BOTH instances of the connection string to the database in your web.config file
yes i did and the error reason not from connection string and i follow up all steps in the tutorials and i still get this error message

4- Did you upload your database to a new database server ?
yes i did to different things
- copy my local database and attached it on my server
- take backup from my local database and restor it into my server
and in both ways i get the same error

plz if any one have any suggestion ideas tell me it because i did erver things i can do it
thanks for all

Not sure if this will help but you can attempt to install the DNN BackItUp Module which is free on your localhost installation.  This will backup your entire site including database into a zip file.  Unzip the file, upload the files, and use the included .bak file to restore your database.

Just a thought.

Derek