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

Category Archives: Open Source

AJAX Picture Gallery using jQuery

October 23, 2007 – 1:44 PM

I have been longing for a custom picture gallery for quite some time, to showcase my pictures, but did not want to go for a ready made solution like Coppermine or Gallery. Sure these are great products with endless features, but would not give me that MADE BY MYSELF feeling So I decided [...]

By Naveen | Also posted in Perl, Technology, Web | Comments (3)

WebOSS ‘07 – Web and Open Source Conference in Kolkata

October 15, 2007 – 1:14 PM

Finally, the day arrived this Saturday, October the 13th, when the first Web & Open Source Technology Conference took place in Kolkata. It was a great initiative to bring like-minded people on the same platform and share our views on all things Web, OSS and Technology. Since the venue host was WBUT , a large [...]

By Naveen | Also posted in Kolkata, Perl, Technology, Web | Comments (0)

I’m Speaking at WebOSS ‘07

October 9, 2007 – 11:49 AM

The first of its kind Web Technology Conference on Open Source Technologies, WEBOSS ‘07 is being organised in Kolkata on Saturday 13th October, 2007. I was pleasantly surprised when Hussain (Hussu) , friend of Pradeep, called upon me to ask whether I would be interested in speaking at the event. The event focuses on Web [...]

By Naveen | Also posted in Fun, Kolkata, Technology | Tagged , , | Comments (1)

Ajax Yahoo! Mail for FireFox!

January 4, 2006 – 5:07 PM

Another Ajax Wonder we have for our disposal. For all Yahoo! Mail+Firefox users theres this cool plugin that saves you from entering the inbox for every message. All you need is to click on the ‘+‘ sign beside every mail, which is put by this plugin, and wow..! you have a drop-down preview of that [...]

By Naveen | Also posted in Fun, Hacks, Technology, Web, Yahoo | Comments (0)

YAGG!!

November 16, 2005 – 3:55 PM

As i was about to announce the advent of one of the most revolutionary Google tools ( Google Analytics) , those guys were up with another can’t-afford-not-to-mention-stuff — GOOGLE BASE ! Whew…. that speed of churning out blockbusters would ceratinly put to shame all the holly & bolly maestros together. Well… first things first… Google [...]

By Naveen | Also posted in Google, Web | Comments (0)

World’s Most Advanced Search Engine!

September 1, 2005 – 6:57 PM

G O O G L E …. these are the 6 letters that flashed through your mind after reading the title of this post. HAHAHA. But it isn’t what i’m talking about. So claims Preview Seek , the newest kid on the search engine block, giving a full page description Here , about how it [...]

By Naveen | Also posted in Google, Microsoft, Technology, Web, Yahoo | Comments (0)

GetFireFox.com vs GetInternetExplorer.com!

August 31, 2005 – 1:41 PM

Don’t I love this …. the wars that seem to be going on for ages, and getting fierce by the day, between the self proclaimed saviours of the web & the computing fraternity ( You know i’m referring to the *nix community) and the guys who started it all ( Dear old MS that is), [...]

By Naveen | Also posted in Microsoft, Technology, Web | Comments (0)

The Competition’s hotting up V 1.1

August 22, 2005 – 1:48 PM

W.R.T this post wonder how quick i’ll run into double digit version numbers if MS keeps on emulating Google! The latest on the block is MS’s own Virtual Earth — needless to say, a take on Google Earth. God knows what on earth is making MS lift ideas one after another from Google and shamelessly [...]

By Naveen | Also posted in Google, Microsoft, Technology, Web | 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(1268339418) 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(1268339418) GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u today
FireStats icon Powered by FireStats