TOPIC:

Hi everyone,

I could not find a solution for this one, maybe someone here on the forum knows:
I'm running XoT 3.85 (github release) in Docker. The database was originally created using 3.8, I did run /upgrade.php on it. If I re-run upgrade.php it states:In the management.php interface, I have no problems editing categories or courses.

However, de groupings page is empty:

I tried adding new groupings, but they don't get added/displayed here.
I see no errors in the browser, no console messages.
The groupings are also not displayed while editing a course:


The database does contain the default groupings. If I view the table grouping with PHPmyadmin, I get:


I want to add/use the grouping mechanism in combination with XAPI. This works without a problem for category values that I add (they get added to the statements) but I also want to use the grouping as a more fine grained way of grouping parts of a learning object.

What am I missing?

Weird. Obviously the database is correct, and the query is really simple.

Could you please check if you have an error in the webserver logs? If not, could you please set $development to true on line 43 of config.php and retry. Afterwards, check the debug.log file in the error_logs folder.

Ah, of course, forgot about that.

Enabling $development = true first increased the problems.

To begin with, there was a problem with the permissions of the error_logs folder. Probably my bad, all the folders in xerteonlinetoolkits that I linked as a volume in Docker had admin:users as owner. I fixed that by attaching as root to the container and:With that fixed, the browser showed a number of PHP errors:anderrors in functions.php
(and some headers / session related things, but they were fixed by fixing the ones above).
It may have to do with me using PHP 7.4 (the deprecation one). Anyway, I fixed those and then was able to see a grouping related error:In itself not so helpful, but debug.log showed that it did not like the SQL statement around the word grouping. I do not use database prefixes, if you do you probably won't have a problem there.
I fixed it the way I know that phpMyadmin does: add ` ` around the table name (including the optional prefix).
I had to change that in management_library.php, new_grouping.php, remove_grouping.php to fix the management.php part
I had to fix it in modules/xerte/edithtml.php to get it to work in the editor.

I forked the 3.8.5 code, made the changes in the fork and created a pull request for the changes. If I try to link directly to the pull request, the forum doesn't like my reply.

Leaving $development = true still showed some problems while opening the more complex courses that I imported from Deltion (not with the small ones that I created myself), causing the editor not to open. But the appear to more template related and not grouping related and the went away when I disabled development, so for now I am going to ignore those.

Ehm, might have been too quick to declare "FIXED".
I still don't see the grouping in XAPI. I see parent, I see category, but nothing that points to the grouping that I attached.
Debug shows really cool info about the LTI handshaking and info going on, some high level XAPI info, but nothing that points to a possible location for an SQL statement related to the grouping table and XAPI.

It's working for me...


The value is set in the editor/wizard of the learning object, and ends up in the data.xml in in the USER-FILES/.../ folder of your LO.

That's passed to the xapi tracking code of Xerte, and added to the xAPI record.

Please note that the grouping is set on the actual interactivities.So for a quiz, thee will be records for the quiz, and for each question. The grouping is added to the question statements.