ERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 1
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 8
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 5
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 2
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.forum_id = 63 AND f.cat_id = 7
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 6
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 3
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 9
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byERROR:
SELECT
p.poster_id,
p.topic_id,
p.forum_id,
p.post_time,
t.topic_title,
t.topic_views,
t.topic_replies,
t.topic_last_post_id,
f.forum_name,
f.auth_view
FROM
(runcms__phpbb_posts p,
runcms__phpbb_forums f)
INNER JOIN runcms__phpbb_topics t ON t.topic_last_post_id = p.post_id
WHERE f.forum_id = t.forum_id
AND f.cat_id = 4
AND f.auth_view = 0
GROUP BY p.topic_id
ORDER BY p.post_time DESC
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql623240_1.p.poster_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
|
News : AUGURI DI BUONA PASQUA 2014 A TUTTI I PILOTI |
Inviato da Cipson su 14/4/2014 16:51:10 (991 Letti)
Buona Pasqua!
ItalianWing coglie l'occasione per fare gli Auguri di Buona Pasqua a tutti i suoi Piloti...
(e alle loro Famiglie che, ahimè, li devono continuare a sopportare .... )
 Dwg Hugault
|
|
|
|
| | |
Menu Seow
1: ospiti (s)