Support

Home Forums Event Espresso Premium Registration could not be completed and DB errors

Registration could not be completed and DB errors

Posted: May 7, 2015 at 11:08 am

Viewing 7 reply threads


vste

May 7, 2015 at 11:08 am

Greetings!

Some users are reporting to us that they are unable to register for events we create. They provided the following screenshots:

Error 1
Error 2

I turned on debug logging for this and the following was outputted (user details removed):


[07-May-2015 16:13:49 UTC] PHP Fatal error: Uncaught exception 'EE_Error' with message 'WPDB Error occurred, but no error message was logged by wpdb! The wpdb method called was "insert" and the arguments were "array (
0 => 'wp_esp_attendee_meta',
1 =>
array (
'ATT_fname' => '########',
'ATT_lname' => '########',
'ATT_address' => '########',
'ATT_address2' => '########',
'ATT_city' => '########',
'STA_ID' => ########,
'CNT_ISO' => '########',
'ATT_zip' => '########',
'ATT_email' => '########',
'ATT_phone' => '########',
'ATT_ID' => ########,
),
2 =>
array (
0 => '%s',
1 => '%s',
2 => '%s',
3 => '%s',
4 => '%s',
5 => '%d',
6 => '%s',
7 => '%s',
8 => '%s',
9 => '%s',
10 => '%d',
),
)"' in /home/vsteorg/public_html/events/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php:1437
Stack trace:
#0 /home/vsteorg/public_html/events/wp-content/plugins/event-espresso-core-reg/core/db_models/E in /home/vsteorg/public_html/events/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php on line 1437
[07-May-2015 16:19:40 UTC] PHP Fatal error: Uncaught exception 'EE_Error' with message 'WPDB Error occurred, but no error message was logged by wpdb! The wpdb method called was "insert" and the arguments were "array (
0 => 'wp_esp_attendee_meta',
1 =>
array (
'ATT_fname' => '########',
'ATT_lname' => '########',
'ATT_address' => '########',
'ATT_address2' => '########',
'ATT_city' => '########',
'STA_ID' => ########,
'CNT_ISO' => '########',
'ATT_zip' => '########',
'ATT_email' => '########',
'ATT_phone' => '########',
'ATT_ID' => ########,
),
2 =>
array (
0 => '%s',
1 => '%s',
2 => '%s',
3 => '%s',
4 => '%s',
5 => '%d',
6 => '%s',
7 => '%s',
8 => '%s',
9 => '%s',
10 => '%d',
),
)"' in /home/vsteorg/public_html/events/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php:1437
Stack trace:
#0 /home/vsteorg/public_html/events/wp-content/plugins/event-espresso-core-reg/core/db_models/E in /home/vsteorg/public_html/events/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php on line 1437


Lorenzo Orlando Caum

  • Support Staff

May 7, 2015 at 12:46 pm

Hi Karen,

One of your questions is likely being repeated multiple times under the same registrant/attendee. Could you check for duplicates and remove it via the Question group in the WP dashboard?

If you do need to capture the same question twice, then create an additional one.

Essentially, its failing as its trying to add two pieces of information to one question.


Lorenzo


vste

May 7, 2015 at 4:24 pm

So the odd thing is that we’ve had 28 people register with no issues but now we’re getting this report. Just checked and there weren’t any duplicates. Even tested just now and was able to register after filling out every field in the form and it went through. Not sure if this could be a browser issue or what is going on.


Lorenzo Orlando Caum

  • Support Staff

May 8, 2015 at 6:32 am

Hi Karen, could you provide a link to one of your events?


Lorenzo


vste

May 12, 2015 at 4:30 pm

Hi Lorenzo,

Here’s a link to the event: redacted – Event Espresso support team – LOC. We’ve had plenty of successful registrations but for a few folks even trying multiple times doesn’t seem to work. Perhaps something with their connection or something that’s not getting passed properly. We’ve just been manually registering those folks that have issues but haven’t been able to nail down what the issue exactly is.


Lorenzo Orlando Caum

  • Support Staff

May 12, 2015 at 5:49 pm

Hi Karen, I did not see any errors on your registration checkout page. Could you update to the latest version and monitor this issue?

https://eventespresso.com/wiki/ee4-changelog/

It would also be helpful to know the web browser that is being used by attendees that are having trouble registering.


Lorenzo


vste

May 12, 2015 at 7:02 pm

Yeah updating to the latest code was one of the first things we tried. The attendee tried both Chrome and IE and got errors in both. It’s quite likely it’s something on their end, just an odd error.


Dean

May 13, 2015 at 2:11 am

Hi,

I also ran a test registration (It will say TEST everywhere) and did not have any issues.

The second error we have only ever seen when there is a duplicate question in the registration form so it’s odd it’s showing when you say there are none. Even more strange is that it’s an intermittent failure.

If this issue occurs again, please try and grab as much data as possible (event name, tickets selected, users browser type and version, home computer or business network, etc.).

Viewing 7 reply threads

The support post ‘Registration could not be completed and DB errors’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso