1062 Duplicate entry '0' for key 1 on linkpoint_api table after changing servers

I moved to a new server. So far everything works fine except linkpoint payments. Customers are able to fill their baskets - when they check out they get this message-

1062 Duplicate entry '0' for key 1
in:
[INSERT INTO linkpoint_api (lp_trans_num, zen_order_id, approval_code, transaction_response_time, r_error, customer_id, avs_response, transaction_result, message, transaction_time, transaction_reference_number, fraud_score, cc_number, cust_info, chargetotal, cc_expire, date_added) ...

You might want to try unloading and reloading Linkpoint. Don't think this is a situation where the clear db cache would work.

I gave this a try. Now when someone tries to pay via CC they get this message-

We apologize for the inconvenience, but we are presently unable to contact the Credit Card company for authorization. Please contact the Store Owner for payment alternatives.

Maybe I will try to upgrade to v1.3.8?

1.3.8a is the current

maxilious:

I moved to a new server.Did you perhaps lose the auto-increment setting on your linkpoint_api (and possibly others) table?

What is the table structure of your linkpoint_api table? (you can get this via phpMyAdmin).