[fixed] SQL error on username change Reply to topic

When, and if you change a username say you changed mine to Bluefin minus the 221 you would receive the following error:

On / While executing query "INSERT INTO nuke_cart_users VALUES ('7412', '', '', 'Bluefin', 'me@myaddress.com', '', '', '', '', '', '', '', '', '0')" the following error occured: Duplicate entry '7412' for key 1 In: /home/main/public_html/modules/Storez/includes/functions.php on line: 65

At first it wasn't much of a problem but as my site has a few thousand members and people change constantly I'm on the datebase almost everyday having to delete out the existing database entry.

Initiated by Bugger (Original Entry) - Comments Here Please.

Try this modified file and let me know how it goes - after a quick check, it should resolve the issue without breaking anything else.

I've loaded it, nothing appears to be broken, I'll need to wait until a user has a name change and then hits the site, this is when the error occurs, I believe its related to placing a storez block on the homepage.

I shall assume the issue is fixed - fix is included in the release I am currently working on.

v9.2.0 will also include the ability to assign a group and duration to each product e.g. provide a 1 year subscription to product support and updates.