aaaaargh no data in listview

[Meyer]

hi. did an import via sugar and afterwrards no data. there is data in the database but ugar shows nothing. i then created a new contacts by clicking on create contact, filled in the info,saved and nada, nothing. please helpA

[andopes]

Hi Meyer

It seems you have a sql issue when displaying the Contacts.
Does it happen only into Contacts module or into any other module?
Edit the file include/ListView/ListViewData.php and add this code:

 echo "<LI>$main_query"; 
  

just after the line

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Cheers

[Meyer]

thanks
but nope. now i get

SELECT contacts.id ,contacts_cstm.building_c,contacts_cstm.streetname _c,contacts_cstm.streetnumber_c,contacts_cstm.stre etsuburb_c,contacts_cstm.streettown_c,contacts_cst m.streetpostalcode_c,contacts_cstm.province_c,cont acts_cstm.dialcode_c,contacts_cstm.url_c,contacts_ cstm.mobilenetwork_c,contacts_cstm.nextsubscriptio nduedate_c,contacts_cstm.listingtype_c,contacts_cs tm.subscriptionstatus_c,contacts_cstm.subscription date_c,contacts_cstm.keywordsallowed_c,contacts_cs tm.tradingas_c,contacts_cstm.typeofbus_c,contacts_ cstm.smsdisplay_c,contacts_cstm.showbuilding_c,con tacts_cstm.geostreet_c,contacts_cstm.geostreetnumb er_c,contacts_cstm.geosuburb_c,contacts_cstm.geoto wn_c,contacts_cstm.geoprovince_c,contacts_cstm.geo type_c,contacts_cstm.geoaccuracy_c,contacts_cstm.d istanceoverflow_c,contacts_cstm.latitude_c,contact s_cstm.longitude_c,contacts_cstm.active_c,contacts _cstm.batchid_c,contacts_cstm.billingdone_c,contac ts_cstm.promotionaltext_c,contacts_cstm.areaserved id_c,contacts_cstm.inbusinesssince_c,contacts_cstm .isopenmonday_c,contacts_cstm.isopentuesday_c,cont acts_cstm.isopenwednesday_c,contacts_cstm.isopenth ursday_c,contacts_cstm.isopenfriday_c,contacts_cst m.isopensaturday_c,contacts_cstm.isopensunday_c,co ntacts_cstm.isopenholidays_c,contacts_cstm.emergen cyservice_c,contacts_cstm.mondayopen_c,contacts_cs tm.tuesdayopen_c,contacts_cstm.wednesdayopen_c,con tacts_cstm.thursdayopen_c,contacts_cstm.fridayopen _c,contacts_cstm.saturdayopen_c,contacts_cstm.sund ayopen_c,contacts_cstm.holidayopen_c,contacts_cstm .mondayclose_c,contacts_cstm.tuesdayclose_c,contac ts_cstm.wednesdayclose_c,contacts_cstm.thursdayclo se_c,contacts_cstm.fridayclose_c,contacts_cstm.sat urdayclose_c,contacts_cstm.sundayclose_c,contacts_ cstm.holidayclose_c,contacts_cstm.minority_c,conta cts_cstm.femaleowned_c,contacts_cstm.drivingdirect ions_c,contacts_cstm.payoffslogan_c,contacts_cstm. templistingid_c,contacts_cstm.dateupdated_c,contac ts_cstm.moreinformation_c,contacts_cstm.categoriza tionchecked_c,contacts_cstm.categorizationflagged_ c,contacts_cstm.recordingnumber_c, CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) as name, contacts.first_name , contacts.last_name , contacts.salutation , accounts.name account_name, jtl0.account_id account_id, contacts.title , contacts.phone_work , jt1.name team_name , jt1.created_by team_name_owner , 'Teams' team_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, contacts.assigned_user_id FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN accounts_contacts jtl0 ON contacts.id=jtl0.contact_id AND jtl0.deleted=0 LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0 AND accounts.deleted=0 LEFT JOIN teams jt1 ON jt1.id= contacts.team_id AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= contacts.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 where contacts.deleted=0 ORDER BY name ASC

[andopes]

Hi Meyer

Now that you can see the query you can copy it and execute it into phpMyAdmin.
It will probably return an error.
Let me know this error.

Cheers

[Meyer]

hail sir andopes
A Sugar Hero.
A man ahead of his time.

Thanks kind sir.
It seems sugar never created the sql tables for the fields.

Maybee you could help me with another query of mine . when i imported into leads, i can see the leads but when i click on the arrows to view the next 20 firefox closes, and iis just does nothing

regards

Paul

[andopes]

Hi Paul

To fix the old issue had you click into Repair Database in the Admin -> Repair?
This new issue is so weird!
I have never faced it before!
Can you describe your stack?
SugarCRM version
Apache/IIS version
MySQL/MS SQL version
Had you installed any package into your SugarCRM installation?
Had you installed any patch?
Had you customized your SugarCRM installation?

Cheers

[mangesh1757]

Hi Experts,

If i modify the said file as describe by adding echo "<LI>$main_query";

I get this error,

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in D:\Data\Sudhir\xampp\htdocs\anm\5_2\include\ListVi ew\ListViewData.php on line 513

now to revert i need to replace that file then only thing get working

any how i am still not able to get echo query at list view.

Please Help!!

[mangesh1757]

Hi Experts,

I was able to move one step ahead (dream weaver had some encoding issues i used notepad for modifying the file .... so now i am able to echo the query)

the query says,

/***************Start of query**************************/

SELECT leads.id ,leads_cstm.budget_c,leads_cstm.currency_id,leads_ cstm.req_desc_text_c,leads_cstm.user_id_c,leads_cs tm.required_location_c,leads_cstm.bank_loan_requir ed_c,leads_cstm.loan_amount_required_c,leads_cstm. disha_project_type_c,leads_cstm.follow_up_c,leads_ cstm.enquiry_date_c,leads_cstm.lead_nature_c,leads _cstm.middle_name_c,leads_cstm.site_visit_c,leads_ cstm.site_visit_type_c,leads_cstm.site_visit_date_ c,leads_cstm.parent_type,leads_cstm.parent_id,lead s_cstm.employee_id_c,leads_cstm.contact_id_c,leads _cstm.lead_source_related_to_c,leads_cstm.user_id1 _c,leads_cstm.multi_select_projects_c,leads_cstm.n et_monthly_salary_c,leads_cstm.loan_tenure_c,leads _cstm.dail_code_mobile_c,leads_cstm.nationality_c, leads_cstm.pancard_no_c,leads_cstm.paid_amount_c,l eads_cstm.cheque_no_c,leads_cstm.branch_c,leads_cs tm.dated_c,leads_cstm.applicant_status_c,leads_cst m.bank_statement_c,leads_cstm.residence_proof_c,le ads_cstm.age_proof_c,leads_cstm.photo_id_proof_c,l eads_cstm.admin_cheque_c,leads_cstm.salary_slip_c, leads_cstm.form_16_c,leads_cstm.applicant_photo_c, leads_cstm.itr_c,leads_cstm.b_s_c,leads_cstm.quali fication_proof_c,leads_cstm.business_existence_c,l eads_cstm.business_profile_c,leads_cstm.drawn_on_t ext_c,leads_cstm.dail_code_home_c,leads_cstm.dail_ code_office_c,leads_cstm.dail_code_other_c,leads_c stm.dail_code_fax_c,leads_cstm.company_name_c,lead s_cstm.area_c,leads_cstm.other_area_c,leads_cstm.m y_p_address_c,leads_cstm.my_a_address_c,leads_cstm .my_p_area_c,leads_cstm.my_a_area_c,leads_cstm.my_ p_city_c,leads_cstm.my_a_city_c,leads_cstm.my_p_st ate_c,leads_cstm.my_a_state_c,leads_cstm.my_p_post al_code_c,leads_cstm.my_a_postal_code_c,leads_cstm .my_p_country_c,leads_cstm.my_a_country_c,leads_cs tm.disposition_status_c,leads_cstm.my_store_locati on_c, CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.phone_mobile , leads.title , leads.status , jt0.name acc_businessassociates_leads_name, jtl0.acc_busineddd4ociates_ida acc_busineddd4ociates_ida , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id ,leads.account_name FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN acc_businesciates_leads_c jtl0 ON leads.id=jtl0.acc_busineec52dsleads_idb AND jtl0.deleted=0 LEFT JOIN acc_businessassociates jt0 ON jt0.id=jtl0.acc_busineddd4ociates_ida AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= leads.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where leads.deleted=0 ORDER BY multi_select_projects_c ASC


/***************End of query**************************/



I have this Business Associate Module with Type "Person"... now according to the mysql it says,

#1054 - Unknown column 'jt0.name' in 'field list'

now further if i remove "jt0.name acc_businessassociates_leads_name," from query or say replace it with "jt0.last_name acc_businessassociates_leads_name," then mysql says,

#126 - Incorrect key file for table '/tmp/#sql_6042_0.MYI'; try to repair it


What can i do further.

I also repaired database through cpanel but no success.


Please Help!!