| Author |
 Topic  |
|
|
Badger
Starting Member
USA
7 Posts |
 Posted - 11 May 2001 : 01:20:32
|
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
|
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 |
 |
|
|
Badger
Starting Member
USA
7 Posts |
Posted - 11 May 2001 : 01:58:54
|
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_"
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 May 2001 : 02:11:49
|
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 |
|
|
|
Badger
Starting Member
USA
7 Posts |
Posted - 11 May 2001 : 02:20:16
|
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
|
|
|
|
Badger
Starting Member
USA
7 Posts |
Posted - 11 May 2001 : 02:27:47
|
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/
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 May 2001 : 02:32:58
|
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 |
|
|
|
Badger
Starting Member
USA
7 Posts |
Posted - 11 May 2001 : 02:49:25
|
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 |
|
|
| |
Topic |
|
|
|
Topic Locked
