Print Page | Close Window

(Send_pms.asp)...Error !!

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2880
Printed Date: 01 April 2026 at 6:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: (Send_pms.asp)...Error !!
Posted By: Cool_Man
Subject: (Send_pms.asp)...Error !!
Date Posted: 20 May 2003 at 12:35pm

Hi all,

i have question, i hope that anyone know how to fix this problem to answer me plzz.

when i use this file: (Send_pms.asp) to send PM  to all members , it's give me Error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/forum/send_pms.asp, line 146

can you help me plzz?



-------------


Thanks for all



Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 May 2003 at 12:54pm

You must be using a different forum system as there is no file called send_pms.asp and there is also no option to send Private Messages to all members.

Try posting your question on the site you got your forum system from, or if using a mod contact the author of that mod.



-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: fernan82
Date Posted: 20 May 2003 at 9:00pm
Judging for the file name you're using a mod i wrote, the all users option was not included on the original mod, it was a later addition, i think i tested it and it was working fine but now i'm looking for it and found like two different versions, i'll look into it and see if i can fix it, it would help if you post a copy of the one you're using so i can download it and check it out..........i'll have a reply for you by tomorrow hopefully.

-------------
FeRnAN
http://www.danasoft.com/">


Posted By: Cool_Man
Date Posted: 21 May 2003 at 12:59pm

yes that it's right fernan82 , it was a later addition.

thank you very mutch sir, it's kind of you to trying to help me

could you download the file from http://www.nooralislam.net/forum/uploads/send_pms.zip - here plzz ?



-------------


Thanks for all


Posted By: fernan82
Date Posted: 21 May 2003 at 8:01pm
I got the file....... i had a very long day today and i just got home so i'll take a look at it tomorrow and post the fix then...

-------------
FeRnAN
http://www.danasoft.com/">


Posted By: Cool_Man
Date Posted: 22 May 2003 at 9:02am
thanks sir

-------------


Thanks for all


Posted By: fernan82
Date Posted: 22 May 2003 at 2:57pm

you posted that you got an error on line 146 but there's nothing on line 146 on the file you sent me



-------------
FeRnAN
http://www.danasoft.com/">


Posted By: fernan82
Date Posted: 22 May 2003 at 3:23pm

i went thru it and fixed all the errors i could find, it should work fine now, download the new version http://forums.webwiz.net/forum_posts.asp?TID=2955&PN=1&TPN=1 - here

<edit> make sure you replace both files, not just send_pms.asp but also pm_groups.asp



-------------
FeRnAN
http://www.danasoft.com/">


Posted By: Cool_Man
Date Posted: 22 May 2003 at 5:24pm

i'm sorry lool

i remove line before i upload the file here, this line i was write it for some thing in my forum.

so , it's must be line: 145

that is:

'Check that the user the pm is being sent to exisits

'Initalise the SQL string with a query to read in the dteails of who the PM is to
strSQL = "SELECT tblAuthor.Author_ID, tblAuthor.Username, tblAuthor.Author_email, tblAuthor.PM_notify "
strSQL = strSQL & "FROM tblAuthor "
strSQL = strSQL & "WHERE tblAuthor.Username = '" & strToUsername & "';"

'Open the recordset
rsCommon.Open strSQL, adoCon



-------------


Thanks for all


Posted By: Cool_Man
Date Posted: 22 May 2003 at 5:27pm

thank you very much sir

i will try it now

*******

yes, ( pm_groups.asp) it's there in my forum.

thanks again

i will try it now, and i will tell you what's happend with me.



-------------


Thanks for all


Posted By: Cool_Man
Date Posted: 22 May 2003 at 5:59pm

 thank you ver mutch sir

it's working good now , i'm very hapy for this function

thank you again



-------------


Thanks for all


Posted By: Cool_Man
Date Posted: 25 May 2003 at 12:50pm

sir fernan82,

i have problem when i send PM for New members,

it's give me tihis massege:

Persits.MailSender.4 error '800a0006'

501 5.5.4 Invalid Address

/forum/functions/functions_send_mail.asp, line 269

have you idea about it plzz??



-------------


Thanks for all


Posted By: Bliss
Date Posted: 25 May 2003 at 2:02pm
I think that either means you have an invalid email address or the address you're sending to is invalid, or maybe the server just can't find the component. It's a guess for now until I find where in the world the forum is on my desktop and study the line...


Posted By: Cool_Man
Date Posted: 25 May 2003 at 5:13pm

yah maybe,

so , how i can skip the error if there is an error when the forum try to send e-mail for all members?

i hope you help me

plzz



-------------


Thanks for all


Posted By: fernan82
Date Posted: 25 May 2003 at 5:51pm

either disable email notification or configure it correctly... if you don't know which email component you have then contact your web host and ask them, if you don't have an email component then you can't send emails...

Also if you have a lot of members subscribed to receive email notification when they receive PMs then you'll also be sending a mass email at the same time and most email components can't handle that so it might crash, i believe the only component capable of sending mass emails is CDONTS.



-------------
FeRnAN
http://www.danasoft.com/">



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net