Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 29, 20196 yr 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!
January 29, 20196 yr 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 ?
January 29, 20196 yr Author 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.
January 29, 20196 yr 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.
January 29, 20196 yr Author 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.
January 30, 20196 yr 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;
January 30, 20196 yr Author 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!
January 30, 20196 yr To mass unban everyone, you'd do UPDATE core_members SET temp_ban=0 where temp_ban=-1
January 30, 20196 yr Author 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?
January 30, 20196 yr One that newbie give you for title the broken images issue, one that bfarber give you is ban issue.
January 30, 20196 yr Author @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. 😉
January 31, 20196 yr 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.
January 31, 20196 yr Author 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! :)
Archived
This topic is now archived and is closed to further replies.