| Author |
 Topic  |
|
NetArchitect
Starting Member
USA
26 Posts |
 Posted - 29 January 2003 : 18:29:29
|
Getting the PM Error
Microsoft VBScript runtime error '800a01a8'
Object required: 'rsPM'
/forum/my.asp, line 322
Any Ideas?
|
-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action- |
 |
|
|
NetArchitect
Starting Member
USA
26 Posts |
Posted - 30 January 2003 : 11:13:51
|
| Ok I have found the bug. It happens when you Un Check the Private Messages Box. Solutions beyond the obvious? |
-We don't need Alien Races to come from other planets to Steal Our Children - We have CPS for that and they wouldn't take too kindly to some Outsider cutting in on their Action- |
|
|
|
ErEf
New Member
Netherlands
74 Posts |
Posted - 09 February 2003 : 10:32:57
|
getting other error
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'FORUM_MY_CONFIG'.
/forum/my_sp.asp, line 108
this is when I use the SP with the my.asp for SP. When I use the normal my.asp file there is no problem. |
If you think you can or you think you cannot, you are right. - Henry Ford |
|
|
|
ErEf
New Member
Netherlands
74 Posts |
Posted - 09 February 2003 : 12:03:28
|
quote:
Originally posted by NetArchitect
Ok I have found the bug. It happens when you Un Check the Private Messages Box. Solutions beyond the obvious?
What do you mean with:"un check Private Messages Box."
I don't see it.
i commented the rsPM.close but what is the impact of that besides that it works now? |
If you think you can or you think you cannot, you are right. - Henry Ford |
Edited by - ErEf on 09 February 2003 12:14:34 |
|
|
|
LeeC
Starting Member
36 Posts |
Posted - 15 February 2003 : 14:43:20
|
Ehhh don't comment the rsPM.close, that leaves the recordset open, and if you get any kind of significant traffic, it's going to eventually lock up your database with open calls.
You need to move that code instead. In your my.asp
Around line 330 find and cut/delete:
rsPM.Close
Set rsPM = Nothing
Around Line 302, find:
Set rsPM = my_Conn.Execute(strSql)
pmcount = rsPM("pmcount")
And paste immediately after that code:
rsPM.Close
Set rsPM = Nothing
Final code should look like:
Set rsPM = my_Conn.Execute(strSql)
pmcount = rsPM("pmcount")
rsPM.Close
Set rsPM = Nothing
Just need to open the recordset, grab the PMcount var and then close it. |
Oh WTF!com
Convergence - an MMORPG guild
.rdw. a CS clan
GotFrag? - Your online eSports resource
urK?!? |
|
|
|
EmperorNeo
Starting Member
32 Posts |
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 05 March 2003 : 02:00:52
|
I noticed the date of the post(s) is missing from the my_default.asp page. Can you tell me how to add this piece of information? Otherwise, I love the mod.
Shannon |
|
|
|
terryp
Junior Member
United Kingdom
174 Posts |
Posted - 07 March 2003 : 06:45:07
|
Love this mod @tomic though having a couple of problems with the edit profile link, eidt gives me this : Microsoft VBScript compilation error '800a03f6'
Expected 'End'
/forum/pop_profile.asp, line 1682
I know it's something incredibly simple but is just as incredibly elusive.........help please!! |
  |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 07 March 2003 : 07:10:39
|
quote:
Originally posted by stwilson
I noticed the date of the post(s) is missing from the my_default.asp page. Can you tell me how to add this piece of information? Otherwise, I love the mod.
Shannon
around line 469
replace
<td bgcolor="<% =strForumCellColor %>" valign="center" align="center" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>" color="<% =strForumFontColor %>"><b><% %></b> <% =ChkTime(rs("T_LAST_POST")) %><%=strLastAuthor%></font></td>
with
<td bgcolor="<% =strForumCellColor %>" valign="center" align="center" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>" color="<% =strForumFontColor %>"><b><% %></b> <b><% =ChkDate(rs("T_LAST_POST"), "</b><br />" ,true) %><%=strLastAuthor%></font></td>
|
The UK MkIVs Forum |
|
|
|
pyrodude
Junior Member
101 Posts |
Posted - 07 March 2003 : 07:45:15
|
Could @tomic correct all the above errors for a complete, bug-free copy?
Thanks |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 07 March 2003 : 09:26:01
|
| may aswell take the <b><% %></b> out of the above too |
The UK MkIVs Forum |
|
|
|
andyjenkins
Junior Member
105 Posts |
Posted - 07 March 2003 : 22:14:51
|
quote:
Originally posted by rsoxhater
Were using access 2k - get this error when trying to load it under my account
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getMemberID'
/test/my_default.asp, line 98
Anyone got a fix for this? I have this exact error also. |
BTOpenworld ADSL Usergroup |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 08 March 2003 : 05:53:06
|
quote:
Originally posted by andyjenkins
quote:
Originally posted by rsoxhater
Were using access 2k - get this error when trying to load it under my account
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getMemberID'
/test/my_default.asp, line 98
Anyone got a fix for this? I have this exact error also.
Make sure you have all the right include files on the page.
<!--#INCLUDE FILE="inc_func_secure.asp" --> |
De Priofundus Calmo Ad Te Damine |
|
|
|
andyjenkins
Junior Member
105 Posts |
Posted - 08 March 2003 : 10:54:24
|
Well that moved the error anyway  quote:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'MEMBER_ID ='.
/v3/forum/my_default.asp, line 108
which isquote:
strSQL = "SELECT * FROM " & strTablePrefix & "MY_CONFIG WHERE MEMBER_ID = " & id
Set objRS = my_Conn.Execute(strSQL)
UpdateIts ok .. its fixed... instead of "id" it must be "intID" (I think).
Got another error now though  geez this is hard work.. |
BTOpenworld ADSL Usergroup |
Edited by - andyjenkins on 08 March 2003 10:59:49 |
|
|
|
andyjenkins
Junior Member
105 Posts |
Posted - 08 March 2003 : 11:09:29
|
| Yeah .. its seems all the "id"'s in the scripts need to be changed to "intID". How come no-one else spotted this ? |
BTOpenworld ADSL Usergroup |
|
|
|
Topic |
|
Topic Locked
