Jump to content
xt:Commerce Community Forum

MySQL Error 'billing_firstname' cannot be null


Crafter
 Share

Recommended Posts

Hallo zusammen,

in letzter Zeit bekommen wir in unserem xt6.2 Shop häufig einen MySQL Error "Column 'billing_firstname' cannot be null". Allerdings nur bei einem bestimmten Kunden. Dieser hat bereits zwischen 2016-2018 erfolgriech bei uns bestellt, kann aber wie es aussieht neuerdings aufgrund des Fehlers keine Bestellungen mehr bei uns tätigen. Die Fehlermeldung habe ich anonymisiert unten angehangen. Die Kunden Adresse selbst ist nicht auffällig. Ich kann da im Vergleich zu anderen Kundenkonten/Adressen nichts merkwürdiges erkennen. Unter "address_class" ist in der xt_customers_address Tabelle "shipping" angegeben. Es besteht kein extra Eintrag für die Rechnungsadresse, aber wird dann nicht automatisch die Lieferadresse genommen?

Viele andere Kunden scheinen auch nur eine der beiden Adressen angegeben zu haben. 

mysqli error: [1048: Column 'billing_firstname' cannot be null] in EXECUTE("INSERT INTO xt_orders ( CUSTOMERS_ID, CUSTOMERS_CID, CUSTOMERS_VAT_ID, CUSTOMERS_STATUS, CUSTOMERS_EMAIL_ADDRESS, DELIVERY_GENDER, DELIVERY_TITLE, DELIVERY_PHONE, DELIVERY_MOBILE_PHONE, DELIVERY_FAX, DELIVERY_FIRSTNAME, DELIVERY_LASTNAME, DELIVERY_COMPANY, DELIVERY_COMPANY_2, DELIVERY_COMPANY_3, DELIVERY_STREET_ADDRESS, DELIVERY_ADDRESS_ADDITION, DELIVERY_SUBURB, DELIVERY_CITY, DELIVERY_POSTCODE, DELIVERY_ZONE, DELIVERY_ZONE_CODE, DELIVERY_COUNTRY, DELIVERY_COUNTRY_CODE, DELIVERY_FEDERAL_STATE_CODE, DELIVERY_FEDERAL_STATE_CODE_ISO, DELIVERY_ADDRESS_BOOK_ID, BILLING_GENDER, BILLING_TITLE, BILLING_PHONE, BILLING_MOBILE_PHONE, BILLING_FAX, BILLING_FIRSTNAME, BILLING_LASTNAME, BILLING_COMPANY, BILLING_COMPANY_2, BILLING_COMPANY_3, BILLING_STREET_ADDRESS, BILLING_ADDRESS_ADDITION, BILLING_SUBURB, BILLING_CITY, BILLING_POSTCODE, BILLING_ZONE, BILLING_ZONE_CODE, BILLING_COUNTRY, BILLING_COUNTRY_CODE, BILLING_FEDERAL_STATE_CODE, BILLING_FEDERAL_STATE_CODE_ISO, BILLING_ADDRESS_BOOK_ID, PAYMENT_CODE, SHIPPING_CODE, CURRENCY_CODE, CURRENCY_VALUE, LANGUAGE_CODE, COMMENTS, LAST_MODIFIED, DATE_PURCHASED, ACCOUNT_TYPE, ALLOW_TAX, CUSTOMERS_IP, SHOP_ID, CAMPAIGN_ID, EXTERNAL_ID ) VALUES ( 23202, '1031375', '', 11, '[email protected]', '', '', '', '', '', 'Max', 'Mustermann', 'Musterfirma', '', '', 'Muster Str. 42', '', '', 'Musterstadt', '936963', '31', null, 'Deutschland', 'DE', 0, null, 78204, null, null, null, null, null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, null, null, null, 'xt_paypal_plus', 'DPDEU', 'EUR', 1.00000000, 'de', '', '2020-02-26 16:06:50', '2021-03-01 17:44:24', 0, 1, null, 1, 0, null )")
#0 /home/user/shop/xtFramework/library/adodb-5.20.14/adodb.inc.php(1282): ADODB_Error_Handler(...)
#1 /home/user/shop/xtFramework/library/adodb-5.20.14/adodb.inc.php(1246): _Execute(...)
#2 /home/user/shop/xtFramework/library/adodb-5.20.14/adodb.inc.php(2198): Execute(...)
#3 /home/user/shop/xtFramework/classes/class.order.php(618): AutoExecute(...)
#4 /home/user/shop/xtFramework/classes/class.order.php(205): _saveCustomerData(...)
#5 /home/user/shop/xtFramework/classes/class.checkout_base.php(435): _setOrder(...)
#6 /home/user/shop/xtFramework/classes/class.checkout_base.php(203): process_pageAction_process(...)
#7 /home/user/shop/xtCore/pages/checkout.php(57): process_pageAction(...)
#8 /home/user/shop/index.php(127): include('/home/user/shop/xtCore/pages/checkout.php')

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
  • Create New...