Author |
Topic |
RM
Starting Member
USA
17 Posts |
Posted - 09 June 2003 : 13:07:29
|
Hello, if I could please get a little help. On my forums, when I installed this, I keep getting this error
quote: Microsoft VBScript compilation error '800a03f2'
Expected identifier
/forums/config.asp, line 126
Dim SubCount, MySubCount, Dim strPMLimit, strPMStatus --------------------------^
I browsed the thread, but cant seem to find anything about this, can anyone help? Please. For reference, I have the smilie manager mod added and that is it besides this one |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 09 June 2003 : 13:23:33
|
There are two ways of fixing this, replace line 126 with either one of the following:quote: Dim SubCount, MySubCount, strPMLimit, strPMStatus
quote: Dim SubCount, MySubCount Dim strPMLimit, strPMStatus
|
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
RM
Starting Member
USA
17 Posts |
Posted - 09 June 2003 : 16:32:04
|
the PM system works but now its telling me that something else is wrong. at the bottom post on every thread, I have this error message inserted into the post, instead of the persons actual post
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
/forums/inc_func_common.asp, line 638
Does anyone know what I can do to fix this?
Thank you!
|
Edited by - RM on 09 June 2003 16:46:39 |
|
|
N-Rico
Starting Member
Netherlands
4 Posts |
Posted - 16 June 2003 : 04:12:05
|
Hi,
I've installed the PM mod, and followed the instructions carefully. Now when I click the PM icon, to send someone a priv msg, everything looks fine, no errors after clicking the 'Send Message' button. However the message is never received. When I click on the 'Preferences' button under Private Messages, I receive the following error message....
<Forum name> private messages are currently turned error '80020009' Exception occurred.
/pm_options.asp, line 103
Suggestions anyone?
N-Rico
|
Regards,
N-Rico
(p.s. is this a boring signature or what!?) |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 16 June 2003 : 09:37:23
|
RM and N-Rico, you should have posted this in the Help: MOD Implementation as your problems aren't due to bugs with the PM mod.
Instead for posting anew here, start a new topic there in which you can answer my questions.
RM, does this error occur only in the last reply to a topic? Could you provide a link to a text-version of your topic.asp?
N-Rico, did you update the database with the dbs-file? Did you recieve any errors when you updated the database? |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
Edited by - masterao on 16 June 2003 09:41:01 |
|
|
Francodepaw
Junior Member
USA
111 Posts |
Posted - 16 June 2003 : 11:33:14
|
quote: Originally posted by N-Rico
Hi, I receive the following error message....
<Forum name> private messages are currently turned error '80020009' Exception occurred.
/pm_options.asp, line 103
Suggestions anyone?
N-Rico
Are you by chance on MySql?
I use MySql, NT Autentication and I have spaces in usernames. I had to do the following on mine. Had to do the following to fix 1) the error message above. 2) PM's going nowhere. The was a place I had to fix for my users with spaces in the names, can't remember just where but will try to locate what I did. My changes are in red.
pm_options.asp around line 82 '## Forum_SQL strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID " strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_NAME " strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_PASSWORD " strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_PMEMAIL " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_USERNAME = '" & strDBNTUserName & "'" strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strUniqueID & "User")("PWord") & "'"
Also in privatemess.asp around line 50 strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS , " & strTablePrefix & "PM " strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_USERNAME = '" & strDBNTUserName & "'" strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO " strSql = strSql & " AND " & strTablePrefix & "PM.M_READ = 0 "
And pm_view.asp around line 149 and again around line 253strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_USERNAME = '" & strDBNTUserName & "'" strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strTablePrefix & "PM.M_TO " strSql = strSql & " ORDER BY " & strTablePrefix & "PM.M_SENT DESC"
Privateread.asp around 116 my code ended up lookin like this. Did some stuff to get around the nested Select statement mysql didn't like.
' Get Private Message Total for display(SQL, mySQL) 'strSql = "SELECT pmtotal1=(SELECT Count(M_TO) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_TO), pmtotal2=(SELECT Count(M_FROM) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_FROM)"
strSql = "SELECT Count(M_TO) as pmtotal1 FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_USERNAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_TO " Set rsPM1 = my_Conn.Execute(strSql)
strSql = "SELECT Count(M_FROM) as pmtotal2 FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_USERNAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_FROM " Set rsPM2 = my_Conn.Execute(strSql)
'Set rsPM = my_Conn.Execute(strSql)
'pmtotal1 = rsPM("pmtotal1") 'pmtotal2 = rsPM("pmtotal2")
'rsPM.close 'set rsPM = nothing rsPM1.close set rsPM1 = nothing rsPM2.close set rsPM2 = nothing
privatesent.asp line 65 strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_USERNAME = '" & strDBNTUserName & "'"
privatedelete.asp line 51 strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_USERNAME = '" & strDBNTUserName & "'"
|
|
|
rejordan
Starting Member
18 Posts |
Posted - 26 June 2003 : 13:43:08
|
Just a quick note to let you know that I just installed the PM mod and it went flawlessly! No problems what-so-ever. I think you should change the difficulty from a 7 to maybe a 4 ;). Thanks for a great mod!
-Richard |
|
|
Locnar
New Member
89 Posts |
Posted - 30 June 2003 : 02:17:37
|
Well hopefully this is a simple one...
For some reason when someone registers in the forums, both fields in the Access database, M_PMEMAIL and M_PMRECEIVE are blank, no 0 or 1. This means that their pm status is off and no PM icon shows up anywhere for them.
I have to manually download the database, change the PM_EMAIL to 0, and change PM_RECIEVE to 1, then upload the database back to the website. How do I make this happen automatically so I don't have to do this each time, and the users don't have to go into PM options to turn it on? (My members are not techies by any means )
I would post code, but I have no idea which file this would be located in.
Thanks for help. |
Locnar Just your basic forums ---> www.duncanet.com/forums Star Wars Galaxies ---> www.duncanet.com/forum/sitenews.asp
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 30 June 2003 : 03:22:31
|
quote: Originally posted by Locnar
I have to manually download the database, change the PM_EMAIL to 0, and change PM_RECIEVE to 1, then upload the database back to the website.
A better method here is to use Table Editor, then there is no download/upload all the time. |
|
|
Locnar
New Member
89 Posts |
|
TestMagic
Senior Member
USA
1568 Posts |
Posted - 05 August 2003 : 23:57:15
|
quote: Originally posted by Locnar
I guess I'm not familiar with that Laser, could you elaborate?
Check out this page. |
Snitz rocks! · Search 2 |
|
|
gareth_moore_2000
Junior Member
United Kingdom
262 Posts |
Posted - 07 August 2003 : 15:59:02
|
did we ever get the 'ignore' feature for this ? |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
|
gareth_moore_2000
Junior Member
United Kingdom
262 Posts |
Posted - 08 August 2003 : 18:56:46
|
thanks, thats great- worked first time :-)
One more thing..... I want all my members PM-VIEW page to view as a single page (ie inbox and outbox on the same page), I dont want to give them the choice ! I have taken this option out of the preferences and set the default view to single. However, I dont want this page to check cookies for this setting. So what do I remove in pm_view.asp to stop the page checking the cookies ? |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 08 August 2003 : 19:20:48
|
The quickest/dirtiest way would be to hard-code the result you want after the code has checked the cookie (maybe?) |
|
|
Topic |
|