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.
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.
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?
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
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?
Photon
Member
26 Points
56 Posts
Missing some stored procedures...
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,
Photon
jimibt
Member
724 Points
185 Posts
Re: Missing some stored procedures...
Sep 22, 2008 04:03 PM|LINK
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.
jimi
Photon
Member
26 Points
56 Posts
Re: Missing some stored procedures...
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?
Thanks,
Photon
jimibt
Member
724 Points
185 Posts
Re: Missing some stored procedures...
Sep 23, 2008 06:32 PM|LINK
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
jimi
Photon
Member
26 Points
56 Posts
Re: Missing some stored procedures...
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?
Thanks,
Photon