39define(
'ALLOWED_IF_UPGRADE_UNLOCK_FOUND', 1);
40include_once
'inc.php';
46if (!file_exists($conffile)) {
47 print
'Error: Dolibarr config file was not found. This may means that Dolibarr is not installed yet. Please call the page "/install/index.php" instead of "/install/upgrade.php").';
49require_once $conffile;
50require_once $dolibarr_main_document_root.
'/core/lib/admin.lib.php';
66$err = error_reporting();
72$setuplang =
GETPOST(
"selectlang",
'aZ09', 3) ?
GETPOST(
"selectlang",
'aZ09', 3) :
'auto';
73$langs->setDefaultLang($setuplang);
74$versionfrom =
GETPOST(
"versionfrom",
'alpha', 3) ?
GETPOST(
"versionfrom",
'alpha', 3) : (empty($argv[1]) ?
'' : $argv[1]);
75$versionto =
GETPOST(
"versionto",
'alpha', 3) ?
GETPOST(
"versionto",
'alpha', 3) : (empty($argv[2]) ?
'' : $argv[2]);
76$dirmodule = ((
GETPOST(
"dirmodule",
'alpha', 3) &&
GETPOST(
"dirmodule",
'alpha', 3) !=
'ignoredbversion')) ?
GETPOST(
"dirmodule",
'alpha', 3) : ((empty($argv[3]) || $argv[3] ==
'ignoredbversion') ?
'' : $argv[3]);
77$ignoredbversion = (
GETPOST(
'ignoredbversion',
'alpha', 3) ==
'ignoredbversion') ?
GETPOST(
'ignoredbversion',
'alpha', 3) : ((empty($argv[3]) || $argv[3] !=
'ignoredbversion') ?
'' : $argv[3]);
79$langs->loadLangs(array(
"admin",
"install",
"other",
"errors"));
81if ($dolibarr_main_db_type ==
"mysqli") {
84if ($dolibarr_main_db_type ==
"pgsql") {
87if ($dolibarr_main_db_type ==
"mssql") {
93if (!is_object($conf)) {
102if (!$versionfrom && !$versionto) {
103 print
'Error: Parameter versionfrom or versionto missing.'.
"\n";
104 print
'Upgrade must be ran from command line with parameters or called from page install/index.php (like a first install)'.
"\n";
106 $sapi_type = php_sapi_name();
107 $script_file = basename(__FILE__);
109 if (substr($sapi_type, 0, 3) ==
'cli') {
110 print
'Syntax from command line: '.$script_file.
" x.y.z a.b.c\n";
116pHeader(
'',
"upgrade2",
GETPOST(
'action',
'aZ09'),
'versionfrom='.$versionfrom.
'&versionto='.$versionto,
'',
'main-inside main-inside-borderbottom');
121if (!
GETPOST(
'action',
'aZ09') || preg_match(
'/upgrade/i',
GETPOST(
'action',
'aZ09'))) {
124 print
'<h3><img class="valignmiddle inline-block paddingright" src="../theme/common/octicons/build/svg/database.svg" width="20" alt="Database"> ';
125 print
'<span class="inline-block">'.$langs->trans(
"DatabaseMigration").
'</span></h3>';
127 print
'<table cellspacing="0" cellpadding="1" border="0" width="100%">';
131 if ((!empty($dolibarr_main_db_pass) && preg_match(
'/crypted:/i', $dolibarr_main_db_pass)) || !empty($dolibarr_main_db_encrypted_pass)) {
132 require_once $dolibarr_main_document_root.
'/core/lib/security.lib.php';
133 if (!empty($dolibarr_main_db_pass) && preg_match(
'/crypted:/i', $dolibarr_main_db_pass)) {
134 $dolibarr_main_db_pass = preg_replace(
'/crypted:/i',
'', $dolibarr_main_db_pass);
135 $dolibarr_main_db_pass =
dol_decode($dolibarr_main_db_pass);
136 $dolibarr_main_db_encrypted_pass = $dolibarr_main_db_pass;
138 $dolibarr_main_db_pass =
dol_decode($dolibarr_main_db_encrypted_pass);
143 $conf->db->type = $dolibarr_main_db_type;
144 $conf->db->host = $dolibarr_main_db_host;
145 $conf->db->port = $dolibarr_main_db_port;
146 $conf->db->name = $dolibarr_main_db_name;
147 $conf->db->user = $dolibarr_main_db_user;
148 $conf->db->pass = $dolibarr_main_db_pass;
151 if (empty($dolibarr_main_db_encryption)) {
152 $dolibarr_main_db_encryption = 0;
154 $conf->db->dolibarr_main_db_encryption = $dolibarr_main_db_encryption;
155 if (empty($dolibarr_main_db_cryptkey)) {
156 $dolibarr_main_db_cryptkey =
'';
158 $conf->db->dolibarr_main_db_cryptkey = $dolibarr_main_db_cryptkey;
160 $db =
getDoliDBInstance($conf->db->type, $conf->db->host, $conf->db->user, $conf->db->pass, $conf->db->name, (
int) $conf->db->port);
163 include_once DOL_DOCUMENT_ROOT.
'/core/class/hookmanager.class.php';
166 if ($db->connected) {
167 print
'<tr><td class="nowrap">';
168 print $langs->trans(
"ServerConnection").
" : ".$dolibarr_main_db_host.
'</td><td class="right"><span class="neutral">'.$langs->trans(
"OK").
'</span></td></tr>'.
"\n";
169 dolibarr_install_syslog(
"upgrade: ".$langs->transnoentities(
"ServerConnection").
": $dolibarr_main_db_host ".$langs->transnoentities(
"OK"));
172 print
"<tr><td>".$langs->trans(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name).
'</td><td class="right"><span class="error">'.$langs->transnoentities(
"Error").
"</span></td></tr>\n";
173 dolibarr_install_syslog(
"upgrade: ".$langs->transnoentities(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
178 if ($db->database_selected) {
179 print
'<tr><td class="nowrap">';
180 print $langs->trans(
"DatabaseConnection").
" : ".$dolibarr_main_db_name.
'</td><td class="right"><span class="neutral">'.$langs->trans(
"OK").
"</span></td></tr>\n";
184 print
"<tr><td>".$langs->trans(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name).
'</td><td class="right"><span class="ok">'.$langs->trans(
"Error").
"</span></td></tr>\n";
185 dolibarr_install_syslog(
"upgrade: ".$langs->transnoentities(
"ErrorFailedToConnectToDatabase", $dolibarr_main_db_name));
192 $version = $db->getVersion();
193 $versionarray = $db->getVersionArray();
194 print
'<tr><td>'.$langs->trans(
"ServerVersion").
'</td>';
195 print
'<td class="right">'.$version.
'</td></tr>';
197 if ($db->type ==
'mysqli' && function_exists(
'mysqli_get_charset')) {
198 $tmparray = $db->db->get_charset();
199 print
'<tr><td>'.$langs->trans(
"ClientCharset").
'</td>';
200 print
'<td class="right">'.$tmparray->charset.
'</td></tr>';
202 print
'<tr><td>'.$langs->trans(
"ClientSortingCharset").
'</td>';
203 print
'<td class="right">'.$tmparray->collation.
'</td></tr>';
208 $versionmindb = explode(
'.', $db::VERSIONMIN);
210 if (count($versionmindb) && count($versionarray)
213 print
"<tr><td>".$langs->trans(
"ErrorDatabaseVersionTooLow", join(
'.', $versionarray), join(
'.', $versionmindb)).
'</td><td class="right"><span class="error">'.$langs->trans(
"Error").
"</span></td></tr>\n";
214 dolibarr_install_syslog(
"upgrade: ".$langs->transnoentities(
"ErrorDatabaseVersionTooLow", join(
'.', $versionarray), join(
'.', $versionmindb)));
219 if (empty($ignoredbversion)) {
220 $dbversion_disallowed = array(
221 array(
'type'=>
'mysql',
'version'=>array(5, 5, 40)),
222 array(
'type'=>
'mysqli',
'version'=>array(5, 5, 40))
226 $listofforbiddenversion =
'';
227 foreach ($dbversion_disallowed as $dbversion_totest) {
228 if ($dbversion_totest[
'type'] == $db->type) {
229 $listofforbiddenversion .= ($listofforbiddenversion ?
', ' :
'').join(
'.', $dbversion_totest[
'version']);
232 foreach ($dbversion_disallowed as $dbversion_totest) {
234 if ($dbversion_totest[
'type'] == $db->type
235 && (
versioncompare($dbversion_totest[
'version'], $versionarray) == 0 ||
versioncompare($dbversion_totest[
'version'], $versionarray) <= -4 ||
versioncompare($dbversion_totest[
'version'], $versionarray) >= 4)
238 print
'<tr><td><div class="warning">'.$langs->trans(
"ErrorDatabaseVersionForbiddenForMigration", join(
'.', $versionarray), $listofforbiddenversion).
"</div></td><td class=\"right\">".$langs->trans(
"Error").
"</td></tr>\n";
239 dolibarr_install_syslog(
"upgrade: ".$langs->transnoentities(
"ErrorDatabaseVersionForbiddenForMigration", join(
'.', $versionarray), $listofforbiddenversion));
249 print
'<tr><td colspan="2"><span class="opacitymedium messagebepatient">'.$langs->trans(
"PleaseBePatient").
'</span></td></tr>';
254 print
'<table cellspacing="0" cellpadding="1" border="0" width="100%">';
261 if ($ok && preg_match(
'/mysql/', $db->type)) {
262 $versioncommande = array(4, 0, 0);
263 if (count($versioncommande) && count($versionarray)
270 MAIN_DB_PREFIX.
'adherent_options',
271 MAIN_DB_PREFIX.
'bank_class',
272 MAIN_DB_PREFIX.
'c_ecotaxe',
273 MAIN_DB_PREFIX.
'c_methode_commande_fournisseur',
274 MAIN_DB_PREFIX.
'c_input_method'
277 $listtables = $db->DDLListTables($conf->db->name,
'');
279 foreach ($listtables as $val) {
281 if (preg_match(
'/^'.MAIN_DB_PREFIX.
'/', $val)) {
283 $sql =
"SHOW CREATE TABLE ".$val;
284 $resql = $db->query($sql);
286 $values = $db->fetch_array($resql);
288 $createsql = $values[1];
290 while (preg_match(
'/CONSTRAINT `(0_[0-9a-zA-Z]+|[_0-9a-zA-Z]+_ibfk_[0-9]+)`/i', $createsql, $reg) && $i < 100) {
291 $sqldrop =
"ALTER TABLE ".$val.
" DROP FOREIGN KEY ".$reg[1];
292 $resqldrop = $db->query($sqldrop);
294 print
'<tr><td colspan="2">'.$sqldrop.
";</td></tr>\n";
296 $createsql = preg_replace(
'/CONSTRAINT `'.$reg[1].
'`/i',
'XXX', $createsql);
301 if ($db->lasterrno() !=
'DB_ERROR_NOSUCHTABLE') {
302 print
'<tr><td colspan="2"><span class="error">'.dol_escape_htmltag($sql).
' : '.
dol_escape_htmltag($db->lasterror()).
"</span></td></tr>\n";
314 $dir =
"mysql/migration/";
315 if (!empty($dirmodule)) {
321 $newversionfrom = preg_replace(
'/(\.[0-9]+)$/i',
'.0', $versionfrom);
322 $newversionto = preg_replace(
'/(\.[0-9]+)$/i',
'.0', $versionto);
327 $from =
'^'.preg_quote($newversionfrom,
'/');
328 $to = preg_quote($newversionto.
'.sql',
'/').
'$';
331 $filesindir = array();
332 $handle = opendir($dir);
333 if (is_resource($handle)) {
334 while (($file = readdir($handle)) !==
false) {
335 if (preg_match(
'/\.sql$/i', $file)) {
336 $filesindir[] = $file;
341 print
'<div class="error">'.$langs->trans(
"ErrorCanNotReadDir", $dir).
'</div>';
345 foreach ($filesindir as $file) {
346 if (preg_match(
'/'.$from.
'\-/i', $file)) {
348 } elseif (preg_match(
'/\-'.$to.
'/i', $file)) {
353 if (count($filelist) == 0) {
354 print
'<div class="error">'.$langs->trans(
"ErrorNoMigrationFilesFoundForParameters").
'</div>';
356 $listoffileprocessed = array();
359 foreach ($filelist as $file) {
360 if (in_array($dir.$file, $listoffileprocessed)) {
364 print
'<tr><td colspan="2"><hr style="border-color: #ccc; border-top-style: none;"></td></tr>';
365 print
'<tr><td class="nowrap">'.$langs->trans(
"ChoosedMigrateScript").
'</td><td class="right">'.$file.
'</td></tr>'.
"\n";
368 $ok =
run_sql($dir.$file, 0,
'', 1,
'',
'default', 32768, 0, 0, 2, 0, $db->database_name);
369 $listoffileprocessed[$dir.$file] = $dir.$file;
374 $modulesfile = array();
375 foreach ($conf->file->dol_document_root as $type => $dirroot) {
376 $handlemodule = @opendir($dirroot);
377 if (is_resource($handlemodule)) {
378 while (($filemodule = readdir($handlemodule)) !==
false) {
379 if (!preg_match(
'/\./', $filemodule) && is_dir($dirroot.
'/'.$filemodule.
'/sql')) {
381 if (is_file($dirroot.
'/'.$filemodule.
'/sql/dolibarr_'.$file)) {
382 $modulesfile[$dirroot.
'/'.$filemodule.
'/sql/dolibarr_'.$file] =
'/'.$filemodule.
'/sql/dolibarr_'.$file;
384 if (is_file($dirroot.
'/'.$filemodule.
'/sql/dolibarr_allversions.sql')) {
385 $modulesfile[$dirroot.
'/'.$filemodule.
'/sql/dolibarr_allversions.sql'] =
'/'.$filemodule.
'/sql/dolibarr_allversions.sql';
389 closedir($handlemodule);
393 if (count($modulesfile)) {
394 print
'<tr><td colspan="2"><hr style="border-color: #ccc; border-top-style: none;"></td></tr>';
396 foreach ($modulesfile as $modulefilelong => $modulefileshort) {
397 if (in_array($modulefilelong, $listoffileprocessed)) {
401 print
'<tr><td class="nowrap">'.$langs->trans(
"ChoosedMigrateScript").
' (external modules)</td><td class="right">'.$modulefileshort.
'</td></tr>'.
"\n";
404 $okmodule =
run_sql($modulefilelong, 0,
'', 1);
405 $listoffileprocessed[$modulefilelong] = $modulefilelong;
414 if ($db->connected) {
420if (empty($actiondone)) {
421 print
'<div class="error">'.$langs->trans(
"ErrorWrongParameters").
'</div>';
425if (!$ok && isset($argv[1])) {
431$nonext = (!$ok && empty($_GET[
"ignoreerrors"])) ? 2 : 0;
run_sql($sqlfile, $silent=1, $entity=0, $usesavepoint=1, $handler='', $okerror='default', $linelengthlimit=32768, $nocommentremoval=0, $offsetforchartofaccount=0, $colspan=0, $onlysqltoimportwebsite=0, $database='')
Launch a sql file.
versioncompare($versionarray1, $versionarray2)
Compare 2 versions (stored into 2 arrays).
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
getDoliDBInstance($type, $host, $user, $pass, $name, $port)
Return a DoliDB instance (database handler).
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
pHeader($subtitle, $next, $action='set', $param='', $forcejqueryurl='', $csstable='main-inside')
Show HTML header of install pages.
pFooter($nonext=0, $setuplang='', $jscheckfunction='', $withpleasewait=0, $morehtml='')
Print HTML footer of install pages.
dolibarr_install_syslog($message, $level=LOG_DEBUG)
Log function for install pages.
dol_decode($chain, $key='1')
Decode a base 64 encoded + specific delta change.