From e00ab5f99437d829109530d4d236b542ac7ce084 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Fri, 1 May 2009 23:35:01 +0000
Subject: [PATCH] MDL-18577 drop enums support - step3: Fix oci8 adodb
set_field_select() without select
---
lib/dml/oci8po_adodb_moodle_database.php | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/lib/dml/oci8po_adodb_moodle_database.php b/lib/dml/oci8po_adodb_moodle_database.php
index 417561b781..f37891b688 100644
--- a/lib/dml/oci8po_adodb_moodle_database.php
+++ b/lib/dml/oci8po_adodb_moodle_database.php
@@ -440,7 +440,8 @@ class oci8po_adodb_moodle_database extends adodb_moodle_database {
$newfield = "$newfield = ?";
array_unshift($params, $newvalue); // add as first param
}
- $sql = "UPDATE {$this->prefix}$table SET $newfield WHERE $select";
+ $select = !empty($select) ? "WHERE $select" : '';
+ $sql = "UPDATE {$this->prefix}$table SET $newfield $select";
$this->query_start($sql, $params, SQL_QUERY_UPDATE);
$rs = $rs = $this->adodb->Execute($sql, $params);
--
2.39.5