Home
SearchSearch MemberlistMemberlist RegisterRegister ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in

Feature Request for Photo Competition
View previous topic :: View next topic  


PostPosted: Tue Oct 19, 2010 6:30 pm    Post subject: Feature Request for Photo Competition Reply with quote

Hi Attila,

Just for fun, would it be possible to request for some summary statistics on how the entries are doing for the photo competition?

For instance, for each category, who are the top three entries with XY scores!


Another request, may be to allow voters to input some comments as to why they like the photo.

Thx! Very Happy


PostPosted: Tue Oct 19, 2010 8:48 pm    Post subject: Reply with quote

You can comment each photo like many of us do already, to comment votes is not possible and not necessary too due you can comment them without voting.

Actual score table is here.

http://forum.mflenses.com/ratings.html?type=p&forum_id=15&ratingsby=1&submit=Go


PostPosted: Fri Nov 19, 2010 5:04 pm    Post subject: Reply with quote

Hi Attila,

This link is broken. Can you fix it and make it sticky?

Thanks.
Si


PostPosted: Fri Nov 19, 2010 5:41 pm    Post subject: Reply with quote

General Error

Couldn't obtain post rating information

DEBUG MODE

SQL Error : 1054 Unknown column 'r.user_id' in 'on clause'

SELECT t.topic_title, t.rating_rank_id AS topic_rating, p.rating_rank_id AS post_rating, t.topic_id, u.username, u.user_id, r.rating_time, ro.label, ro.points AS label2, f.forum_id, p.post_id, f.forum_name, SUM(ro.points) AS points FROM phpbb_rating r, phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_forums f, phpbb_users u2, phpbb_rating_option ro, phpbb_rating_rank rt LEFT JOIN phpbb_rating_bias i ON i.user_id = 1235 AND r.user_id = i.target_user WHERE r.post_id = p.post_id AND p.poster_id = u.user_id AND r.user_id = u2.user_id AND p.topic_id = t.topic_id AND t.topic_status = 0 AND t.forum_id = f.forum_id AND f.auth_view <= 1 AND f.auth_read <= 1 AND r.option_id = ro.option_id AND p.rating_rank_id = rt.rating_rank_id AND t.forum_id = 15 AND (i.bias_status IS NULL OR i.bias_status != 1) GROUP BY p.post_id ORDER BY points DESC, rt.sum_threshold DESC LIMIT 60

Line : 299
File : ratings.php


PostPosted: Fri Nov 19, 2010 6:03 pm    Post subject: Reply with quote

Database was migrated too from version 4.1 to 5.xx

This error come from that

http://bugs.mysql.com/bug.php?id=13551

I am think about it.

Search also broken damn it.


PostPosted: Fri Nov 19, 2010 9:08 pm    Post subject: Reply with quote

Thanks Attila!


PostPosted: Fri Nov 19, 2010 11:24 pm    Post subject: Reply with quote

Attila wrote:
Database was migrated too from version 4.1 to 5.xx

This error come from that

http://bugs.mysql.com/bug.php?id=13551

I am think about it.

Search also broken damn it.


According to the link, the fix is easy.
Just put parentheses around the table names in the "FROM" clause.
Have you tried this?


PostPosted: Fri Nov 19, 2010 11:35 pm    Post subject: Reply with quote

nkanellopoulos wrote:
Attila wrote:
Database was migrated too from version 4.1 to 5.xx

This error come from that

http://bugs.mysql.com/bug.php?id=13551

I am think about it.

Search also broken damn it.


According to the link, the fix is easy.
Just put parentheses around the table names in the "FROM" clause.
Have you tried this?


I did try it now, works Smile thank you!