UsingWW: Upgrade problem?

Installation

Upgrade problem?

This forum has a limit to the number of forum postings you can make in a given time period - this is currently set at 5 posting(s) in 1 day

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/User.pm 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)

Thanks

Re: Upgrade problem?

by Jim Logan - Friday, 14 November 2008, 1:14 AM

Fixed by changing line 226 in
/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Moodle.pm
from this ...

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

to this ...

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

and restarting apache.