Merging users

[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).

[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

[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?

[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