i trying archive table off copying it's data database on same server. gives me headache copying between databases, exported table , tried import archive database. when gives me following error:
#1054 - unknown column 'showorder' in 'field list' this happens whether build exact (including showorder column same properties) copy, or try straight import it. not sure doing wrong. assistance helpful.
error sql query:
--
-- database: db_cherry
--
-- dumping data table product
insert product (p_id, cat_id, cat_name, midas_ref_code, product_name, product_des, spanish_name, prd_img_path, prd_img_name, prd_id, prd_price, prd_quantity, prd_add_date, prd_modify_date, prd_avail_date, prd_weight, prd_length, prd_width, prd_height, prd_sales, featured, status, main_cart, vip_cart, tax_id, showorder) values ('', '31', '', 0, '', '', '', '', '', null, 0.00, 0, '2015-09-03 17:29:03', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', 0, '', 'active', '', '', '', 0), ('0039', '6', 'the candy store', 2, '0039 chocolate caramel squares', 'caramel inside milk chocolate shells. boxed. 6 oz. ', 'cuadritos de chocolate con caramelo', '../images/products/detail/', '0039.jpg', null, 9.50, 721, '2014-09-15 20:15:18', '2016-05-27 08:23:05', '0000-00-00 00:00:00', 'null', 'null', 'null', 'null', 1129, 'not active', 'not active', 'no', '[...]
mysql said: documentation
1054 - unknown column 'showorder' in 'field list'
Comments
Post a Comment