> mysql> select length(html), ExtractValue(html,
> '/html/head/title') from static_h
> tml where html is not null limit 1;
> +--------------+----------------------------------
> ------+
> | length(html) | ExtractValue(html,
> '/html/head/title') |
> +--------------+----------------------------------
> ------+
> | 63453 | NULL
> |
> +--------------+----------------------------------
> ------+
> 1 row in set, 1 warning (0.00 sec)
Do a SHOW WARNINGS at this point to see what the actual warning raised was.
From looking at the pages HTML content the problem is most likely that it is not valid XML (unclosed comments, unclosed tags ...)
http://validator.w3.org/check?uri=http%3A%2F%2Fscoach.ch%2FDEU%2FFactsheet%2FTracker_Certificates%2FCH0030157801&charset=%28detect+automatically%29&doctype=Inline&group=0
--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering