| Author |
 Topic  |
|
|
hakkt
Starting Member
5 Posts |
 Posted - 02 August 2003 : 20:15:21
|
I extracted an ran the dbs_poll_mod.asp file and the report said everything fine.
I made all the changes to the asp and upped the new files, ran setup and all reported fine too.
I then clicked on 'Poll Configuration' and got this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_POLLS'. Make sure it exists and that its name is spelled correctly.
/board/admin_poll.asp, line 152
What is odd, is that there is no FORUM_POLLS table - the dbs_poll_mod.asp file didn't actually trigger one to be created :-s
Am at a real loss - have probably done something really stupid - just need the obvious to be pointed out to me, I guess. All the other db entries in dbs_poll_mod.asp have been created no probs.
Many thanks in advance everyone :) |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 August 2003 : 08:38:49
|
Your dbs_poll_mod.asp file should contain the following code:quote:
Poll Mod v2.0
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRPOLLS','1')
(C_VARIABLE,C_VALUE)#('STRFEATUREDPOLL','0')
(C_VARIABLE,C_VALUE)#('STRFEATUREDPOLLID','0')
(C_VARIABLE,C_VALUE)#('STRFPOLLWINDOW','0')
(C_VARIABLE,C_VALUE)#('STRFPOLLTABLE','0')
(C_VARIABLE,C_VALUE)#('STRHIDEPOLL','0')
(C_VARIABLE,C_VALUE)#('STRMAXVOTES','8')
[END]
[ALTER]
TOPICS
ADD#T_ISPOLL#int#NULL#0
ADD#T_POLLSTATUS#int#NULL#1
[END]
[ALTER]
A_TOPICS
ADD#T_ISPOLL#int#NULL#0
ADD#T_POLLSTATUS#int#NULL#1
[END]
[ALTER]
FORUM
ADD#F_POLLS#int#NULL#0
[END]
[CREATE]
POLLS
POLL_ID
CAT_ID#int##
FORUM_ID#int##
TOPIC_ID#int##
P_WHOVOTES#varchar(12)##'everyone'
P_LASTVOTE#varchar(50)#NULL#
ANSWER1#varchar(100)#NULL#
COUNT1#int#NULL#0
ANSWER2#varchar(100)#NULL#
COUNT2#int#NULL#0
ANSWER3#varchar(100)#NULL#
COUNT3#int#NULL#0
ANSWER4#varchar(100)#NULL#
COUNT4#int#NULL#0
ANSWER5#varchar(100)#NULL#
COUNT5#int#NULL#0
ANSWER6#varchar(100)#NULL#
COUNT6#int#NULL#0
ANSWER7#varchar(100)#NULL#
COUNT7#int#NULL#0
ANSWER8#varchar(100)#NULL#
COUNT8#int#NULL#0
ANSWER9#varchar(100)#NULL#
COUNT9#int#NULL#0
ANSWER10#varchar(100)#NULL#
COUNT10#int#NULL#0
ANSWER11#varchar(100)#NULL#
COUNT11#int#NULL#0
ANSWER12#varchar(100)#NULL#
COUNT12#int#NULL#0
ANSWER13#varchar(100)#NULL#
COUNT13#int#NULL#0
ANSWER14#varchar(100)#NULL#
COUNT14#int#NULL#0
ANSWER15#varchar(100)#NULL#
COUNT15#int#NULL#0
[END]
[CREATE]
POLL_VOTES
POLL_ID
CAT_ID#int##
FORUM_ID#int##
TOPIC_ID#int##
MEMBER_ID#int##
GUEST_VOTE#int##0
[END]
The code to create the POLLS table is there.
What database connection are you using in your config.asp file?
If it's Access 97, then try using the Access 2000 connection string. |
Support Snitz Forums
|
Edited by - Davio on 04 August 2003 08:39:32 |
 |
|
|
hakkt
Starting Member
5 Posts |
Posted - 04 August 2003 : 10:44:20
|
Yes, that's exactly the content of the file - but no-where there does it actually say FORUM_POLLS which is what it goes looking for when i try to configure a new poll.
I am using an Access 2000 db |
|
|
|
hakkt
Starting Member
5 Posts |
Posted - 04 August 2003 : 10:59:52
|
Have fixed it now. No idea why it wouldn't write at the hosted site, don't have any other db problems there.
In the end, I copied db back to local machine, ran script here and then upped it back to server host.
Primitive but it works :)
Thanks for taking the time to try and help me though :)
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 August 2003 : 12:40:51
|
You don't understand, all the table names start with FORUM_. In the install script, the word FORUM_ is automatically added to the name when the script runs.
But glad you got it working. |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
