vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How to increase length of forum title (https://vborg.vbsupport.ru/showthread.php?t=299426)

Gardarika 06-23-2013 11:06 AM

How to increase length of forum title
 
So as the title say's... What and where should I edit?

Lynne 06-23-2013 01:52 PM

The two database fields, title and title_clean, in the forum table is set to 100 characters. So, if you want a longer title, you would need to actually modify the fields in the database.

Please make a database backup prior to doing any changes to your database.

Christos Teriakis 06-24-2013 01:21 PM

Quote:

Originally Posted by Lynne (Post 2429990)
....is set to 100 characters. So, if you want a longer title, you would need to actually modify the fields in the database.

The problem is that for non-English sites operating in UTF-8 the limit is much less as there are letters getting even 4 symbols space.

Lynne 06-24-2013 03:02 PM

Quote:

Originally Posted by Christos Teriakis (Post 2430177)
The problem is that for non-English sites operating in UTF-8 the limit is much less as there are letters getting even 4 symbols space.

Yep, I've run into that problem before which is why I remembered that it was a database limit, not some vbulletin limit, on the length of the title.

Gardarika 06-24-2013 03:09 PM

@ Lynne
I'd searched already in Internet and see the same problem, and to all that I have non-English forum. I completely forgot to mention about that.

And I got to know that datebase and forum should be in the same coding (language), I missed it completely.

Coding for datebase - itf8_general_ci for Russian is what I need or it's wrong?

Christos Teriakis 06-24-2013 03:31 PM

@Lynne: The problem is that such limits are oudated. Lenght limits are coming from the early database days when there was db space limits from Hosting providers especially for users of MS_SQL (Microsoft's tricks :) ). I believe that many users will remember those hosting plans: 100 MB webspace, 1 database max 10MB. I think that is good in a next update to have these values changed to varchar(255).

@Gardarika: If you're running a forum in Russian you're in worst position than Greeks. Without to be 100% sure, I believe that all Russian characters (Cyrillic alphabet) are getting 4 symbols. That means that in real you've not more than 40 characters available. My suggestion is to follow what Lynne wrote. It's not that difficult, but I don't know if there are other sections needing modification. eg search table??

Edited: In case that you'll see strange characters at the end of the title, it means that somewhere there is a restriction on how many characters to show. As an example: I've seen many mods (I'm also doing it) giving you the ability to show xx characters of title (usally in widgets or forum sidebar blocks). Let's say that you set it to 30 characters. If the 30th character is a special character getting double quote space, then you'll see that strange symbol instead the real character.

Gardarika 06-24-2013 05:30 PM

@ Christos

The main problem for me was accordance of language (coding) datebase and the forum, with the same language all problem's disappeared. I have russification for my forum, so all is ok now.


All times are GMT. The time now is 08:39 AM.

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.01690 seconds
  • Memory Usage 1,722KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete