Not working anymore

Conqueror Travel,

If you could provide me with a temporary admin account, sending the credentials to [email protected], I would be happy to take a look and get this resolved for you.

Thanks,
Charlie Maxwell
[NM_Developer]

Hi Charlie,
it still doesn’t work after the update…Moreover, during the update, the plugin was removed and I had to completely reinstall it…
I can not grant you free access to the backend because the last time when I granted access to someone else, it made all sorts of modifications in the site’s settings and codes, and finally, I worked a lot of time to make it work again. If you wish to try to solve the issue from the frontend, you can do it at https://www.travelmaniacshub.com/travel-reviews/

Update!

I found the following error in the database generated by your plugin:

Unknown column ‘reviewer_image’ in ‘field list’ for query INSERT INTO wp_richreviews (date_time, reviewer_name, reviewer_image, reviewer_email, reviewer_id, review_title, review_rating, review_text, review_status, reviewer_ip, post_id, review_category) VALUES (‘2016-03-02 01:49:31’, ‘test’, ”, ‘[email protected]’, ”, ‘test’, ‘5’, ‘test’, ‘0’, ‘104.131.157.98’, 1529, ‘page’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/spacious/archive.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, apply_filters(‘widget_display_callback’), call_user_func_array, afflc_autoshortlink_for_widget, WP_Widget_Text->widget, apply_filters(‘widget_text’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, RichReviews->shortcode_reviews_form_control, handle_form, do_action(‘rr_on_valid_data’), call_user_func_array, rr_insert_new_review

Hopefully, this will help you finding a solution for the bug! Thanks for your time!

Hi ConquerorTravel,

It’s weird, because for me since the 1.7.2 update in all working again properly.

Well, I wrote you about the database error I found…Any clue?
I use the shortcode on a widget and a code in the functions.php file to allow shortcodes working in widgets.
To me, it’s obvious that there is a problem with the information sent by the review form to the database because the issue occurs only when it’s submitted a review on the frontend. In the backend, the plugin works well – I could add directly a review.
Plus, there is the error about I told you, so here could be the solution. Unfortunately, I’m not a programmer so I can not find alone the bug…

ConquerorTravel,

So it appears as though the database update that is required for all versions 1.7+ did not process properly for you. Any update from a version less than 1.7 to any of the 1.7 versions would have triggered a database update to add the column for reviewer_image, this error suggests this did not process for you. You can investigate further by looking at your database structure itself via your webhost, SQLPro, phpMyAdmin, etc. You can also force a DB update through the plugin, but you will first have to uncomment one line in rich-reviews.php. I can walk you through this process if you would like. Further, I would be happy to help you out and take care of this for you, however, unfortunately there is nothing that I can do from the front end of the site, and I can understand your concerns giving admin access.

Let me know if you require any further assistance,
Thanks,
Charlie Maxwell
[NM_Developer]

Hi Charlie,
I just checked, my DB version is 35700, both in the DB and in the version.php. What version should it be?

Which line should I uncomment in rich-reviews.php to force a DB update?

What are the values (Type Collation Attributes Null Default Extra) for reviewer_image to add it manually in the DB?

Thanks,
Victor

So to check in your DB you would want to look for the table wp_richreviews. Note the the prefix wp_ is the standard, but may be different depending on your WP build settings. However, the structure of that table should look like this https://puu.sh/nsrbF/5ee474c597.png. The reviewer_image column was the only change made to the DB in the 1.7+ update. The full sql statement for the table is located in /lib/rich-reviews-db.php and can be seen here https://puu.sh/nsrpU/a96bdf19f3.png.

I’m not entirely sure why the update would not have processed for you. The update processing function is in rich-reviews.php and can be seen here: https://puu.sh/nsrzh/94c2b65609.png, which should have forced a db update. However, as you said above, you can correct this by adding the new column manually, or if you want to go the route of using the db update in the plugin, you actually will not need to uncomment anything. Simply create a new page, place the shortcode [database_now] in the content, and click “Preview Changes”, this will run the database update. Then you will want to delete this page.

If the database update is the source of your issue, then this should remedy that.

Let me know how it goes and if you have any further questions,
Thanks,
Charlie Maxwell
[NM_Developer]

I tried your solution with the shortcode [database_now] but it did into work. I have gone ahead, opened the database and I saw that actually from my DB structure are missing TWO fields: reviewer_image and reviewer_id. I’ve added it manually with the structure you provided and this solved the issue!
I still don’t understand what caused the problem. I suspect a plugin that caused an another error: I could not insert into posts any picture from the library. It’s pretty sure this blocked also the update of the database.
Thanks for your great support and valuable info you provided. I will reward you with a 5-star rating!

That is indeed strange, however, I’m glad we were able to resolve the issue. A review would certainly be appreciated, and thank you as well for your patience and cooperation.

Charlie Maxwell
[NM_Developer]