GROUP CONCAT()-error (MySQL)
Naar navigatie springen
Naar zoeken springen
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.