Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Private Messages 3.4.03
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 20

RM
Starting Member

USA
17 Posts

Posted - 09 June 2003 :  13:07:29  Show Profile
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
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 09 June 2003 :  13:23:33  Show Profile
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.”
Go to Top of Page

RM
Starting Member

USA
17 Posts

Posted - 09 June 2003 :  16:32:04  Show Profile
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
Go to Top of Page

N-Rico
Starting Member

Netherlands
4 Posts

Posted - 16 June 2003 :  04:12:05  Show Profile  Visit N-Rico's Homepage
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!?)
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts

Posted - 16 June 2003 :  09:37:23  Show Profile  Visit masterao's Homepage
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
Go to Top of Page

Francodepaw
Junior Member

USA
111 Posts

Posted - 16 June 2003 :  11:33:14  Show Profile
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 & "'"
Go to Top of Page

rejordan
Starting Member

18 Posts

Posted - 26 June 2003 :  13:43:08  Show Profile  Visit rejordan's Homepage
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
Go to Top of Page

Locnar
New Member

89 Posts

Posted - 30 June 2003 :  02:17:37  Show Profile  Visit Locnar's Homepage
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
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 30 June 2003 :  03:22:31  Show Profile
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.
Go to Top of Page

Locnar
New Member

89 Posts

Posted - 02 July 2003 :  17:18:50  Show Profile  Visit Locnar's Homepage
I guess I'm not familiar with that Laser, could you elaborate?

Thanks!

Locnar
Just your basic forums ---> www.duncanet.com/forums
Star Wars Galaxies ---> www.duncanet.com/forum/sitenews.asp
Go to Top of Page

TestMagic
Senior Member

USA
1568 Posts

Posted - 05 August 2003 :  23:57:15  Show Profile  Visit TestMagic's Homepage
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
Go to Top of Page

gareth_moore_2000
Junior Member

United Kingdom
262 Posts

Posted - 07 August 2003 :  15:59:02  Show Profile
did we ever get the 'ignore' feature for this ?
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 07 August 2003 :  16:04:26  Show Profile
Check this:

http://www.shnforum.com/forum/topic.asp?TOPIC_ID=2561
Go to Top of Page

gareth_moore_2000
Junior Member

United Kingdom
262 Posts

Posted - 08 August 2003 :  18:56:46  Show Profile
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 ?
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 08 August 2003 :  19:20:48  Show Profile
The quickest/dirtiest way would be to hard-code the result you want after the code has checked the cookie (maybe?)
Go to Top of Page
Page: of 20 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07