| Author |
 Topic  |
|
|
Inspectorclave
Starting Member
1 Posts |
 Posted - 29 July 2001 : 22:21:01
|
When I create a thread as an admin (or any user) the process appears to complete successfully. However, when I click on the hyperlink under the forum heading to view the new thread, the page loads, but the thread contains the following error:
------------------------------------------------------------
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cint'
/forum/forum.asp, line 613
------------------------------------------------------------
Also, after a user registers with the forum, when you click on their name under the "Members" section to view their profile, the following error is returned:
------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Errors occurred
/forum/pop_profile.asp, line 110
------------------------------------------------------------
If this has been addressed previously, I apologize. Any help with this would be GREATLY appreciated. Thanks in advance.
Inspectorclave
|
|
|
campsalot
Starting Member
5 Posts |
Posted - 30 July 2001 : 10:40:55
|
ok... I fixed the error with the pop_profile.asp file. It seems as though there was an error in the SQL statement.
However, I am still having the "cint" problem. Here is the snippet of code where the error is occurring:
------------------------------------------------
sub TopicPaging()
mxpages = (rs("T_REPLIES") / strPageSize)
if mxPages <> cint(mxPages) then
mxpages = int(mxpages) + 1
end if
------------------------------------------------
Line 613 is "if mxPages <> cint(mxPages) then". My only guess is that it is trying to divide by zero for some reason. Any suggestions?
Inspectorclave
|
 |
|
|
campsalot
Starting Member
5 Posts |
Posted - 30 July 2001 : 11:05:08
|
Ok.. final reply to this thread. I was able to correct the problem with the "cint" error. To solve the problem I went into the SQL server and set the default value of the T_REPLIES column in the FORUM_TOPICS table to 0. For some reason it didn't like the default <null> value that was entered in when there are no replies to a topic.
Inspectorclave
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 30 July 2001 : 15:15:11
|
You are a Geni...us. I have not seen a self fixed problem on the boards.
Share A Square at forumSquare
gauravbhabu
There is only one miracle...That is LIFE! |
|
|
| |
Topic |
|
Topic Locked
