Codeigniter插入批处理不起作用

Question

我的功能是：

function saveproduct($p_arrProductInfo,$p_arrProductLangInfo){
        $this->db->trans_start();       
        $this->db->insert_batch('t_product', $p_arrProductInfo);    
        $this->db->insert_batch('t_productlang', $p_arrProductLangInfo); 
        $this->db->trans_complete();    
}

我的错误是：

/*
* 提示：该行代码过长，系统自动注释不进行高亮。一键复制会移除系统注释 
* INSERT INTO t_productlang (a_active, a_availablefororder, a_categorydefaultid, a_condition, a_createdby, a_createddate, a_ean13, a_ecotax, a_manufacturerid, a_onlineonly, a_onsale, a_price, a_productid, a_quantity, a_reference, a_showprice, a_styleguideurl, a_supplierid, a_upc, a_weight, a_wholesaleprice, a_createdby, a_createddate, a_description, a_descriptionshort, a_lang, a_linkrewrite, a_metadescription, a_metakeywords, a_metatitle, a_name, a_productid, a_shopid, a_tags) VALUES ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'1',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'2',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'3',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'4',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'5',''), ('1','2013-03-28 07:10:24','<p>With a contemporary approach to the latest fashion trends, <strong>People</strong> is a brand that gives a completely modern spin to ethnic wear for women.</p><p>This <strong>3/4 sleeved, printed, short kurta</strong> boasts of a <strong>printed yoke</strong> and a <strong>pleated front</strong>. Pair it with a fitted churidar for a style statement that will definitely make heads turn wherever you go. Buy online now!</p>','Featuring People's Ethnic, All-over print Short Kurta with a Band Collar, 3/4th sleeve and . It comes in Regular Fit. Wash as indicated on label.','1','printed-band-collar-kurta','Buy PEOPLE Dupatta & Kurta for women at Trendin.com - Shop online for Printed Band Collar Kurta for women at best price with Free Shipping & 15 days Exchange policy','printed band collar kurta, women kurta, women dupatta, buy kurta online, buy dupatta online, kurta dupatta online shop, buy kurta for women, kurtis online, online kutis for sale, trendin','PEOPLE Kurta & Dupatta Online -Printed Band Collar Kurtaat Trendin.com','Printed Band Collar Kurta',3629,'6','')
*/

实际上，第一个和第二个arr键和值正在事务中合并，它显示发生了一个数据库错误

   Error Number: 1136 Column count doesn't match value count at row 1

Answer 1

非常简单，error clear说明了这一点。

我看到你对记录1的查询，它提到了34列，只给出了27列值。存在不匹配。