[yotsume]

EDIT: Error SOLVED

I installed this on my vb3.7x site and i set everything up. I made one edit to the product file before I installed so that the profile message would only go out to new users that confirmed their email address.

I was able to register fine but I received the following database error:

Database error in vBulletin 3.7.4:

Invalid SQL:

                                INSERT INTO vb_attachmentviewslog (attachmentid, userid, dateline)
                                VALUES (146, 203, 1249125999);

MySQL Error   : Duplicate entry '146-203' for key 1
Error Number  : 1062
Request Date  : Saturday, August 1st 2009 @ 07:26:39 AM
Error Date    : Saturday, August 1st 2009 @ 07:26:41 AM
Script        : http://www.mysite.com/attachment.php?attachmentid=146
Referrer      : http://www.mysite.com/
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname     : vB_Database

So how can I fix this? The edit I did to change the hook location was: <hookname>register_activate_process</hookname>

EDIT: I solved my database error by changing the suggested hook edit in a previous post back to defalt. The mod now worked perfectly and my new user has a great new automated welcome message!

THANKS FOR THIS!