Field 'authkey' doesn't have a default value

Hi Tim

Thanks for posting.

I think what's happening here is you are using a recent version of Newsletter Builder.

Version 3 and higher no longer has the function "_nlb_generateAuthKey()".

What you'll want to do is instead is something like this:

// generate auth key - example: 64a3fb69cc - over a trillian possible values (16**10)
$authkey = substr( md5(mt_rand()), 0, 12 );

$colsToValues = array('email'          => $_REQUEST['email'],
                      'first_name'     => $_REQUEST['fullname'],
                      'phone'          => $_REQUEST['phone'],
                      'authkey'        => $authkey
                 );

$recordNum = mysql_insert('_nlb_subscribers', $colsToValues, true);
$subscriber = mysql_get('_nlb_subscribers', $recordNum);


Does that make sense?

Give it a shot and let me know any questions

Thanks Ross - that's done the trick.