Re-connect database to page

Hi,
In the meantime I have looked at the database
and changed the post IDs in yasr_log and yasr_votes
to the value of the new page – seems to work. Structured Data Testing Tool also gives the ok.
However, I have noticed that now only the average value of the ratings is
shown behind the stars.
The number of votes, name of the page, author etc. is not there anymore.
Unsure, if this is related to me messing in the database and what it all means.
Site: hi-flyfoto.de
Thanks
Michael

Hello, you didn’t need to change the post id in the database, but in Yasr:)

e.g. yasr_visitor_votes postid=”XXXX”

You can use the old postid in your new page and you’re done ??

Hi, so you mean inserting a different shortcode?
Guess I was being too complicated.

I see you’re using the visitor votes shortcode, so what you need is this:
first find the id of the old post, then in the new one put this

[yasr_visitor_votes postid=”OLDPOSTIDHERE”]

Ok, thank you I get it.
The risky way of editing the database also worked for me;)
However: There were some orphaned votes from the past for the start page,
which had a different post_id. I wanted to include them with the current ID of the start page, so I:
– changed the post-id in yasr_log of those votes to the current post_id
– edited the entry in yasr_votes: changed number_of_votes and sum_votes to the new values
This did not work. The orphaned votes are not included. What am I doing wrong?
Thank you

if in yasr_votes you updated the number_of_votes and sum_votes it must work: are you sure it was the row with the correct post_id?

I think it was the right row, based on the number of votes.

If in yasr_votes,
I add the values number_of_votes and sum_votes of the old page to the new post_id
and in yasr_log
change the post_id of all votes of the old page to the id of the new page
I thought the votes of the old page are transferred to the new page.
But apparently that is not the case. There must be something else defining the votes of one page.

For now just ignore the yasr_log table: is needed only for create stats.

you’ve to be sure that in yasr_votes table, on the row with the new post_id there are the correct values for number_of_votes and sum_votes.

That’s all.

That’s what I did, and double checked it.
Looking at the page (I have %average%/%total_count% after the visitor rating) and the strutured data testing tool, it shows me the values before the edit.
No caching plugin that could potentially confuse things.
I don’t get it.

it’s right for testing tool to show the old data, will fix this later.

But the shortcode it’s also showing the old data? Can you please paste a link to your site?

Site is hi-flyfoto.de
I have tried this on the startpage, current number of votes is 23 and it should be 39

Did you try to rate the page? Yasr has a built in cache system that is cleaned everytime an user insert a rate

Ah yes, that’s it. Did not know about this cache.
Thank you very much