GROUP CONCAT()-error (MySQL)
Versie door Jeroen Strompf (overleg | bijdragen) op 28 jun 2018 om 16:44
Foutmeldingen zoals dit?
... 23 was cut by GROUP_CONCAT() 1260 Row 45 was cut by GROUP_CONCAT() 1260 Row 69 was cut by GROUP_CONCAT() 1260 Row 93 was cut by GROUP_CONCAT() 1260 Row 115 was cut by GROUP_CONCAT() 1260 Row 136 was cut by GROUP_CONCAT() 1260 Row 159 was cut by GROUP_CONCAT() 1260 Row 198 was cut by GROUP_CONCAT() 1260 Row 243 was cut by GROUP_CONCAT() 1260 Row 266 was cut by GROUP_CONCAT() 1260 Row 291 was cut by GROUP_CONCAT() 1260 Row 315 was cut by GROUP_CONCAT() 1260 Row 340 was cut by GROUP_CONCAT() 1260 Row 363 was cut by GROUP_CONCAT() 1260 Row 387 was cut by GROUP_CONCAT() 1260 Row 411 was cut by GROUP_CONCAT() 1260 Row 434 was cut by GROUP_CONCAT() 1260 Row 469 was cut by GROUP_CONCAT() 1260 Row 510 was cut by GROUP_CONCAT() 1260 Row 535 was cut by GROUP_CONCAT() 1260 Row 555 was cut by GROUP_CONCAT() 1260 Row 588 was cut by GROUP_CONCAT() 1260 Row 612 was cut by GROUP_CONCAT() 1260 Row 639 was cut by GROUP_CONCAT() Records: 1239 Duplicates: 0 Warnings: 378 4,735 sec
Voeg dan zoiets toe:
SET group_concat_max_len=300000
Nog beter: Doe dit in /etc/mysql/my.cnf
. Zie Configuratiebestanden (MySQL) voor details.