The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page