• Resolved WPChina

    (@wordpresschina)


    I have two blogs. On one of them, the WP-PostRatings 1.01 found here works fine:
    http://www.lesterchan.net/wordpress/2006/04/01/my-wp-plugins-update-april-06/

    On my other blog, it also appears to work fine, but when I am the admin and view the admin control panel under the “manage Ratings” area, I find the following code above the box for the Post ratings Logs:

    WordPress database error: [You have an error in your SQL syntax near ‘(meta_value AS UNSIGNED)) FROM wp_postmeta WHERE meta_key = ‘ratings_users” at line 1]
    SELECT SUM(CAST(meta_value AS UNSIGNED)) FROM wp_postmeta WHERE meta_key = ‘ratings_users’

    WordPress database error: [You have an error in your SQL syntax near ‘(meta_value AS UNSIGNED)) FROM wp_postmeta WHERE meta_key = ‘ratings_score” at line 1]
    SELECT SUM(CAST(meta_value AS UNSIGNED)) FROM wp_postmeta WHERE meta_key = ‘ratings_score’

    Everything seems to be working correctly and people can post ratings, but that code is visible on one of my blog’s admin areas. I worry that it might be a problem that could open up into something worse later.

    I have already updated my permalink structure many times and have activated/de-activated it many times but the error message still stays…

    Any idea what is wrong?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hi, you are using mysql 3+. WP-PostRatings work well with MYSQL 4+ =)

    Thread Starter WPChina

    (@wordpresschina)

    Ahhh… yes, you are correct. I upgraded to 4+ and now it works fine on the amdin…

    However, previously I was using 1.00 and now I am using 1.01… this 1.01 version seems to be buggy on the user side. It seems to hang for a very long time after a user submits a rating. And if you click the rating a few times, it loads an error page.

    Is it possible for me to DOWNGRADE to 1.00 from 1.01 without hurting anything? Will the database be corrupt if I do that?

    Tks for you great help and cool plugin!

    do u want to try 1.02 Beta? it fixes the hanging part with a nice fade in and fade out effect. Demo on http://www.lesterchan.net/wordpress

    yawpu

    (@yawpu)

    Hi, I have mysql 4.0.25 and yet I get that same error message in admin>manage; it seems to work great otherwise.
    What is the manage page used for, and how can I fix it?
    I’m on WP 2.0.1.
    TIA.

    YAWPU: Manage is just to see the ratings logs. WordPressChina you upgarde to what version of mysql?

    If I am not wrong, it is 4.1x

    Thread Starter WPChina

    (@wordpresschina)

    oooh! I like the fade in and fade out! When will this be released outside of beta?

    tks!

    1st June, need some testing =D I will add a loading just below the image soon.

    Thread Starter WPChina

    (@wordpresschina)

    Very nice… I hope I can wait until then 🙂

    roger that, just in case you want to test it, it is still stable. http://forums.lesterchan.net/viewtopic.php?t=455

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Bug: WP-PostRatings 1.01’ is closed to new replies.