Bug SQL Error when editing a thread ban

[Trekkan]

I banned a user as a test from a thread. That worked fine, then I deactivated the ban. That worked.

Then I edited the ban to change it to ban the same person on a different thread and then got the following error:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO dbtech_vbshop_threadban
	(`threadid`, `userid`)
VALUES
	('675', '9');


MySQL Error   : Duplicate entry '675-9' for key 'PRIMARY'
Error Number  : 1062

 

[Fillip H.]

Were you editing the ban while it was deactivated?

 

[Trekkan]

Yes

 

[Fillip H.]

Try re-downloading and re-uploading /dbtech/vbshop_pro/items/threadban.php and see if that works

 

[Trekkan]

That fixed it, thanks!