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

Category Archives: Hacks

Perl one-liner to sort a hash and return the top most key/value

October 17, 2007 – 3:32 PM

A while ago Deepz asked me whether we can sort a hash and print the top most key or value or both in a single line, in PERL. After a little permutation & combination, I wrote the following piece. I’m sure there must be a more elegant and efficient way of doing it, but this [...]

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

Install Perl Modules without root

October 16, 2007 – 11:58 PM

How many times Perl developers have to scratch their heads when they find that there is a module dependency which is breaking their code. Worse, they do not have sufficient privileges to install the required modules on the system. And the worst – there is no immediate way to get the module installed and [...]

By Naveen | Also posted in Perl, Technology | Tagged , , , , , , , | Comments (5)

My First JAPH!

October 15, 2007 – 11:23 PM

Finally after procrastinating for long, I decided to tread the path traversed only by the GODs of PERL – writing JAPHs!! And my brain storming for about 6 hours finally ended with a JAPH, not too bad for a debut, albeit a little amateur. For those of who are still wondering what the heck is [...]

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

Multiple Yahoo Messengers simultaneously

October 1, 2007 – 10:49 AM

I just received this forwarded email with instructions on how to activate multiple instances of Yahoo! Messenger on the same machine without the use of any software. I tried it out and its awesome! Working really fine. Just follow the instructions below and you are all set:

Go to Start —-> Run . Type regedit, then [...]

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

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, Open Source, Technology, Web, Yahoo | 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(1268339489) 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(1268339489) GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u today
FireStats icon Powered by FireStats