For the past two weeks I have been caught up with a lot of work, and I didn’t had much time for GD Star Rating. This is another minor release, since I haven’t completed all that I wanted for 1.6.0. Still, this version is well worth the upgrade.
First of all, there are two new languages added: Russian (translated by Studio XL), and Ukrainian (translated by Oleksandr Natalenko). So, right now there are 7 languages fully supporting latest version and 2 more that have not been updated for a while. I have added and improved few more functions (not fully documented yet) and added few more options for controlling cache.
I have fixed several problems, including some incompatibilities with WPMU and BuddyPress. So, this version is a step closer to full WordPressMU compatibility. If you find more problems with WPMU, please report it. Also, I will soon add more options to control the how plugin works in WPMU as a site wide plugin.
In the next version I am adding one more important feature: support for custom taxonomies (WP 2.8.x only) in widget and rating results. For now, report any problems you might encounter with this version in both standard WordPress and WordPress MU.
loading...
Share this:
August 5, 2009
at 2:49 AM
Direct link
The votes for multi in the article page of Gd Setting are not collected, i have also “0″ for all the multi posts
loading...
August 5, 2009
at 4:30 AM
Direct link
Articles page doesn’t show multi ratings, that’s for the multi page, but it’s not yet fully implemented.
loading...
August 5, 2009
at 9:57 AM
Direct link
Hi,
thanks for the update, it fixes some bugs in wpmu; users page and dashboard are now working
We still get error messages for the “update process” though, that is on the first page load for each blog after the new version has been added:
WordPress database error Unknown table 'wp_1_gdsr_data_multi' for query drop table wp_1_gdsr_data_multimade by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->delete_tables
WordPress database error Unknown table 'wp_1_multis_trend' for query drop table wp_1_multis_trend
made by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->delete_tables
WordPress database error Multiple primary key defined for query ALTER TABLE `wp_1_gdsr_multis` ADD PRIMARY KEY (`multi_id`)
made by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
WordPress database error BLOB/TEXT column 'description' can't have a default value for query ALTER TABLE `wp_1_gdsr_multis` CHANGE `description` `description` text NOT NULL default ''
made by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
WordPress database error Can't DROP 'review'; check that column/key exists for query ALTER TABLE `wp_1_gdsr_multis_data` DROP `review`
made by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
WordPress database error Can't DROP 'review_text'; check that column/key exists for query ALTER TABLE `wp_1_gdsr_multis_data` DROP `review_text`
made by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, gdDBInstallGDSR->alter_tables
WordPress database error Column count doesn't match value count at row 1 for query INSERT INTO `wp_1_gdsr_templates` (`section`, `name`, `description`, `elements`, `dependencies`, `preinstalled`, `default`) VALUES('Alternative Widget Blog Rating', '', 'a:1:{s:6:"normal";s:262:"<p class="trw-title">Average rating:</p><p class="trw-rating">%RATING%</p><p class="trw-footer"><strong>%VOTES%</strong> %WORD_VOTES% for <strong>%COUNT%</strong> posts</p>";}', '', '2', '0');
made by require_once, require_once, require_once, require_once, include_once, GDStarRating->GDStarRating, GDStarRating->install_plugin, GDSRDB->install_all_templates, GDSRDB->insert_extras_templates
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to
Thanks for your hard work!!
Cheers, Ben
loading...
August 5, 2009
at 11:53 AM
Direct link
After I release 1.6 next week, I will start adding new features that target WPMU, and among them is use of WPMU actions so that plugin can properly configure everything and prevent such problems.
loading...
August 5, 2009
at 12:16 PM
Direct link
Hm, that sounds good but do the error message above have something to do with new features? I thought the might be a bug in the update process…
loading...
August 5, 2009
at 12:25 PM
Direct link
I still don’t know exactly what’s going on with WPMU updates compared to regular WP, so I am not sure if the GD Star Rating has anything to do with the error. Many things like this to investigate…
loading...
August 5, 2009
at 12:40 PM
Direct link
Sorry for the confusion; by “update” I did not mean a “wordpress mu update” but the “update of gd star rating”. All I changed on the system was to copy the new version of gd-star-rating into the plugins folder and then those errors appeared…
No pressure…
loading...
August 5, 2009
at 1:52 PM
Direct link
OK. Each time the plugin is updated it executes full database checkup to see if something new needs to be added to the database layout.
loading...
August 5, 2009
at 11:34 AM
Direct link
Hi,
After the update I am unable to see any details by clicking on the links under Articles page i.e. the links which details about IP, Vote Date etc.
Thanks,
Rajesh
loading...
August 5, 2009
at 1:51 PM
Direct link
Hi,
Are you planning on telling us how you calculate category averages?
If you manually calculate the averages of the categories in the top 10 on my website you get totally different results and therefore rankings to the ones GDstar rating gets.
Calculate the 2 top results by hand and check out for yourself if you don’t believe me.
Please let me know.
Thanks.
Meda
loading...
August 5, 2009
at 2:10 PM
Direct link
Categories average is calculated using single SQL query that sums all ratings for all posts grouped by the query using various criteria based on the settings in the widget. Rating is rounded at the very end so that there is no loss in calculating. If you get different values then you are doing it wrong. There are many settings on the widget that can influence the calculations.
loading...
August 5, 2009
at 2:45 PM
Direct link
You said:
“If you get different values then you are doing it wrong”.
Do you mean I am calculating the averages wrong? If so, I strongly advise you to do it by hand and see for yourself?
I understand that the widget can influence the top 10 but in the end, the way to calculate averages is still the same (as long as I don’t use bayesian): (Total post Ratings )/ Number of Post.
If you do it by hand it will make this clear to you and we won’t discussing this matter in circles:
Numbers for category ranked 1 in the top 10:
(4.9 + 3.0 + 4.0 + 3)/4 = 3.725
Numbers for category ranked 2 in the top 10:
(4.9)/1= 4.9
Please tell me what is wrong in this calculation? I know how to calculate an average.
loading...
August 5, 2009
at 8:25 PM
Direct link
I figured out what the problem was.
When the posts are ranked by category the “minimum votes” setting is assigned to the posts in these category, not the category itself.
I think you should review the widget so that when the ranking by category is selected, the “minimum votes” setting is applied to the category also. Otherwise it gives flawed results and to much weight to a particular post in certain circumstances.
Do you see what I mean?
loading...
August 5, 2009
at 10:33 PM
Direct link
I am currently changing some things around in these functions and I will see what can be changed.
loading...
August 5, 2009
at 2:17 PM
Direct link
Thanks for your great plugin!
The attached code is for the import of comment ratings from the “Comment Karma” Plugin (same as your thumbs up and down thing). If you’re planning to include this plugin for importing data, this might help you a bit.
It is hacked, not very nice (Comment Karma does not save how much user clicked thumb up or down, just the resulting integer), but it worked fine for me.
Regards,
MB
get_results(“select distinct * from $wpdb->prefix” . “ck_karma as carma join $wpdb->prefix” . “comments on $wpdb->prefix” . “comments.comment_ID = carma.ck_comment_id WHERE carma.ck_rating 0 order by ck_comment_id”);
foreach ($rated_comments as $comment) {
if ($comment->ck_rating > 0) {
$wpdb->query(“insert INTO wp_gdsr_data_comment(post_id, comment_id, visitor_recc_plus) VALUES ($comment->comment_post_ID, $comment->ck_comment_id, $comment->ck_rating)”);
} else {
$wpdb->query(“insert INTO wp3_gdsr_data_comment(post_id, comment_id, visitor_recc_minus) VALUES ($comment->comment_post_ID, $comment->ck_comment_id, ” . abs($comment->ck_rating) . ” )”);
}
$wpdb->query(“insert INTO wp_gdsr_votes_trend(id, vote_type, visitor_voters, visitor_votes) VALUES ($comment->comment_ID, ‘cmmthumb’, ” . abs($comment->ck_rating) . “, $comment->ck_rating)”);
for ($i = 0; $i ck_rating); $i++) {
$wpdb->query(“insert INTO wp_gdsr_votes_log(id, vote_type, user_id, vote) VALUES ($comment->comment_ID, ‘cmmthumb’, 0, ” . ($comment->ck_rating / abs($comment->ck_rating)) . “)”);
}
}
?>
loading...
August 5, 2009
at 2:19 PM
Direct link
Thanx, I will check this plugin and add import support soon.
loading...
August 5, 2009
at 10:45 PM
Direct link
define(‘STARRATING_WPCONFIG’, ”);
Where and how do I define the value for the `wp-content` file here. I do not have in WordPress directory I see I need to update this but do not know exactly what to change and where in the line of code.
loading...
August 6, 2009
at 12:23 AM
Direct link
define(‘STARRATING_WPCONFIG’, ‘HERE’). Replace word HERE with FULL path (not URL) of the wp-config.php file.
loading...
August 7, 2009
at 8:57 PM
Direct link
Hey Millan,
Thanks for the AWESOME plugin. Like many others, I wish I would have found this first before getting other paid review plugins.
Anyway, I’m having trouble with displaying the average reviews for my multi reviews. The average stars wont display. any ideas?
Here is the link:
http://www.m1arifles.com/reviews/nikon-prostaff-3-9×40-rifle-scope-review/
Any tips would be much appreciated.
I look forward to your reply.
loading...
August 8, 2009
at 12:31 AM
Direct link
I am not sure why this happens, because i use this on many websites, and I am 100% sure that this works fine. However, there were some problems with review functions, so wait for 1.6.0 to be released on Sunday evening with many fixes to some functions and rendering.
loading...
August 11, 2009
at 6:51 PM
Direct link
It’s still not working?
Not sure why? It will allow ratings but wont display the average.
loading...
August 12, 2009
at 12:27 AM
Direct link
Review will display average if the template displays it. EVERYTHING depends on templates.
loading...
August 8, 2009
at 10:00 PM
Direct link
Do you think is it possible in the next release add the possibility to load the javascript in the footer instead header ?
loading...
August 8, 2009
at 10:09 PM
Direct link
Next 1.6.0 is now locked, but this will be added soon.
loading...
August 9, 2009
at 12:33 PM
Direct link
Thanks! I’m using a plugin now to load the javascript in the footer and the page load is now very quickly
loading...
August 9, 2009
at 8:16 PM
Direct link
Very nice work on this. For some reason the plugin installed as follows: /wp-content/gd-star-rating/ instead of /wp-content/plugins/gd-star-rating/ Is this correct?
loading...
August 9, 2009
at 8:28 PM
Direct link
Plugin is installed in /wp-content/plugins/gd-star-rating/. Other location is used for cache and additional resources and is created by the plugin.
loading...
August 12, 2009
at 7:14 AM
Direct link
sorry, I have solved my problem. Problem was cookies.
Now I would like to change the language of:
Rating: 0.0 / 5 (0 votes cast and Vote Saved. Rating: 3.0 / 5
Thanks Millan
loading...
August 12, 2009
at 11:42 AM
Direct link
You need to create new templates and use them. Check templates tutorials. Also, there will be a tutorial specifically on this soon.
loading...