now lectures.test_id can be NULL. changes to mysqlapi