[NLP-er]

Originally Posted by Lee G

Cheers for that and the other tip about the footer link :up:

Top man imported_silkroad

Im still getting the data base errors, even after uninstalling the previous version and installing the new version fresh.

The strange thing is

Even with the cache turned off, if you add any that you wanted cached, the errors still happen, but only on those with a tick in the box.

Even with the cache turned off, page loads are a lot faster with the new version :up:

The only two new data basses I can see that have been created are
vbenterprisetranslator_cache
and
vbenterprisetranslator_cache_short

Great little mod, with my own testing so far :up:

You should have 3 cache tables - that is the problem and cause of errors. Have no idea why one didn't created (maybe some mysql version issues) - I could made research but for this I would need access to your admin cp, ftp, and mysql panel. So if you will be desperate enough just PM me
Meantime - put creation code of medium cache table in mysql panel and see does some error messages occurs.

"CREATE TABLE " . TABLE_PREFIX . "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, tl),
INDEX(serie)
) ENGINE = MYISAM, CHARACTER SET utf8 COLLATE utf8_bin"

Just change " . TABLE_PREFIX . " to tour table prefix value with dot. Let me know about results

About errors when cache disabled and checked for language - I found little bug (harmless - always can disable cache for language) and cache is working for 2nd languages group if enabled for language and disabled globally- will be corrected in next release

Page loads are really much faster even without cache There are lot less requests for translations to google (made several translations at once) - that's why it is so fast