title: Mysql insert "MySQL returned an empty result set"
body: <p>I don't understand what's wrong with this query?</p>
  
  <pre class="lang-sql prettyprint-override"><code>INSERT INTO files 
              (FILE, 
               season, 
               episode, 
               playlistname, 
               uuid,
               type
               ) 
  VALUES      ('link', 
               1, 
               3, 
               'name', 
               '123555',
               1
               ) 
  </code></pre>
  
  <p>the response from mysql</p>
  
  <blockquote>
    <p>MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)</p>
  </blockquote>
  
  <p>=================================
  Update</p>
  
  <p>I tried just to run 
  <code>insert into files (file) values('file')</code></p>
  
  <p>and the result is the same.</p>
  
  <p>I'm using mysql percona 5.6</p>
  
  <p>table structure:</p>
  
  <pre><code>| files | CREATE TABLE `files` (
    `pfid` int(11) NOT NULL AUTO_INCREMENT,
    `post_id` varchar(11) DEFAULT NULL,
    `fDomain` varchar(20) DEFAULT NULL,
    `file` text CHARACTER SET utf8 NOT NULL,
    `playlistName` varchar(20) DEFAULT NULL,
    `thumbs_img` text,
    `thumbs_size` text,
    `thumbs_points` text,
    `poster_img` text,
    `mini_poster` varchar(20) DEFAULT NULL,
    `type` int(11) NOT NULL,
    `uuid` varchar(40) DEFAULT NULL,
    `season` int(11) DEFAULT NULL,
    `episode` int(11) DEFAULT NULL,
    `comment` text CHARACTER SET utf8,
    `time` varchar(40) CHARACTER SET utf8 DEFAULT NULL,
    PRIMARY KEY (`pfid`),
    KEY `ix_files__post_id_type` (`post_id`,`type`),
    KEY `ix_playlistName_Ep_Se` (`playlistName`,`season`,`episode`)
  ) ENGINE=InnoDB AUTO_INCREMENT=130030 DEFAULT CHARSET=latin1 |
  </code></pre>