| Author |
 Topic  |
|
2Monto
Starting Member
6 Posts |
 Posted - 17 August 2005 : 13:19:11
|
Using Snitz™ 2000 Foums Version Number 3.4.04
Exact errors 'There will be a "New Poll" link on the forum.asp and topic.asp beside the "New Topic" link.' Nope.
List Of MODS Installed (if any) Poll-Mod 34-07
How Long The Error Has Been There For Indefinitely
A Live Link To Your Forum http://www.ourchorley.co.uk/homeownersunitedforum/default.asp
A Member Name And Password We Can Use Testa/testanewpass
DB Type In Use .mdb 2000
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=***********.mdb" '## MS Access 2000
|
|
|
Chip
Starting Member
Denmark
5 Posts |
Posted - 17 August 2005 : 14:55:56
|
He .. i have the same problem.
Just installed poll_mod-34-207 and theres no way to start a poll.
The poll admin page seems to work fine, but no polls
Read_me says: "To start using your poll mod, go into your Admin Options, select On for the Polls Option." - Check
"Then go to your default.asp page, edit your forum properties and select the type of Poll
Permission you would like for that forum." - Ehhh edit what ? in default.asp ? (this might be a stupid question, and you can all get a good laugh :-) ) but where are my "forum properties" on my default.asp page ?
"Then you will be able to create polls for each forum you edited and turned on the polls." - Wohoo .. ehh ups .. cant find that damm "forum properties" on my default.asp page ?
|
Edited by - Chip on 17 August 2005 15:07:17 |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 August 2005 : 19:01:20
|
2Monto, did you turn on the Poll in your Admin Options? Did you then turn on the poll for each forum?
Chip, on default.asp, for each forum listed, there is a pencil icon to the far right side of it. Click it. TaDa! |
Support Snitz Forums
|
|
|
|
Chip
Starting Member
Denmark
5 Posts |
Posted - 18 August 2005 : 03:25:20
|
quote:
Originally posted by Davio
2Monto, did you turn on the Poll in your Admin Options? Did you then turn on the poll for each forum?
Chip, on default.asp, for each forum listed, there is a pencil icon to the far right side of it. Click it. TaDa!
To Quote Homer: "DOH!"
Thx :-) /Me blind |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 August 2005 : 04:36:22
|
2Monto, also double check the changes you've made to forum.asp and topic.asp against the readme to make sure you didn't miss anything.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
2Monto
Starting Member
6 Posts |
Posted - 18 August 2005 : 12:22:07
|
quote:
Originally posted by Davio
2Monto, did you turn on the Poll in your Admin Options? Did you then turn on the poll for each forum?
Chip, on default.asp, for each forum listed, there is a pencil icon to the far right side of it. Click it. TaDa!
quote:
Thanks very much, Davio: I have it running: much obliged to you, 2Monto, (Langaroo! )
|
|
|
|
2Monto
Starting Member
6 Posts |
Posted - 18 August 2005 : 12:26:00
|
quote:
Originally posted by Shaggy
2Monto, also double check the changes you've made to forum.asp and topic.asp against the readme to make sure you didn't miss anything.
quote:
Many, many thanks; I will do asap. Meantime, it's working, seemingly, news of which my barman, Rashers, urgently awaits. Langaroo!
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 18 August 2005 : 12:27:19
|
If it's working, there's no need to make those checks.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
2Monto
Starting Member
6 Posts |
Posted - 18 August 2005 : 12:58:08
|
quote:
Originally posted by Shaggy
If it's working, there's no need to make those checks.
quote:
Game Ball 
|
|
|
|
robrjohnson
Starting Member
10 Posts |
Posted - 02 September 2005 : 07:15:00
|
I got the polls working on my site (had the same problem as above). One other problem was I couldn't get the Database structure built for an Access Database using MOD Setup. I had to use Access and manually create the new tables (FORUM_POLLS & FORUM_POLL_VOTES). The script indicated that they already existed but looking in the database showed they did not (the INSERTS and ALTER TABLE ADD COLUMN SQL statements worked fine).. I think the SQL statements for Access are slightly different (no Identity keyword). Perhaps your code is checking for a successful update and assuming an unsuccessful update means it was already created (in this case it was the MSAccess' SQL style).
I ran the Mod Update just to see what errors I might get that might clue me in on any other missing data. I noticed that there were some columns in other tables that weren't loaded with the dbs_poll_mod.asp For example, FORUM_TOPICS & FORUM_A_TOPICS required columns labeled Answer1-Answer15, Count1-Count15 and T_LAST_VOTE. Once I loaded them all in the database, the update ran completely (even though there was no data in it). Are these columns necessary for Polls in those tables or can I delete them? |
Edited by - robrjohnson on 02 September 2005 07:20:22 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 September 2005 : 13:32:02
|
| More than likely it is the type of connection string you are using. Are you using the Access 2000 connection string? If not, please do. |
Support Snitz Forums
|
|
|
|
robrjohnson
Starting Member
10 Posts |
Posted - 02 September 2005 : 14:59:50
|
I'm using DSN and Access 2003. I saw in another forum that the Poll Mod link doesn't work with DSN. My service sets up a DSN by default so I don't know if I can use anything else. I don't know the root structure so I tried a virtual path. I tried using this connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/db/mydatabasename.mdb") & ";User Id=myuser;Password=mypassword;"
When I us it though I get this error the first time through:
Microsoft JET Database Engine error '80040e4d'
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
/forum/inc_header.asp, line 111
Then, subsequent refreshes give a 500 error.
|
Edited by - robrjohnson on 02 September 2005 15:01:31 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 02 September 2005 : 15:34:40
|
I don't think you need to pass the ID/password with access...
If you use the "whereami.asp" that should be in the tools.zip file, you can find the path to the db. |
|
|
|
robrjohnson
Starting Member
10 Posts |
Posted - 02 September 2005 : 16:24:16
|
| That worked. Thanks. For reference, you don't need a ID/Password but I couldn't get it to work if the database itself had a password. I had to remove that first before it would work. |
|
|
|
robrjohnson
Starting Member
10 Posts |
Posted - 02 September 2005 : 16:25:47
|
| So do I need the Account1-Account15 and Count1-Count15 in FORUM_TOPICS & FORUM_A_TOPICS or can I safely delete those columns? |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 02 September 2005 : 16:33:45
|
| Glad to see you got the db connection working. As to those fields, having not installed the MOD in question yet, I couldn't say. |
|
|
|
Topic |
|
Topic Locked
