Page 1 of 1
Merging users
Posted: Tue May 16, 2006 3:34 pm
by Kossatsch
After realizing my TXP import I would like to merge two users: the main admin A (me) and the author B of the TXP blog (also me). I only woould like to do this to be able to attribute the old articles of B to A, my new s9y personality (thinking about the authors pages).
Re: Merging users
Posted: Tue May 16, 2006 3:44 pm
by garvinhicking
Hi!
The easiest way for this is to just set the "authorid" column of each entry to your user account:
Code: Select all
UPDATE serendipity_entries SET authorid = 1 WHERE authorid = 2
(1 is the first s9y admin, and I suppose that "2" is the authorid of your imported user)
HTH,
Garvin
Posted: Tue May 23, 2006 2:53 pm
by Kossatsch
Yes, it sounds easy, but it did not work.
authorid is 1 now for all entries. But if you click on
http://roxomatic.de on any author's name, it does not have any entry. If you look instead at the entries of the other user (authorid=2) at
http://roxomatic.de/authors/Kossatsch2, he even possesses newer artcles.
Any idea?
Posted: Tue May 23, 2006 3:20 pm
by garvinhicking
Hi!
Hm, please show me the output of those SQL commands:
Code: Select all
SELECT authorid, realname FROM serendipity_authors;
SELECT authorid, author, id FROM serendipity_entries;
It might be that we forgot to change the author name of the entries table:
Code: Select all
UPDATE serendipity_entries SET author = 'Kossatsch';
Regard,s
Garvin