Peter Ruthven-Stuart

Hello,

Before upgrading my production moodle site to version 2, I am practicing the upgrade process on another server.

The upgrade runs, course files and blog attachments are migrated, and then I get a "DDL sql execution error" - see attached screenshot.

The text following this error is:

Debug info: MySQL server has gone away
ALTER TABLE mdl_log MODIFY COLUMN ip VARCHAR(45) NOT NULL DEFAULT '' after userid
Stack trace:

* line 397 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
* line 636 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
* line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
* line 75 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
* line 636 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
* line 648 of /lib/ddl/database_manager.php: call to database_manager->change_field_type()
* line 1042 of /lib/db/upgrade.php: call to database_manager->change_field_precision()
* line 1360 of /lib/upgradelib.php: call to xmldb_main_upgrade()
* line 252 of /admin/index.php: call to upgrade_core()

Fatal error: Exception thrown without a stack frame in Unknown on line 0

There is a [Continue] button, which when I click takes me back to the "Your Moodle files have been changed, and you are about to automatically upgrade your server to this version:". On trying to re-run the process I am taken back to the same error.

I am trying to upgrade from moodle 1.9.10+ to 2.0.1+

my environment is:

• php: 5.3.0
• mysql: 5.1.40
• server: MacOS 10.5.8

Any suggestions will be gratefully received.

I should add that I have successfully installed a fresh install of version 2.0.1+on this same server.

Hello Tim,

Thanks for your reply. I realise that recommended is different from required, but given the fact that Japanese will be used in my Moodle system, I thought that perhaps the lack of an intl php_extension might be an issue. For example, this Core Developer writes:

"If you are using no-English languages on your Moodle system, you should definitely get php5-intl extension."

which in my context sounds like more of a requirement than I recommendation .

Hello John,

I too have installed version 2 on a MacOsX Server 10.5.8. (and 10.6.6) for test purposes, and the Server check tells me that I need to install the intl php_extension.

I ignored this warning when installing version 2, and it is running OK without this intl extension, and Japanese characters are displaying as expected.

So, do I really need the intl php_extension, and if so how did you go about downloading and installing it on your MacOsX Server?

Any advice will be much appreciated.

Hello Hoang,

Funny you should ask that question now. I just happened to be googling for "moodle v blackboard", when your question arrived, and found:

Blackboard vs. Moodle: a comparison

Note especially the link to the "2009 University of North Carolina report".

Hello Tom,

Thanks for bringing my attention to this issue.

I second everyone who would like to see the functionality of the 'save all grade point values' for questions exist in version 2. The removal of a time-saving feature is tantamount to introducing a 'bug'. Let's hope this can be fixed in time for the release of version 2.