Bug Database Error with new update

Status
Not open for further replies.

viper357

Customer
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
 
Last edited:
Try running the following query:
Code:
truncate table dbtech_usertag_settings
then run the Maintenance actions in under DBTech - User Tagging.
 
Status
Not open for further replies.

Legacy Advanced User Tagging

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
2,502
Customer rating
0.00 star(s) 0 ratings
Back
Top