Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Oct 04, 2008 10:21 PM by Photon
Sep 22, 2008 02:55 PM|LINK
I uploaded the Beerhouse onto Godaddy.com and it appears that I am missing some stored procedures in the datebase. You can see the error I am getting by clicking on my website link
http://www.bertelsenwinery.com I executed the script
file:///C:\Documents App_Data\CreateAllObjects.sql in my Godaddy.com database.
Any help would be appreciated!
Thanks in advance,
Sep 22, 2008 04:03 PM|LINK
I think there may be more to your issue than the missing sp, however, here's the actual sp that you need:
CREATE PROCEDURE [dbo].[tbh_Polls_GetPollByID]
SET NOCOUNT ON
SELECT PollID, AddedDate, AddedBy, QuestionText, IsCurrent, IsArchived, ArchivedDate,
(SELECT SUM(Votes) FROM tbh_PollOptions WHERE PollID = @PollID) AS Votes
WHERE PollID = @PollID
Give it a try and see if that works for you. You may be better to upload the actual database from the download as i seem to recall that the database has some objects (perhaps the above sp being one of them) that aren't included in the CreateAllObjects.sql
Sep 22, 2008 04:28 PM|LINK
You were right on the mark Jimibt! CreateAllObjects.sql is must be missing more than one script because I uploaded your script you shared with me and now I am missing another one. How does one "upload the actual database from the download" that you suggested?
Can the database on vs2005 be converted to a script? or is there another way?
Sep 23, 2008 06:32 PM|LINK
Depending on your hosting company, you'll be able to use the control panel to upload your entire database in a single action. I'm with webhost4life for some of my stuff and this works flawlessly. the other option is to use a tool (which i believe eric engler
wrote) which does indeed upload the entire database as a file. i've never used this, so can't verify it's stability/suitability etc.
anyway, you can find that by hunting around the wrox beerhouse forum:
 - this is the link to the script: http://p2p.wrox.com/topic.asp?TOPIC_ID=60895
Oct 04, 2008 10:21 PM|LINK
I did what the link you were nice enough to share suggested. And now I am getting the following error
http://www.bertelsenwinery.com (click on the link to see the error message). My hosting company is Godaddy.com. Anyone have any ideas why I am getting this error message? Has anyone had any luck getting the
Beerhouse up and running on Godaddy.com?