aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2016-09-21 19:48:04 +1200
committerGitHub <noreply@github.com>2016-09-21 19:48:04 +1200
commit9ee812366367148387f289b9977fd809e6a56786 (patch)
tree230bf869d60e0413dfd5ee801cf4dccab72aba40 /schema
parent19b17695867e00861c719292aad7ae48f33a8eeb (diff)
parent9cc862ea2c3fed6eb69dea8e6f8a646fc7995dbe (diff)
downloadtrackermap-server-9ee812366367148387f289b9977fd809e6a56786.tar.gz
trackermap-server-9ee812366367148387f289b9977fd809e6a56786.tar.bz2
trackermap-server-9ee812366367148387f289b9977fd809e6a56786.zip
Merge pull request #2351 from Abyss777/fix_sqlrequest
Fix groups cleanup request on some MySQL 5.7.x installations
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.7.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema/changelog-3.7.xml b/schema/changelog-3.7.xml
index d82dbe91b..1bae2aaff 100644
--- a/schema/changelog-3.7.xml
+++ b/schema/changelog-3.7.xml
@@ -17,7 +17,7 @@
<update tableName="groups">
<column name="groupid"/>
- <where>groupid NOT IN (SELECT id FROM (SELECT id FROM groups) AS groups_ids)</where>
+ <where>groupid NOT IN (SELECT id FROM (SELECT DISTINCT id FROM groups) AS groups_ids)</where>
</update>
<addColumn tableName="devices">