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

MySQL Version: 5.0.88-userstats-log
SQL Query:
INSERT DELAYED INTO `wp_firestats_pending_data` ( `timestamp`, `site_id` , `url` , `referrer` , `useragent` , `ip`, `type` ) VALUES ( NOW(), '1', 'http://journal.naveeng.com/category/leipzig/', '', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '38.107.191.90', NULL )

Category Archives: Leipzig

Leipzig Town Race

September 28, 2008 – 3:07 AM

Last to last Sunday, I had the chance to be at Clara Zetkin Park to enjoy the carnival atmosphere for the 5 and 10 KM races sponsored by Sportscheck. Actually it was Ronny’s participation which excited me even more to go and see. He finished a commendable 15th with a time of around 39 mintes [...]

By Naveen | Also posted in Fun, Germany, Sports | Tagged , , | Comments (1)

Taxi ride at Porsche

September 10, 2008 – 10:28 PM

Well, if the beginning to my European sojourn is something to go by, then definitely it’ll be fun to be here for the next year. Before I could post some pictures of the beautiful city Leipzig is, and about other things here, I am compelled to write the experience we had yesterday. As part of [...]

By Naveen | Also posted in Entertainment, Fun, Germany, Life, Travel, Videos | Comments (2)

1st week in Germany

September 5, 2008 – 4:41 PM

Well, I know it would come as a surprise to most people who know me and are reading this, and also to some of my close friends also, that I’ve moved to Germany to pursue MBA from the HHL – Leipzig Graduate School of Management. And after landing here on the 28th of August, its [...]

By Naveen | Also posted in Germany, Life, Travel | Comments (2)
Database error: Unknown column 'url_site_id' in 'where clause'

MySQL Version: 5.0.88-userstats-log
SQL Query:
SELECT COUNT(*) FROM `wp_firestats_hits` h WHERE `url_site_id` = 1 AND 1 pages viewed, Database error: Unknown column 'url_site_id' in 'where clause'

MySQL Version: 5.0.88-userstats-log
SQL Query:
SELECT COUNT(*) FROM `wp_firestats_hits` h WHERE `url_site_id` = 1 AND `timestamp` >= FROM_UNIXTIME(1268265259) today
Database error: Unknown column 'url_site_id' in 'where clause'

MySQL Version: 5.0.88-userstats-log
SQL Query:
SELECT SUM(u.c) c FROM (SELECT COUNT(DISTINCT ip_int1, ip_int2) c FROM `wp_firestats_hits` h WHERE `url_site_id` = 1 AND 1 GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u visits, Database error: Unknown column 'url_site_id' in 'where clause'

MySQL Version: 5.0.88-userstats-log
SQL Query:
SELECT SUM(u.c) c FROM (SELECT COUNT(DISTINCT ip_int1, ip_int2) c FROM `wp_firestats_hits` h WHERE `url_site_id` = 1 AND `timestamp` >= FROM_UNIXTIME(1268265259) GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u today
FireStats icon Powered by FireStats