Hi,

Got this error after select the payment method...

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '' for key 'PRIMARY': INSERT INTO {commerce_ipay88} (merchant_code, payment_id, ref_no, amount, currency, prod_desc, user_name, user_email, user_contact, remark, lang, signature, order_id, transaction_id, requery_status, requery_timestamp, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17); Array ( [:db_insert_placeholder_0] => M04505 [:db_insert_placeholder_1] => 6 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => MYR [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => max [:db_insert_placeholder_7] => admin@victoria.my [:db_insert_placeholder_8] => [:db_insert_placeholder_9] => [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => [:db_insert_placeholder_12] => 3 [:db_insert_placeholder_13] => 5 [:db_insert_placeholder_14] => 0 [:db_insert_placeholder_15] => 0 [:db_insert_placeholder_16] => 1346944908 [:db_insert_placeholder_17] => 1346944908 ) in commerce_ipay88_transaction() (line 419 of /home/victori2/public_html/dev/sites/all/modules/commerce_ipay88/commerce_ipay88.module).

Appreciate if this can be solve.

Thanks.

Comments

peterbkk’s picture

peterbkk commented

I have the same issue, using 2x dev version.

khayong’s picture

khayong commented

The error was due to upgrading from previous version 1.x. In version 2.x, there was a change to the database schema 'commerce_ipay88'. We should fully uninstall the previous version, then only install this 2.x dev version.