When conversion issues arise, we look at the cron log. We usually see things like
Convert 1 submission attempt(s) for assignment 89155Is there an easy way without looking in the database to get to the assignment with that id? Seems I actually need the moduleid.
Maybe I'm missing something.
Some info ... but maybe not exactly what you seek ...
Site Admin menu
Reports
Logs
Select the course
All participants/days
* select the assignment * - it's by name of the assignment, not ID.
updates
participating
That should present a page/listing of all info related to the assignment .... not sure about what it would report concerning conversions, however.
'spirit of sharing', Ken
Thanks for trying to help. However, it shows the problem. These cron logs don't tell you what course, or the name of the assignment. They just give you an id, but it isn't the moduleid, it is the assignment id.
Then combo ... cli query of DB mdl_assign to get ID, course it resides in and it's name:
mysql> select id,course,name from mdl_assign;
OR ... maybe
mysql> explain mdl_file_conversion;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| id | bigint(10) | NO | PRI | NULL | auto_increment |
| usermodified | bigint(10) | NO | | NULL | |
| timecreated | bigint(10) | NO | | NULL | |
| timemodified | bigint(10) | NO | | NULL | |
| sourcefileid | bigint(10) | NO | MUL | NULL | |
| targetformat | varchar(100) | NO | | | |
| status | bigint(10) | YES | | 0 | |
| statusmessage | longtext | YES | | NULL | |
| converter | varchar(255) | YES | | NULL | |
| destfileid | bigint(10) | YES | MUL | NULL | |
| data | longtext | YES | | NULL | |
+---------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql> select id,status,statusmessage,converter from mdl_file_conversion;
'spirit of sharing', Ken
Thanks again Ken,
This works fine in my dev environment where I have access to run queries on the db, but on our production server I do not have this access.
Ok, seems I'm not mistaken, there isn't a way without the db to find out the assignment that is failing. All this could be made easier if the cron gave out the moduleid instead.