I successfully upgrades from 1.9.13 to 1.9.19.
Restored everything, was working great. Did a fresh backup of everything and started all over again to upgrade to 2.0. Checked everything to make sure it was compatible and ready. It was.
Uploaded the 2.0 file to the webhosted server. Checked notifications: There were about 8 and none of the continue buttons worked. In other words, it wouldn't let me do anything else.
According to the 2.0 upgrade page:
If it doesn't work
If the upgrade fails for any reason, it is imperative that you completely restore the 1.9 site from your backups before trying again.
So, I went back to FileZilla and uploaded the 1.9.19 Backup. When I did, the following Notifications popped up. (See below)
Needless to say, the backup didn't work either.
On the upgrade page, it says if you encounter errors to turn on Debugging. I can't. It logged me out and won't let me log back in as admin so I can't activate Debugging. In, fact, I can't get past the errors page. Below is the list of errors it generated on one page. Don't know if there are more.
I need genuine help. I am not a programmer and have precious little knowledge of computer-ese. I do have limited access to my webhost's server, but I will need hand-holding to make any changes in the mysql or databases. At this point I don't even know how to access them. Yes, I know I'm in over my head, but at this point there is no one else to do it. Help is deeply appreciated.
----------------------------------------------------------------------------------------
Setting up plugin tables
This script generated 18 warnings - Scroll to the first warning
question/type/calculated plugin needs upgrading
(mysql): CREATE TABLE mdl_question_calculated ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, answer BIGINT(10) unsigned NOT NULL DEFAULT 0, tolerance VARCHAR(20) NOT NULL DEFAULT '0.0', tolerancetype BIGINT(10) NOT NULL DEFAULT 1, correctanswerlength BIGINT(10) NOT NULL DEFAULT 2, correctanswerformat BIGINT(10) NOT NULL DEFAULT 2, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_calculated' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_calculated ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT ..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_calculated ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT ...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_calculated ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT ..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/calculated/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_calculated COMMENT='Options for questions of type calculated'
question/type/match plugin needs upgrading
(mysql): CREATE TABLE mdl_question_match ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, subquestions VARCHAR(255) NOT NULL DEFAULT '', shuffleanswers SMALLINT(4) NOT NULL DEFAULT 1, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_match' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_match ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL ..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_match ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL ...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_match ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL ..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[4]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/match/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_match COMMENT='Defines fixed matching questions'
(mysql): CREATE TABLE mdl_question_match_sub ( id BIGINT(10) unsigned NOT NULL auto_increment, code BIGINT(10) unsigned NOT NULL DEFAULT 0, question BIGINT(10) unsigned NOT NULL DEFAULT 0, questiontext TEXT NOT NULL, answertext VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_match_sub' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_match_sub ( id BIGINT(10) unsigned NOT NULL auto_increment, code BIGINT(10) unsigned NOT NULL ..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_match_sub ( id BIGINT(10) unsigned NOT NULL auto_increment, code BIGINT(10) unsigned NOT NULL ...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_match_sub ( id BIGINT(10) unsigned NOT NULL auto_increment, code BIGINT(10) unsigned NOT NULL ..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[4]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/match/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_match_sub COMMENT='Defines the subquestions that make up a matching question'
question/type/multianswer plugin needs upgrading
(mysql): CREATE TABLE mdl_question_multianswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, sequence TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_multianswer' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_multianswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_multianswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_multianswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/multianswer/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_multianswer COMMENT='Options for multianswer questions'
question/type/multichoice plugin needs upgrading
(mysql): CREATE TABLE mdl_question_multichoice ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, layout SMALLINT(4) NOT NULL DEFAULT 0, answers VARCHAR(255) NOT NULL DEFAULT '', single SMALLINT(4) NOT NULL DEFAULT 0, shuffleanswers SMALLINT(4) NOT NULL DEFAULT 1, correctfeedback TEXT NOT NULL, partiallycorrectfeedback TEXT NOT NULL, incorrectfeedback TEXT NOT NULL, answernumbering VARCHAR(10) NOT NULL DEFAULT 'abc', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_multichoice' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_multichoice ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_multichoice ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_multichoice ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/multichoice/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_multichoice COMMENT='Options for multiple choice questions'
question/type/numerical plugin needs upgrading
(mysql): CREATE TABLE mdl_question_numerical ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, answer BIGINT(10) unsigned NOT NULL DEFAULT 0, tolerance VARCHAR(255) NOT NULL DEFAULT '0.0', CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_numerical' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_numerical ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT N..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_numerical ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT N...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_numerical ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT N..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/numerical/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_numerical COMMENT='Options for numerical questions'
question/type/randomsamatch plugin needs upgrading
(mysql): CREATE TABLE mdl_question_randomsamatch ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, choose BIGINT(10) unsigned NOT NULL DEFAULT 4, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_randomsamatch' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_randomsamatch ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned N..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_randomsamatch ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned N...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_randomsamatch ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned N..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/randomsamatch/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_randomsamatch COMMENT='Info about a random short-answer matching question'
question/type/shortanswer plugin needs upgrading
(mysql): CREATE TABLE mdl_question_shortanswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, answers VARCHAR(255) NOT NULL DEFAULT '', usecase TINYINT(2) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_shortanswer' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_shortanswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_shortanswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_shortanswer ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/shortanswer/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_shortanswer COMMENT='Options for short answer questions'
question/type/truefalse plugin needs upgrading
(mysql): CREATE TABLE mdl_question_truefalse ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT NULL DEFAULT 0, trueanswer BIGINT(10) unsigned NOT NULL DEFAULT 0, falseanswer BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )
1050: Table 'mdl_question_truefalse' already exists
ADOConnection._Execute(CREATE TABLE mdl_question_truefalse ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT N..., false) % line 891, file: adodb.inc.php ADOConnection.Execute(CREATE TABLE mdl_question_truefalse ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT N...) % line 89, file: dmllib.php execute_sql(CREATE TABLE mdl_question_truefalse ( id BIGINT(10) unsigned NOT NULL auto_increment, question BIGINT(10) unsigned NOT N..., true) % line 2364, file: dmllib.php execute_sql_arr(Array[2]) % line 635, file: ddllib.php install_from_xmldb_file(/home/www/chefsgroup.org/moodle/question/type/truefalse/db/install.xml) % line 137, file: adminlib.php
(mysql): ALTER TABLE mdl_question_truefalse COMMENT='Options for True-False questions'