Error while importing content from Wiki.js 1.x.x or editing pages with long content #942

New issue

Open

opened 2026-02-20 15:25:54 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 15:25:54 -05:00

Owner

Originally created by @SConstantinou on GitHub (Dec 9, 2019).

Originally assigned to: @NGPixel on GitHub.

Describe the bug
Wiki.js 2.0.12 with DB mysql
table pageHistory column content is of type text
this causes problems when importing from Wiki.js 1.x or when using the "Import Everything" action under storage. For most entries in the table we get warnings like: "Data too long for column 'content' at row 1". The behaviour is the same when editing a pages and trying to add long content.

To Reproduce
Import pages with long content (over 64KB) especially entered all at once.

Expected behavior
Page should be updated normally without error. LONGTEXT should be used in mysql instead of text.

Screenshots

Host Info (please complete the following information):

OS: Ubuntu 18.04
Wiki.js version: 2.0.12]
Database engine: MariaDB 10.4.10]

Additional context
nsert into pageHistory (action, authorId, content, contentType, createdAt, description, editorKey, hash, isPrivate, isPublished, localeCode, pageId, path, publishEndDate, publishStartDate, title) values ('updated', 1,

.......

Data too long for column 'content' at row 1"

Originally created by @SConstantinou on GitHub (Dec 9, 2019). Originally assigned to: @NGPixel on GitHub. **Describe the bug** Wiki.js 2.0.12 with DB mysql table pageHistory column content is of type text this causes problems when importing from Wiki.js 1.x or when using the "Import Everything" action under storage. For most entries in the table we get warnings like: "Data too long for column 'content' at row 1". The behaviour is the same when editing a pages and trying to add long content. **To Reproduce** Import pages with long content (over 64KB) especially entered all at once. **Expected behavior** Page should be updated normally without error. LONGTEXT should be used in mysql instead of text. **Screenshots** **Host Info (please complete the following information):** - OS: Ubuntu 18.04 - Wiki.js version: 2.0.12] - Database engine: MariaDB 10.4.10] **Additional context** nsert into `pageHistory` (`action`, `authorId`, `content`, `contentType`, `createdAt`, `description`, `editorKey`, `hash`, `isPrivate`, `isPublished`, `localeCode`, `pageId`, `path`, `publishEndDate`, `publishStartDate`, `title`) values ('updated', 1, ....... Data too long for column 'content' at row 1"