|
Ribkick
Junior Member
USA
296 Posts |
 Posted - 07 May 2001 : 14:45:58
|
When installing the poll Mod, I ran into a few hitches. I'm using the Access '97 str. Below are copies of the errors encountered.
1.) When I initially installed Poll Mod:
Slemmies Poll
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN ANSWER1 text(100) NULL
Column added successfully
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
Column added successfully
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
Column added successfully
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
Column added successfully
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
Column added successfully
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
Column added successfully
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
Column added successfully
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
Column added successfully
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 1
-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 1
-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
2.) In adition, it tells me I have to upgrade database code 21472179904.
mod_dbsetup.asp only gives me choices to 3 final release, no choice for 3.1 sr4.
3.) In new poll topic window:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 8.
/topic.asp, line 514
4.) When trying to set active poll:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/admin_poll.asp, line 22
Thanks for any help!!
|
|
Topic Locked
