• srcerer

    (@srcerer)


    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://www.ads-software.com/plugins/thecartpress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Inigo Gonzalez

    (@inigoini)

    Hi,

    In the checkout menu, Have you remove the billing box?

    Best regards

    Thread Starter srcerer

    (@srcerer)

    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

    (@inigoini)

    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.