***MAKE SURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE RUNNING ANY QUERIES AGAINST IT***
Try this:
UPDATE user SET styleid=8
WHERE styleid=4;
If your table has a prefix, make sure to add this in also
Changing styles en mass
Collapse
X
-
Changing styles en mass
I've just done some changes to the styles and templates on my site following both a vB upgrade and a server upgrade that broke current settings in a nasty way. It was easier to start from a clean slate ut this means I've most users on broken styles.
I'm looking for a way to migrate users from one style to another via a database query. For example, migrate all users currently using styleID 4 to use styleID 8
Alternatively, is there a simple way to blow away all existing template and style changes for styleID4 and replace with styleID8?
Can anyone help?
Tags: None
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Leave a comment: