Merge member ..

[Disconnect.]

Hi , i have a problem

Recently happened error on my friend's account , when he logs into profile , it show's nothing , everything white ..

So he made a new account , and he said to one of the administrator's to remove he's old account , not to merge to new ...

So now i have a Guest__* in my top posters sidebar/hook , because he had a lot of posts

http://screencast.com/t/HENzs1pdz

 

What i want is to put his old files to his new account ... 

I only know to do that when he isn't deleted , but since one of admins did it , i can't so if someone could help me with that

Here's how show's his old posts 

http://screencast.com/t/1rN2mq1PU

 

Thanks

Edited September 3, 2014 by Disconnect.

[Lock Down]

Well he had at least 2914 according to you. So run this command and change the command from 2914 to what ever you want it to be.

update ipb_members set posts=2914 where member_id=10197;

Kopakabana 2914

 

 

PS Do you allow guests to post? If you did not delete any other members all those posts must be his.

[Lock Down]

You might want to delete that image as it gave the member ip address.

 

This will not fix it but will tell us if this is the correct person to fix it. Run this sql command in the sql toolbox in the acp under support > sql management.

use one if the 2 commands

select author_name, count(*) from posts where author_name = 'Kopakabana'
or
select author_name, count(*) from ibf_posts where author_name = 'Kopakabana'

[Disconnect.]

Appears to be error

 

Results: Manual Query - posts

Error

Table 'explosio_testament.posts' doesn't exist

 

explosio_testament.posts , i think that Testament was old administrator , also deleted him self ...

Edited September 4, 2014 by Disconnect.

[-Cookie-]

ACP > Members > Member Management Tools, Now insert that guests name into this tool below,

[Lock Down]

 

ACP > Members > Member Management Tools, Now insert that guests name into this tool below,

 

That will clear the guest_ but will not merge the old members posts with his new id.

 

Appears to be error

 

Results: Manual Query - posts

Error

Table 'explosio_testament.posts' doesn't exist

 

explosio_testament.posts , i think that Testament was old administrator , also deleted him self ...

 

Under the title Table at the top of that screen what is the complete name it shows for admin_logs ??

[Disconnect.]

Here's the most of ss when error appears

http://screencast.com/t/ZgUTUEboTmk

[Lock Down]

No you are showing the bottom of the page. I want to see the top of the page like this:

[Disconnect.]

http://screencast.com/t/XXnDnEb0s

[Lock Down]

ok your command is this and it should come back with 3476. If it does I will need the name and member id that he was changed to.

select author_name, count(*) from ipb_posts where author_name = 'Kopakabana'

[Disconnect.]

Kopakabana 2914

[Lock Down]

Check your members in the admin panel for kopakabana if it does not exist then that is the correct one.

 

What is the new member name and member id number for kopakaban ?

[Disconnect.]

How can I find the id od new acc?

[Lock Down]

You know the new members name? If you do put the mouse on the name and it will show id= in the address (url)

 

or if it is furl it will look like this user/25038-disconnect/ and 25038 is the id.

[Disconnect.]

Ok , here's id of new acc 10197

[Lock Down]

And what is the new member display name??