FireStats error : Database error: Unknown column 'type' in 'field list'

MySQL Version: 5.0.67-community
SQL Query:
INSERT DELAYED INTO `wp_firestats_pending_data` ( `timestamp`, `site_id` , `url` , `referrer` , `useragent` , `ip`, `type` ) VALUES ( NOW(), '1', 'http://gbbert.com/babble/index.php/2008/09/04/using-a-gform-to-collect-urls/', '', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '38.107.191.85', NULL )

Using a Gform to Collect URLS

2008 September 4
by Gary

I was having some difficulty aggregating all of the kids different Edublog feeds, I have about 80 kids that are trying out blogging for the first time. I used a google form to get all of the information I would need from each student. 

 

With the data I then added some columns to the spread sheet that concatenated the information to form a URL. I wanted to add this information to a wordpress blog but wordpress strips the html out of blogposts.

After searching I came across rawHtml a plugin that allows me to inlcude HTML code in a blog. This allowed me to create a list of all 80 of the RSS feeds I have going so now I can aggregate the feeds and comments.

 

Sample of the first few feeds

ssismar’s Feed
ssismar’s Comment Feed

ssisye’s Feed
ssisye’s Comment Feed

ssisyeon’s Feed
ssisyeon’s Comment Feed

ssismin’s Feed
ssismin’s Comment Feed

ssiskanh’s Feed
ssiskanh’s Comment Feed

ssisji’s Feed
ssisji’s Comment Feed

ssismon’s Feed
ssismon’s Comment Feed

ssistam’s Feed
ssistam’s Comment Feed

ssisjaise’s Feed
ssisjaise’s Comment Feed

ssisjihye’s Feed
ssisjihye’s Comment Feed

Comments are closed for this entry.