pgsql db queries give errors [#135306]


    * warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in \dev\includes\database.pgsql.inc on line 125.
    * user warning: ERROR: value too long for type character varying(128) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'search', '<em>unstable</em> (Content).', 0, '<a href="/search/node/unstable" class="active">results</a>', 'http://aaa/search/node/unstable', 'http://hp113.mitaua.dk/project/issues/switch?page=2&projects=23&states=1%2C8%2C13%2C14%2C2%2C3%2C4%2C5%2C6%2C7&categories=0&priorities=0&users=&js=0&form_token=485a6ac94537abe6052b34e3f3ecf058&form_id=project_issue_query_result_quick_search', '192.168.5.113', 1176273236) in \dev\includes\database.pgsql.inc on line 144.

Comments

Comment #1

HorsePunchKid commented 23 April 2007 at 19:41

Component:

search.module

» watchdog.module

(Note that the error came from the watchdog insert, not from the search module.)

It does seem like 128 characters is a bit short for a URL. There may be no standard upper bound, but something on the order of thousands would not be unreasonable, methinks. I suspect this limitation exists in other places outside the watchdog module.