query does not work
INSERT INTO products_description (products_id, language_code, products_description, store_id, language_id, products_url, products_name, products_comparison, products_viewed) VALUES (6, en, 'Test prod - English', 'store1', 1, 'www.testprod.co.uk', 'Test Prod - E', 'Comparison - English', 0);
...
com.konakartadmin.app.KKAdminException: Exception Message = (org.apache.torque.TorqueException) - com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6-1' for key 'PRIMARY'<br/><br/>Exception Stack Trace = <br/> at com.konakart.db.KKBasePeer.throwTorqueException(Unknown Source)<br/> at com.konakart.db.KKBasePeer.insertOrUpdateRecord(Unknown Source)<br/> at com.konakart.db.KKBasePeer.doInsert(Unknown Source)<br/> at com.konakartadmin.bl.AdminProductMgr.insertProductWithOptions(Unknown Source)<br/>
...
at com.konakartadmin.bl.KKAdminBase.manageThrowable(Unknown Source)
at com.konakartadmin.bl.KKAdmin.insertProduct(Unknown Source)
at com.konakartadmin.apiexamples.InsertProduct.main(InsertProduct.java:164)
should be so
INSERT INTO products_description (products_id, language_code, products_description, store_id, language_id, products_url, products_name, products_comparison, products_viewed) VALUES (6, 'en', 'Test prod - English', 'store1', 1, 'www.testprod.co.uk', 'Test Prod - E', 'Comparison - English', 0);
How to fix?
KonaKart v7.2.0.2
Example from java_api_examples
INSERT INTO products_description (products_id, language_code, products_description, store_id, language_id, products_url, products_name, products_comparison, products_viewed) VALUES (6, en, 'Test prod - English', 'store1', 1, 'www.testprod.co.uk', 'Test Prod - E', 'Comparison - English', 0);
...
com.konakartadmin.app.KKAdminException: Exception Message = (org.apache.torque.TorqueException) - com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6-1' for key 'PRIMARY'<br/><br/>Exception Stack Trace = <br/> at com.konakart.db.KKBasePeer.throwTorqueException(Unknown Source)<br/> at com.konakart.db.KKBasePeer.insertOrUpdateRecord(Unknown Source)<br/> at com.konakart.db.KKBasePeer.doInsert(Unknown Source)<br/> at com.konakartadmin.bl.AdminProductMgr.insertProductWithOptions(Unknown Source)<br/>
...
at com.konakartadmin.bl.KKAdminBase.manageThrowable(Unknown Source)
at com.konakartadmin.bl.KKAdmin.insertProduct(Unknown Source)
at com.konakartadmin.apiexamples.InsertProduct.main(InsertProduct.java:164)
should be so
INSERT INTO products_description (products_id, language_code, products_description, store_id, language_id, products_url, products_name, products_comparison, products_viewed) VALUES (6, 'en', 'Test prod - English', 'store1', 1, 'www.testprod.co.uk', 'Test Prod - E', 'Comparison - English', 0);
How to fix?
KonaKart v7.2.0.2
Example from java_api_examples