by wbk | 1 maart 2021 19:18
Geen idee meer bij welke upgrade het speelde (NC18 naar NC20?), maar:
An exception occurred while executing 'ALTER TABLE oc_social_3_stream ADD nid BIGINT UNSIGNED DEFAULT NULL, ADD chunk SMALLINT UNSIGNED DEFAULT 1 NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
opgelost met:
su mysql
mysql
show databases;
use nextcloud;
show columns from oc_social_3_stream;
exit ;
cd /var/www/nextcloud/
chmod +x occ
sudo -u nextcloud ./occ maintenance:repair
Source URL: https://online.osba.nl/blog/2021/03/01/nextcloud-fout-bij-upgrade-1118-row-size-too-large/
Copyright ©2025 Open Source, Boudewijns angle unless otherwise noted.