bbRatings « bbPress Plugin Browser

viveksivaram

Inactive

i have installed it on my forum but couldnt get it to work. help me please.

Posted: 2 years ago #
planero

Member

bb_top_topics() don't work, I get this error:

bbPress database error: [Unknown table 'tm' in order clause]
SELECT t.* FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky = '0' ORDER BY 0 + tm.meta_value DESC LIMIT 15

Seems to need bb_topicmeta tabla, how I can fix it? Do I have to change something in bb_rating_init function (when call bb_register_view)

Posted: 2 years ago #
mdawaffe

Key Master

What version of bbPress are you using, planero?

Posted: 2 years ago #
hilium

Member

Planero, I get the same error. I'm using the bbpress 8.3.1

bbPress database error: [Unknown table 'tm' in order clause]
SELECT t.* FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky != '0' ORDER BY 0 + tm.meta_value DESC LIMIT 30

bbPress database error: [Unknown table 'tm' in order clause]
SELECT t.* FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky = '0' ORDER BY 0 + tm.meta_value DESC LIMIT 30

bbPress database error: [Unknown table 'tm' in where clause]
SELECT COUNT(*) FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky = '0' + tm.meta_value

Posted: 2 years ago #
jel3

Member

I'm also getting the error. When I try to view the "Highest Rated" page.

bbPress database error: [Unknown column 'tm.meta_value' in 'order clause'] SELECT t.* FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky != '0' ORDER BY 0 + tm.meta_value DESC LIMIT 30 bbPress database error: [Unknown column 'tm.meta_value' in 'order clause'] SELECT t.* FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky = '0' ORDER BY 0 + tm.meta_value DESC LIMIT 30
bbPress database error: [Unknown column 'tm.meta_value' in 'where clause'] SELECT COUNT(*) FROM bb_topics AS t WHERE t.topic_status = '0' AND t.topic_sticky = '0' + tm.meta_value

Posted: 2 years ago #
mdawaffe

Key Master

To those of you seeing SQL errors, try the most recent version: bbRatings 0.8.4.

Posted: 2 years ago #
kuzanagi

Member

Hi pp, i have a problem, I cant see the ratings, I installed and I dont have any problem with that, but i cant see the ratings, I have the firebug, and every time that i enter on a post a see this error addLoadEvent is not defined any ideas ?!!...

Posted: 2 years ago #
mdawaffe

Key Master

kuzanagi, try the most recent version I just made: bbRatings 0.8.5.

Posted: 2 years ago #
kuzanagi

Member

Hi mdawaffe, thanks for your quick answer, ok with new version , I dont see the error in the firebug, but, I still cant see the rating on the template, ok this is a stupid question, do i have to put hard code on my template?, and if the answer is yes, where?, I install the new addon with no problem, btw I use the bbpress with my wordpress Versión 2.3.3, and i have bbpress version 0.8.3.1, I will try to do something about it, but if you have the answer more quick than me, please share it, cya .. and thanks

Posted: 2 years ago #
mdawaffe

Key Master

kuzanagi, Yes. You need to add calls to bbRating's template functions in your template as described here: http://bbpress.org/plugins/topic/bb-ratings/other_notes/

You'll probably want to put bb_rating_dingus() and bb_rating() in your topic template at the very least.

Do that by adding the following line to you topic template.

<?php if ( function_exists( 'bb_rating' ) ) bb_rating(); ?>

And a similar line for bb_rating_dingus().

Posted: 2 years ago #
kuzanagi

Member

thanks for answer me, I follow your instruccions and it work!!, thanks a lot and also thanks for your support... pura vida!

Posted: 2 years ago #
kmccallum

Member

I've posted the changes required for a smaller star system, along with the changes in the default bbpress 0.9.1 theme required to display both list & full-topic views of the ratings, including voting. Changes are at http://kmccallum.net/dev/bbratings-changes/

Posted: 1 year ago #
CmdrTrekk

Member

Hey, I've figured out a way to better personalize your rating numbers so that it says "Be the first to rate this topic" when at 0, "1 person rated this topic" and then "2 people rated this topic" and anything higher than two for anyone with a less tech savvy audience. Let me know if you all want it.

Posted: 1 year ago #
peterve

Member

I am running this plugin on bbpress 0.9.0.2 (running on windows server) and the rate stars are not showing

When I open the source of the page, the img src tags just say ""
(empty)

what is wrong here ?

Posted: 1 year ago #
sidb85

Member

Hi,
I installed the plugin in my forum running 09.0.2 and added the functions bb_rating(), bb_rating_count(), bb_rating_dingus(), bb_current_user_rating(). I want that when a user votes, the page should automatically reload and show the updated number people who voted and also the rating that the current user applied to the topic.

Can this be done? I put the plugin in the /my-plugins directory of the bbpress root directory.

Thanks a lot!

Posted: 1 year ago #
mithrandir321

Member

Hey, can anybody help with listing top rated topics using bb_top_topics()

I asked here with no reply so far:

http://bbpress.org/forums/topic/bbpress-using-bb_top_topics

Many thanks

Posted: 1 year ago #

_ck_

Moderator

For 1.0 compatibility replace this line #205

if ( $topics = (array) $bbdb->get_col("SELECT topic_id FROM $bbdb->topicmeta WHERE meta_key = 'rating'") ) :

with this one:

if ( $topics = (array) $bbdb->get_col("SELECT object_id as topic_id FROM $bbdb->meta WHERE object_type='bb_topic' AND meta_key='rating'") ) :

Posted: 1 year ago #

mariostella

Member

Hello, Dunno if support for this plugin has been discontinued, but I need help as I have a very strange inconsistency with different browsers.

In FF the plugin displays all the stars correctly, but when rating a post the click on the desired star does not produce any effect, but if I copy the link location and paste it to the address bar it works correctly...this to me seems a css problem.

Just as the IE behavior seems a css problem, as with IE 6 (did not test other IE versions) the problem is opposite. The coloring of the stars (either the default red and yellow ) do not show up, but the link works correctly.

This brings me to think that the problem might lay in the CSS layer that commands the coloring. Since FF sees the coloring and the link but cannot go to the link and IE does not see the coloring therefore being able to go to the link it must be that darn color layer that should be given the linking properties...however this would solve the issue only on FF...

Any ideas???? May be it's the JS...

Thanks

Posted: 1 year ago #
displayname

Member

I installed bb-ratings on bbPress 1.0 and made the changes _ck_ posted, but I'm having a problem. I am able to rate the topic (the colors will appear on the stars) but then the average rating doesn't change. The average rating stays blank even after rating the topic.

I tried viewing the rating count, but no number came up. So I am to conclude that the the rating isn't going into effect.

Posted: 1 year ago #
salemw

Member

Same here, same problem displayname encounters

Posted: 1 year ago #

RSS feed for this topic

« Previous 1 2 3 Next »

Add a Comment »

You must log in to post.

bbPress

Simple, fast, elegant

bbPress Plugin Browser »

bbRatings (0.8.5)

Download

Average Rating

Your Rating

Author: Michael D Adams

Add a Comment »