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
| Status: | New | Start date: | 03/08/2012 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | % 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.