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

Day/Night 2 – Still in train

May 18, 2008 – 1:18 AM

Posted by mobile phone:
The title of this post isn’t something v dint knw b4hand. Wt v dint knw was that i’ll b writin this 4m a place (Gorakhpur) at around 1 am, where we ought to have been 7 hours ago! Courtesy Indian Railways, v now run the risk of not reaching Kathgodam b4 evening n hence not reaching Bageshwar by 18 night, which delays our trip by a day.

2 hours at Dighwar, Bihar due to an engine failure warranted a new engine to be sent before the train could leave. But a storm early morning sent railway schedule haywire.

Spread the Word:
  • Digg
  • del.icio.us
  • StumbleUpon
  • Slashdot
  • Netvouz
  • DZone
  • blogmarks
  • Furl
  • IndiaGram
  • IndianPad
  • Reddit
  • Simpy
  • e-mail
  • Facebook
  • Google Bookmarks
  • Live
  • Technorati
  • YahooMyWeb
  • TwitThis
By admin | Posted in Uncategorized | Comments (0)

Off to Himalayas

May 16, 2008 – 9:45 PM

Posted by mobile phone:
3019 Bagh Express, S2 – 17. This is the precise location from where i\’m posting this. In less than 5 minutes i\’m embarking on my first ever trek – to Pindari Glacier in the Kumaon Himalayas! After a gruelling 36 or more hours me train journey and an insanely sounding 70 stoppages, we\’ll reach Kathgodam from where our sojourn begins.Will keep writing more :-)

Spread the Word:
  • Digg
  • del.icio.us
  • StumbleUpon
  • Slashdot
  • Netvouz
  • DZone
  • blogmarks
  • Furl
  • IndiaGram
  • IndianPad
  • Reddit
  • Simpy
  • e-mail
  • Facebook
  • Google Bookmarks
  • Live
  • Technorati
  • YahooMyWeb
  • TwitThis
By admin | Posted in Uncategorized | Comments (0)
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(1268322304) 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(1268322304) GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u today
FireStats icon Powered by FireStats