Row size too large (> 8126). Changing some columns to TEXT or BLOB may help

Support
#1

Situation
I am moving Opememr from web hosting to localhost. I got error when I import database into phpmyadmin with message MySQL said: #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

OpenEMR Version
I’m using OpenEMR version 5.01

Browser:
I’m using: Chrome

Operating System
I’m using: Windows 10

Logs
MySQL said: #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Capture
Capture2554×950 129 KB

#2

Hi @jhunyan,

Please replace varchar data type to text it will resolve your issue.

#3

Hi @Nilesh_Hake,

Thank you for your reply.

I look at the database in phpmyadmin and unable to find the table ‘history_data’. I wonder where I can look for this.localhost _ 127.0.0.1 _ openemr _ phpMyAdmin 5.0.2.pdf (714.1 KB)

Please advise

#4

@jhunyan

Some of the OpenEMR database tables are missing in your pdf(233 tables in openemr).

Seems the tables are not get completely imported.

Try to import the database again.

For any clarification refer the below link to export and import.
https://mediatemple.net/community/products/wordpress/204403864/export-and-import-mysql-databases

Thanks,
ViSolve