Support

January 28, 2014 at 12:26 pm

Hi Al,

I think what you’ll need to try is set up a clone of your site and run an unmodified copy of the latest version of Event Espresso installed on it. If you get the same errors on the dev site, please send an export of the database and we can take a look.

January 29, 2014 at 5:37 am

Hi,

Unless you own and control the server then yes server changes are very much a possibility. I would speak to your host to clarify if any changes have been made recently and if so what they are.

You may also want to try a “diff” on the event espresso files on the live server versus the clone server to see if there have been modifications made recently that haven’t been accounted for (and possibly causing the issue).

January 30, 2014 at 2:25 am

Hi Al,

So currently is the edit_attendee_record.php on the server the same as the latest version of Event Espresso? (which currently is 3.1.36.4)

Reason I ask, is the Line numbers do no match with the version I have.

The reason the SQL is failing is $question_id is not being set. You can see this from this part of the SQL

'WHERE qgr.group_id in ( ) ORDER BY'

So in slightly better english ‘WHERE qgr.group_id is in “nothing”‘.

$question_id should be set on lines 291 – 305

$SQL = "SELECT question_groups, event_meta FROM " . EVENTS_DETAIL_TABLE . " WHERE id = %d";
$questions = $wpdb->get_row( $wpdb->prepare( $SQL, $event_id ));

$question_groups = unserialize($questions->question_groups);
			$event_meta = unserialize($questions->event_meta);

if ( $is_additional_attendee && isset($event_meta['add_attendee_question_groups']) && $event_meta['add_attendee_question_groups'] != NULL) {
	$question_groups = $event_meta['add_attendee_question_groups'];
}

$questions_in = '';
foreach ($question_groups as $g_id ) {
	$questions_in .= $g_id . ',';
}
$questions_in = substr($questions_in, 0, -1);

There is no check if the event is active, it just pulls all question_groups and event_meta from the events table where the event_id matches.

So it looks like that is returning nothing, which should never happen (as you should always have at least personal information (so at least 1 question group))

So something has changed with either/and/or questions, question groups, event_meta or the event_id.

Nothing regarding that page has been modified though.

If its the questions/question_groups it does’t need to be within this page. It could be almost anywhere that the questions/groups are updated.

Unfortunately as this is a modified version of Event Espresso (also with updates from current versions), that’s about as much info as we can give you as we just don’t know what has been changed, and the knock on effect of any changes that have been made.

The question groups may also be a red herring if changes are made when events become inactive/expired (as that seems to be the only time you have an issue) but that SQL above doesn’t look at the event status.

Have you tried temporarily making the event active and edit the record to see if it update then?

January 30, 2014 at 2:34 pm

Might be different versions of MySQL installed on your dev server compared to your live server.

February 4, 2014 at 3:51 pm

The event id is set in the POST of the form. Do an element inspect on the ‘Update Record’ button. Above the button there should be a hidden input with name=’event_id’. Should be generated by line 664 of includes/admin-reports/edit_attendee_record.php (current version).