Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How to fix 1118 Row Size too large in WHM/cPanel?

Discussion in 'Database Discussion' started by Gatchie, Apr 10, 2016.

  1. Gatchie

    Gatchie Registered

    Joined:
    Apr 10, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Zealand
    cPanel Access Level:
    Website Owner
    I'm looking for anyone who can point me on how to fix 1118 Row Size too large in WHM/cPanel? I am getting errors when adding more fields in my table. I have renamed all of the varchar field to text and change the length of each to mostly 20.

    Any ideas would be highly appreciated.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,214
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you verify if you have root access to the system, and which version of MySQL is installed? Assuming you have root access, the following MySQL document explains a possible cause:

    MySQL :: MySQL 5.6 Release Notes :: Changes in MySQL 5.6.20 (2014-07-31)

    Changing the "innodb_log_file_size" value in your /etc/my.cnf file should address the issue, or if you do not have root access, you can contact your web hosting provider and reference this document to them.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice