Code: Select all
SQL ERROR [ mysql4 ]
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause 
SELECT t.*, ROUND(AVG(te.evaluation), 2) AS evaluation, COUNT(te.evaluation) AS evaluation_count, tp.topic_posted, tt.mark_time FROM (phpbb_topics t) LEFT JOIN phpbb_topics_evaluation te ON (te.topic_id = t.topic_id) LEFT JOIN phpbb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 2) LEFT JOIN phpbb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 2) WHERE t.forum_id = 2 AND t.topic_type IN (0, 1) ORDER BY t.topic_type DESC, t.topic_last_post_time DESC LIMIT 25
Novan wrote:Hello everyone,
my demo board is online again.
Here is my todolist for this Mod. The next release will be until friday:
- Option to disable/enable voting the own topics
- Option to disable/enable change the own voting again
- A variable amount of stars to display and to vote and not staticly six stars.
- I will look if I'm getting the stars a bit nicer displayed. There were many ideas in this topic
In my personal opinion there should not be the feature to see who has how voted in a topic. This could be extended in a further mod for the ACP. Everyone have a right to his Privacy. Also I do not want to create a big menu point for this mod in the ACP.