| Author |
 Topic  |
|
Slaid99
New Member
Canada
67 Posts |
 Posted - 07 June 2002 : 18:50:29
|
I am trying to install Poll Mod (for the 4th time). The second time I installed it, I got the redundant error (unique tablenames, as they already exist). I am running the 3.3.0.5 Snitz, and the uninstall errors out, so.. I cant get a success for uninstalling it.
Anyway... I reinstalled it, and have done all the asp file changes as best I could...double checked, everything looks okay (although, there was some file discrepencies.
The third time I installed I got an error. Stupidly.. I tried fixing it myself...and ended up not being able to edit my posts. So... I attempted uninstall (didnt work), and then reinstalled one last time.
Now.. my board runs fine, but I dont see the Poll feature at all.
Any help would be appreciated.
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 June 2002 : 20:25:47
|
So, you don't see the Poll Feature. That's a lot to go on.
Are you talking about the Featured Poll option?
Or are you talking about the 'Add Poll Link' not showing up on the forum.asp and topic.asp pages?
Or are you talking the Admin Polls option in your Admin options?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
 |
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 07 June 2002 : 22:01:14
|
Sorry Davio... I mean that I cant see anything. No Add Poll link and no to anything in Admin Options.
looking over what I did, and I cant find anything missing so far. When I install the dbs file... it seems to work (other than the redundant error for all the table creation)
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 June 2002 : 22:12:07
|
Didn't you add the code to your forum files?
If you did, you should at least see the link "Poll Configuration" in your admin_home.asp page.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 08 June 2002 : 03:23:14
|
I had them all added... went back in...checked each file, found a couple that were missing (hmmm...), added them.
After all that... it locks up my database, I reboot.
Then... it works... hooray? (hmmmmmm..)
So...anyway...the last part of implementation is figuring out what the heck I screwed up now...
Everything works, but best way to describe problem is to provide you with a link, so you can see it yourself.
(basically, commented code is appearing in web page)
http://www.gdscentral.com/wov/forums/topic.asp?TOPIC_ID=65&FORUM_ID=7&CAT_ID=3&Topic_Title=Test Poll&Forum_Title=Test Posts&pollresults=1
|
|
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 08 June 2002 : 15:34:56
|
I should also add, that I added the File Download Mod (which worked perfectly), Avatar Mod 2.0 (which also worked), Topic Icon Mod (which kinda worked, but was still trying to get working), Poll Mod (which is what caused the board to have this problem, although, it now works, kinda... )
I can provide you with the asp files, if you wish. Or.. If it is easier... I may just start from scratch (although... that kinda works, and kinda doesnt, as the mods are hard to uninstall)
I will continue working on it, and if you could help, I would really appreciate it. Thanks. (oh yeah... I check here about twice a day, so if you need info, I will try to provide it asap)
|
|
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 08 June 2002 : 15:43:02
|
- Okay, I can reply to messages now. (that is good)
- I cant see Message Icons yet (that is something for a different topic I will deal with later.
- I try to post a Poll and get the following error:
quote:
Microsoft OLE DB Provider for SQL Server error '80040e14'
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
/wov/forums/post_info.asp, line 774
- I still can see the asp text in the web portion (near the Post Reply, etc...).
(Will post back here as I fix, or notice new trouble... I am starting to annoy myself.)
In Regards to the Quoted Error Message, this is my Post_Info.asp Contents from Line 759:
quote:
xxxxxxxxx'################ Sticky Topic MOD ######################
if Request.Form("sticky") = 1 then
strSql = strSql & ", 1 "
strSql = strSql & ", 0 "
elseif Request.Form("sticky") = 2 then
strSql = strSql & ", 1 "
strSql = strSql & ", 999999 "
else
strSql = strSql & ", 0 "
strSql = strSql & ", 0 "
end if
'########################################################
'## strSql = strSql & ", 1 "
strSql = strSql & ")"
my_Conn.Execute (strSql)
if Err.description <> "" then
err_Msg = "There was an error = " & Err.description
else
err_Msg = "Updated OK"
end if
' DEM --> Do not update forum count if topic is moderated.... Added if and end if
if Moderation = "No" then
'## Forum_SQL - Increase count of topics and replies in Forum table by 1
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET F_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", F_TOPICS = F_TOPICS + 1"
strSql = strSql & ", F_COUNT = F_COUNT + 1"
strSql = strSql & ", F_LAST_POST_AUTHOR = " & rs("MEMBER_ID") & ""
strSql = strSql & " WHERE FORUM_ID = " & Forum_ID
my_Conn.Execute (strSql)
strSql = "SELECT Max(TOPIC_ID) as NewTopicID "
strSql = strSql & " FROM " & strActivePrefix & "TOPICS "
strSql = strSql & " WHERE FORUM_ID = " & Forum_ID
strSql = strSql & " and T_AUTHOR = " & rs("MEMBER_ID")
set rs9 = my_Conn.Execute (strSql)
NewTopicID = rs9("NewTopicId")
rs9.close
set rs9 = nothing
ProcessSubscriptions rs("Member_ID"), Cat_ID, Forum_ID, NewTopicID
end if
Go_Result err_Msg, 1
Response.End
end if
end if
Edited by - Slaid99 on 08 June 2002 15:47:05 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 June 2002 : 15:44:49
|
Geez, you got serious problems with your topic.asp file. Talk about copying the code in all the wrong places. 
Post a link to a txt version of your topic.asp file.
Are all the problems you are having with the topic.asp file only?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 June 2002 : 15:47:08
|
You really need to look where you are posting your code in your files. And make sure it is in the right place, just like in the files that came with the mod.
Post a link to a txt version of your post_info.asp file too.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 08 June 2002 : 15:51:42
|
Thanks!
(I had trouble with mod installation changing/adding lines, which I had to use best judgement on how it would affect the other mods...
I really gotta learn ASP programming or something)
I usually have 2 notepads running, and Alt-tab between them, so I get a visual overlay (Poll Mod installation works this way... or so I thought), but when you get the "Add this at this line", but a different mod has changed and added some lines... I have been doing trial and error on attempting to NOT screw it up...
sigh... I am failing... 
Edited by - Slaid99 on 08 June 2002 15:54:06
Edited by - Slaid99 on 09 June 2002 09:32:51 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 08 June 2002 : 16:09:03
|
Could you post txt files instead of zip files? So I can just view the code in the browser window.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Slaid99
New Member
Canada
67 Posts |
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 09 June 2002 : 07:45:52
|
Also, something you may have an answer to... the uninstall asp file gives the error (which I mentioned):
quote:
ALTER TABLE FORUM_TOPICS DROP answer1, count1, answer2, count2, answer3, count3, answer4, count4, answer5, count5, answer6, count6, answer7, count7, answer8, count8, T_ISPOLL, T_LAST_VOTE;
Microsoft OLE DB Provider for SQL Server error '80040e14'
'answer1' is not a constraint.
/wov/forums/uninstall_poll.asp, line 13
Just wondered if there was a fix to this, if I wanted to uninstall properly to reinstall.
|
|
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 09 June 2002 : 18:03:34
|
Just to save you time Davio... I have worked out "almost" all my problems.
The one I have now is with the Polls themselves. The mod seems to work great... but when I create a poll, it seems to take up only half the page... is that correct?
I think I have everything working now... umm... I HOPE!
Thanks for the help Davio.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 June 2002 : 20:06:04
|
Ok, please don't make any more modifications to the topic.asp file anymore. You seem to be killing it instead of fixing it.
Did you update the topic.txt since you modified it again?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Slaid99
New Member
Canada
67 Posts |
Posted - 09 June 2002 : 20:09:27
|
Just updated both...
I dont think people can vote on the polls now... hmmmm
Ignore that... apparantly they can 
Edited by - Slaid99 on 10 June 2002 00:18:26 |
|
|
|
Topic |
|
Topic Locked
