Hi Gaurav, thanks for you quick reply. I checked the error log and as you expected it seems to be a duplicate:
[Tue Sep 03 09:12:15.542118 2019] [php7:warn] [pid 3420] [client 127.0.0.1:40942] PHP Warning: pg_execute(): Query failed: ERROR: duplicate key value violates unique constraint "rf_md5unique"\nDETAIL: Key (rf_md5)=(fcae18b6cb2d3b243eddf5734c7c5d9a) already exists. in /usr/local/share/fossology/lib/php/Db/Driver/Postgres.php on line 72, referer: http://localhost/fossy/?mod=admin_license&rf_pk=7&req_marydone=f&req_shortname=LGPL-2.0+ [Tue Sep 03 09:12:15.542447 2019] [php7:notice] [pid 3420] [client 127.0.0.1:40942] [2019-09-03 09:12:15] default.CRITICAL: ERROR: duplicate key value violates unique constraint "rf_md5unique" DETAIL: Key (rf_md5)=(fcae18b6cb2d3b243eddf5734c7c5d9a) already exists. [] [], referer: http://localhost/fossy/?mod=admin_license&rf_pk=7&req_marydone=f&req_shortname=LGPL-2.0+ [Tue Sep 03 09:12:15.543349 2019] [php7:error] [pid 3420] [client 127.0.0.1:40942] PHP Fatal error: Uncaught Fossology\\Lib\\Exception: error executing: admin_license_file::Updatedb.md5($10): UPDATE license_ref SET\n rf_active=$2, marydone=$3, rf_shortname=$4, rf_fullname=$5,\n rf_url=$6, rf_notes=$7, rf_text_updatable=$8, rf_detector_type=$9, rf_text=$10,\n rf_md5=md5($10), rf_risk=$11, rf_spdx_compatible=$12, rf_flag=$13\n WHERE rf_pk=$1 -- -- Array\n(\n [0] => 7\n [1] => true\n [2] => false\n [3] => LGPL-2.0+\n [4] => GNU Library General Public License v2 or later\n [5] => http://www.gnu.org/licenses/old-licenses/lgpl-2.0-standalone.html\n [6] => \n [7] => false\n [8] => 1\n [9] => GNU LIBRARY GENERAL PUBLIC LICENSE\r\n\r\nVersion 2, June 1991\r\n\r\nCopyright (C) 1991 Free Software Foundation, Inc.\r\n51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA\r\nEveryone is permitted to copy and distribute verbatim copies\r\nof this license document, but changing it is not allowed.\r\n\r\n[This is the first released version of the library GPL. It is\r\nnumbered 2 because it goe in /usr/local/share/fossology/lib/php/Db/DbManager.php on line 140, referer: http://localhost/fossy/?mod=admin_license&rf_pk=7&req_marydone=f&req_shortname=LGPL-2.0+ I don't really know how this duplicate was brought in. Can you give me some advice how to get rid of this entry or sanitize the db? As far as I'm aware, unfortunately there is not direct possibility to delete entire license entries using the GUI. BR Steffen -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#3287): https://lists.fossology.org/g/fossology/message/3287 Mute This Topic: https://lists.fossology.org/mt/33104224/21656 Group Owner: fossology+ow...@lists.fossology.org Unsubscribe: https://lists.fossology.org/g/fossology/unsub [arch...@mail-archive.com] -=-=-=-=-=-=-=-=-=-=-=-
