# HG changeset patch
# User Sebastien Jodogne <s.jodogne@gmail.com>
# Date 1626974698 -7200
# Node ID 4454545bb26577d076d99ba9d490ab7f7572b45e
# Parent  e0b9abf98019e54d8834becfb84110e4e2eb9ae3
Fix issue 200 (fields messed up in /changes route)

diff -r e0b9abf98019 -r 4454545bb265 Framework/Plugins/IndexBackend.cpp
--- a/Framework/Plugins/IndexBackend.cpp	Tue Jul 20 17:11:00 2021 +0200
+++ b/Framework/Plugins/IndexBackend.cpp	Thu Jul 22 19:24:58 2021 +0200
@@ -568,8 +568,8 @@
     
     DatabaseManager::CachedStatement statement(
       STATEMENT_FROM_HERE, manager,
-      "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Changes.date, "
-      "Resources.publicId FROM Changes INNER JOIN Resources "
+      "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Resources.publicId, "
+      "Changes.date FROM Changes INNER JOIN Resources "
       "ON Changes.internalId = Resources.internalId WHERE seq>${since} ORDER BY seq " + suffix);
 
     statement.SetReadOnly(true);
@@ -671,8 +671,8 @@
 
     DatabaseManager::CachedStatement statement(
       STATEMENT_FROM_HERE, manager,
-      "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Changes.date, "
-      "Resources.publicId FROM Changes INNER JOIN Resources "
+      "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Resources.publicId, "
+      "Changes.date FROM Changes INNER JOIN Resources "
       "ON Changes.internalId = Resources.internalId ORDER BY seq DESC " + suffix);
 
     statement.SetReadOnly(true);
diff -r e0b9abf98019 -r 4454545bb265 MySQL/NEWS
--- a/MySQL/NEWS	Tue Jul 20 17:11:00 2021 +0200
+++ b/MySQL/NEWS	Thu Jul 22 19:24:58 2021 +0200
@@ -1,6 +1,8 @@
 Pending changes in the mainline
 ===============================
 
+* Fix issue 200 (fields messed up in /changes route)
+
 
 Release 4.2 (2021-07-20)
 ========================