Crafter Posted March 1, 2021 Report Share Posted March 1, 2021 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') Quote Link to comment Share on other sites More sharing options...
Alex@4tfm Posted March 1, 2021 Report Share Posted March 1, 2021 Er hat es irgendwie geschaft keinen Vornamen in der Rechnungsadresse zu haben. Crafter 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.