Sql mode=only full group by: Unterschied zwischen den Versionen
Aus Znalosti
Admin (Diskussion | Beiträge) K |
Admin (Diskussion | Beiträge) K |
||
| Zeile 5: | Zeile 5: | ||
<code> | <code> | ||
/var/www/Projekty/webtrees-1.7/app/Statement.php:82 SQLSTATE[42000]: Syntax error or access violation: 1055 | /var/www/Projekty/webtrees-1.7/app/Statement.php:82 SQLSTATE[42000]: Syntax error or access violation: 1055 | ||
| − | Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webtrees- | + | Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webtrees- |
| − | .7.1.wt_name.n_givn' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with | + | .7.1.wt_name.n_givn' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with |
| − | sql_mode=only_full_group_by | + | sql_mode=only_full_group_by |
#0 /app/Statement.php:82 PDOException("SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 | #0 /app/Statement.php:82 PDOException("SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 | ||
| − | of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webtrees-1.7.1.wt_name.n_givn' | + | of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webtrees-1.7.1.wt_name.n_givn' |
| − | which is not functionally dependent on columns in GROUP BY clause; this is incompatible with | + | which is not functionally dependent on columns in GROUP BY clause; this is incompatible with |
| − | ql_mode=only_full_group_by") | + | ql_mode=only_full_group_by") |
#1 /modules_v3/vytux_cousins/module.php:148 execute([array]) | #1 /modules_v3/vytux_cousins/module.php:148 execute([array]) | ||
#2 /individual.php:227 getTabContent() | #2 /individual.php:227 getTabContent() | ||
</code> | </code> | ||
Version vom 23. Juli 2016, 08:28 Uhr
U všech webů localhost/webtrees se v mnoha případech přestal zobrazovat postranní panel na stránce osoby. Platilo to v případě, kdy byl aktivní přídavný modul Vytux_cousins (Bratranci).
V deníku chyb byla chybová zpráva:
/var/www/Projekty/webtrees-1.7/app/Statement.php:82 SQLSTATE[42000]: Syntax error or access violation: 1055
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webtrees-
.7.1.wt_name.n_givn' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by
#0 /app/Statement.php:82 PDOException("SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3
of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webtrees-1.7.1.wt_name.n_givn'
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with
ql_mode=only_full_group_by")
#1 /modules_v3/vytux_cousins/module.php:148 execute([array])
#2 /individual.php:227 getTabContent()
