Missing some stored procedures...

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,

Photon

Re: Missing some stored procedures...

Photon,

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]
(
   @PollID int
)
AS
SET NOCOUNT ON

SELECT PollID, AddedDate, AddedBy, QuestionText, IsCurrent, IsArchived, ArchivedDate,
   (SELECT SUM(Votes) FROM tbh_PollOptions WHERE PollID = @PollID) AS Votes
   FROM tbh_Polls
   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 file.

Re: Missing some stored procedures...

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?

Thanks,

Photon

Re: Missing some stored procedures...

Photon,

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:

http://p2p.wrox.com/forum.asp?FORUM_ID=261

[edit] - this is the link to the script: http://p2p.wrox.com/topic.asp?TOPIC_ID=60895

jimi

Re: Missing some stored procedures...

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?

Thanks,

Photon