| Author |
 Topic  |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
 Posted - 04 January 2008 : 15:42:12
|
Did you run setup.asp? Did you make sure poll mods is turned on? If it is, turn it off then on again.
Are all the polls messed up or just these 2? Try creating a new test poll and see if that works. |
Support Snitz Forums
|
 |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 January 2008 : 17:14:24
|
Hmm. Can give me a user name and password to login with?
Might require admin access if I don't see something amiss.
It seems to be only on topic.asp that is the problem. The Post New Poll button doesn't show up either on topic.asp. |
Support Snitz Forums
|
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 04 January 2008 : 17:59:02
|
email sent with admin access info through this snitz mail  Thanks! |
coaster crazy |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 January 2008 : 18:59:31
|
Ok, it seems to be the IsPoll variable is not being set on topic.asp.
After line 187 in topic.asp add the following in red:
IsPoll = rsTopic("T_ISPOLL")
if TopicID = 16568 then Response.Write "IsPoll:" & IsPollThat variable has to do with all the poll related features on topic.asp. And if that is not set to 1, then no poll shows up. |
Support Snitz Forums
|
Edited by - Davio on 04 January 2008 18:59:58 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 04 January 2008 : 19:35:13
|
done, that section now looks like this
'############## Poll Mod ##################
IsPoll = rsTopic("T_ISPOLL")
if TopicID = 16568 then Response.Write "IsPoll:" & IsPoll
Forum_Polls = rsTopic("F_POLLS")
Poll_Status = rsTopic("T_POLLSTATUS")
Still no poll showing up on that topic.  |
coaster crazy |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 January 2008 : 20:53:42
|
We are debugging wws. Haven't found the problem yet. 
IsPoll comes up empty. Hmm.
Check your database, particularly T_ISPOLL in FORUM_TOPICS. Search for TopicID 16568 and see what the T_ISPOLL value is. If it has a 1, then we know it's a problem with the query. If it is blank, then we check post.asp & post_info.asp to see why it isn't updating the T_ISPOLL field. |
Support Snitz Forums
|
Edited by - Davio on 04 January 2008 20:53:55 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 04 January 2008 : 21:04:17
|
| It has a value of 1 |
coaster crazy |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 January 2008 : 21:29:31
|
Ok, definitely the query then.
I remember a problem where TEXT fields, if not placed last in a SELECT query would give some problems.
Here's what I need you to try:
1. Take a look at the SQL query from lines 116 to 122 in your topic.asp file. You have added some fields related to some mods. Some of them don't have the table abbreviations in front of them. FOr example M_GLOW_TEXT should be M.M_GLOW_TEXT and T_EVENT_DATE should be T.T_EVENT_DATE. There are more so make sure you add the right table abbreviations.
2. After you do that correction, check if the poll works. If it still doesn't, check if any of the fields you added to the query for mods are of the type TEXT. Place these at the end of the query, like before T.T_MESSAGE. After that, see if polls work.
Update your topic.asp file in your first post, so I can see the changes you made to it after you test everything. |
Support Snitz Forums
|
Edited by - Davio on 04 January 2008 21:30:16 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 04 January 2008 : 22:10:47
|
| by TEXT you mean that the value input is TEXT and not just numeric, right? |
coaster crazy |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 04 January 2008 : 22:19:22
|
| Nevermind! I did both fix the M. T. in that first strSQL block and moved the stuff to after T.T_MESSAGE and everything works now. I did a test vote and wohoo it worked! thanks man! but shouldn't this have been broken long ago. Kinda funny it stopped right after the domain name change? Either way, thanks! |
coaster crazy |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 January 2008 : 05:03:52
|
No no wws. I didn't say to move all the fields after T_MESSAGE. lol
T_MESSAGE in the database is a TEXT field, meaning it can hold a LOT of data, unlike database fields like VARCHAR (variable character) which can hold a max of 255 characters.
I was suggesting, that if any of the mod fields are TEXT fields, that you move them towards the end, right before T_MESSAGE. If you notice, we tend to put the very large fields (like T_MESSAGE) at the end of our SELECT queries in the code.
We have had weird results with selecting data from large fields, when they were anywhere else but at the end of the SELECT statement.
So make sure T_MESSAGE is at the end please. |
Support Snitz Forums
|
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 05 January 2008 : 11:58:07
|
| ok I think I fixed it, the only fiekld that fit the TEXT description was M.M_WARNMESS and it has been moved right before T.T_MESSAGE and first post and poll seem to be working. I'll keep an eye out for any other oddities lol. Thanks Davio! |
coaster crazy |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 January 2008 : 13:26:35
|
Cool.
Glad you got it fixed. |
Support Snitz Forums
|
Edited by - Davio on 05 January 2008 13:27:03 |
|
|
| |
Topic |
|
Topic Locked
