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

Category Archives: Technology

All Text/Data is some kind of executable code or program

February 22, 2008 – 2:48 PM

I just love to see where these technical discussions sometimes end up, or start off for that matter. Reading on a /. post on Largest Hacking Scam in Canadian History, an interesting debate shot off on “There is no data which is also not a program/piece of executable(in some way or the other) code“. Following [...]

By Naveen | Also posted in programming | Comments (1)

First post from mobile

December 5, 2007 – 12:20 AM

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

By Naveen | Also posted in Posting from Mobile | Comments (2)

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 Open Source, Perl, Web | Comments (3)

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 Hacks, Perl | 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 Hacks, Perl | Tagged , , , , , , , | Comments (5)

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, Open Source, Perl, 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, Open Source | 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, Hacks, Yahoo | Comments (0)

It Ain’t Over Yet!

September 27, 2007 – 3:25 PM

Perhaps I wrote my previous post (WTF!) too early! Continuing its assault of emails, the count reached a phenomenal 207!! Way to go Calcutta Telephones Click on the following image to get an idea:

By Naveen | Also posted in Fun, India, Whatever | Comments (3)

WTF!

September 26, 2007 – 11:23 AM

(Click on the image to enlarge)
I guess the guys at BSNL need a good sleep! I opened my mailbox a while ago to be shocked by the number of times the payment notification mail had been sent by their mail server. I know that it is an automated process but something is going amiss big [...]

By Naveen | Also posted in Fun, Whatever | Comments (1)
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(1268183556) 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(1268183556) GROUP BY SUBSTRING(`timestamp`,1,10),url_site_id) u today
FireStats icon Powered by FireStats