Storage error 139 when adding new content!

I came across this little gem when trying to add content to my newly create Drupal content type. I had just created a new content type and was adding some content of that type to make sure everything was working ok. The content type in question had around 25 fields or so, which was a combination of text areas and image fields.

It turns out that INNODB can't take more than 8000 bytes per row. This also doesn't appear to be something that you can increase. I don't know what the reasoning for it is, maybe it's too hard on the transactional setup if you give it too much data at one time.

Anyhow! The solution? Change the engine for that table :) I'm using mySQL WorkBench at the moment so all I did was:

  1. Open a connection to the server
  2. Connect to the database (click the Database menu, the click Query Database)
  3. Right-click the problem table, click "Alter Table"
  4. in the engine drop-down, select MyISAM.

 

That's it! The content type works again :)

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.