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/germany/', '', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '38.107.191.94', NULL )

Category Archives: Germany

Bryan Adams Live in Berlin

I couldn’t have imagined in my wildest dreams that I’ll be able to go to a Bryan Adams concert when I came to Germany! In fact, I didn’t even know about it till a week before the conert. Thanks to Shah Rukh Khan, and his later-got-cancelled-concert in Germany (Berlin, Munich, Frankfurt) Temptations Reloaded, I had [...]

An exciting weekend in Berlin

I can’t thank myself enough for not coming back to Leipzig straight after the BA concert on Friday, and rather staying in Berlin for the weekend – to witness this great city soaked in history and culture, and also the famous famous Berlin Marathon 2008! Although I could not witness the legendary Haile Gebrselassie crossing [...]

Leipzig Town Race

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 [...]

Looking forward to Berlin

So much has been happening here in Leipzig that I bareky get any time to think over the experiences and manifest them. Investment banks, consultancies , projects, exams.. huh! In the meantime I even got the chance to go to a 10 KM race event (details later) here at the Clara Zetkin Park which was [...]

Taxi ride at Porsche

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 [...]

1st week in Germany

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 [...]

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(1268265227) 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(1268265227) GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u today
FireStats icon Powered by FireStats