Author Name: Bob Gobeille
Original Redmine Issue: 567, http://www.fossology.org/issues/567
Original Date: 2012/01/26
Original Assignee: Bob Gobeille
showjobs provides a link to browse the upload. However, if adj2nest fails, plugins (like view_info) that use that link will fail.
Warning: pg_query(): Query failed: ERROR: operator does not exist: integer >= LINE 1: ...HERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND up... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /usr/local/share/fossology/www/ui/ui-view-info.php on line 530 Call Stack: 0.0002 662840 1. {main}() /usr/local/share/fossology/www/ui/index.php:0 0.1071 13223176 2. ui_view_info->Output() /usr/local/share/fossology/www/ui/index.php:51 0.1084 13224768 3. ui_view_info->ShowTagInfo() /usr/local/share/fossology/www/ui/ui-view-info.php:581 0.1085 13226952 4. pg_query() /usr/local/share/fossology/www/ui/ui-view-info.php:530
File: /usr/local/share/fossology/www/ui/ui-view-info.php, Line number: 531
ERROR: operator does not exist: integer >= LINE 1: ...HERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND up... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_file,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.pfile_fk = T.pfile_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= UNION SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_uploadtree,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.uploadtree_pk = T.uploadtree_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= ORDER BY ufile_name
0 debugbacktrace() called at [/usr/local/share/fossology/lib/php/common-db.php:158]
1 DBCheckResult(, SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_file,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.pfile_fk = T.pfile_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= UNION SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_uploadtree,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.uploadtree_pk = T.uploadtree_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= ORDER BY ufile_name, /usr/local/share/fossology/www/ui/ui-view-info.php, 531) called at [/usr/local/share/fossology/www/ui/ui-view-info.php:531]
2 ui_view_info->ShowTagInfo(11, 1892660) called at [/usr/local/share/fossology/www/ui/ui-view-info.php:581]
3 ui_view_info->Output() called at [/usr/local/share/fossology/www/ui/index.php:51]
Author Name: Bob Gobeille Original Redmine Issue: 567, http://www.fossology.org/issues/567 Original Date: 2012/01/26 Original Assignee: Bob Gobeille
showjobs provides a link to browse the upload. However, if adj2nest fails, plugins (like view_info) that use that link will fail.
Warning: pg_query(): Query failed: ERROR: operator does not exist: integer >= LINE 1: ...HERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND up... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /usr/local/share/fossology/www/ui/ui-view-info.php on line 530 Call Stack: 0.0002 662840 1. {main}() /usr/local/share/fossology/www/ui/index.php:0 0.1071 13223176 2. ui_view_info->Output() /usr/local/share/fossology/www/ui/index.php:51 0.1084 13224768 3. ui_view_info->ShowTagInfo() /usr/local/share/fossology/www/ui/ui-view-info.php:581 0.1085 13226952 4. pg_query() /usr/local/share/fossology/www/ui/ui-view-info.php:530 File: /usr/local/share/fossology/www/ui/ui-view-info.php, Line number: 531 ERROR: operator does not exist: integer >= LINE 1: ...HERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND up... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_file,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.pfile_fk = T.pfile_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= UNION SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_uploadtree,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.uploadtree_pk = T.uploadtree_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= ORDER BY ufile_name
0 debugbacktrace() called at [/usr/local/share/fossology/lib/php/common-db.php:158]
1 DBCheckResult(, SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_file,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.pfile_fk = T.pfile_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= UNION SELECT * FROM uploadtree INNER JOIN (SELECT * FROM tag_uploadtree,tag,tag_ns WHERE tag_pk = tag_fk AND tag_ns_fk = tag_ns_pk) T ON uploadtree.uploadtree_pk = T.uploadtree_fk WHERE uploadtree.upload_fk = 11 AND uploadtree.lft >= AND uploadtree.rgt <= ORDER BY ufile_name, /usr/local/share/fossology/www/ui/ui-view-info.php, 531) called at [/usr/local/share/fossology/www/ui/ui-view-info.php:531]
2 ui_view_info->ShowTagInfo(11, 1892660) called at [/usr/local/share/fossology/www/ui/ui-view-info.php:581]
3 ui_view_info->Output() called at [/usr/local/share/fossology/www/ui/index.php:51]