During our last theme change, our database tech was able to go into the database and convert all our review scores from our old theme to the new theme after we were able to find the correct database value where the new theme was storing review scores. We would like to do something similar if possible as we have too many old reviews to do the the conversion by hand.
Is it possible to do something similar with Newspaper?
Hi,
Please check this topic where you can find the review in database https://forum.tagdiv.com/topic/deleting-a-review-cant-review-again/
Thank you!
Hi,
This partially covers what I need as we will be able to convert the reviews into the Newspaper format with this. I can’t seem to find where the score is being saved in the screenshots as we will need to convert the scoring from our current theme to Newspaper.
Thanks.
I have been doing final work on the theme before deployment and have realized that I think the tdc_review might be for User Reviews as website reviews appear to only be set as regular articles with a review score attached to the article.
I am not trying to convert our existing reviews into user reviews. I am trying to turn our existing reviews into the type our writers would use the “add new post” function and then add the score to the post. I also need to copy over our old score into that post’s score.
If I do not want to convert these reviews into user reviews, but rather regular reviews posts, do I still use the tdc_review post type or do I change all the old reviews into posts and proceed to copy old score to td_review_key?
Hello,
Our theme has 2 type of reviews, the one set buy the author – https://demo.tagdiv.com/newspaper_pro/td-post-cisco-knows-its-routers-are-the-fastest-ever-for-desktop-pcs/ – https://forum.tagdiv.com/reviews-2/ and the one that can be set by visitors – https://forum.tagdiv.com/use-posts-lists-shortcode/ – https://forum.tagdiv.com/user-reviews/
Now to add only the final score (this one-https://i.imgur.com/zGmwgpp.png) you need to add the score in wp_postmeta in td_review_key, for example I have a post with score 5 – https://i.imgur.com/lRbOSYR.png
Thank you!
I are running into a very strange issue with td_review_key in my test environment on Local using mySQL. Saving a review score in WordPress will correctly update meta_value for td_review_key. However, if I update the score using the td_review_key’s meta_value, nothing happens. When I checked the database queries using Query Monitor, I noticed the post with the review is not querying the td_review_key meta_value at all.
You can see the updated value in this image, but no change in WordPress in this screenshot.
I have cleared the browser cache multiple times, used a new browser, and incognito mode to confirm updating database scores are not being reflected on the posts.
Please let me know how I should proceed
Hi,
It is possible to be the wrong place updated, please check it like this, get the post id – https://i.imgur.com/UTW5G1Q.png – https://i.imgur.com/wls9q93.png, then go to database to wp_postmeta and search after that post id – https://i.imgur.com/IBMTGvM.png and the results will be – https://i.imgur.com/VItAZJF.png
I hope this will help better!
Hi Calin,
I double checked using your instructions. I was editing the correct post ID. I tried another post just in case, but the result was the same. I checked the article using incognito mode: no success. Changing the score in WordPress’ editor successfully changes the td_review_key value in the database, but not the other way around. You can see the result here: https://imgur.com/a/4fM3FNs
Hello,
Can we take a look? If yes, please contact us via email at contact@tagdiv.com and please provide temporary wp-admin access to the website and database. We’ll check it as soon as possible.
Thank you!
