Hello,

to answer your last point: 

1. the texts for LGPL-2.0-or-later / LGPL-2.0+ and LGPL-2.0-only / LGPL-2.0 are 
maybe the same or very similar. Faintly remembering, the formatting is 
different between the two entries.

2. We have discussed deleting licenses, it could be done. Case are difficult if 
a license is involved in a clearing decision or scan result. And a problem is / 
was that some licenses are tied to the way scanners work, so pulling a license 
out, can make it complicated when preserving existing data /scan results is a 
goal.

Kind regards, michael

On 03.09.19, 09:42, "fossology@lists.fossology.org on behalf of Steffen 
Mueller" <fossology@lists.fossology.org on behalf of pulvert...@gmx.de> wrote:

    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 &quot;rf_md5unique&quot;\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 (#3292): https://lists.fossology.org/g/fossology/message/3292
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]
-=-=-=-=-=-=-=-=-=-=-=-

Reply via email to