userid

Hey there! How would I go about removing the 2FA from a user? I've tried running the following code: UPDATE user SET dbtech_twofactor_secret = '', dbtech_twofactor_recovery = '' WHERE userid = 'x' Replacing X with the userID, however I'm met with the following error: An error occurred while...

Ok its been a while im having this issue but i never found time to scearch/explain My vbshout works fine most of the time but it appears that if some users are logged for long period on forum, they cannot shout anymore. When i check database it appears that missing shouts are saved but under...

i got this mysql error : Datenbankfehler in vBulletin 4.2.2: Invalid SQL: UPDATE user SET dbtech_classifieds_unpaid_seller_count + 1 WHERE userid = 1; MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right...

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 ...