empty list view after adding custom fields

[cerhorn]

Using version 5.1
Contacts list view showed all the contacts before adding custom fields.
After adding some custom fields, list view is empty.
Search for specific contact records brings in the appropriate record.

I read a post somewhere that said this was a known problem. Is it fixed in 5.2? Is there a work-around?

Thanks!

[malcolmh]

Hi,

I believe this was fixed with 5.1b.

Hope this helps

[genius36]

Maybe it's fixed but now the list view doesn't show the custom fields.

[vishwasrao]

Hi
cerhorn ,
Have u changed code for adding custom fields .

[vantagejuan]

i have this issue as well, where i've changed the coding of some fields using enhanced studio. does anyone know how i can fix this?

[andopes]

Using version 5.1
Contacts list view showed all the contacts before adding custom fields.
After adding some custom fields, list view is empty.
Search for specific contact records brings in the appropriate record.

I read a post somewhere that said this was a known problem. Is it fixed in 5.2? Is there a work-around?

Thanks!

Hi cerhorn

The ListView is empty due a LisView SQL query error.
Follow the steps here to identify the error and let us know both SQL query and error message.

Kind regards

[vantagejuan]

I'm having an issue with my list view still. It's not showing and I've queried the database and i get this error:

#1054 - Unknown column 'leads_cstm.total_transport_c' in 'field list'

i think it may have to do with the fact that that this field did not store a column for it in the database when it was created. what are my options? if i don't need for that field to have a stored value, is there any way i can get the list view to show by bypassing that field in the list view query?

[ptemplin7]

Use your DB tool, myphpadmin or other, and edit the fields_meta_data table to get rid of that field OR

better yet, Edit the leads_cstm table and add that column back in.

After you get it fixed use the studio and delete the field.

Have you tried to use the repair tool under the admin? IF not try that first. May make it all right without manipulating the database.

Good luck Paris

[vantagejuan]

i have tried the repair tool under the database, but that does not cure the problem.

the best fix i've found is to go into the leads_cstm table and just add the columns. tedious, but it works...

[vantagejuan]

i just wanted to report that this was actually due to me using a bad value in the DB Type field while creating a custom field with enhanced studio. i was creating a "Currency" field and was typing "Currency" in the DB Type, when I should have been typing in "DECIMAL (26,6)" to correlate with the parameters of MySql for column storage.