Registration dbase error

When I turn email-verification (user needs to activate upon receiving email) on, after hitting submit on a registration, a database error shows. If i disable it, everything works fine. I did do a number of hacks but everything else works fine so I doubt it is directly related.

Is there anything specific I should be looking at?

thx

[Lesane]

Today at 12:59 AM DiscussAnything said this in Post #9
Which 6 are there supposed to be in 2.3.0 ?

The 6 fields wich you have are fine. It's the line in register.php that causes the error!

[DiscussAnything]

this is the register.php bit about it

PHP Code:

    //save to DB
        $DB_site->query("INSERT INTO useractivation VALUES (NULL,'$userid','".time()."','$activateid',0)"); 


if I add ,3 after the zero, making it default to 'awaiting confirmation', would that work??

[Lesane]

It would work yes but not 100% because there is also a usergroup called '(COPPA) Users Awaiting Moderation' wich is benifical here.

[DiscussAnything]

The original is

PHP Code:

//save to DB
    $DB_site->query("
        INSERT INTO useractivation
            (useractivationid, userid, dateline, activationid, type, usergroupid)
        VALUES
            (NULL, $userid, ".time().", '$activateid', 0, " . iif($newusergroupid == 4, 4, 2) . ")
    ");

    eval("\$message = \"".gettemplate("email_activateaccount",1,0)."\";");
    eval("\$subject = \"".gettemplate("emailsubject_activateaccount",1,0)."\";");

    vbmail($email, $subject, $message);

  } 


My current one is:

PHP Code:

//save to DB
        $DB_site->query("INSERT INTO useractivation VALUES (NULL,'$userid','".time()."','$activateid',0)");

    eval("\$message = \"".gettemplate("email_activateaccount",1,0)."\";");
    eval("\$subject = \"".gettemplate("emailsubject_activateaccount",1,0)."\";");

    mail ($email,$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>");

  } 


I dont think Ive changed this, although I'll go over the hacks again. Still weird though that a whole section disappeared... I think I'll just reset it to what it's supposed to be and see if that works

[Lesane]

It's changed. :lick:

If you change those current lines with the original then you are done.

[DiscussAnything]

i'll give it a shot. At least now I have an idea where to look, I wouldnt have found this by myself. Thanks for the help, I appreciate it

[Lesane]

You're Welcome