Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190110.sql =================================================================== diff -u -rfd46695dcabc301f28799564c23314aa53d72dc6 -r97b429e997f02bf7a8c0e2bf551fa2941f29ed86 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190110.sql (.../patch20190110.sql) (revision fd46695dcabc301f28799564c23314aa53d72dc6) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190110.sql (.../patch20190110.sql) (revision 97b429e997f02bf7a8c0e2bf551fa2941f29ed86) @@ -31,7 +31,7 @@ -- find matching questions in Question Bank and set up references UPDATE tl_lamc11_que_content AS mcq, lams_qb_question AS qb - SET mcq.qb_question_uid = qb.ui + SET mcq.qb_question_uid = qb.uid WHERE TRIM(mcq.question) = qb.name AND mcq.mark = qb.mark AND (TRIM(mcq.feedback) = qb.feedback OR (IF(TRIM(mcq.feedback) = '', NULL, TRIM(mcq.feedback)) IS NULL AND qb.feedback IS NULL))