| Author |
 Topic  |
|
|
spg
Starting Member
26 Posts |
 Posted - 12 November 2003 : 14:17:56
|
| I'm having a problem with the Poll Mod (not sure what version) in Snitz 3.4.03. I recently moved from a shared server to a dedicated server, and from an Access database to a MS SQL. Polls worked fine before the move, and the only thing that changed on the new server was the database. The code is all the same, nothing changed there. But, the poll system no longer works. A new poll will appear to post fine, but then when you try to view it, it shows up just like a normal topic instead of a poll (no voting options, etc). Any ideas? |
~Spencer
Owner-Editor of TabletPCBuzz.com
Microsoft MVP - Tablet PC |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 12 November 2003 : 21:01:16
|
Post a link to your forum and a username and password I can use to logon and test it.
Also post a link to a txt version of your topic.asp file. |
Support Snitz Forums
|
 |
|
|
spg
Starting Member
26 Posts |
Posted - 16 November 2003 : 16:41:45
|
Thanks Davio.
My forum is located at http://www.tabletpcbuzz.com/forum/ and you can login with the account name "test" and the password "tester".
Also, here is the link to a txt version of the topic.asp file -http://www.tabletpcbuzz.com/topic.txt |
~Spencer
Owner-Editor of TabletPCBuzz.com
Microsoft MVP - Tablet PC |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 16 November 2003 : 23:24:30
|
Probably try checking to see if T_ISPOLL is = 1 in the TOPICS table for some of the polls.
Also check the POLLS and POLL_VOTES tables to make sure the poll data is still there for the polls. |
Support Snitz Forums
|
|
|
|
spg
Starting Member
26 Posts |
Posted - 18 November 2003 : 20:28:43
|
| Yes, that was one of the first things I checked. Everything appears to be there. I program in ASP alot, so I have a good understanding of it, but I've looked at just about everything I can think of and this has me stumped. |
~Spencer
Owner-Editor of TabletPCBuzz.com
Microsoft MVP - Tablet PC |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 November 2003 : 12:29:37
|
Can you email me a sql dump of the following tables:
FORUM_TOPICS
FORUM_FORUM
FORUM_POLLS
FORUM_POLL_VOTES
You know how to make an sql dump right? I only need the data, not the structure.
Oh my email address is forumATdsilveraDOTcom
Replace AT with @ and reply the DOT with . |
Support Snitz Forums
|
Edited by - Davio on 19 November 2003 12:30:55 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 November 2003 : 14:47:13
|
Got your email.
Can you email me an admin username and password to your forum?
Also, make a copy of your topic.asp file and call it topic2.asp.
After line 169 add the following code to topic2.asp:IsPoll = rsTopic("T_ISPOLL") '<-- line 169
Response.Write "ispoll:" & IsPoll & "<br>"
On line 121 add the following code: " AND M.MEMBER_ID = T.T_AUTHOR "
Response.Write strSql & "<br>" '<-- line 121
set rsTopic = Server.CreateObject("ADODB.Recordset") |
Support Snitz Forums
|
|
|
|
spg
Starting Member
26 Posts |
Posted - 24 November 2003 : 16:48:31
|
| Sent. |
~Spencer
Owner-Editor of TabletPCBuzz.com
Microsoft MVP - Tablet PC |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 November 2003 : 23:56:29
|
If you notice here the IsPoll variable is empty. According to your database data you gave me, it should be 1.
I have sent you a file with some changes to the code. I am hoping to see what is causing the variable to be empty. |
Support Snitz Forums
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 November 2003 : 00:01:10
|
I am also getting this error when previewing the polls from the poll configuration in the admin options.ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/inc_func_common.asp, line 55
On another note, have you considered upgrading your poll mod to the latest version? |
Support Snitz Forums
|
|
|
|
spg
Starting Member
26 Posts |
Posted - 25 November 2003 : 00:53:26
|
Hmmm... I'm not getting that error on my end. Still getting it there?
Actually... I didn't even know that a new version of the mod was out. The old version was working fine, so I haven't bothered checking for updates. |
~Spencer
Owner-Editor of TabletPCBuzz.com
Microsoft MVP - Tablet PC |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 November 2003 : 08:48:21
|
The latest version fixes a number of bugs and adds some additional features. One of the bugs being that the poll data in the poll tables don't get deleted when you delete a poll. So they just stay there, taking up space.
Back to the problem. I can see the poll is now showing up with the changes I made to the file. All i did was remove the M_BIO, T_LASTHEREDATE, and AVATAR_URL fields from the sql query.
Now we need to add each field back into the query. Probably re-arrange which ones get selected first.
Will get back to you on this. |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
