Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 08, 2009 02:13 PM by learner01
Dec 20, 2007 07:46 PM|LINK
I need help with the classifieds starter kit. I have godaddy hosting and I can't get it up to the server. I believe it is because my connection strings were not properly modified, and my SQL databases that I created are not being recognized. If someone
would be willing to walk me through it I will pay $50.
Dec 20, 2007 09:16 PM|LINK
Have you tried posting here:
Dec 21, 2007 02:12 AM|LINK
I work through Saturday, so I'm only available in the evening, but I will walk you through it if you want.
Or if you just want it done, I'll upload it for you for the $50.
I too have godaddy hosting, and it was a little tricky to get it right.
Let me know what you would like to do.
Dec 21, 2007 10:12 PM|LINK
If you could walk me through it that would be great! I would really like learn how to make it work. I am available anytime this weekend to work on it, or next week in the evening. Please let me know what time would be best.
Dec 22, 2007 12:29 AM|LINK
First off I need a little information from you.
What type of database are you using? (MSSQL???)
And did you signup for the account with two MSSQL databases??
Did you make any changes to the database other than maybe creating usernames???
In the meantime, your first step is to upload the starter kit,
everything except the .mdf databases in the App_Data folder, and the welcome.htm file.
Then go to the control panel on godaddy, and I think it's in settings, change the asp.net run time to 2.0
Let me know on the answers to my questions above, and I will continue.
Talk to you later
Dec 22, 2007 07:37 AM|LINK
You can post your requirement here www.getafreelancer.com . There are plenty of Professional Freelancers available who can solve your problem.
Dec 22, 2007 08:43 PM|LINK
I have the GoDaddy plan that allows two MSSQL databases. I didn't make any changes to the databases.
The runtime has been set to 2.0
All files have been uploaded except for the two .mdf files and the welcome.htm
Dec 23, 2007 03:32 AM|LINK
Great, that's exactly like mine.
Next you need to create two mssql databases.
I will call one of the members and the other classifieds. (it speaks for itself which one's which)
When you create the databases take note of the username and password you set, Write it down.
The members database is perfect as is, once it's created, but the classifeds one is not.
You need to go into the classifieds database and delete all the tables, views, and stored procedures.
Some of the tables are referencing others so you have to delete them in a certain order.
If you hit the delete button and it tells you it's binded to another, just select a different one 'til they're all gone.
Now you're ready to start loading your classifieds database,
If you look on your computer in your classifieds starter kit folder App_Data
one of the files is classifieds-add.sql
this file holds the original classifieds database configuration.
Open the file with a notepad copy and paste into the query analizer on godaddy for the classifieds database.
Now do the same with the classifieds-categories.sql file, that creates the categories.
Just a mental note, but I had an issue uploading that first .sql file
It was saying error near "," or something like that.
The problem was in the storedprocedure RelistAd
Part of it is commented out, and godaddy doesn't like it, (-- @DateCreated smalldatetime = NULL,)
So you have two options,
1. delete the line before you send it in the query analizer.
I did that so that if the ad expires and is then relisted, it changes the date created to today, and the listing is at the top of the search again.
Now we are ready to go into the web.config to set the connection strings.
Let me know when you are ready.
We'll get you up on Sunday.
Talk to you tomorrow.
Dec 23, 2007 04:11 AM|LINK
When creating the databases should I choose DNS and ASP schema?
Dec 23, 2007 04:38 AM|LINK
Sorry, I forgot about that.
I think you do select them both.