Bug #9197

DB_QueryTool does not save

Details

Submitted	2006-10-31 10:07 UTC
From	martin dot kaffanke at gmx dot at
Assigned	quipo
Status	Duplicate
Package	DB_QueryTool
PHP Version	4.4.3
OS	ubuntu linux
Roadmaps	(Not assigned)

Comments

[2006-10-31 10:07 UTC] martin dot kaffanke at gmx dot at

Description:
------------
The Data wasn't saved correctly on an update. Now with backtics it works for me:

--- /usr/share/php/DB/QueryTool/Query.php 2006-09-04 10:48:39.000000000 +0200
+++ lib/DB/QueryTool/Query.php 2006-10-31 10:59:19.000000000 +0100
@@ -608,7 +608,7 @@
$values = array();
foreach ($newData as $key => $aData) { // quote the data
//$values[] = "{$this->table}.$key=". ($raw ? $aData : $this->db->quote($aData));
- $values[] = "$key=". ($raw ? $aData : $this->db->quote($aData));
+ $values[] = "`$key`=". ($raw ? $aData : $this->db->quote($aData));
}

$query['set'] = implode(',', $values);