Merge statistics

[riksarchen]

Hello,
I have mined on two different addresses. Is it possible to merge statistics from the old address into the new by altering the database?

[oliverw]

Should work.

[oliverw]

Getting this error
ERROR: type " " does not exist

Do not use double quotes.

[riksarchen]

This command
miningcore=# UPDATE minerstats SET miner = 'vtc1qcrn34kay4c7kegv349
pv0eknmdjkxudw8upyel' WHERE miner = 'VhrFrQxJm4BQgu4QZiGjxRSsrTq3Co
hnWk';

Gets the error

[oliverw]

This command
miningcore=# UPDATE minerstats SET miner = 'vtc1qcrn34kay4c7kegv349
pv0eknmdjkxudw8upyel' WHERE miner = 'VhrFrQxJm4BQgu4QZiGjxRSsrTq3Co
hnWk';

Gets the error

Hmm. Looks good to me.

[riksarchen]

Something wrong on my side. Tried it again and update 19k posts..

[riksarchen]

Hm, stats did not update though. Old stats didnt show under api

[riksarchen]

I ran this command aswell and now I got all statistics with me

miningcore=# UPDATE payments SET address = 'vtc1qcrn34kay4c7kegv349
pv0eknmdjkxudw8upyel' WHERE address = 'VhrFrQxJm4BQgu4QZiGjxRSsrTq3
CohnWk';
UPDATE 29
miningcore=#

[riksarchen]

Thanks a lot for your help! Much appreciated

[oliverw]

You're welcome 😄

[riksarchen]

For future referenser also updated balancechanges table and blocks tables (finder column)

This can be closed. Thanks for your Support