Accounts list disappears :P

[nexusglobalnet]

Fist please accept my apologies if this has already been raised.

I'm running SugarCRM CE 5.2.0k (build 5837) with the following modules installed:

CETeams
OpenSales Quotes
OpenSales Products
OpenSales Contracts

I have 393 Contacts linked to 393 Accounts.

Everything works fine until I create a Google Maps link and add it to the DetailView of the Accounts Layout. At this point all of the Accounts disappear from the Account List. However, they are still accessible through the Account Name link on any of the Contacts pages.

Can anyone shed any light on this please?

Thanks in advance.

Nexus

[andopes]

Follow my suggestions here.

Cheers

[nexusglobalnet]

Hi andopes

Thank you for the quick reply.

Following your suggestion yielded the following output directly under the Search and Clear buttons on the Accounts:Home page:

SELECT accounts.id ,accounts_cstm.ceteam_id_c,accounts_cstm.googlemap s_c, accounts.name , accounts.billing_address_city , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON jt0.id= accounts.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where ((accounts.name like 'ABC Group%') AND 1=1 ) AND accounts.deleted=0 AND 1=1

The account in question was not displayed.

Are you able to determine what is at fault from this output?

Kind regards

Nexus

[andopes]

Try to run execute query on phpMyAdmin and let us know the error returned.

Cheers

[nexusglobalnet]

My apologies but my knowledge of databases is exceptionally limited.

I'm able to follow complex instructions, however, im unsure of what you mean by your response.

Could you clarify exactly what query I have to run on phpMyAdmin, ie what syntax I have to enter?

Thanks again

Nexus

[andopes]

You have to copy the query displayed on Accounts ListView, for example:

SELECT accounts.id ,accounts_cstm.ceteam_id_c,accounts_cstm.googlemap s_c, accounts.name , accounts.billing_address_city , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON jt0.id= accounts.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 where ((accounts.name like 'ABC Group%') AND 1=1 ) AND accounts.deleted=0 AND 1=1

I supposed you configured your sugar with a MySQL database, so you are able to execute this query on phpMyAdmin.
Make sure you have phpMyAdmin installed, so you can access it through your browser.
Type the credentials to log in, select the database, click on SQL, paste the query and execute.

Let us know if you get any error.

Cheers

[nexusglobalnet]

Thank you for clarifying that.

The executed query returned the following:

#1054 - Unknown column 'accounts_cstm.googlemap' in 'field list'

SELECT accounts.id, accounts_cstm.ceteam_id_c, accounts_cstm.googlemap s_c, accounts.name, accounts.billing_address_city, accounts.phone_office, jt0.user_name assigned_user_name, jt0.created_by assigned_user_name_owner, 'Users'assigned_user_name_mod, accounts.assigned_user_id
FROM accounts
LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c
LEFT JOIN users jt0 ON jt0.id = accounts.assigned_user_id
AND jt0.deleted =0
AND jt0.deleted =0
WHERE (
(
accounts.name LIKE 'ABC Group%'
)
AND 1 =1
)
AND accounts.deleted =0
AND 1 =1
LIMIT 0 , 30


So it would appear that the problem lies with the unknown 'accounts_cstm.googlemap' column in 'field list'. How should I best resolve this without breaking Sugar?

Thanks in advance

Nexus

[andopes]

Google Maps addon is breaking your Accounts ListView.
Try to uninstall it or remove from Accounts and try again.
Contact the project maintainer regarding such issue.

Cheers

[nexusglobalnet]

Thanks for the response but I'm afraid that doesn't really help.

Firstly I've tried removing it from the Accounts ListView, tried running repair, tried readding it but to no avail, I still have lost the list of Accounts.

Having merely created a simple Link Field for Google Maps I cannot understand why it's breaking the install, especially as I followed the instructions from the SugarCRM Sugar_CommunityEdition_Install_Admin_Guide_5.2.pdf to create the Field.

When you say contact the Project Maintainer are you referring to someone else at SugarCRM?

Anyone else have any ideas?

Thanks in advance

Nexus

[nexusglobalnet]

Fixed!

After looking at the accounts_cstm table on PHPMyAdmin, I noticed that the heading was contactmap_c. This was different to the Field I'd recreated after removing it, as I changed the name to googlemaps_c. This had not been updated (for whatever reason) on the table.

Removing the googlemaps_c Field and recreating a contactmap_c Field, then adding it back into the Detail layout fixed the issue of the accounts not showing in the Account List.

Thank you for your help