Row size too large (> 8126)
Bill Karwin has addressed this before in his answer to Row size error with MySQL
I also addressed this in the past : MySQL: Row size too large (> 8126)
Based on his post, and the fact that you still have several TEXT and VARCHAR fields, you should set the following values higher in my.cnf
:
[mysqld]
max_allowed_packet = 1G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M
Then, restart mysqld.
UPDATE 2015-01-26 23:15 EST
Your comment
In act of despair, I've erased yesterday all the blob columns. I've leave just one. The problem disappeared . But I'll create them again an will try your approach. As soon as possible I return with the result. Thanks for the indication
You should not put 20 BLOB in one table. You should create table to hold the BLOBs
CREATE TABLE mi_fotos
(
id INT NOT NULL AUTO_INCREMENT,
passeio INT NOT NULL,
foto BLOB,
PRIMARY KEY (id)
) ENGINE=InnoDB;
Store your photos in this table and have passeio in this table link back to your original table.