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: Database: MS SQL Server
 Initial Setup w/SQL Server Problems		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

kwilliams
Starting Member

2 Posts
Posted - 10 May 2004 :  13:01:21  Show Profile
I just downloaded the Snitz Forum v 3.4, and I'm trying to add the tables into a DB that I've created just for the Snitz Forum that I've named "BulletinBoard". When I tried to fill the DB with the tables, I received an error message. So I took each query, and put them manually into SQL Server to create all of the tables. Then I tried to do the same thing with the "Alter Table" queries, but I received this error for all of them:
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax error near the keyword 'ADD'

This is one of the "Alter Table" queries that I tried and failed with:

ALTER TABLE FORUM_MEMBERS WITH NOCHECK ADD CONSTRAINT FORUM_SnitzC49
DEFAULT  1 FOR M_STATUS, CONSTRAINT FORUM_SnitzC50 DEFAULT 1 FOR M_DEFAULT_VIEW, CONSTRAINT FORUM_SnitzC51 DEFAULT 1 FOR M_LEVEL, 
                      CONSTRAINT FORUM_SnitzC52 DEFAULT '' FOR M_DATE, CONSTRAINT FORUM_SnitzC53 DEFAULT 0 FOR M_SUBSCRIPTION, 
                      CONSTRAINT FORUM_SnitzC54 DEFAULT 0 FOR M_HIDE_EMAIL, CONSTRAINT FORUM_SnitzC55 DEFAULT 1 FOR M_RECEIVE_EMAIL, 
                      CONSTRAINT FORUM_SnitzC56 DEFAULT '000.000.000.000' FOR M_LAST_IP, CONSTRAINT FORUM_SnitzC57 DEFAULT '000.000.000.000' FOR M_IP, 
                      CONSTRAINT FORUM_SnitzC58 PRIMARY KEY NONCLUSTERED (MEMBER_ID)


Is this error message common? Does anyone have any idea what I'm doing wrong? Any & all help is appreciated. Thanks.

KWilliams
Edited by - ruirib on 10 May 2004 16:27:40

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 10 May 2004 :  13:36:33  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Why do you want to create the tables manually?
Have you followed the instructions from the readme?
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

Doug G
Support Moderator

USA
6493 Posts
Posted - 10 May 2004 :  13:38:40  Show Profile
What was the original error message? The SQL Server setup works well, there is no reason that you should need to run individual queries manually to create your db.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

kwilliams
Starting Member

2 Posts
Posted - 10 May 2004 :  16:36:12  Show Profile
I originally tried to use the auto-run of all of the queries like it stated to do (see details below), but I kept getting errors saying that it couldn't access the DB to create the tables. I checked the user status for all of the users on this DB, and they all had Permissions set correctly. So to test it out, I took the first query, and manually put it into the Query Analyzer to see what would happen...and it worked. So I thought that instead of spending hours trying to figure out why it wasn't working for me, I'd just enter them manually. All of the "Create Table" queries worked fine, but the "Alter Table" queries gave me that error message.

So this is what I've done:

1) I created a DB named "BulletinBoard" for these tables
2) I went to the setup.asp page that's titled "Installation of forum-tables in the database" to run the job to create & alter the tables.
3) I entered the User Name & PW from the Connection string into the first set of fields
4) I entered what I want my User Name & PW to be for the forum, and clicked the "Continue" button.

After following the above steps, I get redirected to an error page that says "Error: -2147217900 CREATE TABLE permission denied in database 'BulletinBoard'". It then states all of the queries that failed.

If anyone knows what I need to do to get the job to run automatically with no errors, it would be greatly appreciated. Thanks.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 10 May 2004 :  18:22:30  Show Profile  Send ruirib a Yahoo! Message
The user you specified in the installation page, what roles does he have for that DB?

Snitz 3.4 Readme | Like the support? Support Snitz too
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07