[Phpbb-checkins] r10130 - /branches/phpBB-3_0_0/phpBB/install/database_update.php

[Andreas F. <ba...@ph...>]

Author: bantu
Date: Thu Sep 10 09:58:24 2009
New Revision: 10130

Log:
Fix database updater for PostgreSQL: Data needs to be GROUPed BY left_id, before we can ORDER BY left_id. Introduced in r10072.

Modified:
    branches/phpBB-3_0_0/phpBB/install/database_update.php

Modified: branches/phpBB-3_0_0/phpBB/install/database_update.php
==============================================================================
*** branches/phpBB-3_0_0/phpBB/install/database_update.php (original)
--- branches/phpBB-3_0_0/phpBB/install/database_update.php Thu Sep 10 09:58:24 2009
***************
*** 677,682 ****
--- 677,683 ----
  				WHERE module_class = '" . $db->sql_escape($module_data['class']) . "'
  					AND parent_id = {$parent_id}
  					AND left_id BETWEEN {$first_left_id} AND {$module_row['left_id']}
+ 				GROUP BY left_id
  				ORDER BY left_id";
  			$result = $db->sql_query($sql);
  			$steps = (int) $db->sql_fetchfield('num_modules');