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 INTOwp_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
- The topic ‘WordPress database error Column 'firstname' cannot be null for query INSERT …’ is closed to new replies.