GROUP CONCAT()-error (MySQL)

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.

Zie ook

• Configuratiebestanden (MySQL)

Bronnen

• https://stackoverflow.com/questions/7208773/mysql-row-30153-was-cut-by-group-concat-error