target list error maybe database error from callroom module

[yeldarb]

I get the following error in sugar 4.01 and 4.20d running under a shared server envirnoment

Error running count query for ProspectList List: Query Failed SELECT count(*) FROM prospects INNER JOIN prospect_lists_prospects ON (prospects.id=prospect_lists_prospects.prospect_id AND prospect_lists_prospects.prospect_list_id='b1ac165 8-5fe8-3c5e-e2b7-4379529e0e67') where ( prospect_lists_prospects.deleted=0 AND prospects.deleted=0) AND prospects.deleted=0 )::MySQL error 1054: Unknown column 'prospect_lists_prospects.prospect_id' in 'on clause'

I just updated from 3.5.1 latest maybe h to 4.20 but each time after hours of frustration i had to do a clean install of new version and then manually run the sql updates on my existing database - i suspect i have the table for prospect_lists_prospects wrong - here is the structure I have

id varchar(36)
prospect_list_id varchar(36)
related_id varchar(36)
related_type varchar(25)
date_modified datetime
deleted tinyint(1)

so clearly i have prospect_list_id and no prospect_id

so my question is can someone show me their table structure for prospect_lists_prospects so I can see if I simply need to rename the column.

Thanks in anticipation

[yeldarb]

I added the 3 fields that were apparently dropped in 4.0.1 and on.

prospect_id
lead_id
contact_id

and the target list area worked fine once again.