First I'd like to say that this is a great module, just what I needed for a new site. Simple and everything in one neat package.

Would it be possible to expose the total votes as a field that can be used by views? I used fivestar once and it exposed the vote tally so you could sort on it using views.

That would make it possible to create custom views that sorted on the total votes for a node

I know there's blocks and the "more" link, but it would be great to be able to totally customize the display with views.

CommentFileSizeAuthor
#2 drupal5.1-drupalit1.3-error.jpg29.22 KBILTK

Comments

tic2000’s picture

tic2000 commented

Download the version 1.3 release.

ILTK’s picture

ILTK commented
StatusFileSize
new drupal5.1-drupalit1.3-error.jpg29.22 KB

Thanks,

I installed the 1.3 version but for some reason it now just spits out all the code from the module as raw html.

I tried it on a fresh drupal install with only core modules enabled with default theme on my test server, and it does the same there.

Attached a screenshot.

tic2000’s picture

tic2000 commented

Yeap, I know, that's why the latest version is 5.x-1.3-a

ILTK’s picture

ILTK commented

Yep that took care of the code being output raw.

But it looks like there's a few missing database fields, I ran the update script but I'm getting these errors when I try to use a view and sort on the drupalit vote sums:

---------
Views error using Total votes sorting:
user warning: Unknown column 'drupalit_votes.votes' in 'order clause' query: SELECT node.nid FROM node node ORDER BY drupalit_votes.votes ASC LIMIT 0, 10 in D:\wamp\www\drupal3\includes\database.mysql.inc on line 172.

Views error using Daily votes sorting:
user warning: Unknown column 'drupalit_votes.daily_votes' in 'order clause' query: SELECT node.nid FROM node node ORDER BY drupalit_votes.daily_votes ASC LIMIT 0, 10 in D:\wamp\www\drupal3\includes\database.mysql.inc on line 172.

Views error using Weekly votes sorting:
user warning: Unknown column 'drupalit_votes.weekly_votes' in 'order clause' query: SELECT node.nid FROM node node ORDER BY drupalit_votes.weekly_votes ASC LIMIT 0, 10 in D:\wamp\www\drupal3\includes\database.mysql.inc on line 172.

Views error using Monthly votes sorting:
user warning: Unknown column 'drupalit_votes.monthly_votes' in 'order clause' query: SELECT node.nid FROM node node ORDER BY drupalit_votes.monthly_votes ASC LIMIT 0, 10 in D:\wamp\www\drupal3\includes\database.mysql.inc on line 172.
-------------

tic2000’s picture

tic2000 commented

Try the latest version. It works on my test site. I think that you have to clear the drupal cache, views cache before it works correctly.

ILTK’s picture

ILTK commented

I just played with the latest version today, still the problem with the sql error, I installed it again on a new clean test install of drupal just to make sure there's no caching issues, and latest views version and I'm still getting the error.

Looked at the database in phpmyadmin and the fields it's complaining about are there, strange.

tic2000’s picture

tic2000 commented

Really strange. I have on my test site the 5.x-1.3-beta3 release of drupalit, latest of views and it works perfectly now. You can see it in action here: http://pnl.tic2000.ro/drupalit-test

tic2000’s picture

tic2000 commented
Status: Active » Closed (fixed)

Release 1.3-beta4 solves this problem so I close the issue.

ILTK’s picture

ILTK commented

Great news :)

Thanks for your time.