Support

Home Forums Event Espresso Premium Posting new questions for registration forms, error began to occur

Posting new questions for registration forms, error began to occur

Posted: May 2, 2016 at 2:43 pm


Matthew Olden

May 2, 2016 at 2:43 pm

I have added several questions before this attempt and none had an issue.

An EE_Error exception was thrown! code: EEM_Base – _do_wpdb_query – 1851
“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_question’, 1 => array ( ‘QST_display_text’ => ‘Do you have range safety protection equipment? Commercial earmuffs and wrap around eye shields?’, ‘QST_admin_label’ => ‘range safety equipment’, ‘QST_system’ => ”, ‘QST_type’ => ‘CHECKBOX’, ‘QST_required’ => true, ‘QST_required_text’ => ‘This class requires time on the firing range for live fire exercises. We must know who needs to rent equipment.’, ‘QST_order’ => 13, ‘QST_admin_only’ => false, ‘QST_max’ => -1, ‘QST_wp_user’ => 1, ‘QST_deleted’ => false, ), 2 => array ( 0 => ‘%s’, 1 => ‘%s’, 2 => ‘%s’, 3 => ‘%s’, 4 => ‘%d’, 5 => ‘%s’, 6 => ‘%d’, 7 => ‘%d’, 8 => ‘%d’, 9 => ‘%d’, 10 => ‘%d’, ), )””
click to view backtrace and class/method details
/var/www/html/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php ( line no: 1851 )


Tony

  • Support Staff

May 3, 2016 at 2:22 am

Hi Matthew,

From the above it looks like no ‘value’ has been set for the checkbox – http://take.ms/BZjIi

If you try to re-create the question and provide a value and description before attempting to save the new question, does it work for you then?


Matthew Olden

May 3, 2016 at 10:47 am

I have completed all fields though. I have tried checkboxes and radio buttons and both have the same result.

http://take.ms/iI2oc


Matthew Olden

May 3, 2016 at 10:49 am

After the last failure just now, I used back button to reopen the add question page. I noticed the No value row was gone. I added and noticed it is not yellowed like it has been when I have been adding them the first time around. However, it still resulted in a failure.


Lorenzo Orlando Caum

  • Support Staff

May 3, 2016 at 11:25 am

Hi Matthew,

Are you familiar with a tool like Firebug or Chrome Developer Tools? If so, could you inspect that page and let us know if you see any errors? They are typically shown in red.


Lorenzo


Matthew Olden

May 3, 2016 at 12:20 pm

Using Chrome Dev Tools, I am viewing Elements and Script but do not see any items coming up as errors. Does not the WP_Debug log snippet explain anything?


Josh

  • Support Staff

May 3, 2016 at 2:09 pm

Yes, it provides a clue. It turns out that the Required Text field has a 100 character limit, and the text you input there exceeds the limit. Can you shorten the message for the Required Text field so it’s under 100 characters?


Matthew Olden

May 3, 2016 at 2:45 pm

Is that limitation on any required text field?


Matthew Olden

May 3, 2016 at 2:53 pm

I ensured all fields had no more than 100 characters (including spaces). Successful question creation achieved!

It would seem that field validation is in order here so users do not exceed available space per field. Or at least some notice somewhere on these forms or in the help file.


Josh

  • Support Staff

May 3, 2016 at 3:28 pm

Yes there’s an open ticket to add some field validation to that required text field.

The support post ‘Posting new questions for registration forms, error began to occur’ 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