Support

Home Forums Events Calendar Add-on SQL Error "`post_parent` cannot be NULL" when registering for event

SQL Error "`post_parent` cannot be NULL" when registering for event

Posted: May 18, 2017 at 5:27 am

Viewing 5 reply threads


Joseph Dell

May 18, 2017 at 5:27 am

EE 4.3.1.p
Wordpress 4.7.5
====
We suddenly started getting errors on our WordPress site yesterday when users are attempting to register for events.

Here is the error as shown in the debug log:

[18-May-2017 11:29:30] WordPress database error Column 'post_parent' cannot be null for query INSERT INTOwp_posts(post_title,post_content,post_name,post_date,post_excerpt,post_modified,post_author,post_parent,post_type,post_status) VALUES ('TEST NAME', 'No Biography Provided', 'test-name', '2017-05-18 07:29:30', 'No Biography Provided', '2017-05-18 07:29:30', 1, NULL, 'espresso_attendees', 'publish') made by do_action('wp_ajax_espresso_process_attendee_information'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, EED_Single_Page_Checkout::process_attendee_information, EED_Single_Page_Checkout->_process_attendee_information, EE_Base_Class->save, EEM_Base->insert, EEM_Base->_insert_into_specific_table
[18-May-2017 11:29:30] PHP Fatal error:  Uncaught exception 'EE_Error' with message 'Error inserting values Test Name,No Biography Provided,test-name,2017-05-18 07:29:30,No Biography Provided,2017-05-18 07:29:30,1,,espresso_attendees,publish for columns post_title,post_content,post_name,post_date,post_excerpt,post_modified,post_author,post_parent,post_type,post_status, using data types %s,%s,%s,%s,%s,%s,%d,%d,%s,%s, into table wp_posts. Error was Column 'post_parent' cannot be null' in /internal/path/to/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php:1253
Stack trace:
#0 /internal/path/to/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php(1125): EEM_Base->_insert_into_specific_table(Object(EE_Primary_Table), Array, false)
#1 /internal/path/to/wp-content/plugins/event-espresso-core-reg/core/db_classes/EE_Base_Class.class.php(972): EEM_Base->insert(Array, true)
#2 /internal/path/to/wp-content/plugins/event-espresso-core-reg/modules/single_page_checkout/EED_Singl in /internal/path/to/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php on line 1253
  • This topic was modified 7 years, 6 months ago by Tony. Reason: Fix code formatting


Tony

  • Support Staff

May 18, 2017 at 6:51 am

Hi there,

EE 4.3.1.p – is this the correct version number you are currently using on the site?

If so that version if over 2 years old, I recommend updating to the latest version and confirm if you have the same problem a there have been multiple bug fixes in both EE and WP since that version was released. The latest version (4.9.38.p) has all of the latest fixes to be compatible with the latest versions of WP.


Joseph Dell

May 18, 2017 at 7:11 am

Hello Tony,
So can the plugin be updated without purchasing a support license?

Thanks


Joseph Dell

May 18, 2017 at 7:23 am

Hello Tony,
So we would like some information on the licensing. We have 1 webpage using event espresso. We want the Event Espresso and the Event Espresso Calendar. What would be the pricing for this ?

Thanks


Josh

  • Support Staff

May 18, 2017 at 7:29 am

Hi Joseph,

It can be manually updated without a current support license. The one-click updates require a current support license.

https://eventespresso.com/wiki/how-to-upgrade-event-espresso/#ee4-manual-update

You’ll need a current support license to download the current version from your account page, but it’s also available on Github.


Joseph Dell

May 18, 2017 at 10:30 am

Thanks Tony and Josh,

We upgraded to EE 4.8.43.p (due to PHP 5.3 on CentOS 6) and this corrected the SQL error.

Viewing 5 reply threads

The support post ‘SQL Error "`post_parent` cannot be NULL" when registering for event’ 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