Fixed Issue#129, Issue#130

2 files changed, 7 insertions, 5 deletions

diff --git a/HISTORY b/HISTORY
index 936bcf0d..63e64c02 100644
--- a/HISTORY
+++ b/HISTORY
@@ -4,6 +4,8 @@ BUG: Issue#87 - TinyMCE : empty string disapears after encoding JS, that's a pro
 BUG: Issue#96 - THttpResponse::redirect don't send status code (Christophe)
 BUG: Issue#107 - typo in TDbConnection::getCharset() (Christophe)
 BUG: Issue#127 - TDataSourceConfig::findConnectionByID try to access private var (Cristophe)
+BUG: Issue#129 - TDbLogRoute::init don't close the sql command (Christophe)
+Bug: Issue#130 - TDbLogRoute::processLogs wrong values binding (Christophe)
 CHG: Issue#7 - Clients Scripts are not combined anymore in Debug application mode (Christophe)
 ENH: Issue#115 - Registry for Prado generated clientside counterparts of serverside controls (Yves Berkholz)
 ENH: Added caching of message files to TException (Michael)
diff --git a/framework/Util/TLogRouter.php b/framework/Util/TLogRouter.php
index aa772194..70c701ee 100644
--- a/framework/Util/TLogRouter.php
+++ b/framework/Util/TLogRouter.php
@@ -764,7 +764,7 @@ class TDbLogRoute extends TLogRoute
 		$sql='SELECT * FROM '.$this->_logTable.' WHERE 0';

 		try

 		{

-			$db->createCommand($sql)->execute();

+			$db->createCommand($sql)->query()->close();

 		}

 		catch(Exception $e)

 		{

@@ -788,10 +788,10 @@ class TDbLogRoute extends TLogRoute
 		$command=$this->getDbConnection()->createCommand($sql);

 		foreach($logs as $log)

 		{

-			$command->bindValue(':level',$log[0]);

-			$command->bindValue(':category',$log[1]);

-			$command->bindValue(':logtime',$log[2]);

-			$command->bindValue(':message',$log[3]);

+			$command->bindValue(':message',$log[0]);

+			$command->bindValue(':level',$log[1]);

+			$command->bindValue(':category',$log[2]);

+			$command->bindValue(':logtime',$log[3]);

 			$command->execute();

 		}

 	}