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 V3 Help!
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Badger
Starting Member

USA
7 Posts

Posted - 11 May 2001 :  01:20:32  Show Profile  Visit Badger's Homepage  Send Badger an AOL message
Hello,

I have latest version of Snitz Forums installed. I also installed the MOD for active_users. Everything is working great then I go to install Guestbook Version 3.

I followed the instructions and uploaded the files into my forum directory. I ran the file mod_dbsetup.asp and selected Guestbook Addon and this is what I got....HELP!!!

GuestBook Addon

Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID int COUNTER NOT NULL , G_NAME VARCHAR (50) NOT NULL , G_EMAIL VARCHAR (100) NOT NULL , G_WEBSITE VARCHAR (100) NULL , G_ICQ VARCHAR (30) NULL , G_MESSAGE memo NOT NULL , G_DATE VARCHAR (50) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

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

Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int COUNTER NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL , G_V1_SWITCH INT NOT NULL , G_V2_SWITCH INT NOT NULL , G_V3_SWITCH INT NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.

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

Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_VARFIELD1, G_VARFIELD2, G_VARFIELD3) VALUES (0, 0, 0, 'ab', 'ab', 'ab')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_GB_OPTIONS'.

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

Adding Column...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_MESSAGE memo NOT NULL DEFAULT 'Welcome to my Guestbook'
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated



big9erfan
Average Member

540 Posts

Posted - 11 May 2001 :  01:40:53  Show Profile
Are you using the access 2000 connection string?

If not change to use that ( the Jet Drivers ) and try again.


http://www.ugfl.net/forums
Go to Top of Page

Badger
Starting Member

USA
7 Posts

Posted - 11 May 2001 :  01:58:54  Show Profile  Visit Badger's Homepage  Send Badger an AOL message
This is the settings I have (path to DB been crossed out with ****)


dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit

'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines!
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=*:\************" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/*********") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*:\*************;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

Go to Top of Page

Aznknight
Senior Member

USA
1373 Posts

Posted - 11 May 2001 :  02:11:49  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
switch to the one of the connstrings with this:
Microsoft.Jet.OLEDB.4.0;Data Source="

- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Go to Top of Page

Badger
Starting Member

USA
7 Posts

Posted - 11 May 2001 :  02:20:16  Show Profile  Visit Badger's Homepage  Send Badger an AOL message
Ok, I switched to this one:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=*:\*************;" '## MS Access 2000


And this is what I got back:

GuestBook Addon

Creating table(s)...
CREATE TABLE FORUM_GUESTBOOK( G_ID int IDENTITY (1, 1) NOT NULL , G_NAME VARCHAR (50) NOT NULL , G_EMAIL VARCHAR (100) NOT NULL , G_WEBSITE VARCHAR (100) NULL , G_ICQ VARCHAR (30) NULL , G_MESSAGE memo NOT NULL , G_DATE VARCHAR (50) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL )
-2147217900 | Table 'FORUM_GUESTBOOK' already exists.

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

Creating table(s)...
CREATE TABLE FORUM_GB_OPTIONS( G_ID int IDENTITY (1, 1) NOT NULL , G_VARFIELD1 VARCHAR (100) NULL , G_VARFIELD2 VARCHAR (100) NULL , G_VARFIELD3 VARCHAR (100) NULL , G_V1_SWITCH INT NOT NULL , G_V2_SWITCH INT NOT NULL , G_V3_SWITCH INT NOT NULL )
-2147217900 | Table 'FORUM_GB_OPTIONS' already exists.

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

Adding new records..
INSERT INTO FORUM_GB_OPTIONS (G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_VARFIELD1, G_VARFIELD2, G_VARFIELD3) VALUES (0, 0, 0, 'ab', 'ab', 'ab')

Value(s) updated succesfully
--------------------------------------------------------------------------------

Adding Column...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_MESSAGE memo NOT NULL DEFAULT 'Welcome to my Guestbook'
-2147217887 | Field 'G_MESSAGE' already exists in table 'FORUM_GB_OPTIONS'.
Table(s) updated

--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
Snitz Forums



Go to Top of Page

Badger
Starting Member

USA
7 Posts

Posted - 11 May 2001 :  02:27:47  Show Profile  Visit Badger's Homepage  Send Badger an AOL message
I see that some errors say it already exists. I refreshed the forum page and I do not see any Guestbook link in the forum?
http://disabledcops.com/forum/

Go to Top of Page

Aznknight
Senior Member

USA
1373 Posts

Posted - 11 May 2001 :  02:32:58  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
err umm.. you have to manually add in the guestbook link like it says in the readme file in the zip. the mod_dbsetup is just for setting up the database tables and it seemed like the tables where added fine

- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Go to Top of Page

Badger
Starting Member

USA
7 Posts

Posted - 11 May 2001 :  02:49:25  Show Profile  Visit Badger's Homepage  Send Badger an AOL message
Thanks for getting the DB setup. Do you have any idea where and what to manually add in the guestbook link please? I just checked and do not see the readme file.

These were the only files in the unzip file:

admin_guestbook.asp
guestbook.asp
guestbook.dbs
guestbook_update.dbs
mod_dbsetup.asp

No other files...rats...




Edited by - badger on 11 May 2001 03:14:36
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.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07