- //} else {
- // We have to check if "INSERT IGNORE" will work on newer MySQL versions
- // $r = $db->q("INSERT IGNORE INTO `".$temp_name."` SELECT * FROM `".$name."`;");
- // if (!dbm::is_result($r)) {
- // $errors .= t('Errors encountered performing database changes.').$sql3.EOL;
- // return $errors;
- // }
- // $r = $db->q("DROP TABLE `".$name."`;");
- // if (!dbm::is_result($r)) {
- // $errors .= t('Errors encountered performing database changes.').$sql3.EOL;
- // return $errors;
- // }
- // $r = $db->q("RENAME TABLE `".$temp_name."` TO `".$name."`;");
- // if (!dbm::is_result($r)) {
- // $errors .= t('Errors encountered performing database changes.').$sql3.EOL;
- // return $errors;
- // }
- //}
+ } else {
+ $r = $db->q("INSERT INTO `".$temp_name."` SELECT * FROM `".$name."`".$group_by.";");
+ if (!dbm::is_result($r)) {
+ $errors .= t('Errors encountered performing database changes.').$sql3.EOL;
+ return $errors;
+ }
+ $r = $db->q("DROP TABLE `".$name."`;");
+ if (!dbm::is_result($r)) {
+ $errors .= t('Errors encountered performing database changes.').$sql3.EOL;
+ return $errors;
+ }
+ $r = $db->q("RENAME TABLE `".$temp_name."` TO `".$name."`;");
+ if (!dbm::is_result($r)) {
+ $errors .= t('Errors encountered performing database changes.').$sql3.EOL;
+ return $errors;
+ }
+ }