Closed (fixed)
Project:
Bot
Version:
7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
8 Jan 2013 at 21:11 UTC
Updated:
23 Jan 2013 at 01:00 UTC
We've noticed that Druplicon gets automatically kicked when someone pastes a link to a d.o issue with a long title in IRC. Example links that cause this:
http://drupal.org/node/1882584
http://drupal.org/node/1883610
http://drupal.org/node/1875632
Comments
Comment #1
morbus iffPDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'title' at row 1: INSERT INTO {bot_urls} (url, title, count, last_seen) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => http://drupal.org/node/1883610 [:db_insert_placeholder_1] => #1883610: This is a test issue with a very long title. Lost in thought and lost in time, while the seeds of change were planted........... [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 1357679255 ) in drupal_write_record() (line 6884 of /srv/www/druplicon.info/public_html/includes/common.inc).
Comment #2
dave reidYeah I was going to say the title field is limited to 128 characters but is never trimmed before insertion.
Comment #3
morbus iffI'd want to increase the default to match d8 n.title (being 255).
Comment #4
morbus iffFixed.