Bug Database Error with new update

[viper357]

I get the following database error when importing the XML file...

Database error in vBulletin 3.8.5:

Invalid SQL:

INSERT INTO `dbtech_usertag_settings`
(`userid`)
SELECT `userid` FROM `user`;

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Monday, October 13th 2014 @ 05:31:28 AM
Error Date : Monday, October 13th 2014 @ 05:31:29 AM
Script : Log in - Marine Aquariums South Africa - vBulletin Admin Control Panel
Referrer : Log in - Marine Aquariums South Africa - vBulletin Admin Control Panel
IP Address :
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.73-cll

 

[Fillip H.]

Try running the following query:

truncate table dbtech_usertag_settings

then run the Maintenance actions in under DBTech - User Tagging.

 

[viper357]

Thank you, the XML imported properly after doing that.