Thread: Forum Display Enhancements - vB Enterprise Translator
View Single Post
  #206  
Old 08-18-2009, 02:12 PM
NLP-er's Avatar
NLP-er NLP-er is offline
 
Join Date: Aug 2008
Location: Wrocław
Posts: 1,353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TheLastSuperman View Post
sorry off on a tangent as usual lol..

Hmm let's enable db caching and copy/paste the error hold tight...

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbenterprisetranslator_cache_medium help, vbenterprisetranslator_cache_medium cache WHERE help.originaltext='2142 Tournament C7: Aug 23rd, Battle #5 Map Downloads.' AND help.tl='sq' AND cache.serie=help.serie;

MySQL Error   : Table 'dbnamewashere.vbenterprisetranslator_cache_medium' doesn't exist
Error Number  : 1146
Request Date  : Monday, August 17th 2009 @ 09:15:19 PM
Error Date    : Monday, August 17th 2009 @ 09:15:20 PM
Script        : http://www.tournamentgamingworld.com/online/index.php?language=sq
Referrer      : http://www.tournamentgamingworld.com/online/index.php
IP Address    : hey hey now :p
Username      : [TGW]GA|TheLastSuperman
Classname     : vB_Database
MySQL Version : 4.1.22-max-log
Ok so I think it might be this conflicting w/ the cache:

https://vborg.vbsupport.ru/showthread.php?t=219874

As some of the originaltext in the error above is code I just added to that in the forumhome template to be one of the rotating content seen below the normal navbar location.

I'll try this in the morning, wife is home so time to get off computer

<!--START vBET NOT TRANSLATED AREA--> and <!--END vBET NOT TRANSLATED AREA-->
_____________________

The Tabs mod... I used images instead of the standard CSS but the tabs mod is here:

https://vborg.vbsupport.ru/showthread.php?t=175687

The forum I'm using this on is here:
http://www.tournamentgamingworld.com

Thanks for ANY help you can provide.

S-MAN
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... - just go back to styles
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02363 seconds
  • Memory Usage 1,776KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete