[Solved] Reviews present in BE ande in FE but not in the DB

[ClaudioRomeo]

J 3.6.4
VM 3.0.18
PHP 5.5.37

There are three strange things that are driving me crazy.

#1. There is a review reported both in BE (the one at the top in image BackEnd.jpg) and in the FE, but not present in the DB (see Ratings.jpg, Ratings_Reviews.jpg and Ratings_Votes.jpg). So: where is the review/vote stored?

#2. Two of the reviews seem to be duplicated, even if with times slightly different. In each of them, one seems to refer to vote, the other one to review, so I need to have them both published for having the product page displayed correctly.

#3. As you can see from the dumps of the DB tables, some data appear strange:
NULL in Ratings_Reviews virtuemart_rating_vote_id
Blank in Ratings_Reviews customer
0 in Ratings rates
It makes me think the DB is corrupted or something similar. Am I right?

Can someone clear #1 and #2 to me?
If my DB is really corrupted, how can I fix it?

[lindapowers]

Hi I was going to ask the same thing cause I went crazy searching for reviews in phpmyadmin but didnt find the table for the reviews.

Using 3.0.18.5

[Studio 42]

YOu have 3 table
__virtuemart_ratings
__virtuemart_rating_reviews
__virtuemart_rating_votes
__virtuemart_ratings is the main (cumulated) rating for a product, rating_reviews have the review and rating_votes the votes associate to a review id.

[ClaudioRomeo]

Thank you, Studio 42.
This is exactly what I said. But, as you can see from the attached pictures, now it seems that new reviews don't appear in none of the DB tables, even if they are reported both in FE and in BE.
So, where are they stored?

[Studio 42]

Perhaps you don't checked the right DB, but a copy of it ?
I say you that because i had a day the same problem, the db was the copy for a stagin server

[ClaudioRomeo]

Ehmm... 
I don't know how to tell you, but... you are RIGHT!
I asked my hoster to restore the DB after some experiments, and he duplicated the DB, updating the reference in the Joomla site.
Two tons of Valium wasted! 
Thank you again, Studio 42.

Any suggestion about the strange data in the DB? Should I correct them by hand?

[Studio 42]

If you have only a review then vote id is  null for this review(eg. adding a review from back-end)
And same if you have only a vote and no reviews

[ClaudioRomeo]

OK. It seems to me strange, since I never added a review from the BE (I don't know if it is really possible).
But the main thing is that the NULL value is not a DB corruption.

Now I have a more specific question, but I will open another discussion.

Thank you very much.

[lindapowers]

YOu have 3 table
__virtuemart_ratings
__virtuemart_rating_reviews
__virtuemart_rating_votes
__virtuemart_ratings is the main (cumulated) rating for a product, rating_reviews have the review and rating_votes the votes associate to a review id.

Oh lord, had it in the second page of PHPmyadmin, thanks Patrick!