Non-core contributed modules

Attendance generates errors when updating database

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 1.9.2, 1.9.4
  • Fix Version/s: None
  • Component/s: Package: Attendance
  • Labels:
    None
  • Environment:
    FreeBSD v6, PhP 5, MySQL 5
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_19_STABLE

Description

Moving from Moodle 1.9.2+ to 1.9.5 and I wanted to update Attendance. After some confusion about where the latest version was located (see http://moodle.org/mod/forum/discuss.php?d=127795) I downloaded the package from Modules and Plugins. The RELEASES.txt file shows "2.1.0 - 28 feb 2009" but CHANGES shows edits made on 2009-04-13 which I found rather confusing. Nevertheless, confident that this was indeed the latest version I added it to my 1.9.5 test pilot which used a copy of the 1.9.2 production database. Upon visiting the Admin page the database updated but threw the errors shown in the attached images, namely:

(mysql) : UPDATE mdl_attendance_log SET statusid=61, statusset='61,62,63,64' WHERE sessionid IN () AND status = 'P'
1064: You have an error in your SQL syntax;

I am assuming that such errors won't the affect the functioning of Attendance in new courses, right?
Mark

Activity

There are no comments yet on this issue.

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated: