0000206: Query error when updating a certificate's expiration date

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000206

[Trellis] Certificates

minor

always

2009-03-20 13:27

2009-03-20 13:32

Reporter

james

View Status

public

Assigned To

james

Priority

normal

Resolution

fixed

Status

resolution committed

Product Version

0.5.2

Summary

0000206: Query error when updating a certificate's expiration date

Description

I received an error when a certificate that the user already had was awarded to the user and in turn extended the expiration date of the certificate. Here's the query error I received:

Example error produced:
SteamDB->query(UPDATE users_certificates SET expiration_date = '2014-03-20 13:22:10' WHERE user_id = '1604' certificate_id '3'): the query could not be completed; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'certificate_id '3'' at line 1; /var/www/trellis/0.5/core/global/classes/SteamDB_to_TrellisDB.php @ line 186;

It looks like the culprit is a missing AND and = in the query statement on line 1113 of the TrellisCourse class.

Additional Information

Tags

No tags attached.

Error Code

URI

Attached Files

Relationships

Notes
(0000771) vcs (reporter) 2009-03-20 13:30	issue#206 fixed query error in check_certificate_completion method Repository: /var/svn/trellis-dev, Revision: 8578, Committer: james

(0000772) vcs (reporter) 2009-03-20 13:32	issue#206 resolved fixed query error in check_certificate_completion method Repository: /var/svn/trellis, Revision: 111, Committer: james

Issue History
Date Modified	Username	Field	Change
2009-03-20 13:27	james	New Issue
2009-03-20 13:29	james	Description Updated
2009-03-20 13:29	james	Status	new => confirmed
2009-03-20 13:29	james	Status	confirmed => assigned
2009-03-20 13:29	james	Assigned To	=> james
2009-03-20 13:30	vcs	Checkin
2009-03-20 13:30	vcs	Note Added: 0000771
2009-03-20 13:32	vcs	Checkin
2009-03-20 13:32	vcs	Note Added: 0000772
2009-03-20 13:32	james	Status	assigned => resolution committed
2009-03-20 13:32	james	Resolution	open => fixed
2009-03-20 13:32	james	Fixed in Version	=> 0.5.3

Mantis 1.1.6[^]