View of image causes errors

I uploaded an image into an album. There was an error there, but I neglected to capture it. If I view the image now, I get the following error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: function concat(text) does not exist LINE 1: ...tid = 3 AND (n.moderate = 0 AND n.status = 1) AND CONCAT(LPA... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts. in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT COUNT(n.nid) FROM lemming_node n INNER JOIN lemming_term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 3 AND (n.moderate = 0 AND n.status = 1) AND CONCAT(LPAD(9999999999 - n.nid, 10, '0')) < '9999999989' in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 144.

example can be found at www.uniquelemming.com