Mi da quest'errore quando voto un sito:
Codice:
vote-sum
1140: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SELECT site
, SUM((1 + 99 * (NOT ISNULL(votes.user))) * votes.value_content) AS vote_content
, SUM((1 + 99 * (NOT ISNULL(votes.user))) * votes.value_estetic) AS vote_estetic
, SUM((1 + 99 * (NOT ISNULL(votes.user))) * votes.value_feeling) AS vote_feeling
FROM votes
WHERE site = "14"
vote-refresh
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[vote_content] + [vote_estetic] + [vote_feeling]
, vote_content = [vote_conten' at line 2
UPDATE sites
SET vote = [vote_content] + [vote_estetic] + [vote_feeling]
, vote_content = [vote_content]
, vote_estetic = [vote_estetic]
, vote_feeling = [vote_feeling]
WHERE site = [site]