vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Forum Display Enhancements - vB Enterprise Translator (https://vborg.vbsupport.ru/showthread.php?t=220886)

NLP-er 08-18-2009 06:31 PM

Quote:

Originally Posted by T2x (Post 1869977)
I have updated the code in my old post for vbseo.php as well as the 301 redirects.

This should hopefully finally fix any issues people were having :D


https://vborg.vbsupport.ru/showpost....&postcount=181

Still same problem on my side :/

.htaccess has possibility to made internal redirect, I was trying it but without success. Maybe you will find working solution in this area. Such internal redirect should work without any vbseo.php changes, because to vbseo will come link with language param. This is idea - as I wtore it don't works for me, but maybe I miss somesthing. This is this not working rule:
Code:

RewriteCond %{REQUEST_URI} ^/(..|zh-TW|zh-CN)/(.*)
RewriteRule ^(.*)$ /%2\?language=%1


TheLastSuperman 08-18-2009 06:35 PM

Quote:

Originally Posted by NLP-er (Post 1869847)
About error - you don't have medium cache table. Please set it manually (have no idea why it didn't create during installation - maybe some mysql version issues) - and in case of errors during creation please give me error measage.
Code:

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

Change " . TABLE_PREFIX . " to your table prefix if use any.

About translaion of images... :D - just go back to styles :)

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.

Code:

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.

NLP-er 08-18-2009 07:25 PM

Quote:

Originally Posted by TheLastSuperman (Post 1870006)
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.

Code:

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):
Code:

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.

T2x 08-18-2009 09:15 PM

Quote:

Originally Posted by NLP-er (Post 1870002)
Still same problem on my side :/

.htaccess has possibility to made internal redirect, I was trying it but without success. Maybe you will find working solution in this area. Such internal redirect should work without any vbseo.php changes, because to vbseo will come link with language param. This is idea - as I wtore it don't works for me, but maybe I miss somesthing. This is this not working rule:
Code:

RewriteCond %{REQUEST_URI} ^/(..|zh-TW|zh-CN)/(.*)
RewriteRule ^(.*)$ /%2\?language=%1



I have already tried doing it via rewrite rules in .htaccess but it will not work with vBSEO


Paste me your ENTIRE .htaccess so I can see if there is a problem with it maybe

Aclikyano 08-18-2009 10:33 PM

Quote:

Originally Posted by NLP-er (Post 1869839)
LOL I think I know what it is. Probably you uploaded new files, bud didn't importend new product file :D I just checked and in previous version this method has less parameters. So made full update - new files on FTP and import new product file. Good lock ;):up:

well i noticed i still had the old XML on DISABLED on admincp but i still uploaded the new xml and i thought i put allow overwrite but ill let u kno in a min thanks! :D

Aclikyano 08-18-2009 10:57 PM

lol it only was showing the Automatic Translation text and no flags
i have flags uploaded to /public html/ forums
im not newbie status i know what im doing most the time lol but something is just not working lmfaooo

merkaz 08-18-2009 11:01 PM

URL tracking trackink every link internal or exitrnal link even if it is not vb link such as gallery or adv and change the link to ?language= .

It should be tracking internal vb links only .

I hope you understand what i mean .

and thanks alot for sharing this amazing mod .

TheLastSuperman 08-18-2009 11:44 PM

Quote:

Originally Posted by NLP-er (Post 1870029)
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):
Code:

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.

I think we both lost each other on images as that was never an issue just that Webdeveloper Plus mod I provided a link to in a previous post, that would translate but the DB error resulted form text in that however we know now that the table was never created so that was not the cause of the error ;)

And MySQL version per the previously posted DB error:

Quote:

MySQL Version : 4.1.22-max-log
I'll drop that table ASAP and try the new, thanks for the revision and prompt replies :D.

S-MAN

NLP-er 08-19-2009 01:10 AM

Quote:

Originally Posted by Aclikyano (Post 1870134)
lol it only was showing the Automatic Translation text and no flags
i have flags uploaded to /public html/ forums
im not newbie status i know what im doing most the time lol but something is just not working lmfaooo

Please give me link to your forum I will look :)

NLP-er 08-19-2009 01:17 AM

Quote:

Originally Posted by merkaz (Post 1870137)
URL tracking trackink every link internal or exitrnal link even if it is not vb link such as gallery or adv and change the link to ?language= .

It should be tracking internal vb links only .

I hope you understand what i mean .

and thanks alot for sharing this amazing mod .

Thanks for note :) I already realized that there is problem with tracing without vbSEO, or with some specific configuration. I have already corrected solution, but want to implement also some new features before release - hope you will forgive me ;)

In this solution language param will be added to all links which not beginning from http (so are local)
or beginning from http ://your.forum.domain - so also local but not relative.

Mostly I'm waiting for solution to new URLs pattern working for everyone. When I got it then new release will come with some harmless bugs fixed and new features. Please be patience a while :)


All times are GMT. The time now is 05:19 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01901 seconds
  • Memory Usage 1,766KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete