bbRatings « bbPress plugin browser

viveksivaram

Inactive

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

Posted: 7 months 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: 4 months ago #
mdawaffe

Key Master

What version of bbPress are you using, planero?

Posted: 4 months 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: 4 months 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: 4 months ago #
mdawaffe

Key Master

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

Posted: 4 months 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: 3 months ago #
mdawaffe

Key Master

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

Posted: 3 months 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: 3 months 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: 3 months 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: 3 months 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: 2 months 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 day ago #

RSS feed for this topic

« Previous 1 2

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