| Author |
 Topic  |
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 19 August 2001 : 01:22:34
|
For those of you that haven't noticed (and those of you that have) the 3.1 SR4 version of the poll mod doesn't work with the 3.3 version of the Snitz Forums.
I put a lot of care into making my mods. I try to make them as user freindly as possible and try to make users able to install it easily.
When I release a 3.3 verison for the mod, I will post a link to it on the first post in this topic. No need to search all 100's of replies. I keep the first topic updated. If you want to know when I release the mod for the 3.3, you can subscribe to this topic. That's the easiest way.
Benny, for your problem, I agree with @tomic on that one. It means that it cannot connetc to the database you specified. Did you overwrite your config.asp file?
Komarowsky, that problem has nothing to do with the poll mod. I believe you need to change the M_BROWSE field to a "memo" field. This has been a known problem with that mod.quote:
1) Every time someone voted, the topic last post date was modified and it became an active topic, when it really wasn't. I would click on the topic hoping to see an actual reply and then I'd come to the realization it was just another vote. I wonder how many of my users have done the same thing. I know this has been discussed and the fix has been stated in here a couple of times.
Workmule, that has been fixed in the mod already. It was bugging me too. 
- David |
 |
|
|
geminione
Starting Member
39 Posts |
Posted - 19 August 2001 : 02:05:14
|
Grrrr....
I installed the mod with no problem... pretty simple line editing and adding... or so I thought.
I can add polls with no problem... but when I click on the link to view a poll that was added... I get a '500 internal server error'
Actually... I get that error message when I click to VIEW ANY topic.
I restored to the origianl files... but I have the ones with the poll mod added if someone could take a look and/or tell we where I went wrong.
http://www.geminione.com/forum/forum.asp?FORUM_ID=16&CAT_ID=6&Forum_Title=What+you+say%3F
Any idea why? What more do you need to know from me?
many thanks in advance --matt
Edited by - geminione on 19 August 2001 02:12:19 |
|
|
|
-X-
Starting Member
3 Posts |
Posted - 19 August 2001 : 02:06:56
|
Ok... I can say that this mod works great with SQL 6.5 However, blows chunks with Access 97/2000. Anyways, I would like to know if you can also add the following:
1: Multi Poll Voting: Instead of selecting one item, being able to select more than one Item. We need a voting system to determine which maps for UT should stay and which should go.
2: Allow more than 8 lines of voting. Maybe make it user selectable and allow up to 20 lines of voting?
Thanks.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 August 2001 : 20:29:52
|
quote:
but when I click on the link to view a poll that was added... I get a '500 internal server error'
matt, go into your Internet Options, select the Advanced Tab, and uncheck the "Show friendly HTTP error messages" option. You will get a more detailed error message.
One thing you failed to mention is what version of the forums you are using.
3.1 SR4 or 3.3? This mod is for the 3.1 SR4 version of the Snitz Forums.quote:
I can say that this mod works great with SQL 6.5 However, blows chunks with Access 97/2000.
That should be the other way around. I created this mod around the Access database. And it works quite well. Also works well with MySql. I haven't tested it extensivly on the SQL database. But since I haven't gotten too many users with problems using SQL server, I guess it works ok on it.
quote:
1: Multi Poll Voting: Instead of selecting one item, being able to select more than one Item. We need a voting system to determine which maps for UT should stay and which should go.
Not going to implement that.quote:
2: Allow more than 8 lines of voting. Maybe make it user selectable and allow up to 20 lines of voting?
That will be implemented in the next update. If you want it before the next release, see here:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=11228
A user created it as an addon to the poll mod.
- David |
|
|
|
geminione
Starting Member
39 Posts |
Posted - 19 August 2001 : 23:25:40
|
quote:
matt, go into your Internet Options, select the Advanced Tab, and uncheck the "Show friendly HTTP error messages" option. You will get a more detailed error message.
Microsoft VBScript compilation error '800a0400'
Expected statement
/forum/topic.asp, line 580
<% if trim(rs("answer1")) = "" then
^
I pretty much pasted it straight from the file you offered.
I hope you can help.... thanks so far.
quote:
One thing you failed to mention is what version of the forums you are using.
3.1 SR4 or 3.3? This mod is for the 3.1 SR4 version of the Snitz Forums.
3.1 sr4
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 August 2001 : 00:33:40
|
It's because you have an extra ASP tag lying around somewhere.
If you can post a link to a txt version of your topic.asp file, I'll show you how to fix it.
- David |
|
|
|
bjlt
Senior Member
1144 Posts |
Posted - 20 August 2001 : 03:02:48
|
quote:
quote:
1: Multi Poll Voting: Instead of selecting one item, being able to select more than one Item. We need a voting system to determine which maps for UT should stay and which should go.
Not going to implement that
What would happen if I simply change radio button of the poll item to select box? will it do the multi poll? if it would work, a new field of allow_multi and an if then clause would be enough.
Will the new version use it's seperate table and store the votes in the db?
thanks.
|
|
|
|
geminione
Starting Member
39 Posts |
Posted - 20 August 2001 : 03:24:06
|
quote:
It's because you have an extra ASP tag lying around somewhere.
If you can post a link to a txt version of your topic.asp file, I'll show you how to fix it.
- David
Thanks soooo very much!!! 
http://www.geminione.com/files/topic.txt
|
|
|
|
geminione
Starting Member
39 Posts |
Posted - 20 August 2001 : 17:44:24
|
ok... around that line and including that line I've tinkered with adding and removing some of these guys <% %> with no luck.
That is a 'tag' right?
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 21 August 2001 : 00:40:21
|
Heres the problem ( lines 578 - 580 )
<% end if %>
<% ' ############ Poll Mod - 1 line ###########
<% if trim(rs("answer1")) = "" then
The red one has no closing tag.
Try replacing that with this
<% end if
' ############ Poll Mod - 1 line ###########
if trim(rs("answer1")) = "" then
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Nathan Bales
May the God of hope fill you with all joy and peace as you trust in Him, so that you may overflow with hope by the power of the Holy Spirit.
-Romans 15:13 |
|
|
|
geminione
Starting Member
39 Posts |
Posted - 21 August 2001 : 02:02:18
|
i made the changes that nathan suggested....
Microsoft VBScript compilation error '800a0400'
Expected statement
/forum/topic.asp, line 581
<% if (AdminAllowed = 1 or rs("MEMBER_ID") = Member_ID) or (strNoCookies = "1") then
^
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 August 2001 : 11:38:56
|
You have so many missing asp tags. Disregard the first email I sent you. I found some more missing tags after I emailed you. I will just send you back the fixed file. Nathan just found one out of a few missing tags.
If you get any more errors let me know.
Bljt, I'm not sure what might happen. You can try it and see what happens.
- David |
|
|
|
michaeltran
Starting Member
13 Posts |
Posted - 23 August 2001 : 19:35:00
|
Help, please HELP:
My Snitz version is 3.1 SR4.
I can easy create a new poll, but then when I click on the link to go see the poll, then on the topic.asp I got this error:
Microsoft VBScript runtime error '800a01a8'
Object required: 'my_Conn'
/vietboard/inc_functions.asp, line 1787
Line 1787 in inc_function.asp is this:
function getNewMemberNumber()
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & strDBNTUserName & "'"
set rsGetMemberID = my_Conn.Execute(strSql)
if rsGetMemberID.EOF or rsGetMemberID.BOF then
getNewMemberNumber = -1
exit function
end if
getNewMemberNumber = rsGetMemberID("MEMBER_ID")
end function
Also, when I click on Poll Admin in Admin area, I got the same error.
I check the inc_functions.asp, it is the original one. What is wrong here???Please help
Edited by - michaeltran on 23 August 2001 19:42:32
Edited by - michaeltran on 23 August 2001 19:43:11 |
|
|
|
michaeltran
Starting Member
13 Posts |
Posted - 23 August 2001 : 23:05:54
|
Wow....this poll feature is based on per vote per IP not by per vote per Member.
That means 100 members are using the same station, then only one member be able to vote once and the others can not vote because the same IP.
Is that right??
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 August 2001 : 11:53:07
|
hmmm, The getNewMemberNumber() function in the SR4 version should look like this:function getNewMemberNumber()
dim my_Conn2
set my_Conn2 = Server.CreateObject("ADODB.Connection")
my_Conn2.Open strConnString
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & strDBNTUserName & "'"
set rsGetMemberID = my_Conn2.Execute(strSql)
if rsGetMemberID.EOF or rsGetMemberID.BOF then
getNewMemberNumber = -1
exit function
end if
getNewMemberNumber = rsGetMemberID("MEMBER_ID")
my_Conn2.Close
Set my_Conn2 = nothing
end function Yours is missing the Connection.
The voting isn't based on ip, but it sets a cookie on the users computer that they voted from, telling the poll if they voted or not. I'm implementing the voting by members only option in the next release.
- David |
|
|
|
Topic |
|
Topic Locked
