Help with SQL

Topics: Help
Mar 18, 2007 at 3:20 PM
I get an error message when trying to open my site that says something about using WEBCONTROL.SQL. Where can I get this or how do I fix this? I am using GODADDY and I also get an error when submitting the SQL Scripts that say Error Foreign Key. What am I having trouble with.
This is a great site.
Thank you,
dpr
Coordinator
Mar 18, 2007 at 9:28 PM
Did you upload using the SQL script download? Try reuploading the database and use the SQL scripts that are for download on the Beta 2 release page.
Mar 20, 2007 at 12:35 AM
i get error when i run the sql script from app_data folder. (this is a blank db). error are as below:

Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.foreign_keys'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.views'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)
Error: Invalid object name 'sys.objects'. (State:S0002, Native Code: D0)

The same error also i get if run the sql script from SQL2000Scripts.zip

I using WIN SQL Server 2K
Coordinator
Mar 20, 2007 at 10:42 AM
Interesting... I have no way of debuging SQL 2000 since I don't have access to a SQL 2000 server.
Mar 20, 2007 at 11:00 AM
can you pls try the script on a 2K3 server with .net framework 2.0 installed?
Coordinator
Mar 20, 2007 at 10:30 PM
I don't have access to one.
Mar 22, 2007 at 9:55 AM
OK, I already manage to installed the sql script i get download from "source code page" if i try using the script from "release" page i will get that error.

thank for your help.
Mar 23, 2007 at 2:01 AM
Edited Mar 23, 2007 at 2:03 AM
Thank you for all of your help. I am unclear as to what scripts I am using for my database. I tried and downloaded a site from the source code page and uploaded the scripts that were included. I get such errors as:
"Line 11: Incorrect syntax near '('."
"Invalid object name 'sys.objects'."
"Invalid object name 'sys.foreign_keys'."

In addition, every once and a while it says turn custom error to remote only - so I do and it still says the same thing.

I am not sure where to go from here...Please advise!

Thanks again,

dpr00