Title: WordPress database error Column 'firstname' cannot be null for query INSERT … Last modified: August 31, 2016 --- # WordPress database error Column 'firstname' cannot be null for query INSERT … * [srcerer](https://wordpress.org/support/users/srcerer/) * (@srcerer) * [10 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-firstname-cannot-be-null-for-query-insert/) * My orders are failing to write to the WordPress database, however, the order gets processed through PayPal. The users are fully set up correctly in the database as well. * This started in February 2016. * WordPress is at version 4.4.2 (started on 2/5/2016 perhaps with automatic upgrade?) The Cart Press at 1.4.8.1 (current version 1.4.9.2). * This is the complete error: * [25-Feb-2016 19:25:56 UTC] WordPress database error Column ‘billing_firstname’ cannot be null for query INSERT INTO `wp_tcp_orders` (`created_at`, `customer_id`,` ip`, `weight`, `shipping_method`, `shipping_notice`, `shipping_class`, `shipping_instance`,` status`, `order_currency_code`, `shipping_amount`, `discount_amount`, `payment_name`,` payment_method`, `payment_amount`, `payment_notice`, `transaction_id`, `comment`,` comment_internal`, `code_tracking`, `shipping_firstname`, `shipping_lastname`,` shipping_company`, `shipping_street`, `shipping_street_2`, `shipping_city`, ` shipping_city_id`, `shipping_region`, `shipping_region_id`, `shipping_postcode`,` shipping_country`, `shipping_country_id`, `shipping_telephone_1`, `shipping_telephone_2`,` shipping_fax`, `shipping_email`, `billing_firstname`, `billing_lastname`, `billing_company`,` billing_tax_id_number`, `billing_street`, `billing_street_2`, `billing_city`,` billing_city_id`, `billing_region`, `billing_region_id`, `billing_postcode`, ` billing_country`, `billing_country_id`, `billing_telephone_1`, `billing_telephone_2`,` billing_fax`, `billing_email`) VALUES (‘2016-02-25 11:25:56’, 176, ‘XX.XXX.XXX. XXXX’, 0, ‘XXX XXXXXXXX’, ”, ‘TCPLocalPickUp’, ‘0’, ‘PENDING’, ‘USD’, 0.000000, 0.000000, ‘PayPal’, ‘TCPPayPal’, 0.000000, ”, ”, ‘XXXXXXXXXX’, ”, ”, ”, ”, ”,”,”,”,”,”,”,”,”,”,”,”,”,”, NULL, NULL, NULL, NULL, NULL, ”, NULL, ”, ”, ”, ”, ”, NULL, NULL, NULL, NULL, NULL) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template- loader.php’), include(‘/themes/XXXX/page.php’), get_template_part, locate_template, load_template, require(‘/themes/XXXX/loop-page.php’), the_content, apply_filters(‘ the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ActiveCheckout->show, TCPCheckoutManager->show, TCPCheckoutManager- >show_next_box, TCPCheckoutManager->show_next_box, TCPCheckoutManager->show_box, TCPCheckoutManager->create_order, Orders::insert [25 * [25-Feb-2016 19:25:56 UTC] WordPress database error Column ‘firstname’ cannot be null for query INSERT INTO `wp_tcp_addresses` (`customer_id`, `custom_id`,` default_shipping`, `default_billing`, `name`, `firstname`, `lastname`, `company`,` tax_id_number`, `company_id`, `street`, `street_2`, `city`, `city_id`, `region`,` region_id`, `postcode`, `country_id`, `telephone_1`, `telephone_2`, `fax`, `email`) VALUES (176, 0, ‘N’, ‘Y’, ”, NULL, NULL, NULL, ”, ‘0’, NULL, ”, NULL, ”, ”, ”, NULL, NULL, NULL, NULL, NULL, NULL) made by require(‘wp-blog-header.php’), require_once(‘ wp-includes/template-loader.php’), include(‘/themes/XXXX/page.php’), get_template_part, locate_template, load_template, require(‘/themes/XXXX/loop-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ActiveCheckout->show, TCPCheckoutManager->show, TCPCheckoutManager->show_next_box, TCPCheckoutManager->show_next_box, TCPCheckoutManager- >show_box, TCPCheckoutManager->create_order, TCPCheckoutManager->createNewBillingAddress, Addresses::save, Addresses::insert (END) * I will be updating the plugin and hopefully this error will go away. I thought this could be useful information for anyone else looking on a break that technically shouldn’t be happening. My plugin version isn’t that old. The WordPress upgrade was a step – not a full release. Seems odd that something so essential like a firstname is breaking. * Has anyone seen this? * Cheers, Jill * [https://wordpress.org/plugins/thecartpress/](https://wordpress.org/plugins/thecartpress/) Viewing 3 replies - 1 through 3 (of 3 total) * Plugin Author [Inigo Gonzalez](https://wordpress.org/support/users/inigoini/) * (@inigoini) * [10 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-firstname-cannot-be-null-for-query-insert/#post-7115696) * Hi, * In the checkout menu, Have you remove the billing box? * Best regards * Thread Starter [srcerer](https://wordpress.org/support/users/srcerer/) * (@srcerer) * [10 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-firstname-cannot-be-null-for-query-insert/#post-7115708) * Hi, * Yes, it’s always been this way. I’ve been using this plugin for several years. I don’t need billing addresses. These have been removed: * TCPSigninBox TCPBillingBox TCPShippingBox TCPNoticeBox * TheCartPress -> Addresses have hundreds of records that have hardly any data ( just Country filled in). There are several required fields. * The only change that was made was WordPress was automagically updated. Not clear why this would have triggered the database validation error for records that probably should not be created in the first place. * Any ideas? * Cheers, Jill * Plugin Author [Inigo Gonzalez](https://wordpress.org/support/users/inigoini/) * (@inigoini) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-firstname-cannot-be-null-for-query-insert/#post-7115729) * Hi, * TheCartPress doesn’t support to remove billing box(it’s ready to create different billing boxes, but not remove all of them). * You could modify the database and set the address table to allow null values in all fields. * Or * You could add the billing box and set visible and required only first and last name fields. * Best regards Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘WordPress database error Column 'firstname' cannot be null for query INSERT …’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/thecartpress_fefefe.svg) * [TheCartPress eCommerce Shopping Cart](https://wordpress.org/plugins/thecartpress/) * [Frequently Asked Questions](https://wordpress.org/plugins/thecartpress/#faq) * [Support Threads](https://wordpress.org/support/plugin/thecartpress/) * [Active Topics](https://wordpress.org/support/plugin/thecartpress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/thecartpress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/thecartpress/reviews/) * 3 replies * 2 participants * Last reply from: [Inigo Gonzalez](https://wordpress.org/support/users/inigoini/) * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-firstname-cannot-be-null-for-query-insert/#post-7115729) * Status: not resolved