Forums | Mahara Community
Core upgrade from 17.04.10 to 19.04.1 - Failed to upgrade.
08 August 2019, 12:22 PM
Getting an error Failed to upgrade - trying to upgrade from 17.04.10 to 19.04.1- no other information
As I am a new user I can't include the apache2 error logs that contain links or urls
Failed to get a recordset: mysqli error: [1054: Unknown column 'time' in 'field list'] in EXECUTE("SELECT event, data, time, FROM "event_log", WHERE event = 'createuser', AND POSITION(',"password":"",' IN data) = 0, ")Command was: SELECT event, data, time, FROM "event_log", WHERE event = ?,AND POSITION(',"password":"",' IN data) = 0, and values was (0:createuser),
08 August 2019, 1:39 PM
It sounds like your upgrade maybe has partially been done before.
Please check the event_log table in the database - if it has a 'ctime' column instead of 'time' column then edit the htdocs/lib/db/upgrade.php file and change the line containing
SELECT event, data, time
SELECT event, data, ctime
And that should allow the upgrade to work
08 August 2019, 3:14 PM
Now I am stuck with a message - "An upgrade began at 2019/08/08 13:45 and did not complete. Run this upgrade anyway." and when I click on the "Run this upgrade anyway link" it tells me You do not have access to this functionality. Please provide the value for "urlsecret" from your config.php file as part of the URL. - is there anyway to get the upgrade to run without restoring the database starting again?
09 August 2019, 8:50 AM
It sounds like you are trying to upgrade via the web interface (rather than terminal / command line) so you will need find out your urlsecret value - this should either be stored in your htdocs/config.php file or htdocs/lib/config-defaults.php file as
and copy that to the upgrade page url, eg if your $cfg->urlsecret = 'tulips';
you would need to change the URL to admin/upgrade.php?rerun=1&urlsecret=tulip
If you run the upgrade via the terminal / command line you don't need to bother about the rerun / urlsecret so you can do an upgrade like so:
sudo -u www-data php htdocs/admin/cli/upgrade.php