halufax Posted June 1, 2005 Report Share Posted June 1, 2005 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', '[email protected]', '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 Link to comment Share on other sites More sharing options...
_RosE_ Posted March 9, 2006 Report Share Posted March 9, 2006 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_ Link to comment Share on other sites More sharing options...
_RosE_ Posted March 9, 2006 Report Share Posted March 9, 2006 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_ Link to comment Share on other sites More sharing options...
kingsmedia Posted March 25, 2006 Report Share Posted March 25, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.