Hello, how did you install it? I think ct_pk should not be there but some older code is expecting it:
https://github.com/fossology/fossology/pull/1201 (apparently it is also not in the DB anymore, but suspecting some older code is still running) Kind regards, Michael > On 2. Oct 2019, at 14:44, Martin von Willebrand > <martin.vonwillebr...@hhpartners.fi> wrote: > > Hi, > > I get the following log from the Fossology copyright agent, which fails to > find all copyright notices: > --- > 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: > "ERROR: ERROR: column "ct_pk" does not exist" > 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: > "LINE 1: ...k = 12) inner join pfile on (PF = pfile_pk) WHERE ct_pk IS n..." > 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: " > ^" > 2019-10-02 14:46:47 copyright [0] :: JOB[1821].copyright[1163.localhost]: > "On: SELECT pfile_pk FROM ( SELECT distinct(pfile_fk) AS PF FROM > uploadtree_a WHERE upload_fk = 213 and (ufile_mode&x'3C000000'::int)=0 ) AS > SS left outer join copyright on (PF = pfile_fk and agent_fk = 12) inner join > pfile on (PF = pfile_pk) WHERE ct_pk IS null or agent_fk <> 12" > --- > > I had a similar error in 3.5.0 and recently updated to 3.6.0. Since the > error persisted, I decided to ask for help from the list. The problem seems > to repeat across uploads. The agent seems to process copyright notices > partially, but clearly leaves quite a bit unprocessed. I’m running Fossology > on Debian 8. I collected the logs from the output in the web UI/Show > Jobs/copyright/log. > > Appreciate any help. > > Best > Martin > > Martin von Willebrand, Attorney-at-law, Partner > HH Partners, Attorneys-at-law Ltd > Bulevardi 7, 5th floor > P.O. Box 232, 00101 Helsinki, Finland > Tel: +358 9 177 613, Fax: +358 9 653 873 > GSM: +358 40 770 1818 > martin.vonwillebr...@hhpartners.fi > www.twitter.com/mvonwi > www.hhpartners.fi > Validos ry, Chairman, www.validos.org > > HH Partners shines in international rankings. See details at hhpartners.fi. > Privileged and confidential information may be contained in this message. If > you are not addressee indicated in this message (or responsible for delivery > of the message to such person), you may not copy or deliver this message to > anyone. In such case, kindly notify us by reply e-mail and delete this > message immediately. Thank you. > > -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#3305): https://lists.fossology.org/g/fossology/message/3305 Mute This Topic: https://lists.fossology.org/mt/34369588/21656 Group Owner: fossology+ow...@lists.fossology.org Unsubscribe: https://lists.fossology.org/g/fossology/unsub [arch...@mail-archive.com] -=-=-=-=-=-=-=-=-=-=-=-
