Error Number: 1054 using xmlGrab
Development and Programming
I am using EE 1.6.8 and cannot grab an xml file using xmlgrab.
here is my template:
{exp:xmlgrab url="http://www.physiotherapy.ca/rss/cparss.xml"
itempath="/rss/channel/item"
weblog="9"
title="title"
date="pubDate"
use="link|description"
fields="link|Whats_New_Short"}
{exp:weblog:entries orderby="date" sort="asc" limit="10" weblog="Whats_New" }
<h2>{title}</h2>
{Whats_New_Short}
<a href="http://{link}">Link</a>
{/exp:weblog:entries}Here is part of the xml file
<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title>Canadian Physiotherapy Association News</title>
<link>http://www.physiotherapy.ca/public/public.asp?WCE=C=47|K=231368|RefreshT=231367|RefreshS=LeftNav|RefreshD=2313670</link>
<description>Timely, relevant information about all-things-physiotherapy in Canada (i.e., notable professional, political, economic, social and technological events).</description>
<language>en-ca</language>
<copyright>2009-2010 Canadian Physiotherapy Association</copyright>
<lastBuildDate>Tue, 2 Feb 2010 9:00:00 -0500</lastBuildDate>
<image>
<url>http://www.physiotherapy.ca/PublicUploads/225941CPAlogo_rss.jpg</url>
<title>Canadian Physiotherapy Association</title>
<link>http://www.physiotherapy.ca/public/public.asp?WCE=C=47|K=231368|RefreshT=231367|RefreshS=LeftNav|RefreshD=2313670</link>
<width>88</width>
<height>31</height>
</image>
<item>
<title>Canadian physiotherapists a growing, multi-faceted, more educated profession</title>
<link>http://www.physiotherapy.ca/public.asp?WCE=C=47|K=231368|RefreshT=231367|RefreshS=LeftNav|RefreshD=2313670#38</link>
<description>More physiotherapists are available to help Canadians of all ages, according to a new report by the Canadian Institute for Health Information. The report, Physiotherapists in Canada, 2008, provides a snapshot of these university-educated professionals and where they deliver their personal hands-on care across the country.</description>
Tue, 2 Feb 2010 9:00:00 -0500</pubDate>
</item>and this is what my template looks like when published: Fetching: http://www.physiotherapy.ca/rss/cparss.xml Checking: Canadian physiotherapists a growing, multi-faceted, more educated profession Found new entry: Canadian physiotherapists a growing, multi-faceted, more educated profession
Notice: Undefined index: id in /home/user/public_html/admin/plugins/pi.xmlgrab.php on line 310
Notice: Undefined index: id in /home/user/public_html/admin/plugins/pi.xmlgrab.php on line 311
Notice: Undefined index: format in /home/user/public_html/admin/plugins/pi.xmlgrab.php on line 311 MySQL ERROR:
Error Number: 1054
Description: Unknown column ‘field_id_’ in ‘field list’
Query: INSERT INTO exp_weblog_data (entry_id, weblog_id, field_id_, field_ft_, field_id_26, field_ft_26) VALUES (‘6798’, ‘9’, ‘http://www.physiotherapy.ca/public.asp?WCE=C=47|K=231368|RefreshT=231367|RefreshS=LeftNav|RefreshD=2313670#38’, ”, ‘More physiotherapists are available to help Canadians of all ages, according to a new report by the Canadian Institute for Health Information. The report, Physiotherapists in Canada, 2008, provides a snapshot of these university-educated professionals and where they deliver their personal hands-on care across the country.’, ‘none’)
ok got the error fixed with a typo in one custom field.
now I am getting
Fetching: http://www.physiotherapy.ca/rss/cparss.xml
Checking: Canadian physiotherapists a growing, multi-faceted, more educated profession
Found new entry: Canadian physiotherapists a growing, multi-faceted, more educated profession
Checking: Physiotherapy research grants available
Found new entry: Physiotherapy research grants available.........on and onat the top of my template. How do I hide this checking found checking found etc?
and then in my page the first entry is repeated 5 times then the others flow as they should.
Solved. I was confusing xml grab with the Magpie plugin.