Help needed with mysql commands

[Black Tiger]

Hello.

Since ticket support does not include mysql commands, maybe somebody else can help us.
We got a lot of users which got the ban status during conversion. Issue almost certainly caused by wrong status notices in the old vB database.
Anyway, we need to unban these users and it's a lot of users.

Is there a way to mass-unban them?
Or is this possible via a mysql command and if yes, how is this done?

Next to that, the user's title was imported to the Invision Ranks, instead of the vBulletin Ranks (which we didn't use). So at this moment they contain html code to an image.
We need a mysql command to clear all member ranks because we don't use those! And the members title icon is already present as group icon.

I'm don't know how to create this commands, can only execute them. So if anybody can help me with one or both of these, I would be very happy!
 

[Pete T]

1 hour ago, Black Tiger said:

Hello.

Since ticket support does not include mysql commands, maybe somebody else can help us.
We got a lot of users which got the ban status during conversion. Issue almost certainly caused by wrong status notices in the old vB database.
Anyway, we need to unban these users and it's a lot of users.

Is there a way to mass-unban them?
Or is this possible via a mysql command and if yes, how is this done?

Next to that, the user's title was imported to the Invision Ranks, instead of the vBulletin Ranks (which we didn't use). So at this moment they contain html code to an image.
We need a mysql command to clear all member ranks because we don't use those! And the members title icon is already present as group icon.

I'm don't know how to create this commands, can only execute them. So if anybody can help me with one or both of these, I would be very happy!
 

are they in a group or just have ban in the profile ?

[Black Tiger]

Thank you!
They are in different groups. At this moment I did a lot manually already.

But they are in several groups like is used default by Invision.

I would also be very very glad if somebody know's how to clear the rank from content, because that concerns all users.

[Aiwa]

You didn't test the conversion before converting your live site? 

That aside, it would be better to write a script to do this using built in IPS methods. Otherwise you run the risk of creating a disconnect between tables as well as any cache. 

Suggest looking in the providers section for a developer to help you if you're unable to do this yourself. 

[Black Tiger]

No we did not test because we closed the old site and could easily go back when things would go really wrong.

But it's running fine now. We spend some time with a couple of admins to unban all users manually.

The rank stuff is the only thing that's remaining.

But even when checked before, I doubt if we could have removed all those vB titles quickly.
It's this one below. So we have to either clear or replace it. Clear it would be better.

Would really amaze me if this could not be done via a mysql command.

 

Don't worry, this is not a right wing forum or something like that. My friend has his forum for Militaria collectibles like helmets etc. mostly from the Belgian army.
 

[newbie LAC]

Hello,

11 hours ago, Black Tiger said:

We need a mysql command to clear all member ranks because we don't use those! And the members title icon is already present as group icon.

UPDATE core_members SET member_title=NULL;

 

[Black Tiger]

Great! Thank you very much. Ofcourse I'll backup the database first, but after this command everything is as should be.

You made my day!

[bfarber]

To mass unban everyone, you'd do

UPDATE core_members SET temp_ban=0 where temp_ban=-1

 

[Black Tiger]

Great, thank you.

In the other thread you wrote:

UPDATE core_members SET member_title='';

Is there any difference in using this line or using NULL there (without the ' characters) like Newbie LAC suggested?

Or is it in fact the same result?

[Pete T]

One that newbie give you for title the broken images issue, one that bfarber give you is ban issue.

[Black Tiger]

@Pete T

You missed something.

Quote

In the other thread you wrote:

And the command quoted below this is the command he gave me in the other thread for member titles. It also says so in the quoted command.

😉

[bfarber]

23 hours ago, Black Tiger said:

Great, thank you.

In the other thread you wrote:

UPDATE core_members SET member_title='';

Is there any difference in using this line or using NULL there (without the ' characters) like Newbie LAC suggested?

Or is it in fact the same result?

There shouldn't be any practical or noticeable difference.

[Black Tiger]

Thank you. Did a database backup before and after I issued the command. It worked flawlessly and html ranks are gone now, looks way better! :)