MFlenses - デジタル時代の新しさ
MFLenses 2026

マニュアルフォーカスレンズフォーラム

修理ノート、実際のテスト写真、画像豊富な詳細アーカイブスレッドから、ヴィンテージレンズの世界を探検してください。

修理ノート、実際のテスト写真、画像豊富な詳細アーカイブスレッドから、ヴィンテージレンズの世界を探検してください。
スポットライト

フォーラムトップページのおすすめパートナー掲載。

Feature Request for Photo Competition
前のトピックへ :: 次のトピックへ  


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 氏の書き込み:
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 氏の書き込み:
Attila 氏の書き込み:
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!