From 09bff8e8f113236977bcccd87faf8cf826c83d85 Mon Sep 17 00:00:00 2001
From: dongsheng <dongsheng>
Date: Fri, 3 Apr 2009 07:31:43 +0000
Subject: [PATCH] "MDL-17475, fix bad sql when add repository instances"
---
repository/lib.php | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/repository/lib.php b/repository/lib.php
index d683123d17..fb42937db4 100644
--- a/repository/lib.php
+++ b/repository/lib.php
@@ -1743,7 +1743,8 @@ final class repository_instance_form extends moodleform {
global $DB;
$errors = array();
- if ($DB->count_records('repository_instances', array('name' => $data['name'], 'typeid' => $data['typeid'])) > 1) {
+ $sql = "SELECT count('x') FROM {repository_instances} i, {repository} r WHERE r.type=:plugin AND r.id=i.typeid AND i.name=:name";
+ if ($DB->count_records_sql($sql, array('name' => $data['name'], 'plugin' => $data['plugin'])) > 1) {
$errors = array('name' => get_string('err_uniquename', 'repository'));
}
--
2.39.5