$path_to_root="..";
include_once($path_to_root . "/includes/session.inc");
-page(_("Software Upgrade"));
+page(_($help_context = "Software Upgrade"));
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/admin/db/company_db.inc");
//
function check_table($pref, $table, $field=null, $properties=null)
{
- $fields = @db_query("SHOW COLUMNS FROM ".$pref.$table);
- if (!$fields)
+ $tables = @db_query("SHOW TABLES LIKE '".$pref.$table."'");
+ if (!db_num_rows($tables))
return 1; // no such table or error
+ $fields = @db_query("SHOW COLUMNS FROM ".$pref.$table);
if (!isset($field))
return 0; // table exists
$state = $inst->installed($pref);
if (!$state || $force)
{
- if (!$inst->pre_check($pref)) return false;
+ if (!$inst->pre_check($pref, $force)) return false;
$sql = $inst->sql;
+ error_log(sprintf(_("Database upgrade for company '%s' (%s:%s*) started..."),
+ $conn['name'], $conn['dbname'], $conn['tbpref']));
+
if ($sql != '')
$ret &= db_import($path_to_root.'/sql/'.$sql, $conn, $force);
$ret &= $inst->install($pref, $force);
+
+ error_log(_("Database upgrade finished."));
+
} else
if ($state!==true) {
display_error(_("Upgrade cannot be done because database has been already partially upgraded. Please downgrade database to clean previous version or try forced upgrade."));
$_SESSION["wa_current_user"]->prefs = new user_prefs($user);
display_notification(_('All companies data has been successfully updated'));
}
+ unset($_SESSION['SysPrefs']); // re-read system setup
$Ajax->activate('_page_body');
}
start_form();
-start_table($table_style);
+start_table(TABLESTYLE);
$th = array(_("Version"), _("Description"), _("Sql file"), _("Install"),
_("Force upgrade"));
table_header($th);