Thanks for following up and clarifying - half my fault, you did say database; got distracted by the 'file' part I guess-:). I've checked the config value in the database and it is 2012041004 - so it doesn't look like that's the problem unfortunately.
Regards,
Dantina
]]>Ah I might have led you slightly wrong when I said config file - I meant the config table in the database.
To check that the version number is there you can run:
SELECT value FROM config WHERE field = 'version';
And it should be something like: 2012041004 (as that is the version number for release 1.5.1)
If it is missing then run this:
INSERT INTO config VALUES('version', '2012041004');
FYI: The release number that gets displayed in the upgrade screen comes from:
SELECT value FROM config WHERE field = 'release';
Hope this helps
Robert
]]>I am sorry I missed your response somehow. I hope you are still able to help. I've check the config file and the there was no version value set. But the upgrade page did say upgrade from 1.5.1 to 1.9.1 - I've a screenshot of the error but I can't seem to include the image with this post.
Regards,
Dantina
By the sounds of things there is a row 'auth_remove_old_session_files' in your cron database table in the pre update database that is not expected by the upgrade and so is trying to add the row again - hence the error 'Duplicate entry ...'
looking at the error line: xmldb_core_upgrade(null) it seems as though the system is trying to upgrade from the beginning rather than from 1.5
In your database config file - what is the 'version' value set to?
Cheers
Robert
]]>
I am trying to upgrade our Mahara site from 1.5 to the latest version (1.9.1) and it has failed. The following are the steps:
Failed to get a recordset: mysql error: [1062: Duplicate entry 'auth_remove_old_session_files' for key 'cron_cal_uk'] in adodb_throw(INSERT INTO "cron" ("callfunction", "minute", "hour", "day", "month", "dayofweek") VALUES ('auth_remove_old_session_files', '30', '20', '*', '*', '*'), ) Command was: INSERT INTO "cron" ("callfunction", "minute", "hour", "day", "month", "dayofweek") VALUES (?, ?, ?, ?, ?, ?) and values was (auth_remove_old_session_files,30,20,*,*,*)
Call stack (most recent first):
upgrade_core(object(stdClass)) at /var/www/mahara17upgrade/admin/upgrade.json.php:95
We've been able to install Mahara 1.9 fresh on the same server by unable to upgrade. We need to be able to upgrade and move students' date across from the old system so please help.
I have a screenshot but unsure if I'll be able to upload the screenshot.
Thanks and best regards,
Dantina
]]>