Bug #1443

Bug #1383: can not edit the information for a license when click on [Admin]-->[License Admin] menu, then click on any edit icon

can not edit the information for a license

Added by larry shi about 1 year ago. Updated 7 months ago.

Status:New Start date:03/08/2012
Priority:Normal Due date:
Assignee:Bob Gobeille % Done:

0%

Category:UI
Target version:-
Rank:99 Tester:

Description

reproduce:
1. click on [Admin]-->[License Admin] menu, then click on any edit icon, click on the link 'update' to change some items of this license.
2. repeat the step 1, get one error msg :

File: /usr/local/share/fossology/www/ui/admin-license-file.php, Line number: 361
ERROR: duplicate key value violates unique constraint "rf_md5unique"
UPDATE license_ref set rf_active='true', marydone='false', rf_shortname='3DFX', rf_fullname='', rf_url='', rf_notes='', rf_text_updatable='false', rf_detector_type='2', rf_text='License by Nomos.', rf_md5='2837743839a3f8e500aed1b9144452bb' WHERE rf_pk='202'

#0 debugbacktrace() called at [/usr/local/share/fossology/lib/php/common-db.php:158]
#1 DBCheckResult(, UPDATE license_ref set
rf_active='true',
marydone='false',
rf_shortname='3DFX',
rf_fullname='',
rf_url='',
rf_notes='',
rf_text_updatable='false',
rf_detector_type='2',
rf_text='License by Nomos.',
rf_md5='2837743839a3f8e500aed1b9144452bb'
WHERE rf_pk='202', /usr/local/share/fossology/www/ui/admin-license-file.php, 361) called at [/usr/local/share/fossology/www/ui/admin-license-file.php:361]
#2 admin_license_file->Updatedb(Array ([rf_pk] => 202,[req_marydone] => all,[req_shortname] => All,[updateit] => true,[rf_active] => true,[marydone] => false,[rf_shortname] => 3DFX,[rf_fullname] => ,[rf_text] => License by Nomos.,[rf_text_updatable] => false,[rf_detector_type] => 2,[rf_url] => ,[rf_notes] => )) called at [/usr/local/share/fossology/www/ui/admin-license-file.php:457]
#3 admin_license_file->Output() called at [/usr/local/share/fossology/www/ui/index.php:51]

the reason is because for now, almost all the 'license text' are 'License by Nomos.', but definition of license_ref say rf_md5 should be unique, rf_md5 is from md5(rf_text) .

History

Updated by larry shi about 1 year ago

after #717 is fixed, the text of some licenses contain double quotation marks, when edit one license and save, will get error msg:
File: /usr/local/share/fossology/www/ui/admin-license-file.php, Line number: 360
ERROR: syntax error at or near "s" LINE 41: ...term \"Program\" as used in this Agreement refers to 3DFX's ^

Updated by Bob Gobeille 7 months ago

  • Rank set to 99

Change unranked issues to rank 99 so they show up in a ranking report at the bottom. Otherwise, they show up on top.

Also available in: Atom PDF