Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Guestbook installation error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

guido331
Starting Member

USA
25 Posts

Posted - 11 October 2004 :  17:32:35  Show Profile
I'm getting the following errors when I try to install my guestbook. I'm running this on a windows 2003 server using SQL server 2000. Help!!


MOD: Guestbook v3.4

Dropping Table..

Table does not exist
--------------------------------------------------------------------------------

Dropping Table..

Table does not exist
--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , G_NAME nvarchar (50) NULL , G_EMAIL nvarchar (100) NULL , G_WEBSITE nvarchar (100) NULL , G_ICQ nvarchar (30) NULL , G_MESSAGE ntext NOT NULL , G_DATE nvarchar (50) NOT NULL , G_VARFIELD1 nvarchar (100) NULL , G_VARFIELD2 nvarchar (100) NULL , G_VARFIELD3 nvarchar (100) NULL )
Table already exists

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , G_VARFIELD1 nvarchar (100) NULL , G_VARFIELD2 nvarchar (100) NULL , G_VARFIELD3 nvarchar (100) NULL , G_V1_SWITCH int NULL , G_V2_SWITCH int NULL , G_V3_SWITCH int NULL , G_MESSAGE ntext NULL , G_V1_REQ int NOT NULL DEFAULT 0, G_V2_REQ int NOT NULL DEFAULT 0, G_V3_REQ int NOT NULL DEFAULT 0, G_PAGECOUNT int NOT NULL , G_T_MAIL int NOT NULL DEFAULT 0, G_W_MAIL int NOT NULL DEFAULT 0, G_T_AUTHOR nvarchar (150) NOT NULL , G_T_REPLYTO nvarchar (150) NOT NULL , G_T_MESSAGE ntext NOT NULL )
Table already exists

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_VARFIELD1, G_VARFIELD2, G_VARFIELD3, G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_MESSAGE, G_V1_REQ, G_V2_REQ, G_V3_REQ, G_PAGECOUNT, G_T_MAIL, G_W_MAIL, G_T_AUTHOR, G_T_REPLYTO, G_T_MESSAGE) VALUES ('State', 'Country', 'Age', 1, 1, 1, 'Thank you for signing my Guestbook', 0, 0, 0, 10, 0, 0, 'Admin', 'you@yourdomain.com', 'Thank you for signing my Guestbook')
INSERT INTO FORUM_GB_OPTIONS (G_VARFIELD1, G_VARFIELD2, G_VARFIELD3, G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_MESSAGE, G_V1_REQ, G_V2_REQ, G_V3_REQ, G_PAGECOUNT, G_T_MAIL, G_W_MAIL, G_T_AUTHOR, G_T_REPLYTO, G_T_MESSAGE) VALUES ('State', 'Country', 'Age', 1, 1, 1, 'Thank you for signing my Guestbook', 0, 0, 0, 10, 0, 0, 'Admin', 'you@yourdomain.com', 'Thank you for signing my Guestbook')
-2147217865 | Invalid object name 'FORUM_GB_OPTIONS'.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 12 October 2004 :  00:04:06  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Have you tried using the Alternate MOD Setup and entering the code from the dbs file into the box provided?

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

guido331
Starting Member

USA
25 Posts

Posted - 13 October 2004 :  16:01:58  Show Profile
I figured it out...

The user account I had set up in SQL did not have enough priveledges to create tables.
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 14 October 2004 :  20:44:32  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Glad you fixed it.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07