This project is read-only.

Problem publishing to existing website

May 13, 2011 at 5:59 PM

I have attempted to integrate the app into an existing site hosted by godaddy.  I created an asp.net MSSQL database on godaddy, used VS8 to create a script, and executed the script against the host database.  I am getting errors when I execute the script. Here is an excerpt:

Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. The variable name '@RoleName' has already been declared. Variable names must be unique within a query batch or stored procedure. The variable name '@RoleMemberName' has already been declared. Variable names must be unique within a query batch or stored procedure. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. The variable name '@RoleName' has already been declared. Variable names must be unique within a query batch or stored procedure. The variable name '@RoleMemberName' has already been declared. Variable names must be unique within a query batch or stored procedure. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'. Incorrect syntax near 'GO'.

I got the app to run on my local machine.  I copied the files and folders from my local machine to the website host as best as I can tell.  In addition, when I uploaded the config file, it killed the whole site.

May 13, 2011 at 10:30 PM

Incorrect syntax near 'GO'.

 

You have to execute the script on the server without 'GO'

May 14, 2011 at 3:39 PM

I believe I succeeded in installing the database. Before and now whenever I upload the config file it crashes the site.  It did not have a config file before.

May 16, 2011 at 3:06 AM

I guess I need step by step instructions for installing on a web host like Go Daddy.

May 16, 2011 at 5:49 AM

Sorry for being a pain.  I cannot get the script to run against the Go Daddy database without errors.  Even when I remove "GO."  You have some script in your installation package.  I ran two of those with no problem but I don't know if they do anything.  They certainly don't include my mods.  I even tried emptying my site of everything except a default.html with one image and some text and your web.config file.  It will load without the config but crashes with it.  What is it about a config file that would crash an empty site?

May 16, 2011 at 9:34 PM
mrjuice wrote:

I guess I need step by step instructions for installing on a web host like Go Daddy.

 

change the connection string in the web.config and copy all the files on your web host. Then navigate to http://www.yoursite.com/install.aspx

you don't need to execute the scripts manually.

May 17, 2011 at 3:57 AM

That did the trick.  The app installed but I am unable to make modifications through the normal admin interface.  I will start new threads for these if none currently exist.  Thank you for patiently assisting me.