phpBB • Free and Open Source Forum Software

Data too long for column 'post_subject' at row 1 [1406]

Text length it tried to allow: 259:

Code: Select all: Re: &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

Was using this:

Code: Select all: $subject = truncate_string($subject, 254);

EDIT: Seems to work properly on submitting a topic, but if you reply to a topic it seems not to work...

And easy fix:

Open:
includes/functions_content.php

Find:

Code: Select all: if ($allow_reply && strpos($string, 'Re: ') === 0) { $strip_reply = true; $string = substr($string, 4); }

In the if statement add:

Code: Select all: $max_store_length -= 4;

Related to: http://www.phpbb.com/bugs/phpbb3/33885

Also: http://www.phpbb.com/bugs/phpbb3/25235 (which was fixed with r8667)

Essentially, setting $max_store_length -= 4; is the same as removing the "allow reply" functionality altogether. I'm not sure I understand the reason behind having the $allow_reply parameter, tbh. I guess it was a holdover from before #25235 was fixed, when the DB field was 64 chars and the maximum length allowed was 60. Could we depricate this parameter?

	What:	Where:	Country:
vacatures php arbeit php jobs php lavoro php emploi php trabajo php jobs php arbeit php

truncate_string not working correctly when replying (fix completed in vcs)

Comments / History

Ticket details

Related SVN changesets

Advertisements