After Server Move Lead List Empty

[ianobetz]

I moved from a shared GoDaddy linux host to a RackSpace server cloud today. I exported entire database, zipped up the files, transferred them to new server, unzipped, loaded database, reset permissions (777), owner and grop and viola... almost everything is working.

Unfortunately, the lead list is completely empty. When I search for a lead, its not found. I'm logged in as admin. The leads are in the list on the old server, not on the new server.

I changed the paths in config.php to be correct. I checked the error.log file but nothing in there. I then used all of the tools in the admin, check for upgrade, rebuild cache, etc. I checked the database and the leads are still in the database, but no luck in the list.

Can anyone give me a suggestion where to turn to next?

[jnassi]

I moved from a shared GoDaddy linux host to a RackSpace server cloud today. I exported entire database, zipped up the files, transferred them to new server, unzipped, loaded database, reset permissions (777), owner and grop and viola... almost everything is working.

Unfortunately, the lead list is completely empty. When I search for a lead, its not found. I'm logged in as admin. The leads are in the list on the old server, not on the new server.

I changed the paths in config.php to be correct. I checked the error.log file but nothing in there. I then used all of the tools in the admin, check for upgrade, rebuild cache, etc. I checked the database and the leads are still in the database, but no luck in the list.

Can anyone give me a suggestion where to turn to next?

Are all of your other listviews populating with search results? Everything EXCEPT Leads?

[ianobetz]

The only list view I have is leads. We don't have any opportunities or contacts. Is there another place to see a list view? We're pretty new to sugar.

[ianobetz]

I did receive the follow error:

Error retrieving Lead list: Query Failed SELECT meetings.id , meetings.name , 0 reply_to_status , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.parent_id , meetings.parent_type , meetings.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , meetings.assigned_user_id , 'meetings' panel_name FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN meetings_leads ON (meetings.id=meetings_leads.meeting_id AND meetings_leads.lead_id= '99fefdfa-6eea-48d6-e49f-4c813fda8755') where ( meetings_leads.deleted=0 AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT meetings.id , meetings.name , 0 reply_to_status , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.parent_id , meetings.parent_type , meetings.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , meetings.assigned_user_id , 'oldmeetings' panel_name FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id = '99fefdfa-6eea-48d6-e49f-4c813fda8755' AND meetings.parent_type = 'Leads' AND meetings.id NOT IN ( SELECT meeting_id FROM meetings_leads ) AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , 0 reply_to_status , tasks.status , contact_name , tasks.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.parent_id , tasks.parent_type , tasks.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= '99fefdfa-6eea-48d6-e49f-4c813fda8755' AND tasks.parent_type='Leads' AND tasks.deleted=0 AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , 0 reply_to_status , calls.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , calls.parent_id , calls.parent_type , calls.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , calls.assigned_user_id , 'calls' panel_name FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 INNER JOIN calls_leads ON (calls.id=calls_leads.call_id AND calls_leads.lead_id= '99fefdfa-6eea-48d6-e49f-4c813fda8755') where ( calls_leads.deleted=0 AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , 0 reply_to_status , calls.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , calls.parent_id , calls.parent_type , calls.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, ' ' filename , calls.assigned_user_id , 'oldcalls' panel_name FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id = '99fefdfa-6eea-48d6-e49f-4c813fda8755' AND calls.parent_type = 'Leads' AND calls.id NOT IN ( SELECT call_id FROM calls_leads ) AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT notes.id , notes.name , 0 reply_to_status , ' ' status , contact_name , notes.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, notes.parent_id , notes.parent_type , notes.date_modified , ' ' assigned_user_name , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.filename , notes.created_by , 'notes' panel_name FROM notes LEFT JOIN contacts contacts ON contacts.id= notes.contact_id AND contacts.deleted=0 AND contacts.deleted=0 where ( notes.parent_id= '99fefdfa-6eea-48d6-e49f-4c813fda8755' AND notes.parent_type='Leads' AND notes.deleted=0) AND notes.deleted=0 ) ORDER BY date_modified desc LIMIT 0,10::MySQL error 1054: Unknown column 'contact_name' in 'field list'

[roblaus]

Rebuild roles (even though you do not use them) if you haven't done so and restart your webserver. The latter solved some of the weirder problems I had recently.

[roblaus]

ok, then it isn't Apache most likely and not the roles either. The 1054 error pops up quite frequently without a real solution as it seems. Try to run the query in phpmyadin and see whether it gives the same result.

[ianobetz]

When I run the query in phpmyadmin the responding error is:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') UNION ALL ( SELECT meetings.id , meetings.name , 0 reply_to_status , meetings.' at line 1

I haven't modified any of the code in Sugar.

[ianobetz]

In the config file, I changed the db type during the server switch to mysqli instead of leaving it as mysql. I changed it back and everything works.