Technology Errors

Zen Cart New Product Error: 1062 Duplicate entry ‘2147483647’ for key ‘PRIMARY’

A client of mine contacted me earlier because he was unable to add products to his Zen Cart store. I recently installed a couple modules for him and was thinking that the issue may be related to one of the modules however this did not end up being the case. After some investigation I was able to resolve the problem easily by first deleting a product that had been added and then by issuing a SQL command to modify the auto increment numbers for the Zen Cart products table. Below there is more information on the error as well as details on how to resolve the issue.

Technology Insights

Amazon Machine Tags WordPress Plugin Not Working After Upgrade

If you are using the Amazon Machine Tags plugin for WordPress then you are aware that Amazon recently changed their policy for the Amazon Product Advertising API and now will require that all requests are authenticated. Initially with the AMT (Amazon Machine Tags) plugin you wethe re only required to have the Amazon Access Key ID configured and not the Amazon Secret Access Key. Most people probably already had the Secret Access Key configured however if you did not have your “Secret Access Key” configured then after upgrading the AMT plugin will no longer work. If this is the case then your Amazon Machine Tags will display like the below in your WordPress posts instead of displaying the product properly.

Example AMT WordPress Post Tag: “[ amtap book:isbn=0596510489 ]”