No leads showing in lead view

[totalimpact]

When I click the leads tab and go to view leads - it is empty - 0 leads, says "No data".

I just installed 6.0.3 on windows with fastrack with mysql on a 2003 server. I am doing all work as admin in sugar -

I customized the leads module with 4-5 new fields. Imported a csv of leads.

They show on the home page as new leads, and I can click on one there to open the lead.

I manually entered a new lead, same deal.

I have read a couple postings on this, and didnt see any solutions.

Clicking "clear" on the search changes nothing.
Listview items per page: 20
I can see all the leads in mysql, and the deleted value is set to 0

[davidboris]

Hello,

I think the query seems to be failing for your module. Do echo in include/ListView/ListViewData.php $main_query on around line # 295 and execute the query directly in database.

[totalimpact]

interesting black magic

query replied with:
#1054 - Unknown column 'leads_cstm.years_of_experience_c' in 'field list'

I didnt see a table called field list in mysql.

i assume that needs to be in the table called "leads_cstm"?

[totalimpact]

i think i found a pattern here -

in sugar i am trying to make a new field with a data type "Decimal", it saves, but never shows up in the leads_cstm table, if i make a regular Text Field it shows up in the table

- is this a bug?

[robertbmirth]

hmm... well if it is a bug, I can't duplicate it - if I try to add a custom decimal it shows right up in my leads_cstm table. Mind going to the fields_meta_data table and seeing what shows up there?