increase temporty table type to LONGTEXT

  • I spent hours trying to figure this one out!

    wp2epub uses a temporary mysql table to store things as it goes along. Unfortunately it is defined as a TEXT field, which contains only so many characters – not enough, it seems, for some of my posts which exceeded the allowable length and got truncated (but wihout any warnings or errors)

    So, please would you change the line that reads
    $q="CREATE TEMPORARY TABLE$this->base(idINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,valTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL) ENGINE = MYISAM";

    to

    $q="CREATE TEMPORARY TABLE$this->base(idINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,valLONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL) ENGINE = MYISAM";

    in file wp2epub.class.php

    And then everything works fine!

    Thanks

    Noel

    https://www.ads-software.com/plugins/wp2epub/

  • The topic ‘increase temporty table type to LONGTEXT’ is closed to new replies.