--- trunk/irc-logger.pl	2006/03/01 22:42:21	8
+++ trunk/irc-logger.pl	2006/03/01 23:35:56	9
@@ -84,7 +84,7 @@
 		$_[KERNEL]->post($IRC_ALIAS => register => 'all');
 		$_[KERNEL]->post($IRC_ALIAS => connect => $CONNECT);
     },
-    irc_255 => sub {            # server is done blabbing
+    irc_255 => sub {	# server is done blabbing
 		$_[KERNEL]->post($IRC_ALIAS => join => $CHANNEL);
 		$_[KERNEL]->post($IRC_ALIAS => join => '#logger');
 		$_[KERNEL]->yield("heartbeat"); # start heartbeat
@@ -140,7 +140,7 @@
 					channel,
 					nick,
 					message
-				from log order by time desc limit $nr
+				from log order by log.time desc limit $nr
 			});
 			$sth->execute();
 			$res = "Last $nr messages: ";