Upgrade from 3.3RC2 to sprint 125
I have tried in multiple ways to upgrade. This latest try, I did the following:
1. unzipped TAO3.3RC2 to a new directory. Renamed it to tao33 as my previous installation
2. replaced composer.json with https://github.com/oat-sa/tao-community/blob/v0.125.3-alpha/composer.json
3. composer update'd (I did NOT install before the update - when I did that, I ended with compability problems)
4. Installed using the GUI. Using EXACT the same information as the previous installation (same instance name, same database and user).
5. I could now log in. But... I wanted to use my "old" data.
6. I replaced the new data folder with the previous one (I also tried to replace the config, but that gave errors - and I guess that when the usernames, instance name etc. are the same, it is better to keep the new version).
7. I copied every row from the previous statements, result_storage and variables_storage tables (I also tried to just replace the whole database) - in the new version there is one row in the kv_store - I have kept that.
8. I can go to the login in screen. I can even log in as a guest and see the public delivery I had in my previous installation. BUT...
9. When I log in as my own (admin) user, I get a 500 error. I cannot see anything in the logs.
10. I have tried to use both the previous and the new value as GENERIS_SESSION_NAME in generis.conf.php.
Please give me a hint on what to do next...
Comments
We didn't provide yet a tutorial to upgrade from TAO 3.3 (sprint 96) to TAO 3.4 (sprint 116), so please wait a little bit until TAO 3.4 is released (no ETA yet).
The problem is that I need to get access to the bug fix of the duration problem (all durations above 1 minute are just reported as the seconds parts). And that bug fix depends on newer versions of generis and tao... So if you could help me to find out to just get access to that fix in 3.3RC2, it would be perfect.
What is the exact TAO extension and eventually the commit number that brings this tweak?
I solved my problem by writing a script that downloads the student responses directly from the database - including the correct duration times.
So I don't need this update anymore, and I will just wait for the update and instructions.
Thanks,
Jeppe
PS. In the script I extract information about students, tests, deliveries, items and results into separate tables (more in line with a relational database approach than the RDF-approach in TAO), and pull the data from those. It made the export of data go very much faster. So if anyone gets frustrated by the download times from TAO, I can give you that script (you will have to adapt it, so it is not off-the-shelf-ready).
Hi jeppebundsgaard, I'm very interested in your script. Could you post it here?
Sorry stephan_cgn - I don't get emails from this forum, so I didn't see your request.
My solution was to first create new tables in the new database tao_results - here as export output from phpmyadmin:
Then I extract information from tao33-database to tao-results:
--- Insert items into item table
--- Insert tests into test table
--- Insert deliveries into delivery table
--- Relate to test
--- Insert users into test_taker table
--- Insert data into result table
And finally I can extract the results:
This is my query-string in PHP - I have a script which I use for a simple GUI to select delivery, test or user.
Because of the regular expressions in this query, you need MYSQL 8.
And I also needed to set the mysql-variable
regexp_time_limit=1024
in /etc/mysql/conf.d/mysql.cnf-file (or similar)jeppebundsgaard, thank you very much!