New Plugin: WP-PostRatings

GamerZ, but my WordPress Version: 1.5.2

no wonder. the post rating is for WP 2.0 only.

OK. I’ll deactivate. Any chance of tweaking for V1.5.2?

I’m on WP 2.0.1 and I’m having the same problems Katie has!
And the useronline is giving these same kind of problems also…

CarolineG: sorry, as it is still a beta version, you need to deactivate your wp-postratings, drop your wp-ratingslogs database and than activate it back and it will work fine.

Regarding the useronline, it has been fixed and an update will surface on 1st March 2005. U are getting the duplicate key error?

Thanks for the help Lester, ?an you tell me where i can find wp-ratingslogs?

Yes I’m getting the duplicate error, and an error that the table does not exist…

An update will surface on the 1st of March 2005? You mean last year? Or will there be an update next 1st of March…

GamerZ

I’ve upgraded my test blog to WP2.0

When I upgraded your useronline and ran admin.php this is the error I got:

Please Define The Useronline Table In wp-settings.php.

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ON DUPLICATE KEY UPDATE timestamp = ‘1139895903” at line 1]
INSERT INTO wp_useronline VALUES (‘1139895902’, ‘admin’, ‘60.229.191.16’, ‘strictlyromance.com’, ‘%2Ftest%2F’) ON DUPLICATE KEY UPDATE timestamp = ‘1139895903’

I found a completely different approach on voting at https://www.chrisjdavis.org/2004/11/30/new-plugin/ Basically anyone can vote for an article to be noteworty and based on the amount of votes it will display an icon. For example:

1. 1-29 votes, no icon value.
2. 30-49 votes, ★ is displayed.
3. 50 votes the peak of like-ability, gets a ?

I am trying it on my site https://www.bos89.nl/
Also check out the archives, where it works out nicely.

Want to try yourself? Scroll down at https://www.chrisjdavis.org/2004/11/30/new-plugin/ He’s telling you where to get it in comment 32.

Cheers,
Martijn

CarolineG: it will be 1st of March 2006, u need to use phpmyadmin I think you can find it in cpanel. And look under your wordpress database. The duplicate key error has been fixed, and also the update will be release on 1st march 2006, but if u need it immediately, u can drop me an email.

katie1: the error occurs because u are using mysql lower than 4.1. to solve the problem, open up useronline.php find:
$insert_user = $wpdb->query("INSERT INTO $wpdb->useronline VALUES ('$timestamp', '$memberonline', '$ip', '$make_page', '$url') ON DUPLICATE KEY UPDATE timestamp = '".($timestamp+1)."'");
Replace:
$insert_user = $wpdb->query("INSERT INTO $wpdb->useronline VALUES ('$timestamp', '$memberonline', '$ip', '$make_page', '$url')");
This bug has been already been fixed also in the next release.

mstegink: If you want to modify that it is possible and maybe I can also add in a function to use that in the future so that users can choose what type of rating they want. The plugin approach is quite unique.

I will fix my plugins on a monthly basic so that i can consolidate all the bug fixes rather than keep on fixing it.

Thanks GamerZ,

As noted in another post, I upgraded my test site to Version 2.1?? and now I can’t open an article in single view.

So, I’ve asked my hosting company to roll me back to the very neat, very well behaved 1.5.2.

Thank God for BACKUPS!

Thanks for all your help but I’ll hold out now until the next version release before uploading.

Sorry to be a pain in the butt ??

I think u mean 2.0.1. LOL I think it may due to some htaccess errors. My site is still on 1.5.2 because it takes alot of work to convert my whole site to 2.0. LOL

I have the same problems. The same message. GamerZ, can you help me ?

I’m on Wp 202

When i actived plugin the message is :

Fatal error: Cannot redeclare upgrade_all() (previously declared in /***/***/html/wordpress/wp-admin/upgrade-functions.php:7) in /***/***/html/wordpress/wp-admin/upgrade-functions.php on line 6

And, in page :

WordPress database error: [Table ‘site.wp_ratings’ doesn’t exist]
SELECT rating_ip FROM wp_ratings WHERE rating_postid = 18 AND rating_ip = ‘81.240.22.53’

For POST Ratings –
I am getting the same issue of the database not being created.

It might be helpful if you give us the Create table SQL as a separate item so we can add the table via myPHPAdmin. Else I’ll have to dig it out of your code.

Also where do we put the “get highest” code? “Outside the wp-loop” is not very descriptive for those of us not familiar with all lines of code in WP.

briceric: It is a bug, I will fix it when I am at home. In the mean time open postratings.php.
Find:
include(ABSPATH.'/wp-admin/upgrade-functions.php');
Replace:
include_once(ABSPATH.'/wp-admin/upgrade-functions.php');

esearing: are u getting the same error? Regarding the loop, here u go. https://codex.www.ads-software.com/The_Loop

when i downloaded the plugin, i only got the image folders. i uploaded those and i place the code on single.php but nothing shows up…