invalid query. (ERRNO 1055) Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fah-addict-fr.com_topic.number_comments' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query: SELECT a.id, a.is_cat, a.hits, a.redirect, a.id_cat, a.title, a.encoded_title, a.is_cat, a.defined_status, com_topic.number_comments, f.id AS id_favorite, a.undefined_status, a.auth, c.menu, c.content
FROM phpboost_wiki_articles a
LEFT JOIN phpboost_wiki_contents c ON c.id_contents = a.id_contents
LEFT JOIN phpboost_wiki_favorites f ON f.id_article = a.id
LEFT JOIN phpboost_comments_topic com_topic ON a.id = com_topic.id_in_module AND com_topic.module_id = 'wiki'
WHERE a.encoded_title = 'installation-du-client-smp-cpu-classique-linux'
GROUP BY a.id
STACKTRACE
| METHOD | FILE | LINE |
|---|
| + | MySQLQuerier->execute(string, array) | /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php | 48 |
SELECT a.id, a.is_cat, a.hits, a.redirect, a.id_cat, a.title, a.encoded_title, a.is_cat, a.defined_status, com_topic.number_comments, f.id AS id_favorite, a.undefined_status, a.auth, c.menu, c.content
FROM phpboost_wiki_articles a
LEFT JOIN phpboost_wiki_contents c ON c.id_contents = a.id_contents
LEFT JOIN phpboost_wiki_favorites f ON f.id_article = a.id
LEFT JOIN phpboost_comments_topic com_topic ON a.id = com_topic.id_in_module AND com_topic.module_id = 'wiki'
WHERE a.encoded_title = 'installation-du-client-smp-cpu-classique-linux'
GROUP BY a.id Array
(
[param1] => wiki
[param2] => installation-du-client-smp-cpu-classique-linux
)
|
| + | MySQLQuerier->select(string, array, int) | /kernel/framework/io/db/DBQuerier.class.php | 50 |
SELECT a.id, a.is_cat, a.hits, a.redirect, a.id_cat, a.title, a.encoded_title, a.is_cat, a.defined_status, com_topic.number_comments, f.id AS id_favorite, a.undefined_status, a.auth, c.menu, c.content
FROM phpboost_wiki_articles a
LEFT JOIN phpboost_wiki_contents c ON c.id_contents = a.id_contents
LEFT JOIN phpboost_wiki_favorites f ON f.id_article = a.id
LEFT JOIN phpboost_comments_topic com_topic ON a.id = com_topic.id_in_module AND com_topic.module_id = :param1
WHERE a.encoded_title = :param2
GROUP BY a.id Array
(
[param1] => wiki
[param2] => installation-du-client-smp-cpu-classique-linux
)
1
|
| + | DBQuerier->select(string, array, int) | /kernel/framework/db/Sql.class.php | 548 |
SELECT a.id, a.is_cat, a.hits, a.redirect, a.id_cat, a.title, a.encoded_title, a.is_cat, a.defined_status, com_topic.number_comments, f.id AS id_favorite, a.undefined_status, a.auth, c.menu, c.content
FROM phpboost_wiki_articles a
LEFT JOIN phpboost_wiki_contents c ON c.id_contents = a.id_contents
LEFT JOIN phpboost_wiki_favorites f ON f.id_article = a.id
LEFT JOIN phpboost_comments_topic com_topic ON a.id = com_topic.id_in_module AND com_topic.module_id = :param1
WHERE a.encoded_title = :param2
GROUP BY a.id Array
(
[param1] => wiki
[param2] => installation-du-client-smp-cpu-classique-linux
)
1
|
| + | Sql->select(string) | /kernel/framework/db/Sql.class.php | 164 |
SELECT a.id, a.is_cat, a.hits, a.redirect, a.id_cat, a.title, a.encoded_title, a.is_cat, a.defined_status, com_topic.number_comments, f.id AS id_favorite, a.undefined_status, a.auth, c.menu, c.content
FROM phpboost_wiki_articles a
LEFT JOIN phpboost_wiki_contents c ON c.id_contents = a.id_contents
LEFT JOIN phpboost_wiki_favorites f ON f.id_article = a.id
LEFT JOIN phpboost_comments_topic com_topic ON a.id = com_topic.id_in_module AND com_topic.module_id = 'wiki'
WHERE a.encoded_title = 'installation-du-client-smp-cpu-classique-linux'
GROUP BY a.id
|
| + | Sql->query_while(string, int, string) | /wiki/wiki.php | 51 |
SELECT a.id, a.is_cat, a.hits, a.redirect, a.id_cat, a.title, a.encoded_title, a.is_cat, a.defined_status, com_topic.number_comments, f.id AS id_favorite, a.undefined_status, a.auth, c.menu, c.content
FROM phpboost_wiki_articles a
LEFT JOIN phpboost_wiki_contents c ON c.id_contents = a.id_contents
LEFT JOIN phpboost_wiki_favorites f ON f.id_article = a.id
LEFT JOIN phpboost_comments_topic com_topic ON a.id = com_topic.id_in_module AND com_topic.module_id = 'wiki'
WHERE a.encoded_title = 'installation-du-client-smp-cpu-classique-linux'
GROUP BY a.id 51 /home/fah-addict-fr/wiki/wiki.php
|