-
Bug
-
Resolution: Fixed
-
3.0.0
-
None
-
PHP Environment:
Database:
Using
123456789012345678901234567890123456789012345678901"""""""""
|
SQL ERROR [ mysql4 ]
|
|
|
Data too long for column 'topic_title' at row 1 [1406]
|
|
|
SQL
|
|
|
INSERT INTO phpbb_topics (topic_poster, topic_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment) VALUES (2, 1207842143, 11, 0, 1, '123456789012345678901234567890123456789012345678901"""""""""', 'nickvergessen', '0066FF', 0, 0, 0)
|
|
|
BACKTRACE
|
|
|
FILE: includes/db/mysql.php
|
LINE: 158
|
CALL: dbal->sql_error()
|
|
|
FILE: includes/functions_posting.php
|
LINE: 1826
|
CALL: dbal_mysql->sql_query()
|
|
|
FILE: posting.php
|
LINE: 1003
|
CALL: submit_post()
|
this happens because you change " to " before submitting to the DB.
The DB-column is only 100 chars long, so we need only 9 " which leed to + 45 Chars which is with 60 allowed in the title 5 to much for the column. In worst case a User may use 64 " which where about 384 Chars in the DB
Also Case in 301 but it's not in the drop-down