Advanced Guesbook

[sferris1166]

BlueHost online documentation mentions installing Advanced Guestbook ... can someone steer me in the right direction as to where the installion is located ?

Thanks in Advance. Steve

[Early Out]

The Advanced Guestbook seems to have disappeared. If you go to the Control Panel and hit CGI Center, the options include a Simple Guestbook, but the entry for the Advanced version is gone.

[lsuedulive]

Anyone know of an online tutorial for importing files into a SQL database? You would think Blue host would have some links in their KB.

This is what I am trying to import into a DB.

if exists (select * from sysobjects where id = object_id(N'[dbo].[insp_guestbook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[insp_guestbook]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[selsp_guestbook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[selsp_guestbook]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[tblGuestBook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblGuestBook]
GO

CREATE TABLE [dbo].[tblGuestBook] (
[fldGID] [int] IDENTITY (1, 1) NOT NULL ,
[fldName] [varchar] (50) NULL ,
[fldEmail] [varchar] (50) NULL ,
[fldMessage] [varchar] (255) NULL ,
[fldDate] [smalldatetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[tblGuestBook] WITH NOCHECK ADD
CONSTRAINT [PK_GuestBook] PRIMARY KEY NONCLUSTERED
(
[fldGID]
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

CREATE PROCEDURE [insp_guestbook] (@strDate smalldatetime, @strName varchar(50), @strEmail varchar(50), @strMess varchar(255)) AS
INSERT INTO tblGuestBook (fldDate,fldName,fldEmail,fldMessage) VALUES (@strDate,@strName,@strEmail,@strMess)
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

CREATE PROCEDURE [selsp_guestbook] AS
SELECT fldName,fldEmail,fldMessage,fldDate FROM tblGuestBook Order By fldDate desc, fldGID desc


GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

[felgall]

Log into cPanel and select phpMyAdmin You should be able to run all the commands from there.

[lsuedulive]

I tried that. I followed the clicks. It asked for a text file. I have no idea which file it is asking for. There is no help in Bluehot. Nor links to basic tutors.

I did not know Bluehost was only setup for experienced users.

[felgall]

Go to the SQL tab and type in the SQL there.

BlueHost is about as easy as it gets. Experienced users wouldn't need to use anything like cPanel.

[lsuedulive]

Thanks for the SQL update. I will cancel this hosting package tomorrow as it seems I am the only one who is having problems uploading or installing features such as this.

[felgall]

Well that does look like rather advanced SQL - far beyond what most people would use.

[alemcherry]

Thanks for the SQL update. I will cancel this hosting package tomorrow as it seems I am the only one who is having problems uploading or installing features such as this.

Seems like you have totally gone wrong. To me, the sql queries looks like generated from/for MSSQL server. Bluehost offer you Linux servers with MySQL. There is no MSSQL server on Linux. You will need Windows server with SQL Server, which will cost you more money as well.

It is not bluehots's fault - you should know what you are doing.

[lsuedulive]

I don't know what I am doing which is why I have to find a hoster with KB step by step or built in scripts that install a guestbook, forum, etc.

Thank you for updating about Bluehost. They are too advanced for my level of knowledge.

[felgall]

It isn't BlueHost that is too advanced for your level of knowledge - their setup is about as simple as you will find. The problem you have is the really advanced processing that you are trying to run. You are going to have the same issues or worse trying to do that complex setup where ever you pick for hosting. What you need to do is to select a script to install that has its own install process (if that script has install instructions then they should lead you through how to install it). The installation of a given script is dependent on how automated the script writer has made the install and how well their install instructions are written. It has nothing to do with which hosting you choose unless you were to choose hosting that didn't provide the control panel features that the instructions describe. cPanel and phpMyAdmin offered by BlueHost are probably one of the most commonly available control panel options you will find provided by web hosts.

[mburp]

Hi lsuedulive,

If you'd tell us what you're trying to install, one of us might be able to help you get back on track.

Michael