Your upgrade is incomplete, the user_agent column should had been added by the upgrade process that apparently did not run or not complete. You could try to point your browser logged in as admin to the YOURSITE/upgrade.php and see if that runs anything.

If it just tells "No upgrade required" then you could try to edit table `piwigo_upgrade` and delete the record with `id`=164 and if table `piwigo_user_infos` does not have column `preferences` then delete 163 as well, those are the two db upgrades that should had been executed for 12.0.0 to 13.0.0 (`description` contains "migration from 12.0.0 to 13.0.0"). It'd be odd though if the records were there but the modifications weren't done. If you upgraded from an earlier version proceed with earlier ids accordingly. Then run upgrade.php again.

Alternatively inspect all relevant to the upgrade install/db/*-database.php files and tweak the database manually using the correct SQL statements. For the `user_agent` column of install/db/164-database.php that would be

ALTER TABLE `piwigo_activity` ADD COLUMN `user_agent` varchar(255) default NULL

and for `presence` of install/db/163-database.php

ALTER TABLE `piwigo_user_infos` ADD COLUMN `preferences` TEXT default NULL