-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
2.1
-
None
-
Moodle 1.9.12 installed on Redhat Linux 4.9 server, using Oracle 11.2.0.1.0, Apache 2.2.19 and PHP 5.3.6
php_extension intl should be installed and enabled for best results
Intl extension is used to improve internationalization support, such as locale aware sorting. Check
moodle version 1.9 is required and you are running 1.9.12 OK
unicode must be installed and enabled OK
database oracle version 10.2 is required and you are running 11.2.0.1.0 OK
php version 5.3.2 is required and you are running 5.3.6 OK
php_extension iconv must be installed and enabled OK
php_extension mbstring should be installed and enabled for best results OK
php_extension curl must be installed and enabled OK
php_extension openssl should be installed and enabled for best results OK
php_extension tokenizer should be installed and enabled for best results OK
php_extension xmlrpc should be installed and enabled for best results OK
php_extension soap should be installed and enabled for best results OK
php_extension ctype must be installed and enabled OK
php_extension zip must be installed and enabled OK
php_extension gd should be installed and enabled for best results OK
php_extension simplexml must be installed and enabled OK
php_extension spl must be installed and enabled OK
php_extension pcre must be installed and enabled OK
php_extension dom must be installed and enabled OK
php_extension xml must be installed and enabled OK
php_extension json must be installed and enabled OKMoodle 1.9.12 installed on Redhat Linux 4.9 server, using Oracle 11.2.0.1.0, Apache 2.2.19 and PHP 5.3.6 php_extension intl should be installed and enabled for best results Intl extension is used to improve internationalization support, such as locale aware sorting. Check moodle version 1.9 is required and you are running 1.9.12 OK unicode must be installed and enabled OK database oracle version 10.2 is required and you are running 11.2.0.1.0 OK php version 5.3.2 is required and you are running 5.3.6 OK php_extension iconv must be installed and enabled OK php_extension mbstring should be installed and enabled for best results OK php_extension curl must be installed and enabled OK php_extension openssl should be installed and enabled for best results OK php_extension tokenizer should be installed and enabled for best results OK php_extension xmlrpc should be installed and enabled for best results OK php_extension soap should be installed and enabled for best results OK php_extension ctype must be installed and enabled OK php_extension zip must be installed and enabled OK php_extension gd should be installed and enabled for best results OK php_extension simplexml must be installed and enabled OK php_extension spl must be installed and enabled OK php_extension pcre must be installed and enabled OK php_extension dom must be installed and enabled OK php_extension xml must be installed and enabled OK php_extension json must be installed and enabled OK
-
Oracle
-
MOODLE_21_STABLE
-
-
http://dev.oten.tafensw.edu.au/online2/admin/index.php?confirmplugincheck=1 (internal url when error happens)
-
When upgrading Moodle 1.9.12 instance to version 2.1 I get the following oracle error when upgrading qtype_multichoice:
Debug info: ORA-00972: identifier is too long
UPDATE m_question_multichoice SET question = :o_question,layout = :o_layout,answers = :o_answers,single = :o_single,shuffleanswers = :o_shuffleanswers,correctfeedback = :o_correctfeedback,partiallycorrectfeedback = :o_partiallycorrectfeedback,incorrectfeedback = :o_incorrectfeedback,answernumbering = :o_answernumbering,correctfeedbackformat = :o_correctfeedbackformat,partiallycorrectfeedbackformat = :o_partiallycorrectfeedbackformat,incorrectfeedbackformat = :o_incorrectfeedbackformat WHERE id=:o_id
[array (
'o_question' => '249',
'o_layout' => '0',
'o_answers' => '460,461,462,463,464',
'o_single' => '0',
'o_shuffleanswers' => '1',
'o_correctfeedback' => '',
'o_partiallycorrectfeedback' => '1',
'o_incorrectfeedback' => '',
'o_answernumbering' => 'none',
'o_correctfeedbackformat' => '1',
'o_partiallycorrectfeedbackformat' => '0',
'o_incorrectfeedbackformat' => '1',
'o_id' => '125',
)]
Stack trace:
line 396 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 268 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
line 1285 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
line 1318 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->update_record_raw()
line 124 of /question/type/multichoice/db/upgrade.php: call to oci_native_moodle_database->update_record()
line 379 of /lib/upgradelib.php: call to xmldb_qtype_multichoice_upgrade()
line 1460 of /lib/upgradelib.php: call to upgrade_plugins()
line 317 of /admin/index.php: call to upgrade_noncore()
I notice that the bind variable o_partiallycorrectfeedbackformat is too long being more than 30 characters based on table column partiallycorrectfeedbackformat.
How can I get the upgrade to complete? Every time I log in it tries to continue this step and produces this error.
Can I fudge or comment out this field in moodle upgrade code so the upgrade completes?
- duplicates
-
-
- Closed
-