| Author |
 Topic  |
|
|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 01 April 2001 : 23:07:08
|
I got MOD: Poll (by slemieux) installed and when I go to Admin options to set the poll I get this error?? Please help me. Thanks 
Microsoft JET Database Engine
error '80040e07'
Data type mismatch in criteria expression.
/forums/admin_poll.asp, line 22
Sr_Erick... Snowmobile Fanatics
Edited by - sr_erick on 01 April 2001 23:08:12
Edited by - sr_erick on 01 April 2001 23:08:42 |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 01 April 2001 : 23:13:46
|
I figured that part out that you have to make a poll in the topic first but when I go to set it as the feature poll is it suppposed to show up on the main page?? I set it and it doesnt seem to work.
Sr_Erick... Snowmobile Fanatics
Edited by - sr_erick on 01 April 2001 23:17:17 |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 April 2001 : 23:18:29
|
There's nothing better than the users figuring out thier own problems. If everybody else was like you eh, sr_erick? 
Ok, you changed your post. You need to do 2 things before the featured poll should show. 1. Turn on the "Show Featured Poll" option in the "Feature Configuration" in your "Admin options".
2. Make sure you have selected a "Feature Poll" from the "Set Feature Poll" options in your "Admin Options".
Edited by - Davio on 01 April 2001 23:22:11 |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 02 April 2001 : 14:05:38
|
OK, I did something not too good. Included with the mod was a file that said drop down poll or something like that. Since I uploaded all the files, I was checking out what they all were. I opened up that file in my browser, it said that the database changes have been made. Now I can still visit my forums main page but when I go into a single forum I get this error message.
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forums/forum.asp, line 182
What should I do now?? Thanks for all your help so far. The link to my site is in me signarure. I will post those lines of code for you guys to look at.
Sr_Erick... Snowmobile Fanatics
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 02 April 2001 : 14:10:57
|
Here are some lines before and after line 182. I think that they are the right ones?
if nDays > "0" then
strSql2 = strSql2 & " AND " & strTablePrefix & "TOPICS.T_LAST_POST > '" & defDate & "'"
end if
set rsCount = my_Conn.Execute(strSql2)
if not rsCount.eof then
maxpages = (rsCount("PAGECOUNT") \ strPageSize )
if rsCount("PAGECOUNT") mod strPageSize <> 0 then
maxpages = maxpages + 1
end if
else
maxpages = 0
end if
rsCount.close
set rs = Server.CreateObject("ADODB.Recordset")
' rs.cachesize=20
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
end if
else 'end MySql specific code
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize=20
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if
end if
'## Forum_SQL - Get all Forum Categories From DB
strSql = "SELECT CAT_ID FROM " & strTablePrefix & "CATEGORY"
set rsCat = my_Conn.Execute (StrSql)
%>
<script language="JavaScript">
<!-----
function jumpTo(s) {if (s.selectedIndex != 0) top.location.href = s.options[s.selectedIndex].value;return 1;}
function setDays() {document.DaysFilter.submit(); return 0;}
// -->
</script>
<%
if rsCStatus.EOF = true OR rsFStatus.EOF = true then
Response.Redirect("default.asp")
end if
%>
Thanks!
Sr_Erick... Snowmobile Fanatics
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 April 2001 : 17:34:30
|
What you did was delete the poll tables. Just run the poll database setup again.
Only use the drop_poll.asp file if you want to delete the poll mod or re-install it. I explained it in the readme file.
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 02 April 2001 : 21:38:39
|
Thank you VERY much. I thought that file was something like a differnet poll insteadof a button poll I thought it was a drop down menu poll or something. 
THANKS!!
Sr_Erick... Snowmobile Fanatics
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 April 2001 : 11:43:37
|
You're Welcome.
|
|
|
| |
Topic |
|
Topic Locked
