Black Tiger Posted January 29, 2019 Share Posted January 29, 2019 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! Link to comment Share on other sites More sharing options...
Pete T Posted January 29, 2019 Share Posted January 29, 2019 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 ? Link to comment Share on other sites More sharing options...
Black Tiger Posted January 29, 2019 Author Share Posted January 29, 2019 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. Link to comment Share on other sites More sharing options...
Aiwa Posted January 29, 2019 Share Posted January 29, 2019 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. Link to comment Share on other sites More sharing options...
Black Tiger Posted January 29, 2019 Author Share Posted January 29, 2019 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. Link to comment Share on other sites More sharing options...
newbie LAC Posted January 30, 2019 Share Posted January 30, 2019 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; Link to comment Share on other sites More sharing options...
Black Tiger Posted January 30, 2019 Author Share Posted January 30, 2019 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! Link to comment Share on other sites More sharing options...
bfarber Posted January 30, 2019 Share Posted January 30, 2019 To mass unban everyone, you'd do UPDATE core_members SET temp_ban=0 where temp_ban=-1 Link to comment Share on other sites More sharing options...
Black Tiger Posted January 30, 2019 Author Share Posted January 30, 2019 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? Link to comment Share on other sites More sharing options...
Pete T Posted January 30, 2019 Share Posted January 30, 2019 One that newbie give you for title the broken images issue, one that bfarber give you is ban issue. Link to comment Share on other sites More sharing options...
Black Tiger Posted January 30, 2019 Author Share Posted January 30, 2019 @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. 😉 Link to comment Share on other sites More sharing options...
bfarber Posted January 31, 2019 Share Posted January 31, 2019 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. Link to comment Share on other sites More sharing options...
Black Tiger Posted January 31, 2019 Author Share Posted January 31, 2019 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! :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.