Data too long for column 'referer' [#238952]

I've got this database error when i renamed and saved a taxonomy term.

user warning: Data too long for column 'referer' at row 1 query: INSERT INTO site2_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'taxonomy', 'The term <em>Example</em> was updated.', 0, '<a href=\"/index.php?q=admin/content/taxonomy/edit/term/55\" class=\"active\">Edit</a>', 'http://my-very-very-very-long-hostname.drupal1.example.com/index.php?q=admin/content/taxonomy/edit/term/55&destination=admin%2Fcontent%2Ftaxonomy%2F2', 'http://my-very-very-very-long-hostname.drupal1.example.com/index.php?q=admin/content/taxonomy/edit/term/55&destination=admin%2Fcontent%2Ftaxonomy%2F2', '192.168.0.55', 1206541724) in C:\InetPub\drupal1\includes\database.mysql.inc on line 172.

Comments

Comment #1

goose2000 commented 7 August 2008 at 13:24

Hi, I know this has been addressed else where, but I'll chime in here a bit. This will happen I found, when you use other modules like 'Node Go To' (this module allows you to define any page or URL as the target). This adds a really long referrer in the address bar. And this is what is trying to get saved in the watchdog table.

Only trouble is, it won't fit in there. The datatype won't accept that many characters. This can happen in D5 or D6. My work around eventually was to change the datatype to just 'TEXT' and the problem was gone. This does need to be looked at by Drupal core people, it is a real bug.