Bug #1893

stack trace on license list

Added by Bob Gobeille about 1 year ago. Updated about 1 year ago.

Status:Closed Start date:05/04/2012
Priority:High Due date:
Assignee:Dong Ma % Done:

0%
Category:UI
Target version:2.0.0
Rank: Tester:

Description

http://fossology.usa.hp.com/?mod=list_lic_files&napk=36&item=457338630&lic=GPL_v3%2B&RememberMe=false

Click on the "Show All" link and you get a stack trace:

File: /usr/share/fossology/lib/php/common-license-file.php, Line number: 332
ERROR: invalid input syntax for integer: "" 
select count(license_file.pfile_fk) as count, count(distinct license_file.pfile_fk) as unique from license_file, (SELECT pfile_fk as PF, uploadtree_pk, ufile_name from uploadtree where upload_fk=1011 and uploadtree.lft BETWEEN 2914915 and 2916660) as SS where PF=license_file.pfile_fk and agent_fk=36 and rf_fk=''
#0  debugbacktrace() called at [/usr/share/fossology/lib/php/common-db.php:158]
#1  DBCheckResult(, select count(license_file.pfile_fk) as count, count(distinct license_file.pfile_fk) as unique
          from license_file, 
              (SELECT pfile_fk as PF, uploadtree_pk, ufile_name from uploadtree 
                 where upload_fk=1011
                   and uploadtree.lft BETWEEN 2914915 and 2916660) as SS
          where PF=license_file.pfile_fk and agent_fk=36 and rf_fk=''
                 , /usr/share/fossology/lib/php/common-license-file.php, 332) called at [/usr/share/fossology/lib/php/common-license-file.php:332]
#2  CountFilesWithLicense(36, GPL_v3 , 457338630, , , ) called at [/usr/share/fossology/nomos/ui/ui-list-lic-files.php:110]
#3  list_lic_files->Output() called at [/usr/share/fossology/www/ui/index.php:51]

This makes doing browser searching extremely tedious since you have to do it a page at a time. - Sutula

History

#1
Updated by Bob Gobeille about 1 year ago

  • Assignee set to Dong Ma

#2
Updated by Dong Ma about 1 year ago

  • Status changed from New to Resolved

Fixed in revision 5841.

#3
Updated by Bob Gobeille about 1 year ago

Does not appear to be fixed in svn 5841:

http://newbobg.ostt/fv2/?mod=list_lic_files&napk=36&item=96189454&lic=GPL_v2%2B

Click on "Show All" and get the following stack dump:

File: /home/bobg/fossology/branches/fossology2.0/fossology/src/lib/php/common-license-file.php, Line number: 332
ERROR: invalid input syntax for integer: "" LINE 6: ... where PF=license_file.pfile_fk and agent_fk=36 and rf_fk='' ^
select count(license_file.pfile_fk) as count, count(distinct license_file.pfile_fk) as unique from license_file, (SELECT pfile_fk as PF, uploadtree_pk, ufile_name from uploadtree where upload_fk=265 and uploadtree.lft BETWEEN 1 and 880) as SS where PF=license_file.pfile_fk and agent_fk=36 and rf_fk=''
#0  debugbacktrace() called at [/home/bobg/fossology/branches/fossology2.0/fossology/src/lib/php/common-db.php:158]
#1  DBCheckResult(, select count(license_file.pfile_fk) as count, count(distinct license_file.pfile_fk) as unique
          from license_file, 
              (SELECT pfile_fk as PF, uploadtree_pk, ufile_name from uploadtree 
                 where upload_fk=265
                   and uploadtree.lft BETWEEN 1 and 880) as SS
          where PF=license_file.pfile_fk and agent_fk=36 and rf_fk=''
                 , /home/bobg/fossology/branches/fossology2.0/fossology/src/lib/php/common-license-file.php, 332) called at [/home/bobg/fossology/branches/fossology2.0/fossology/src/lib/php/common-license-file.php:332]
#2  CountFilesWithLicense(36, GPL_v2 , 96189454, , , ) called at [/home/bobg/fossology/branches/fossology2.0/fossology/src/nomos/ui/ui-list-lic-files.php:111]
#3  list_lic_files->Output() called at [/home/bobg/fossology/branches/fossology2.0/fossology/src/www/ui/index.php:51]

#4
Updated by Bob Gobeille about 1 year ago

  • Status changed from Resolved to In Progress

#5
Updated by Dong Ma about 1 year ago

  • Status changed from In Progress to Resolved

New fix, revision 5843.

#6
Updated by Bob Gobeille about 1 year ago

  • Status changed from Resolved to Closed

fix patched into fo.usa and verified. Closing.

Also available in: Atom PDF