Ich habe gerade mal wieder kurz "geswitched" und versucht eine bestellung aufzugeben.
Hier das Ergebnis:
1406 - Data too long for column 'shipping_method' at row 1
insert into orders (customers_id, customers_name, customers_firstname, customers_lastname, customers_cid, customers_vat_id, customers_company, customers_status, customers_status_name, customers_status_image, customers_status_discount, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_firstname, delivery_lastname, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_country_iso_code_2, delivery_address_format_id, billing_name, billing_firstname, billing_lastname, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_country_iso_code_2, billing_address_format_id, payment_method, payment_class, shipping_method, shipping_class, cc_type, cc_owner, cc_number, cc_expires, cc_start, cc_cvv, cc_issue, date_purchased, orders_status, currency, currency_value, customers_ip, language, comments) values ('1', 'Thomas Huhn', 'Thomas', 'Huhn', '94', '', 'DITH-Software', '0', 'XXXXXX', 'admin_status.gif', '0.00', 'Feldstrasse 94', '', 'Herten', '45699', 'Nordrhein-Westfalen', 'Deutschland', '+49 (2366) 5009870', 'XXXXXX@dith.de', '5', 'Thomas Huhn', 'Thomas', 'Huhn', 'DITH-Software', 'Feldstrasse 94', '', 'Herten', '45699', 'Nordrhein-Westfalen', 'Deutschland', 'DE', '5', 'Thomas Huhn', 'Thomas', 'Huhn', 'DITH-Software', 'Feldstrasse 94', '', 'Herten', '45699', 'Nordrhein-Westfalen', 'Deutschland', 'DE', '5', 'cash', 'cash', 'Selbstabholung (Selbstabholung der Ware in unserer Geschäftsstelle.)', 'selfpickup_selfpickup', '', '', '', '', '', '', '', now(), '1', 'EUR', '', '195.4.61.129', 'german', '')
[XT SQL Error]
(Keine Panik, meine Daten dürfen ruhig öffentlich sichtbar sein...)
Die entsprechenden Einstellungen (MySQL-Admin) sehen hier so aus:
http://195.4.61.129/UBB-Forum/Bilder/sonst/mysql5.jpg