Upgrade problem?

Upgrade problem?

by Jim Logan -
Number of replies: 1
Everything was working fine with moodle 1.9.2 and webwork, until
the moodle database was dumped from our moodle 1.9.1 production
server and loaded into our moodle 1.9.2 test server. Moodle went
through it's database upgrade. Now ...

Selecting a course using Webwork bridge 1 results in this error:

DBD::mysql::st execute failed: Unknown column 'mdl_wwassignment_bridge.coursename' in 'where clause' at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Moodle/ line 393.

The table "
mdl_wwassignment_bridge" has a field "course",
but not "coursename". We don't know if the database schema
is out of sync, or the code.

We're trying to upgrade to moodle v1.9.2 and webwork 2.4.5

Environment (all below working fine):
FreeBSD 7.1
Moodle 1.9.2
Webwork Bridge 2 (wwmoodle,wwqs,wwqt)


In reply to Jim Logan

Re: Upgrade problem?

by Jim Logan -
Fixed by changing line 226 in
from this ...

my $coursename_field = $self->sql->_quote("coursename");

to this ...

my $coursename_field = $self->sql->_quote("course");

and restarting apache.