Im guessing MySQL doesn't complain about this which is why no one has seen this yet but the length of the referer column in the watchdog table isn't long enough. For example, Drupal tried logging this referer when an error came about:
http://xxxxxxxxx.xxx.xxxx.xxx-xx.xx.xx/admin/content/node-type/project/f...
which is 157 chars long, this kicked up a big stink in Postgres, the query failed, and I don't get to revise what should have been logged.
so do we cut the referer down to 128 chars before inserting or do we bump up the capacity. The column is varchar so there is no problem in using 255 for example, because if the string is only 157 chars long then only 157 chars worth of space will be used not the whole 255.
Comments
Comment #1
dave reidDuplicate of #107824: Convert {watchdog}.referer and {accesslog}.url from VARCHAR to TEXT.