| Author |
 Topic  |
|
|
Rob64
Starting Member
23 Posts |
 Posted - 06 April 2001 : 21:17:49
|
Hello today i tryed to install the poll mod on my forum i have the final 4 version,
that is what i receive wen i upgrade:
Any suggestion very is appreciated
Slemmies Poll
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER1 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER1' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT1 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER2 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER2' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT2 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER3 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER3' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT3 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER4 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER4' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT4 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER5 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER5' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT5 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER6 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER6' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT6 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER7 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER7' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT7 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER8 text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'ANSWER8' already exists in table 'FORUM_TOPICS'.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN COUNT8 int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_CONFIG ADD COLUMN C_ADMINPOLLS int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD COLUMN C_USERPOLLS int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_CONFIG ADD COLUMN C_ACTIVEPOLL int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
Snitz Forums
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 06 April 2001 : 21:37:22
|
That happens when you tried to install it a second time, right? Because it is saying some of the fields exsist already.
Are you using the Access 97 connection string in your config.asp file? Try using the Access 2000 connection string.
Edited by - Davio on 06 April 2001 21:38:04 |
 |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 09 April 2001 : 09:44:09
|
I haven´t tried the poll MOD yet on my forum, but since I´m running Richard Kinsers version of SR4, wouldn´t it ruin something else in the code, if I overwrite them with the files from the poll MOD?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 April 2001 : 12:39:57
|
Only overwrite the files if you don't have any mods installed. Since you are using Richards version, you would need to copy and paste the code into the files.
|
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 09 April 2001 : 14:51:43
|
Could you send me the files with instuctions on where to change the code?
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 April 2001 : 19:15:46
|
No I can't do that. I'm sorry. I'm too busy to sit down and type out instructions for you.
The files you need to edit are in the zip file. For example, if you need to edit default.asp, open the one from the zip and the one from Richards forum and look at each code and see where you should add it in.
After that, if you run into any problems I'll try and help you. But that's the best I can do.
|
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 April 2001 : 02:42:04
|
ok, thanks.
|
|
|
| |
Topic |
|
Topic Locked
