Form App used. When entering the Donor Form I get the above error. When i re-enter the data the form goes through. On the Before Insert Event I do this check:
if({pswd} != {confirm_pswd})
{
sc_error_message({lang_error_pswd});
sc_error_exit();
}
{pswd} = md5({pswd});
if({login} != {email})
{
sc_error_message(‘Error: Email does not match’);
sc_error_exit();
}
/**
- Check for an existing Donor record
*/
// SQL statement parameters
$check_table = ‘n_user_donors_and_admin’; // Table name
$check_where = “Identity_Number = ‘{Identity_Number}’”; // Where clause
// Check for record
$check_sql = ‘SELECT *’
. ’ FROM ’ . $check_table
. ’ WHERE ’ . $check_where;
sc_select(dataset, $check_sql);
if (false == {dataset})
{
// Error while accessing database
}
elseif ({dataset}->EOF)
{
// No Donor record found
/**
* Insert a record on another table
*/
// SQL statement parameters
$insert_table = 'n_user_donors_and_admin'; // Table name
$insert_fields = array( // Field list, add as many as needed
'E_mail' => "'{login}'",
'First_Name' => "'{name}'",
'Last_Name' => "'{surname}'",
'Identity_Number' => "'{Identity_Number}'",
'How_Did_You_Hear_About_Us' => "'{How_Did_You_Hear_About_Us}'",
'Registration_Type' => "'Website'",
'Date_Joined' => "'{Form_Date}'"
);
// Insert record
$insert_sql = 'INSERT INTO ' . $insert_table
. ' (' . implode(', ', array_keys($insert_fields)) . ')'
. ' VALUES (' . implode(', ', array_values($insert_fields)) . ')';
sc_exec_sql($insert_sql);
}
else
{
// Donor Record found
sc_redir(control_donor_user_already_exists);
}
/**
- Check for an existing User record
*/
// SQL statement parameters
$check_table = ‘sec_v8_publicusers’; // Table name
$check_where = “Identity_Number = ‘{Identity_Number}’”; // Where clause
// Check for record
$check_sql = ‘SELECT *’
. ’ FROM ’ . $check_table
. ’ WHERE ’ . $check_where;
sc_select(dataset, $check_sql);
if (false == {dataset})
{
// Error while accessing database
}
elseif ({dataset}->EOF)
{
// No User record found
}
else
{
// User Record found
sc_redir(control_donor_user_already_exists);
}
And on the After Insert This:
send_mail_to_admin();
send_mail_to_new_user();
sc_commit_trans(“conn_mysql”);
[name] = {name};
[surname] = {surname};
[email] = {login};
[identity] = {Identity_Number};
In desperation I even setup a link to try and force stability. Did not work.