When completed the checkout: Signup data (attendees) not inserted into signup_log tables

Did you install the required version and patches for the signup module?

hi puneet,
After applying all required patches for signup.module , still i am facing the same problem.
Attendees information is not inserting in the database.
My case is :
1. User can select multiple events at same time.
2. More than 1 qty can be purchased for single event.

The proble is that, attandees data are not inserting into the database after complete checkout/payment with paypal.

I have work around for the problem & find that there is no 'submit' value found in $op variable befor or after checkout in function uc_signup_order($op, &$arg1, $arg2).

but If i changed the case value to 'can_update' it will work fine for me , but just inserting only attendees info for single event, not for multiple events.

But for the second issue I have again look into the uc_signup.module file & modify uc_signup_order($op, &$arg1, $arg2) function a bit.

Here is the modified code:

foreach ($_SESSION['uc_signup']['nids'] as $nid => $attendees) {

foreach ($attendees as $key => $mail) {
$account = user_load(array('mail' => $mail));
if (empty($account->uid)) {
$new_account['mail'] = $mail;
$namenew = preg_replace('/@.*$/', '', $mail);
// From the email registration module:
if (db_result(db_query("SELECT count(*) FROM {users} WHERE LOWER(name) = LOWER('%s')", $namenew)) > 0) {
// Find the next number available to append to the name
$sql = "SELECT SUBSTRING_INDEX(name,'_',-1) FROM {users} WHERE name REGEXP '%s' ORDER BY CAST(SUBSTRING_INDEX(name,'_',-1) AS UNSIGNED) DESC LIMIT 1";
$nameidx = db_result(db_query($sql, '^'. $namenew .'_[0-9]+$'));
$namenew .= '_'. ($nameidx + 1);
}
$new_account['name'] = $namenew;

$profile_form = array_values(module_invoke('profile', 'user', 'register', array(), (object)array()));
if (!empty($profile_form)) {
$profile_form = $profile_form[0];
foreach ($profile_form as $key => $value) {
if ($key[0] != '#') {
$new_account[$key] = $_SESSION['uc_signup']['profile'][$key .'_'. $mail];
}
}
}

$account = user_save(NULL, $new_account);
}
$to_signup[$nid][] = $account->uid;
}

// First, create accounts for emails that don't have accounts.
//uc_signup_cancel_temporary_signups($order);
$placeholders = '';
global $user;
// TODO: check if there are any signups to create.
//Make sure that there are enough spots before continuing. If there are not enough spots, the order should fail.
foreach ($to_signup as $nid => $value) {
$spots_remaining = uc_signup_spots_remaining(array('nid' => $nid));
if (count($to_signup[$nid]) > $spots_remaining) {
$insufficient_space[] = $nid;
$message .= _uc_signup_limit_reached_message($spots_remaining, array('nid' => $nid));
}
if (!empty($insufficient_space)) {
$message .= t("Events can fill up rapidly, and people may have signed up since you added these events to your cart. Please adjust the quantity before checking out.");
return array(array('pass' => FALSE, 'message' => t($message)));
}
}

foreach ($to_signup[$nid] as $key => $uid) {
$signup_form = array(
'nid' => $nid,
'uid' => $uid,
);
$sid = NULL;
$sid = signup_sign_up_user($signup_form, FALSE);
drupal_set_message($sid);
if (is_numeric($sid)) {
db_query("INSERT INTO {uc_signup_log} (oid, sid, type) VALUES (%d, %d, %d)", $arg1->order_id, $sid, 0);
}
}
}
}

In the above code I have put
foreach ($to_signup[$nid] as $key => $uid) {
$signup_form = array(
'nid' => $nid,
'uid' => $uid,
);
$sid = NULL;
$sid = signup_sign_up_user($signup_form, FALSE);
drupal_set_message($sid);
if (is_numeric($sid)) {
db_query("INSERT INTO {uc_signup_log} (oid, sid, type) VALUES (%d, %d, %d)", $arg1->order_id, $sid, 0);
}
}
Part of code inside the
foreach ($_SESSION['uc_signup']['nids'] as $nid => $attendees) {
loop for inserting multiple attendees information for multiple events.It work fine for me, but i am not sure if it works for all condition's. please can anyone help me to guide if it is ok or I have to do somthing more.

In my previous post, I have also commented the
uc_signup_cancel_temporary_signups($order) function coz this function will delete data from uc_signup_log,singup_log tables against a Order_id.

I have no idea what you are talking about when you say there is no 'submit' op for hook_order. See http://www.ubercart.org/docs/api/hook_order .

I'm not clear on the problem you're having, but I just found and fixed #530396: Signups not created for more than 1 event per cart, so this might address the issue you're experiencing.

Is paypal set to capture immedietly? It should be. The order pending status sounds like it paypal is not processing the payment when the order is submitted. From the uc_signup project page: "Once checkout is complete, if the order balance is not cleared, the signups are cancelled. If the balance is cleared, the signups are converted from temporary to final signups."

Also, I just rolled a new beta, which requires Signup.module RC4.

1) This sounds like a bug report that should go to signup.module. In any case, users on your site should not have the "sign up for content" permissions.
2) You're saying you don't know where this setting is but you set it already? It's at http://new.aussiepd.com/admin/store/settings/payment/edit/gateways .

Please re-open this issue if you're still having this problem.

I'm having the same problem as described in the original post. Signups are not being saved in the db.

I'm currently using:
uc_signup 6.x-1.0-beta3
signup 6.x-1.0-rc4

When testing with the 'Test Gateway' payment method, things were working fine. But, when using 'PayFlow Link' or 'PayPal Website Payments Standard', the signups are not saved. The 'submit' block in uc_signup_order is not being called.

from docs on http://www.ubercart.org/docs/api/hook_order:
submit - When a sale is being completed and the customer has clicked the Submit order button from the checkout screen, the hook is invoked with this op.

I think this is the problem:

Both 'PayFlow Link' and 'PP WPS' alter the form on the 'Review Order' checkout screen. They unset the submit button and add a new one that redirects to the payment forms at paypal.

Any help would be greatly appreciated.

seems like this may be a duplicate of http://drupal.org/node/540298

I can confirm the same problem:

D6.13
ubercart 6.x-2.0-rc3
uc_signup 6.x-1.0-beta3
signup 6.x-1.0-rc4

uc_signup conditional actions are in place

using credit cart/test gateway the transaction goes as expected; the user is added to the signup list.

using paypal web payment standard on the sandbox server completes the payment, but the user is not added to the signup list, and no signup generated confirmation emails are sent (to either the Admin or the user). (UC's payment confirmation emails are sent OK)

I'm excited about this module, I hope this can be resolved!

I'm marking this a duplicate of #540298: Signups not created when off-site payment methods fail to call hook_order case submit.. Let's solve this over there.