Issue 17710

Crawler badly writes username into timestamp field

17710
Reporter: mdoering
Type: Bug
Summary: Crawler badly writes username into timestamp field
Priority: Major
Status: Open
Created: 2015-07-22 10:55:18.763
Updated: 2015-07-22 10:55:18.763
        
Description: Found this in postgres error logs. Looks like we try to write the createdBy value into a timestamp db field.

http://pg1.gbif.org/pgreport_all.html#NormalizedErrorsMostFrequentReport
-----
Error: invalid input syntax for type timestamp with time zone: "crawler.gbif.org at character 32

UPDATE machine_tag SET
Created: 'crawler.gbif.org' WHERE KEY IN(160158, 157421);]]>