Error when content contains long URL - value too long for type character varying(100)


(Dean Taylor) #1

Hi,

This error is in the logs from an import from phpBB.

Looks like long URL’s in content cause this one.

PG::Error: ERROR:  value too long for type character varying(100)
: INSERT INTO "topic_links" ("created_at", "domain", "post_id", "topic_id", "updated_at", "url", "user_id") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"

Backtrace:

Example log URL in content causing issue:

http://www.was-a-good-idea-at-the-time-now-in-debt-and-because-its-not-running-its-the-aaaaaa-cat-ever-but-i-dont-want-to-sell-it-im-attached.com

(Sam Saffron) #2

Fixed here:


(Sam Saffron) #3