post title

[living199]

how do i change the maximum size of a post title?

thanks

[ameeck]

Find this in includes/functions_posting.php:

Code: Select all

$subject = truncate_string($subject);
$data['topic_title'] = truncate_string($data['topic_title']); 

and replace it with this:

Code: Select all

  $subject = truncate_string($subject, 100);
$data['topic_title'] = truncate_string($data['topic_title'], 100); 

'100' is the max number of chars, you can safely change it up to ~200.

You will also have to change the data type for the title fields in the database.

post_subject in phpbb_posts
topic_title in phpbb_topics
from VARCHAR(100) to VARCHAR(255).

You can do this with these two queries:

Code: Select all

ALTER TABLE phpbb_posts MODIFY post_subject VARCHAR(255) NOT NULL;
ALTER TABLE phpbb_topics MODIFY topic_title VARCHAR(255) NOT NULL;

[living199]

thanks.

sorry it took so long to reply

[davidm_nodeo]

Thanks for this, as I needed it... crystal clear instructions, 2mns implemented

[TheHighwayman]

Thank you ameeck, for the answer.
I'm looking for it.

However, I have noticed there are other database fields must be modified, that are topic_last_post_subject e forum_last_post_subject.
Besides also charset and collation must be added.

So queries to be done, are:

Code: Select all

ALTER TABLE phpbb_posts MODIFY post_subject VARCHAR(255) character set utf8 collate utf8_unicode_ci NOT NULL default '';
ALTER TABLE phpbb_topics MODIFY topic_title VARCHAR(255) character set utf8 collate utf8_unicode_ci NOT NULL default '';
ALTER TABLE phpbb_topics MODIFY topic_last_post_subject VARCHAR(255) collate utf8_bin NOT NULL default '';
ALTER TABLE phpbb_forums MODIFY forum_last_post_subject VARCHAR(255) collate utf8_bin NOT NULL default '';

Change charset and collation, if you use other ones.

Regards
The Highwayman

[AUDIOMIND]

anyone else did this with success for 3.0x?

[ziplock122940]

anyone else did this with success for 3.0x?

nope, just tried. all of my database values were already 255. I have even tried changing the values in posting_editor inside the template but that has not helped. I am building a new site running 3.0.2

[AUDIOMIND]

ugh....

there must be a way to lengthen the post title. it is aggravating!

[Linda Carter]

Is there a way to make this work in the last 3.0.7-PL1 version?

I have tried changing that file and performing both SQL queries but nothing seems to work.

[Bluesplayer]

I am running version 3.0.8 and I managed to alter the topic length by:

Find this in includes/functions_posting.php (as mentioned by ameeck above):

Code: Select all

$subject = truncate_string($subject);
$data['topic_title'] = truncate_string($data['topic_title']); 

and replace it with this:

Code: Select all

$subject = truncate_string($subject, 200);
$data['topic_title'] = truncate_string($data['topic_title'], 200); 

I then altered this string in posting_body.html:

Code: Select all

<!-- IF S_NEW_MESSAGE -->60<!-- ELSE -->64<!-- ENDIF -->" tabindex="2" value="{SUBJECT}" />

to this:

Code: Select all

<!-- IF S_NEW_MESSAGE -->80<!-- ELSE -->84<!-- ENDIF -->" tabindex="2" value="{SUBJECT}" />

The above allowed a longer title to be inserted when creating a topic or editing a topic title.

I used the forum admin template editor and I didn't need to refresh the cache, but if you manually alter it I should think you would have to refresh the cache.

Seems to work fine now.

[dueller]

Thank you Bluesplayer. I recently updated my forum to 3.0.8 and your solution works great.

[qu4rk]

I am running version 3.0.8 as well. I don't see a includes/functions_posting.php. Did the file change or am I missing something?

Thanks

[Alien_Time]

Hi Guys,

I am using phpbb 3.0.8 as well and I tried to do the above steps to increase the length of the post title and nothing seems to change...This is what I did so far:

I added the following code in includes/functions_posting.php:

Find

Code: Select all

$subject = truncate_string($subject);
$data['topic_title'] = truncate_string($data['topic_title']);

And Replaced with:

Code: Select all

$subject = truncate_string($subject, 200);
$data['topic_title'] = truncate_string($data['topic_title'], 200);

I could not find the codes to alter the string in posting_body.html as mentioned by Bluesplayer above. So where is this code? does it need to be changed?

Code: Select all

<!-- IF S_NEW_MESSAGE -->60<!-- ELSE -->64<!-- ENDIF -->" tabindex="2" value="{SUBJECT}" />

Anyways, after this i went ahead and added the following queries in phpmyadmin:

Code: Select all

ALTER TABLE phpbb_posts MODIFY post_subject VARCHAR(255) NOT NULL;
ALTER TABLE phpbb_topics MODIFY topic_title VARCHAR(255) NOT NULL;

The above sql query was executed successfully showing the below results in the end:

Code: Select all

ALTER TABLE phpbb_posts MODIFY post_subject VARCHAR(255) NOT NULL;# 989 row(s) affected.

ALTER TABLE phpbb_topics MODIFY topic_title VARCHAR(255) NOT NULL;# 231 row(s) affected.

Even with the sql query, I wasnt able to run the query that Bluesplayer mentioned above. The Bluesplayer's sql query gives me an error. So I just did the query as given by ameeck.

Now, even after doing the above, the post title still has a limit of only 60 characters. I cleared the cache and I tried it by creating a new topic and also trying to edit topic titles...its still only 60 characters...How does it work? How to change it??

[Alien_Time]

HI everyone...

I got it to work now...I was looking around the files and I edited the following in the template/posting_editor.html file:

Find:

Code: Select all

	<!-- IF S_POST_ACTION or S_PRIVMSGS or S_EDIT_DRAFT -->
	<dl style="clear: left;">
		<dt><label for="subject">{L_SUBJECT}:</label></dt>
		<dd><input type="text" name="subject" id="subject" size="45" maxlength="<!-- IF S_NEW_MESSAGE -->60<!-- ELSE -->64<!-- ENDIF -->" tabindex="2" value="{SUBJECT}{DRAFT_SUBJECT}" class="inputbox autowidth" /></dd>
	</dl>

Replaced with:

Code: Select all

	<!-- IF S_POST_ACTION or S_PRIVMSGS or S_EDIT_DRAFT -->
	<dl style="clear: left;">
		<dt><label for="subject">{L_SUBJECT}:</label></dt>
		<dd><input type="text" name="subject" id="subject" size="45" maxlength="200" tabindex="2" value="{SUBJECT}{DRAFT_SUBJECT}" class="inputbox autowidth" /></dd>
	</dl>

After that I cleared the cache and viola! Its works...

I hope what i did was correct since its working now..But I am too sure if there is something else to edit as well...if someone can confirm this, it would be great!

Cheers...

[FreddyGdiP]

I´m using version 3.0.9 and tried to follow the steps suggested by BluesPlayer but couldn´t find the string in posting_body.html
To summarize, since there seem to be a lot of steps and missteps to increase the length of the post title, what are the correct steps to do this on version 3.0.9? Anyone out there with the same problem?
Thanks!