next try

Github Release Action · Github Release Action · commit f410d2fa2225 · 2024-10-31T10:37:16.000+01:00
diff --git a/cms/models/placeholdermodel.py b/cms/models/placeholdermodel.py
@@ -785,11 +785,10 @@ def _recalculate_plugin_positions(self, language):
         elif db_vendor == 'postgresql':
             sql = (
                 'WITH RowNbrs AS ('
-                '    SELECT ID, ROW_NUMBER() OVER (ORDER BY position, id) AS RowNbr'
-                '    FROM {0}'
-                '    WHERE placeholder_id=%s AND language=%s '
+                '    SELECT ID, ROW_NUMBER() OVER (ORDER BY position) AS RowNbr'
+                '    FROM {0} WHERE placeholder_id=%s AND language=%s '
                 '）UPDATE {0} SET position = RowNbrs.RowNbr '
-                'FROM RowNbrs WHERE table.id = RowNbrs.id'
+                'FROM RowNbrs WHERE {i}.id = RowNbrs.id'
             )
             (
                 'UPDATE {0} '
