Star rating problems after update to 4.1

Hi Maximilian,

There’s a new required option for rating items. If you set this to Yes, then 0 is not allowed to be selected for star ratings. An error should appear next to the star rating on click of the Submit button. So a resolution to you second problem (unable to set Required checkbox) should fix this.

The only time this error is returned when updating the rating items is when the column name is unknown in the AJAX request POST data. Try clearing your page and browser cache. I don’t know why this is not working, are you able to send the HTTP post request data? Worst case you can update the required flag in the wp_mr_rating_item database table to 1 instead of 0.

Thanks,
Daniel.

Hi Daniel,

bad news: I checked the database and there is no column ‘required’. Here is a full select. Note that I have a custom prefix configured during setup:

SELECT rating_item_id, rating_id, description, default_option_value, max_option_value, active, weight, type FROM dsmarwp_mr_rating_item

So eventually during plugin upgrade to 4.1 it failed to extend the table by new column ‘required’?

Can you please provide a full DB structure script so I can check if there are more columns missing? Hope there is a fix though…

Thanks
Maximilian

Hi Daniel, any news about this?

Thanks
Maximilian

Hi Daniel,
I just installed the plugin and i noticed that even if “Default option value” is set to 5 stars, in the frontend the rating form always shows zero stars.
Can you sort it?
Thank you!

Hi maximilianknap,

The table structure for the rating items should be:

CREATE TABLE IF NOT EXISTSwp_mrp_rating_item` (
rating_item_id bigint(20) NOT NULL,
rating_id bigint(20) NOT NULL,
description varchar(255) NOT NULL,
default_option_value int(11) DEFAULT NULL,
max_option_value int(11) DEFAULT NULL,
active tinyint(1) DEFAULT ‘1’,
weight double DEFAULT ‘1’,
option_value_text varchar(1000) DEFAULT NULL,
include_zero tinyint(1) DEFAULT ‘1’,
type varchar(20) NOT NULL DEFAULT ‘select’,
required tinyint(1) DEFAULT ‘0’
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;`

Where wpdb prefix is wp_. There has not been any other recent database structure changes.

Hi Diondream,

For star ratings, the default option value is ignored. I have done this on purpose to improve the user experience and a lot of people asked me to do this. The default option value is only supported for select, radio and thumbs.

Thanks,
Daniel

Hi Daniel,

I have to come back to this because my database structure is still out of sync with what the plugin expects.

You stated the new, correct table structure above. With which version exactly have these three fields been added, and shouldn’t this be reflected somewhere in the sources? I can’t find any add column statement.

option_value_text varchar(1000) DEFAULT NULL,
include_zero tinyint(1) DEFAULT ‘1’,
required tinyint(1) DEFAULT ‘0’

It’s a bit confusing, to me it seems that the update process didn’t work properly for me. Just want to make sure I get it corrected the right way, executing the right ‘alter table add column’ statements including indexes and so on. I might not be the only one running into that issue, having three installations and all having the same issue.

Could you please provide a proper ‘alter table’ script as it would have been executed during the update?

Thank you very much,
Maximilian

Hi Maximilian,

Is this for the Pro version or the free version? Please contact me here https://danielpowney.com/contact/ for all Pro support.

If it’s for the free version, I can help you here.

Cheers,
Daniel

Hi, changed the message, it work.
It was my fault because one of my own plugin.

Hi Maximilian,

Did you send a technical support request via my website? I thought I saw it but I seem to have lost your e-mail sorry.

Thanks,
Daniel