Database upgrade in maintenance mode

Support & Bugs
1

Hi,

I am doing the 1.3 -> 1.4 upgrade with databaseupgrade in command line.

The updater page in piwik tells:

It is also recommended for high traffic Piwik servers to momentarily disable visitor Tracking and put the Piwik User Interface in maintenance mode.

The linked page How to - Analytics Platform - Matomo tells me to put piwik in maintenance mode. But when doing so the commandline job fails:


tracking@somehost:~/httpdocs$ php /path/to/site/httpdocs/index.php -- "module=CoreUpdater" 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title>Piwik &rsaquo; Error</title>
...
<p>Piwik is in scheduled maintenance. Please come back later.</p>

So the maintenance mode make the upgrade impossible…!?

gr33tings,
tvierb

2

tvierb, maintenance mode will only allow the archiving to be triggered in the Shell via the command line, I have updated the FAQ to clarify this

3

hi matt,

the faq now says:


disable the Piwik User Interface: you can disable the User Interface only if you run the Piwik DB
Upgrade using the shell/console command (even the Upgrade process will be disabled in the browser).

but I had faced the problem that even the console db upgrade did not run anymore.

tvierb

4

Oh sorry I didn’t read your message properly! you are right that there is a bug in there: please try the following patch: http://dev.piwik.org/trac/changeset/4673

thx for the report

5

Does this patch work? Is it integrated in the next release?

I recognized the effect today, too. Thank you for the answers.

6

patch works