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

Category Archives: Travel

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

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

Back from Kafni Glacier Trek

Finally the dream is over and I have to land in civilization! After 2 weeks in Utopian territories, as far as possible from any signs of so-called modern advancements and technology, and as near as possible to the nature, the mighty Kumaon Himalayas and myself, I come back back with memories of definitely the most [...]

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