MFlenses - A new life in a digital age
MFLenses 2026

Manual Focus Lenses Forum

Explore the world of vintage lenses through repair notes, real test shots, and detailed archive threads packed with images.

Explore the world of vintage lenses through repair notes, real test shots, and detailed archive threads packed with images.
Spotlight

Featured partner placement for the forum front page.

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


Reply

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


Reply

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


Reply

Hi Attila,

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

Thanks.
Si


Reply

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


Reply

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.


Reply

Thanks Attila!


Reply

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?


Reply

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!