pafranklin Posted March 17, 2006 Posted March 17, 2006 I am receiving the following error which I need to fix urgently. 1054 - Unknown column 'p.products_ship_price' in 'field list' select p.products_ship_price, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '47' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] Please could someone tell me the MYSQL text / instruction to load into PHPMyadmin? Many thanks.[ You will never learn if you don't try. And boy am I trying....!
kgt Posted March 17, 2006 Posted March 17, 2006 You installed a products shipping contribution that modifys the products table. The install instructions would have provided a .sql file or SQL statement in the instructions which will correctly alter the table. You need to run this statement. Contributions Discount Coupon Codes Donations
pafranklin Posted March 17, 2006 Author Posted March 17, 2006 You installed a products shipping contribution that modifys the products table. The install instructions would have provided a .sql file or SQL statement in the instructions which will correctly alter the table. You need to run this statement. Hi there, I have tried that but for some reason when I run the MYSQL file I receive an error. I run this command---- INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES('300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (1001, 'Product Model', 'DISPLAY_MODEL', 'Display and allow modification', 'Configure the display and modification of the product model number', 300, 1, '2005-11-03 00:10:49', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1002, 'Product Name', 'DISPLAY_NAME', 'Display and allow modification', 'Configure the display and modification of the product name', 300, 2, '2005-11-03 00:10:59', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1003, 'Product Active Status', 'DISPLAY_STATUS', 'true', 'Configure the display and modification of the product status', 300, 3, '2005-09-29 15:04:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (1004, 'Product Weight', 'DISPLAY_WEIGHT', 'Display and allow modification', 'Configure the display and modification of the product weight', 300, 4, '2005-11-04 19:26:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1005, 'Product Quantity', 'DISPLAY_QUANTITY', 'Display and allow modification', 'Configure the display and modification of the product quantity', 300, 5, '2005-11-03 00:12:28', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1006, 'Product Image', 'DISPLAY_IMAGE', 'Do not display or modify', 'Configure the display and modification of the product image filename (The actual image is not displayed)', 300, 6, '2005-09-29 15:04:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1007, 'Product Manufacturer', 'DISPLAY_MANUFACTURER', 'Display and allow modification', 'Configure the display and modification of the product manufacturer', 300, 7, '2005-11-03 18:16:22', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1008, 'Vendor Name', 'DISPLAY_VENDOR', 'Do not display or modify', 'Configure the display and modification of the product vendor name', 300, 8, '2005-11-03 00:12:46', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1009, 'Vendor Cost', 'DISPLAY_VENDOR_COST', 'Do not display or modify', 'Configure the display and modification of the vendor product cost', 300, 9, '2005-11-03 00:12:54', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1010, 'Vendor Product Number', 'DISPLAY_VENDOR_NUM', 'Do not display or modify', 'Configure the display and modification of the vendor product number', 300, 10, '2005-11-03 00:13:12', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1011, 'Tax Class', 'DISPLAY_TAX', 'Display and allow modification', 'Configure the display and modification of the taxable status (Taxable Goods/-N/A-)', 300, 11, '2005-11-04 19:44:58', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1012, 'Display price with all included tax when mouse is over the item', 'DISPLAY_TVA_OVER', 'true', 'Enable/Disable the display of the Price with all tax included when your mouse is over a product', 300, 12, '2005-09-29 15:04:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (1013, 'Display price with all included tax while typing a new price.', 'DISPLAY_TVA_UP', 'false', 'Enable/Disable the display of the Price with all tax included when you are typing the price?', 300, 13, '2005-11-03 00:13:34', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (1014, 'Display a link to the product information page.', 'DISPLAY_PREVIEW', 'false', 'Enable/Disable the display of the link to the product information page', 300, 14, '2005-11-04 19:45:16', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (1015, 'Display the link to the page where you will be able to do a full', 'DISPLAY_EDIT', 'true', 'Enable/Disable the display of the link to the page where you will be able to do a full edit of the product', 300, 15, '2005-09-29 15:04:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (1016, 'Activate or deactivate the commercial margin.', 'ACTIVATE_COMMERCIAL_MARGIN', 'false', 'Do you want to activate the commercial margin markup-markdown ability?', 300, 16, '2005-11-03 00:14:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),'), (1017, 'Product Ship Price 1', 'DISPLAY_SHIP_PRICE', 'Display and allow modification', 'Configure the display and modification of the vendor product cost', 300, 17, '2005-09-29 15:04:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'), (1018, 'Product Ship Price 2', 'DISPLAY_SHIP_PRICE_TWO', 'Display and allow modification', 'Configure the display and modification of the vendor product cost', 300, 18, '2005-09-29 15:04:11', '2005-09-29 15:04:11', NULL, 'tep_cfg_select_option(array(''Do not display or modify'', ''Display Only'',''Display and allow modification''),'); The I receive the following error message: - SQL query: INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` ) VALUES ( '300', 'Quick Updates', 'Here you can configure what you will be able to modify in Quick Updates.', '300', '1' ) MySQL said: #1062 - Duplicate entry '300' for key 1 Any guidance please..???????? You will never learn if you don't try. And boy am I trying....!
kgt Posted March 17, 2006 Posted March 17, 2006 That error happens because you have already run the code and it ran successfully. Your first error suggests you have a contribution that altered the products table. It will be a statement like ALTER TABLE products... This is the statement you need to find and run. Contributions Discount Coupon Codes Donations
Recommended Posts
Archived
This topic is now archived and is closed to further replies.