Field 'authkey' doesn't have a default value
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
Ross Fairbairn - Consulting
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/