Ich versuche gerade zusätzliche Datenfelder (ISBN und Autor) in Webs einzubauen. Dafür habe ich die admin/includes/modules/new_product.php und die admin/includes/classes/categories.php entsprechend erweitert und den folgenden sql Code in meiner DB ausgeführt.
Code: Alles auswählen
ALTER TABLE `products`
ADD `products_isbn` VARCHAR( 30 ) NOT NULL ,
ADD `products_author` VARCHAR( 80 ) NOT NULL;
Code: Alles auswählen
[WEB-Shop SQL Error]
/home/httpd/vhosts/engelis-naturshop.ch/httpdocs/inc/xtc_db_perform.inc.php:69
1054 - Unknown column 'products_autor' in 'field list'
update products set products_quantity = '10', products_model = '042230001', products_ean = '', products_isbn = '', products_autor = '', products_price = '57.073200', products_sort = '17', products_shippingtime = '11', products_discount_allowed = '0.00', products_date_available = '0000-00-00', products_date_expire = '0000-00-00', products_weight = '0.720', products_status = '1', products_startpage = '0', products_startpage_sort = '3', products_tax_class_id = '5', product_template = 'product_info_1.html', options_template = 'table_listing_attributes.html', manufacturers_id = '18', products_fsk18 = '0', products_vpe_value = '0.0000', products_vpe_status = '', products_vpe = '', products_image = '261a84bbf8d8c73f56952f1b5cf3fe2c.jpg', group_permission_0 = '1', group_permission_1 = '1', group_permission_3 = '1', google_category = 'Gesundheit & Schönheit > Gesundheitspflege > Fitness & Ernährung > Vitamine & Nahrungsergänzungsmittel', agi_google_export = '1', agi_google_online_only = '0', agi_google_condition = 'new', agi_google_adwords_grouping = '', agi_google_adwords_labels = '', agi_google_adwords_redirect = '', agi_google_excluded_destination = '', agi_google_expiration_date = '', agi_google_identifier_exists = '1', agi_google_products_brand = '', agi_google_energy_efficiency = '', agi_google_multipack_amount = '1', products_last_modified = now() where products_id = '1077'