submitting tags over 128 characters throws postgres errors

Bug #864926 reported by Melissa Draper
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Low
Son Nguyen

Bug Description

[WAR] 5f (lib/errors.php:749) Failed to get a recordset: postgres7 error: [-1: ERROR: value too long for type character varying(128)] in adodb_throw(INSERT INTO "view_tag" ("view", "tag") VALUES (?, ?), Array)
Command was: INSERT INTO "view_tag" ("view", "tag") VALUES (?, ?) and values was (6,overflooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooow)

Master, postgres only.

Melissa Draper (melissa)
summary: - submitting tags over 128 characters throws sql errors
+ submitting tags over 128 characters throws postgres errors
Changed in mahara:
status: New → Confirmed
importance: Undecided → Medium
importance: Medium → Low
tags: added: bite-sized
tags: added: postgres
Son Nguyen (ngson2000)
Changed in mahara:
assignee: nobody → Son Nguyen (ngson2000)
status: Confirmed → In Progress
Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/1147
Committed: http://gitorious.org/mahara/mahara/commit/ca064efb4a5d56c6664e26afcb053328597569d5
Submitter: Hugh Davenport (<email address hidden>)
Branch: master

commit ca064efb4a5d56c6664e26afcb053328597569d5
Author: Son Nguyen <email address hidden>
Date: Tue Apr 10 11:10:25 2012 +1200

    Submitting tags over 128 characters throws postgres errors Bug#864926

    + truncate the tag before insert it into the database

    Change-Id: I4eda5698425bba91a3048881c0ce9bc1df21b568
    Signed-off-by: Son Nguyen <email address hidden>

Melissa Draper (melissa)
Changed in mahara:
milestone: none → 1.6.0
Son Nguyen (ngson2000)
Changed in mahara:
status: In Progress → Fix Committed
Revision history for this message
Hugh Davenport (hugh-davenport) wrote :

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

 status fixreleased
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iJwEAQECAAYFAlCbHO8ACgkQuMoJ2LQ3zxH8TAP/YN4BiCJZsn5a899/0UzV31Qg
lM8LXAwZWa6zFv6t0BQUHCqe6eFK9wPp51qgCWWXjUZ3vvvVcsyeWp6626aBFKSU
pCQXI9E7huPw802nJQ9WcZXRBUmgw87ww72Tx4mybnu7SPSrkZgXdnPGSMwDs89N
oWvTpl7Xuac48e6p0lU=
=ouU+
-----END PGP SIGNATURE-----

Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.