Support

Site Restoration

#35769 ErrNo #1118 Row size too large (8126)

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

cardexchange

I have backed up my site and i am trying to restore to the new server, the extraction goes ok but I get this error creating the database tables.

 

<h2>Database error processing line 109</h2> <p>Database server error reply:</p> <tt>ErrNo #1118</tt> <pre>Row size too large (&gt; 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Can you please advise what this is referring to and how I can resolve it?

tampe125
Akeeba Staff

Hello,

this usually happens when you have a row with so many data that exceeds the limit inside MySQL configuration. Sadly there's no workaround for that, because it simply doesn't fit.

During database restoration, please remove the check from the option Stop on CREATE error and Stop on other errors. In this way ANGIE will continue restoration, once it completes you can review the query that failed and check if that's something critical or you can continue without.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.