Bug #2997

UI error when schedule bucket but do not start the scheduler

Added by larry shi 11 months ago. Updated 9 months ago.

Status:Closed Start date:06/20/2012
Priority:High Due date:
Assignee:Mary Laser % Done:

0%
Category:UI
Target version:2.1.0 Estimated time:16.00 hours
Rank:2 Tester:

Description

with svn 5967, On my fresh install(from source) fossology, did not start the scheduler, then log on via fossy/fossy,
add one default bucket pool for fossy, then upload one file from local, enable bucket agent, then click on 'upload', will get the error msg below on UI:
File: /usr/local/share/fossology/lib/php/common-db.php, Line number: 93
ERROR: invalid input syntax for integer: "" LINE 1: ...etpool_fk='1' and upload_fk='4' and nomosagent_fk='' and age... ^
SELECT * from bucket_ars where bucketpool_fk='1' and upload_fk='4' and nomosagent_fk='' and agent_fk='' and ars_success='true' limit 1

#0 debugbacktrace() called at [/usr/local/share/fossology/lib/php/common-db.php:158]
#1 DBCheckResult(, SELECT * from bucket_ars where bucketpool_fk='1' and upload_fk='4' and nomosagent_fk='' and agent_fk='' and ars_success='true' limit 1, /usr/local/share/fossology/lib/php/common-db.php, 93) called at [/usr/local/share/fossology/lib/php/common-db.php:93]
#2 GetSingleRec(bucket_ars, where bucketpool_fk='1' and upload_fk='4' and nomosagent_fk='' and agent_fk='' and ars_success='true') called at [/usr/local/share/fossology/buckets/ui/agent-bucket.php:98]
#3 agent_bucket->AgentHasResults(4) called at [/usr/local/share/fossology/buckets/ui/agent-bucket.php:141]
#4 agent_bucket->AgentAdd(4, 4, , Array ()) called at [/usr/local/share/fossology/lib/php/common-agents.php:145]
#5 AgentCheckBoxDo(4, 4) called at [/usr/local/share/fossology/www/ui/upload-file.php:108]
#6 upload_file->Upload(1, /tmp/phpFfIG4a, , ) called at [/usr/local/share/fossology/www/ui/upload-file.php:146]
#7 upload_file->Output() called at [/usr/local/share/fossology/www/ui/index.php:51]

History

#1
Updated by larry shi 11 months ago

  • Status changed from New to Resolved
  • Priority changed from Normal to High
  • Estimated time set to 2.00
  • Rank set to 2
  • IterNum set to 3

fixed in svn 5968.

#2
Updated by larry shi 11 months ago

  • Status changed from Resolved to In Progress
  • Estimated time changed from 2.00 to 8.00

bucket can not be scheduled.

#3
Updated by larry shi 11 months ago

  • Estimated time changed from 8.00 to 16.00

#4
Updated by larry shi 11 months ago

  • Status changed from In Progress to Resolved

fixed in svn 5984.

#5
Updated by Mary Laser 10 months ago

mary to verify fix & close.

#6
Updated by larry shi 10 months ago

  • Assignee changed from larry shi to Mary Laser

mary, please help to verify and close it, thanks

#7
Updated by Paul Holland 10 months ago

  • IterNum changed from 3 to 6

Needs to be validated by Mary. She'll be back in iteration 6.

#8
Updated by Mary Laser 10 months ago

  • Status changed from Resolved to Closed

verified on pigwidgeon with svn 6098

#9
Updated by Mary Laser 9 months ago

  • Target version changed from 2.0.1 to 2.1.0

Also available in: Atom PDF