Where is webcontent.sql ?

Topics: Help
Jun 22, 2007 at 1:55 AM
Hello.

Thanks to whoever is responsible for making the CSK 2.0 available in VB and making it so easy for beginners like me to learn ASP and all of the web technologies.

I'm trying to get the CSK 2.0 (from here) up and running on a GoDaddy web site. I modified the CSK, but only mostly verbage and additional menu options. Did not change the database or the structure of the site. I followed the instructions in the thread titled "GoDaddy Installation Walkthrough" from the ASP.NET web site.

I'm at a point where when i open IE and go to my website, it gives the error "The database does not appear to contain WebContent table, this is a feature of the extended ClubSite, please ensure you have run WebContent.SQL against the database".

Does anybody know where "webcontent.sql" is? I searched all over this site and ASP.NET site and cannot find it or any mention of it.

Any help would be gratefully appreciated.

Thanks,
Tony
Coordinator
Jun 22, 2007 at 3:28 AM
The error you are recieving is just telling you that the site can't find your database. Look at your connection string and make sure it is acurate.
Jun 22, 2007 at 10:34 PM

z2bass wrote:
The error you are recieving is just telling you that the site can't find your database. Look at your connection string and make sure it is acurate.


Hello z2bass.

I tried several versions of connection strings found on this web site. Some of them don't match what GoDaddy's knowledge base shows. They all give me the same error.

Does anybody have the CSK 2.0 form here working on GoDaddy.com?

Thanks,
Tony
Coordinator
Jun 22, 2007 at 11:00 PM
It should. Maybe you didn't upload the scripts properly.At any rate, try making a new database, uploading the scripts, plug in the connection string. Oh, and put the connection stirng in here, marking out your username and password. Sometimes it is all about formating (like, for example, it can't end with a ; )
Jun 22, 2007 at 11:12 PM

z2bass wrote:
It should. Maybe you didn't upload the scripts properly.At any rate, try making a new database, uploading the scripts, plug in the connection string. Oh, and put the connection stirng in here, marking out your username and password. Sometimes it is all about formating (like, for example, it can't end with a ; )


You say "upload the scripts properly". I only remember doing one script and i don't remember which one. That might be the problem. Following the instructions from "GoDaddy Installation Walkthrough" from the ASP.NET web site, it says to use "club-add.sql", so i only did one script.

If i do both scripts from Scripts.zip, from this site, do i do both the same way? and does the order matter?

After hearing from you about the above questions, i will probably try making a new database as you suggest.

Thanks,
Tony
Coordinator
Jun 23, 2007 at 1:00 AM
club-add was for v1. Which are you using (we can't discuss v1 here... only v2) that might be your problem.

First run "Schema" and then "Data".
Jun 23, 2007 at 1:10 AM

z2bass wrote:
club-add was for v1. Which are you using (we can't discuss v1 here... only v2) that might be your problem.

First run "Schema" and then "Data".


I deleted my whole website, deleted the database and started this whole thing all over.

I tried using Schema.sql first and got error "Error -2147217900 User does not have permission to perform this action."

I didn't get this error before.

I don't get it.

Do you know of anybody that has the CS 2.0 Starter Kit running on GoDaddy? I would gladly pay for the help to get it up and running.

Thanks,
Tony


Coordinator
Jun 23, 2007 at 4:10 AM
GoDaddy seems to be the one hoster that doesn't like those scripts :(. Do you have Express, Standard, or Pro of Visual Studio?
Jun 23, 2007 at 4:33 AM

z2bass wrote:
GoDaddy seems to be the one hoster that doesn't like those scripts :(. Do you have Express, Standard, or Pro of Visual Studio?


I have VS2005 Pro.
Coordinator
Jun 23, 2007 at 5:05 PM
OK... download the SQL Publish Wizard and generate your scripts from VS.
Jun 23, 2007 at 7:00 PM

z2bass wrote:
OK... download the SQL Publish Wizard and generate your scripts from VS.


Thanks for giving me that tool.

I generated the script and ran it in the GoDaddy Query Analyzer. It ran for a while then gave this error "Error -2147217900 Incorrect syntax near 'addAttendance'."

I tried it three times from three different computers.

Just to let you know, the web site run fine locally on WIN XP Pro, SP2.

Thanks,
Tony
Coordinator
Jun 23, 2007 at 11:20 PM
Wow... GoDaddy doesn't like that Stored Procedure! Other people have gotten that same error. I'm not sure what to tell you... other than ask GoDaddy.
Jun 24, 2007 at 3:43 AM

z2bass wrote:
Wow... GoDaddy doesn't like that Stored Procedure! Other people have gotten that same error. I'm not sure what to tell you... other than ask GoDaddy.


Maybe i'll search the internet for an answer, but i'm definitely not calling them.

Thanks for all of your help.

Tony
Jun 24, 2007 at 2:48 PM
I had many issues when postin version 1 to go daddy but was able to get it working after some trial and error. This particular error, if I remember correctly, was caused by a missing comma at the end of a line, or something similar. Can you post the script here you are trying to run in the query analyzer on Go Daddy?
Jun 24, 2007 at 6:25 PM

rhhanson wrote:
I had many issues when postin version 1 to go daddy but was able to get it working after some trial and error. This particular error, if I remember correctly, was caused by a missing comma at the end of a line, or something similar. Can you post the script here you are trying to run in the query analyzer on Go Daddy?


Wow. I don't think so. It's a six meg file. Will this discussion group allow that?

Thanks,
Tony
Jul 19, 2007 at 1:37 AM
Tony I hope this is not too late, but we have found the problems with the GoDaddy Query Analyzer, and the club site database setup script.
There are a number of places in Schema.sql where the comment format is not recognizable in GoDaddy.
For example lines 482 - 485:
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

After you delete the line, the script should be fine.
We did have problems with the lines 41, 42 44, and 45. It could be a problem with GoDaddy or it could be the poor state of our database. We'll find out in a little while. We just deleted those lines for now.
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'zowens')
CREATE USER zowens FOR LOGIN zowens WITH DEFAULT_SCHEMA=zowens
/****** Object: Schema zowens Script Date: 05/11/2007 21:07:00 ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'zowens')
EXEC sys.sp_executesql N'CREATE SCHEMA zowens AUTHORIZATION zowens'

Cpt_caveman http://www.pangzee.com


Coordinator
Jul 19, 2007 at 1:59 AM
Really? SWEET!

I will need to look at the upcoming v3 beta 1 script and see if that still applies.
Jul 19, 2007 at 2:34 AM
Hello Pangzee.

I have since gone to discountAsp.net. I had no problems at all loading everything up to their site.

I won't even think about using goDaddy again.

Thanks for your reply.

Tony
Jul 19, 2007 at 6:56 AM
I think staying away from goDaddy is a good idea.

z2bass, I apreciate the work you have put into this club site. It is great.
We have the club site up and running on goDaddy. I've documented the whole procedure and will be happy to provide you with the material if you want to include it in v3.
cpt_caveman
http://www.pangzee.com
Coordinator
Jul 19, 2007 at 4:53 PM
Hopefully we can just fix the problem before release and what hoster someone is using won't be an issue.
Jul 19, 2007 at 6:39 PM
Pangzee, that looks great!

Zack, I didn't have nearly the issues I thought I would. I wonder what godaddy;s deal is. I'm glad I didn't use them.