[NLP-er]

Originally Posted by TheLastSuperman

I had a similar error just like this: http://www.mydigitallife.info/2007/0...-a-key-length/

I used this and it worked, turned on cache yet when you navigate to another page after translation is does not stick? Long story short no DB error when cache is enabled like I used to have but it will not hold the translation.

CREATE TABLE vbenterprisetranslator_cache_medium (
id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
serie BIGINT(14) UNSIGNED,
dateline int(10) UNSIGNED default 0,
tl VARCHAR(5),
originaltext VARCHAR(255),
translated VARCHAR(255),
UNIQUE (originaltext, tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

And images? Not sure about that, it was that other mod I used err well code actually but I added in the do not translate tags and no effect.

About DB - the reason is differences in mySQL versions. On my version varchar(328) is not automatically changed to blob/text - on yours it is.

Please let me know which version do you have?

You made wrong changes in SQL, please drop your table and use this one (corection will be included in next release):

CREATE TABLE vbenterprisetranslator_cache_medium (
id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
serie BIGINT(14) UNSIGNED,
dateline int(10) UNSIGNED default 0,
tl VARCHAR(5),
originaltext VARCHAR(328),
translated VARCHAR(1000),
UNIQUE (originaltext(328), tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin

About holding translation - turn on tracking in options.

Not understood about images.