automatically rate old posts or all posts with 5 stars

Hi, thank you for using Yasr!

It’s not possible from the yasr settings, but if you’ve access to phpmyadmin we can do this in the database (only for the old posts).

Is it ok for you?

yes it will also ok of course..can you please teach, instruct me how to do it..

and second question is … stars is not appearing on my website desktop version.. in mobile version its appearing(wp-touch theme)…. I think its theme related issue.. what I should add to theme or to check..please advice ..thank you

thank you dear Dudo

Open your phpmyadmin and execute this query;

UPDATE wp_yasr_votes SET overall_rating=5

PLASE note that if you use a different prefix for your table you have to change the table name, e.g.

UPDATE YOURPREFIX_yasr_votes SET overall_rating=5

About the theme can you please give me the link to your site?

Best,
Dario

1. (about stars rating on website not showing on desktop version(just visit any post in it..)) here url goo.gl/3A6Ods its should be after word рейтинг (“rating” means.. its written in russian lang)

I put to post author review only..also tried to put both…
and did as you explained. but not worked..not changed anything I mean..
here screenshot how I did run execute query..if I did corectly…. if not please explain…. I need your help to solve it..
https://s27.postimg.org/bhth9uulv/shot.jpg

also tried without UPDATE word… and it gave SQL query error #1064
)) ..I am sorry if I am taking your time.. but you are the one who can help me with this ..because you are the developer of this YASR plugin.. thanks Dario

1) Can you please try to disable the caching plugin?

2) Uhm, yeah, sorry, you’re right, that query can only change the post or page you’re already rated…I’ll sand you a query to use as soon as tomorrow I’ll come back at home ??

Best,
Dario

1) .net/new-posts/ there new posts to check (disabled cache plugin)but still not showing on desktop version…
maybe is there I have to add any javascript.? or any other advice plz.

2)yes ?? will be very good help from your side..because I am first time use review thing ) I want too ..my posts appear on google with stars :)))

3) what you think ..I disabled visitor review and left only author rate.. is it also make sense ..I mean is it plus for my posts for SEO,,,
or its possible to enable visitors votes..and add them too 5 stars rates as many I want… if yes. ..you advice me best options..(queries) )) thanks Dario for your help

1) This is so so strange: I can’t find js error or css conflict, but it still doesn’t appear.
Can you please try to insert the shortcode manually and see if it works?

2) First, empty your wp_yasr_votes tabele, then do this:

INSERT INTO wp_yasr_votes (post_id)
SELECT ID FROM wp_posts WHERE post_status='publish'

and only then you can run this

UPDATE wp_yasr_votes SET overall_rating=5

3) You can do whetever you prefer: in the Yasr settings, in the “Rich snippet options” you can choose between ” Review Rating ” or ” Aggregate Rating “. Click on the “What is this?” link to have more info ??

hello, 2) solved..thank you now all old posts rated

1) not yet.. still not showing…tried insert shortcode from post.. also tried it appear on top of post.. very strange if you say no conflict….
dont you remember is anyone had same issue..

No, I never seen something like this before.

Does it work if you try to change the theme? (it should cause it’s working on mobile)

Hovewer, in the next week, I’ll try to test yasr with your theme and let you know

yes I checked on other theme it works.. ok I will wait… for example first I installed and it did not work I just wanted to delete plugin …after I said maybe to contact with developer…so I contacted with you..some people they just delete and install other… but I liked your work… what other plugin or projects you have on web or apps?

Thank you ??

Yasr, is my first plugin/app, I’ve some other project on the internet but are not related with software development ??

I’ll let you know about the theme.

Best,
Dario

thank you Dario,,,
also for me interesting,, how long it takes it appears with stars on search results google….

because the news post I posted and rated it already indexed but stars not showing on result…for example if you search google with:
long keyword to appear my website’s new posted post:
Mover uz видео онлайн Скачать формате MP4
will appear but with no stars ))

or its also not appearing because of theme issue.?

It should be indexed, if it’s not appearing just wait some days. Some sites needs just a few hours, other need 1 month or more…you can try to test your pages here: https://developers.google.com/structured-data/testing-tool/ if everything is fine, you’re ok ??

unfortunately )but i see error there here you can see https://uploadpie.com/sQtav
… Dario take a look please and give advice me..thank you for your time.