| Author |
 Topic  |
|
tathy
Starting Member
3 Posts |
 Posted - 10 January 2001 : 13:41:49
|
I still has this error
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'FormatNumber'
/snitz/topic.asp, line 728
Does anyone know how to fix it
My update database file looks like this:
<%
dbupdate="E:\Inetpub\wwwroot\snitz\snitz.mdb"
set Myconn= Server.CreateObject("ADODB.Connection")
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&dbupdate
MyConn.Open ConnString
sqlstr="ALTER TABLE FORUM_TOPICS ADD answer1 CHAR(100) NULL,count1 INTEGER NULL,answer2 CHAR(100) NULL,count2 INTEGER NULL,answer3 varchar(100) NULL,count3 INTEGER NULL,answer4 varchar(100) NULL,count4 INTEGER NULL,answer5 varchar(100) NULL,count5 INTEGER NULL,answer6 varchar(100) NULL,count6 INTEGER NULL,answer7 varchar(100) NULL,count7 INTEGER NULL,answer8 varchar(100) NULL,count8 INTEGER NULL"
MyConn.execute(sqlstr)
response.write "New field added to FORUM_TOPICS table!<br>"
sqlstr="ALTER TABLE FORUM_CONFIG ADD C_ADMINPOLLS INTEGER NULL, C_USERPOLLS INTEGER NULL,C_ACTIVEPOLL INTEGER NULL"
MyConn.execute(sqlstr)
response.write "New field added to FORUM_CONFIG table!<br>"
MyConn.close
%>
Edited by - tathy on 10 January 2001 13:47:45 |
 |
|
|
slemieux
Junior Member
USA
234 Posts |
Posted - 10 January 2001 : 14:42:35
|
quote:
I've installed the mod per the instructions at http://209.35.175.12/snitz/polls.txt. The error with the featured topic appears to be fixed. However, I am still getting the error with the first message in each thread displaying a blank message. Any ideas?
Triple check these lines
<% if trim(rs("answer1")) = "" then %>
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><% =formatStr(rs("T_MESSAGE")) %></font></td>
<% end if %>
Might try taking out the if / end if statements and see if the message shows up. If not, the problem is somewhere else.
Scott LeMieux
Ready... Fire... Aim!!  |
|
|
|
need300z
Starting Member
14 Posts |
Posted - 10 January 2001 : 15:36:26
|
I'm having the same problem I downloaded I think the latest files and the featured poll still has the EOF and also when you post the first topic there is nothing in the subject line after viewing it. Is it in topic that i'm supposed to look for
<% if trim(rs("answer1")) = "" then %> <font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><% =formatStr(rs("T_MESSAGE")) %></font></td><% end if %>
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 10 January 2001 : 16:35:06
|
tathy, if you read the earlier posts in this topic you would see that I had posted that same problem and the reason why it was giving that error. You haven't set up your database fields for the polls correctly. The count[n] fields have to have a default value of 0.
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----* |
|
|
|
L_D
Starting Member
8 Posts |
Posted - 10 January 2001 : 21:18:02
|
Hey. I am using CFM-Resources for my board. I want to add this mod to my forums, but I have a question.
Which one will work best on cfm with least bugs: the .txt file (self installation) or the .zip (files already changed)? Or both the same? Just wondering so I know which one to use. Thanks 
|
|
|
|
tathy
Starting Member
3 Posts |
Posted - 10 January 2001 : 23:25:43
|
The problem is it doesn't creat a null value in countn
is something wrong in my pollupdatedb.asp , it look like this :
<%
dbupdate="E:\Inetpub\wwwroot\snitz\snitz.mdb"
set Myconn= Server.CreateObject("ADODB.Connection")
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&dbupdate
MyConn.Open ConnString
sqlstr="ALTER TABLE FORUM_TOPICS ADD answer1 CHAR(100) NULL,count1 INTEGER NULL,answer2 CHAR(100) NULL,count2 INTEGER NULL,answer3 varchar(100) NULL,count3 INTEGER NULL,answer4 varchar(100) NULL,count4 INTEGER NULL,answer5 varchar(100) NULL,count5 INTEGER NULL,answer6 varchar(100) NULL,count6 INTEGER NULL,answer7 varchar(100) NULL,count7 INTEGER NULL,answer8 varchar(100) NULL,count8 INTEGER NULL"
MyConn.execute(sqlstr)
response.write "New field added to FORUM_TOPICS table!<br>"
sqlstr="ALTER TABLE FORUM_CONFIG ADD C_ADMINPOLLS INTEGER NULL, C_USERPOLLS INTEGER NULL,C_ACTIVEPOLL INTEGER NULL"
MyConn.execute(sqlstr)
response.write "New field added to FORUM_CONFIG table!<br>"
MyConn.close
%>
I run it, countn are not = 0
|
|
|
|
L_D
Starting Member
8 Posts |
Posted - 12 January 2001 : 02:17:03
|
Well, I'm just going to do the self install. Mainly because I already modified some of the files to include a custom header, and some CSS.
The only problem is, I can't add the stuff into the Database. I can't open it. I tried my HTML editor, and Notepad. Neither worked. So, could you post a download for just the database file?
EDIT: Ok. I just downloaded the zip file. And I noticed that there is no database file included. Well, since it isn't in there, could someone please tell me how to open it? Or what to use? Thanks
Edited by - L_D on 12 January 2001 02:24:17 |
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 12 January 2001 : 03:42:14
|
To use the Hurw Dbmod setup with this poll you need to include the default value for the countn fields.
like this:
[ALTER]
TOPICS
answer1;varchar(100);NULL;
count1;int;NULL;0
.......
It work for me on clean SR4 install, using Davio zip files.
Slemieux,
Could you please check to see if a member can vote many time? the blocking seem not working for me (or maybe my cookie corrupt)
You can look at the demo/probs forum here:
http://www.cfm-resources.com/e/evehawk/default.asp
Edited by - evehawk on 12 January 2001 06:02:12 |
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 12 January 2001 : 11:21:43
|
The one vote per member work :) Found the cookie section i think Davio rem out.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 12 January 2001 : 13:03:11
|
Oops, sorry about that. I did that because I was testing the polls on my server. And each time I went in to vote it kept telling me that I voted already, so I had to disable it for a while. Thanks evehawk.
Zip file has been updated with the changes.
I also included the HuwR's Mod Setup script so you don't have to do the database setup yourself. Everything should be ok now. (I hope) Let me know if you have any more problems.
*----*----*----*----*----*----*----*----*
"Even when you feel you have nothing left,
You still have prayer--And that's enough."
*----*----*----*----*----*----*----*----* |
|
|
|
evehawk
New Member
Australia
65 Posts |
Posted - 12 January 2001 : 13:55:37
|
Well one last thing Davio :)
If any of you still have problem with the 1st portion of topic blank this is what i find out:
Look at the portion:
<% ' ##### Poll Mod #######
if trim(rs("answer1")) = "" then %>
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"><% =formatStr(rs("T_MESSAGE")) %></font></td>
<% end if %>
Go ahead and delete it :)
Look down about 60 lines you will see a section :
</td>
</tr>
</table>
<% end if %>
<% end if %>
Insert the red codes so it look like this:
</td>
</tr>
</table>
<% end if %>
<% else %>
<font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<% =formatStr(rs("T_MESSAGE")) %>
</font>
<% end if %>
and that should fix it. It work for me.
Thanks slemieux, Davio, Hurw and everyone for this great mod.
|
|
|
|
need300z
Starting Member
14 Posts |
Posted - 12 January 2001 : 15:50:57
|
Where am I supposed to look for the code? in what page?
|
|
|
|
need300z
Starting Member
14 Posts |
Posted - 12 January 2001 : 15:51:08
|
Where am I supposed to look for the code? in what page?
|
|
|
|
L_D
Starting Member
8 Posts |
Posted - 12 January 2001 : 16:45:59
|
Ok. I downloaded the zip file, and that didn't work right. I used the db mod files, though.
Anyway, I installed everything correctly, but I can't view the poll.
I used the topic.asp that was in the .zip (only with a few slight modifications), and when I try to view the poll, it gives me this error:
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 8.
/j/jsp/forum/topic.asp, line 515
What can I do to correct that? Keep in mind I still have the commented lines in there. Just thought I'd mention that so you look at the right thing =)
EDIT: I thought I should add that I use SR4. I was told shortly after I posted this that the Poll has a few bugs with SR4... So, how can I correct that?
Edited by - L_D on 12 January 2001 17:10:45 |
|
|
|
SniperDude
Starting Member
USA
47 Posts |
Posted - 12 January 2001 : 17:27:42
|
Wow...
I was actually able to make it work...
http://www.nwcfonline.com/main/forum <--Please note this site is brand new and under development =) (Thanks Guys/gals for all your helps!- err messages!  )
I took the 3.1Sr4 zip file from snitz forums and the zip file eve made.. put them all in a directory on the webserver and used the mod_dbsetup.asp that someone made.... and downloaded the images from the test site by Slemieux.... found a problem in the mod_dbsetup.asp script... that I corrected...
the lines that create these fields for the database...
FORUM_CONFIG
C_ADMINPOLLS Number-LongInteger/0 (int)
C_USERPOLLS Number-LongInteger/0 (int)
C_ACTIVEPOLL Number-LongInteger/0 (int)
are wrong they need to be integers the .asp script made them but as text fields... after I manually changed the DB ... everything works...
-Tim
Thanks Again!
*Graphics Withheld for Adminstrative reasons*
-Tim
System Admin |
|
|
|
Topic |
|
Topic Locked
