XF 2.2 Running a sql query

[HuskerGarrett]

Hi, sorry I have not ran a query before and want to make sure I don't mess anything up. I'm trying to run a query to switch everyone over to a new style, so that the old ones are still active but they at least have to try out the new one and switch back if they choose.

Which database should I run the query on?

 

[HuskerGarrett]

Nevermind, I ran it in the main db and it worked fine.

 

[olgert zerbaska]

Cna you share with us please what sql you run?

 

[HuskerGarrett]

Cna you share with us please what sql you run?

Sorry, I just saw this.

Run the following query on PHPMYADMIN. STYLEID Attention!

UPDATE xf_user SET style_id = STYLEID;

Just change styleid to the styleid # of the style you want to switch everyone to