if (mysql_query($prefixed_query[0],$db) !== false) {
$progress[] = 'Table <strong>'.$table.'</strong> altered successfully.';
} else {
- $errors[] = 'Table <strong>'.$table.'</strong> alteration failed.';
+ if (mysql_errno($db) == 1060)
+ $progress[] = 'Table <strong>'.$table . '</strong> fields already exists. Skipping.';
+ elseif (mysql_errno($db) == 1091)
+ $progress[] = 'Table <strong>'.$table . '</strong> fields already dropped. Skipping.';
+ else
+ $errors[] = 'Table <strong>'.$table.'</strong> alteration failed.';
}
}elseif($prefixed_query[1] == 'DROP TABLE'){
$sql = "SELECT VERSION() AS version";
$result = mysql_query($sql, $db);
$row = mysql_fetch_assoc($result);
- if (version_compare($row['version'], '4.3', '>=') === FALSE) {
- $errors[] = 'MySQL version '.$row['version'].' was detected. ATutor requires version 4.3 or later.';
+ if (version_compare($row['version'], '4.1.10', '>=') === FALSE) {
+ $errors[] = 'MySQL version '.$row['version'].' was detected. ATutor requires version 4.1.10 or later.';
}
if (!$errors) {