Sql Fehler Nach Best?tigung Der Bestellung

[halufax]

hallo nach dem ich die bestellung best?tige bekomme ich diesen fehler

1054 - Unknown column 'delivery_firstname' in 'field list'

insert into orders (customers_id, customers_name, 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_address_format_id, payment_method, payment_class, shipping_method, shipping_class, billing_country_iso_code_2, 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', 'Ruben Seara', '', '', 'Motoidea.de', '0', 'Admin', 'admin_status.gif', '0.00', 'M?hringer Weg 98', '', 'Ulm', '89075', 'Baden-W?rttemberg', 'Germany', '0731 56324', 'seara@motoidea.de', '5', 'Ruben Seara', 'Ruben', 'Seara', 'Motoidea.de', 'M?hringer Weg 98', '', 'Ulm', '89075', 'Baden-W?rttemberg', 'Germany', 'DE', '5', 'Ruben Seara', 'Ruben', 'Seara', 'Motoidea.de', 'M?hringer Weg 98', '', 'Ulm', '89075', 'Baden-W?rttemberg', 'Germany', '5', 'cod', 'cod', 'flat', 'flat_flat', 'DE', '', '', '', '', '', '', '', now(), '1', 'EUR', '', '212.75.41.32', 'german', '')

[XT SQL Error]

Bitte um Hilfe

[_RosE_]

Hi kann es sein das du das Modul zum Datenaustausch von XTC und CAO benutzt bzw. ihrgendwann letztens ein update gemacht hat?

ich hatte den fehler wie oben beschrieben auch. es ging vorher ohne probleme. ihrgendwann tauchte der fehler dan auf.. und das einzige was ich geaendert habe waere eigentlich dieses import exort script

es haben dann auch noch ein stapel mehr felder in der tabelle gefehlt.
einfach in phpMyAdmin die fehlenden felder als varchar(32) anlegen

delivery_firstname
delivery_lastname
delivery_country_iso_code_2
billing_firstname
billing_lastname
billing_country_iso_code_2

klaube das waren alle die fehlten...
ich hoffe es hat geholfen und viel spass beim testen

gruss _RosE_

[_RosE_]

Hir mal nen SQL code zum fixen des "1054 - Unknown column 'delivery_firstname' in 'field list' "-Fehlers am Ende einer Bestellung:

ALTER TABLE `orders` 
ADD `delivery_firstname` VARCHAR( 64 ) NOT NULL , 
ADD `delivery_lastname` VARCHAR( 64 ) NOT NULL , 
ADD `delivery_country_iso_code_2` VARCHAR( 8 ) NOT NULL , 
ADD `billing_firstname` VARCHAR( 64 ) NOT NULL , 
ADD `billing_lastname` VARCHAR( 64 ) NOT NULL , 
ADD `billing_country_iso_code_2` VARCHAR( 8 ) NOT NULL;

gruss _RosE_

[kingsmedia]

hab den gleichen fehler aber der code hat nicht allzuviel geholfen

1054 - Unknown column 'cc_cvv' in 'field list'

insert into orders (customers_id, customers_name, customers_cid, 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_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, 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