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/2007/12/05/first-post-from-mobile/', '', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', '38.107.191.94', NULL )

First post from mobile

Finally i got my GPRS activated yesterday and its been a great experience so far! With apps like Opera browser, GMAIL mobile, Nimbuzz, surfing from your cell is a temptation which you can’t resist. And my SONY ERICSSON is well equipped to provide a pleasurable surfing experience. So here goes my first GPRS blog post, with many more to follow! Keep watching :-)

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
This entry was written by Naveen, posted on December 5, 2007 at 12:20 AM, filed under Posting from Mobile, Technology. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

RSS feed | Trackback URI

2 Comments »

Comment by Shabbir INDIA Windows Vista Mozilla Firefox 2.0.0.11
2007-12-15 17:10:50

Don’t you think you should also have a snap of it as well

Reply to this comment
 
Comment by Naveen INDIA Windows XP Mozilla Firefox 2.0.0.11
2007-12-15 22:45:41

Don’t you think you should also have a snap of it as well

Well I didn’t get you. Snap of what?

Reply to this comment
 
Name (required)
E-mail (required - never shown publicly)
URI
Subscribe to comments via email
Your Comment (smaller size | larger size)
You may use <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> in your comment.

Trackback responses to this post

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