Support

July 11, 2012 at 7:28 am

Hi,

There is a bug in Event Espresso when dealing with additional attendees and invoice payment.

In the pricing.php file from includes/functions/ directory on line 347:

$ice_row = $wpdb->get_row($wpdb->prepare(“select * from “.EVENTS_ATTENDEE_COST_TABLE.” inner join “.EVENTS_ATTENDEE_TABLE.” where registration_id = ‘%s'”,$registration_id));

there is a bug because the SQL doesn’t have the ON for INNER JOIN.

To fix it change it to this:

$ice_row = $wpdb->get_row($wpdb->prepare(“select * from “.EVENTS_ATTENDEE_COST_TABLE.” inner join “.EVENTS_ATTENDEE_TABLE.” on wp_events_attendee_cost.attendee_id = wp_events_attendee.id where registration_id = ‘%s'”,$registration_id));

• This topic was modified 11 years, 9 months ago by  mwilkinson.