| Author |
 Topic  |
|
frankie
Junior Member
Vatican City
304 Posts |
 Posted - 10 January 2001 : 01:12:02
|
Kycable,
Thanks for this great mod (you too HuwR  ). Everything worked fine for me (installation & setup wise), but when I registered as a new member and went to check my inbox, the message was there but the sender name was still Admin even though I've changed it in the new_mem_pm admin page to a different name. Plus the customized message I entered and even previewed to make sure everything was ok (and it did show in the preview box) didn't show up all I got was the Enter your message here thing that was the default value. I didn't get any error when I modified the name and the message in the admin page to alarm me that's something was wrong!!
Thoughts?!!
ô¿~ |
 |
|
|
kycable
New Member
USA
82 Posts |
Posted - 10 January 2001 : 01:18:02
|
quote:
Kycable,
Thanks for this great mod (you too HuwR ). Everything worked fine for me (installation & setup wise), but when I registered as a new member and went to check my inbox, the message was there but the sender name was still Admin even though I've changed it in the new_mem_pm admin page to a different name. Plus the customized message I entered and even previewed to make sure everything was ok (and it did show in the preview box) didn't show up all I got was the Enter your message here thing that was the default value. I didn't get any error when I modified the name and the message in the admin page to alarm me that's something was wrong!!
Thoughts?!!
ô¿~
Did you try re-seting the message, subject, and username? If that doesn't work. There are only two other places it could be. The database. (Which if you ran the setup should be fine) and the register.asp I have noticed on a few that I have looked at they forgot to put in the New Mem 1 line strSql lines. Did you check these?
Let me know... I am going to bed right now (really tired) I will check this in the morning to see if you have it fixed. If not send me your register.asp file if I amy look at it to the kycable99@msn.com
Thanks,
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
Hopper
Junior Member
192 Posts |
Posted - 10 January 2001 : 08:10:41
|
Will this mod work WITHOUT mod commander?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 January 2001 : 08:24:23
|
It will yes, but you will have to create your own link to admin_new_pm.asp
'Resistance is futile' |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 10 January 2001 : 19:52:57
|
Fixed it. Had to change the data type for the M_VALUE field in the MOD table from Text to Memo!!
ô¿~ |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 January 2001 : 13:30:24
|
Hey wouldn't it be easier in terms of no updates to the database to just add code in the register.asp page so that it adds a new message by by the admin after the user completes registration?
Kinda like how it's done with the "congratulations for registering" email after someone registers.
This was what I did. Finish registering and you get new private message in mbox.
demo: http://www.calvsa.net/snitz31sr4/
- Alan
alan@calvsa.net
www.calvsa.net
Edited by - aznknight on 11 January 2001 13:30:48 |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 11 January 2001 : 13:34:25
|
quote:
Hey wouldn't it be easier in terms of no updates to the database to just add code in the register.asp page so that it adds a new message by by the admin after the user completes registration?
Kinda like how it's done with the "congratulations for registering" email after someone registers.
This was what I did. Finish registering and you get new private message in mbox.
demo: http://www.calvsa.net/snitz31sr4/
- Alan
alan@calvsa.net
www.calvsa.net
Edited by - aznknight on 11 January 2001 13:30:48
In the begining that is pretty much what I did. Although I thought it would be nice to be able to change the message easily in a post box. The information had to be stored somewhere so that is basically all the changes that were done here.
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 22 January 2001 : 18:26:07
|
After Doing a Register.. after you hit submit this error comes up:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/register.asp, line 294
Here is line 294,295,296:
'########################### PM NEW MEMBER #####################
strSql = strsql & ", '1'"
'########################### PM NEW MEMBER #####################
Here is my Register.asp file
www.eastpasco.com/files/register.txt
Thanks,
Rick
My Demo Site
www.eastpasco.com |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 22 January 2001 : 18:30:28
|
quote:
After Doing a Register.. after you hit submit this error comes up:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/register.asp, line 294
Here is line 294,295,296:
'########################### PM NEW MEMBER #####################
strSql = strsql & ", '1'"
'########################### PM NEW MEMBER #####################
Here is my Register.asp file
www.eastpasco.com/files/register.txt
Thanks,
Rick
My Demo Site
www.eastpasco.com
Rick, E-Mail me your Register.asp file, let me see if I can find out what is going on...
kycable@webzonecomplete.com
or
webmaster@webzonecomplete.com
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 January 2001 : 19:11:44
|
rick,
Try removing the ' ' from around the 1 see if that helps
'Resistance is futile' |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 22 January 2001 : 19:37:05
|
Ok.. Now I get this:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/register.asp, line 300
Line 300> my_Conn.Execute (strSql)
My Demo Site
www.eastpasco.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 22 January 2001 : 20:04:14
|
Itwas just a thought.
could you do the following, put the ' ' back and put this line
response.write strSQL
response.end
just above the
my_conn.execute(strSQL)
Now in stead of the error, it will print the SQL string, could you copy this and post it.
Then remove the two lines you added.
MAny thanks
'Resistance is futile' |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 22 January 2001 : 20:25:37
|
That does nothing, but freak it out.. it loops all over the place.. I just keeps opening different windows.
My Demo Site
www.eastpasco.com |
|
|
|
kycable
New Member
USA
82 Posts |
Posted - 22 January 2001 : 21:55:17
|
quote:
Ok.. Now I get this:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/register.asp, line 300
Line 300> my_Conn.Execute (strSql)
My Demo Site
www.eastpasco.com
I am looking at your code right now, Line 300 is blank on the version you sent me... Are you adding anything else to the strSql lines?
Line 295 on mine... (It also depends on your editor as well) I am looking over it one more time to see what I can find out.
Jeff Brown
Web Zone Complete
<Snitz with many addons> |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 22 January 2001 : 22:08:54
|
Well I restored the Register.asp file and it's back to the old error
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forums/register.asp, line 294
My Demo Site
www.eastpasco.com |
|
|
|
Topic |
|
Topic Locked
