Update a Setting Value in the WHMCS Database
To update a specific configuration setting in WHMCS, you can use the following SQL command via MySQL or phpMyAdmin:
UPDATE `tblconfiguration` SET value = '0' WHERE setting = 'DisableAdminPWReset';Example:
This command sets the DisableAdminPWReset setting to 0, effectively enabling the Admin Password Reset feature.
⚠️ Always back up your database before making direct modifications.
How to Empty Attachments in WHMCS
If you want to remove all attachments associated with support tickets and replies (e.g., to free up space or for privacy reasons), you can use the following SQL commands:
UPDATE tbltickets SET attachment = "";
UPDATE tblticketreplies SET attachment = "";These commands will clear the attachment field in both the main ticket and the reply entries.
🛑 This does not delete the physical files from the
/attachments/directory. You should remove those manually via SSH or FTP if needed.