Leads not showing in listview

[jcb23]

Windows XP and Vista
Sugar 5.1.0
Apache 2.2.4
PHP: 5.2.3-1ubuntu6.3
MySQL Server: 5.0.45-1ubuntu3.3

I'm having some serious issues with the list view in the leads module. I've added several leads, but none of them show up in the list view when I click on the leads tab. I've checked in phpmyadmin and the leads that I've added are all there and all have 0 in the deleted field. I've cleared the search area as well so there is nothing in there that should keep the records from showing. So its seems as though it has to be an issue with one of the leads list view files, but I even replaced those files with the originals (from my install folder) and still am not seeing anything in the leads list views. I have no idea where to go from here...any help would be greatly appreciated.

[vantagejuan]

I'm having this exact same issue... could someone please give us some insight?

[andopes]

Hi guys

This may be a sql issue.

Edit the file include/ListView/ListViewData.php and add this line

 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']; 
  

Then try to access the ListView again.
You should see a query string at the screen. Copy this one and execute that into phpMyAdmin.

Let us know both query string and error message from phpMyAdmin.

Regards

[jcb23]

I just realized that when I installed the latest patch this problem was eliminated. I know I uninstalled the two enhanced modules (studio and search) and then reinstalled them in the process of installing the patch. For some reason during the installation I lost my contacts list as well and when I reinstalled those two modules the list reappeared so maybe this corrected the error in the Leads as well.

Either way the problem is gone now - thanks for your help anyway.

Vantagejuan do you have either the enhanced studio or enhanced search installed? If so it may be a problem with one of those modules.

jcb23

[vantagejuan]

I do have enhanced studio installed. I'm running 5.1.0b. What exactly did you do again? Were you running 5.1.0a when you had the problem and then when you installed 5.1.0b it was solved? Or did you just uninstall and re-install the enhanced modules? I've got fields with coding in them and don't want to have them erased by uninstalling. Will that happen?

[vantagejuan]

Ok, I uninstalled enhanced studio and reinstalled. No difference. The custom code fields that I had added were still there with code intact upon re-installation. I'll be trying the other suggestion next.

[vantagejuan]

• SELECT leads.id ,leads_cstm.ssn_c,leads_cstm.gender_c,leads_cstm.d ate_of_birth_c,leads_cstm.marital_status_c,leads_c stm.race_c,leads_cstm.religion_c,leads_cstm.nation al_origin_c,leads_cstm.name_2_c,leads_cstm.name_3_ c,leads_cstm.name_4_c,leads_cstm.name_5_c,leads_cs tm.name_6_c,leads_cstm.name_7_c,leads_cstm.name_8_ c,leads_cstm.name_9_c,leads_cstm.dob_2_c,leads_cst m.dob_3_c,leads_cstm.dob_4_c,leads_cstm.dob_5_c,le ads_cstm.dob_6_c,leads_cstm.dob_7_c,leads_cstm.dob _8_c,leads_cstm.dob_9_c,leads_cstm.spouse_c,leads_ cstm.dob_spouse_c,leads_cstm.ssn_spouse_c,leads_cs tm.on_note_c,leads_cstm.on_note_2_c,leads_cstm.on_ note_3_c,leads_cstm.on_note_4_c,leads_cstm.on_note _5_c,leads_cstm.on_deed_c,leads_cstm.on_deed_2_c,l eads_cstm.on_deed_3_c,leads_cstm.on_deed_4_c,leads _cstm.on_deed_5_c,leads_cstm.purchase_date_c,leads _cstm.property_type_c,leads_cstm.current_home_valu e_c,leads_cstm.owner_occupied_c,leads_cstm.number_ properties_owned_c,leads_cstm.closing_date_c,leads _cstm.closing_date_2_c,leads_cstm.closing_date_3_c ,leads_cstm.mortgage_balance_1_c,leads_cstm.mortga ge_balance_2_c,leads_cstm.mortgage_balance_3_c,lea ds_cstm.mortgage_type_c,leads_cstm.mortgage_type_2 _c,leads_cstm.mortgage_type_3_c,leads_cstm.lender_ 1_c,leads_cstm.lender_2_c,leads_cstm.lender_3_c,le ads_cstm.interest_rate_1_c,leads_cstm.interest_rat e_2_c,leads_cstm.interest_rate_3_c,leads_cstm.mont hly_pay_1_c,leads_cstm.monthly_pay_2_c,leads_cstm. tax_insurace_indcluded_c,leads_cstm.hoa_amt_c,lead s_cstm.pi_payment_c,leads_cstm.clothing_c,leads_cs tm.hoa_period_c,leads_cstm.insurance_period_c,lead s_cstm.tax_period_c,leads_cstm.pay_status_1_c,lead s_cstm.pay_status_2_c,leads_cstm.pay_status_3_c,le ads_cstm.account_number_1_c,leads_cstm.account_num ber_2_c,leads_cstm.account_number_3_c,leads_cstm.a uction_date_c,leads_cstm.min_1_c,leads_cstm.min_2_ c,leads_cstm.min_3_c,leads_cstm.affordable_payment _c,leads_cstm.annual_household_income_c,leads_cstm .hh_income_last_year_c,leads_cstm.purchase_price_c ,leads_cstm.number_of_rooms_c,leads_cstm.rent_rece ived_c,leads_cstm.property_condition_c,leads_cstm. major_repairs_c,leads_cstm.other_liens_c,leads_cst m.servicer_1_c,leads_cstm.servicer_2_c,leads_cstm. servicer_3_c,leads_cstm.months_behind_1_c,leads_cs tm.months_behind_2_c,leads_cstm.months_behind_3_c, leads_cstm.total_transport_c,leads_cstm.total_medi cal_c,leads_cstm.mortgage_status_c,leads_cstm.insu rance_amt_c,leads_cstm.principal_bal_3_c,leads_cst m.arrears_amt_3_c,leads_cstm.principal_bal_1_c,lea ds_cstm.tax_amt_c,leads_cstm.payoff_amt_3_c,leads_ cstm.gas_c,leads_cstm.tithes_c,leads_cstm.monthly_ pay_3_c,leads_cstm.ti_payment_c,leads_cstm.predato ry_practices_c,leads_cstm.payment_awareness_c,lead s_cstm.closing_fees_c,leads_cstm.previous_refi_c,l eads_cstm.lender_contact_c,leads_cstm.unethical_pe rsons_c,leads_cstm.budget_changes_c,leads_cstm.inc ome_changes_c,leads_cstm.self_help_c,leads_cstm.ho me_repairs_c,leads_cstm.plan_b_c,leads_cstm.contri butor_1_c,leads_cstm.contributor_2_c,leads_cstm.co ntributor_3_c,leads_cstm.late_explanation_c,leads_ cstm.income_type_1_c,leads_cstm.income_type_2_c,le ads_cstm.income_type_3_c,leads_cstm.pay_period_1_c ,leads_cstm.pay_period_2_c,leads_cstm.pay_period_3 _c,leads_cstm.employer_zip_code_1_c,leads_cstm.emp loyer_zip_code_2_c,leads_cstm.employer_zip_code_3_ c,leads_cstm.net_income_2_c,leads_cstm.net_income_ 1_c,leads_cstm.gross_income_3_c,leads_cstm.gross_i ncome_2_c,leads_cstm.gross_income_1_c,leads_cstm.e mployer_1_c,leads_cstm.employer_2_c,leads_cstm.emp loyer_3_c,leads_cstm.work_phone_1_c,leads_cstm.wor k_phone_2_c,leads_cstm.work_phone_3_c,leads_cstm.e mployer_address_1_state_c,leads_cstm.employer_addr ess_1_city_c,leads_cstm.department_1_c,leads_cstm. department_2_c,leads_cstm.department_3_c,leads_cst m.start_date_1_c,leads_cstm.start_date_2_c,leads_c stm.start_date_3_c,leads_cstm.end_date_1_c,leads_c stm.end_date_2_c,leads_cstm.end_date_3_c,leads_cst m.position_1_c,leads_cstm.position_2_c,leads_cstm. position_3_c,leads_cstm.business_type_1_c,leads_cs tm.business_type_2_c,leads_cstm.business_type_3_c, leads_cstm.additional_income_1_c,leads_cstm.additi onal_income_2_c,leads_cstm.additional_income_3_c,l eads_cstm.add_income_type_1_c,leads_cstm.add_incom e_type_2_c,leads_cstm.add_income_type_3_c,leads_cs tm.self_emp_type_1_c,leads_cstm.self_emp_type_2_c, leads_cstm.self_emp_type_3_c,leads_cstm.debt_1_c,l eads_cstm.debt_2_c,leads_cstm.debt_3_c,leads_cstm. debt_4_c,leads_cstm.debt_5_c,leads_cstm.debt_6_c,l eads_cstm.debt_7_c,leads_cstm.debt_8_c,leads_cstm. debt_9_c,leads_cstm.debt_10_c,leads_cstm.debt_type _1_c,leads_cstm.debt_type_2_c,leads_cstm.debt_type _3_c,leads_cstm.debt_type_4_c,leads_cstm.debt_type _5_c,leads_cstm.debt_type_6_c,leads_cstm.debt_type _7_c,leads_cstm.debt_type_8_c,leads_cstm.debt_type _9_c,leads_cstm.debt_type_10_c,leads_cstm.debt_pay ment_1_c,leads_cstm.debt_payment_2_c,leads_cstm.de bt_payment_3_c,leads_cstm.debt_payment_4_c,leads_c stm.debt_payment_5_c,leads_cstm.debt_payment_6_c,l eads_cstm.debt_payment_7_c,leads_cstm.debt_payment _9_c,leads_cstm.debt_payment_8_c,leads_cstm.debt_p ayment_10_c,leads_cstm.debt_balance_1_c,leads_cstm .debt_balance_2_c,leads_cstm.debt_balance_3_c,lead s_cstm.debt_balance_4_c,leads_cstm.debt_balance_5_ c,leads_cstm.debt_balance_6_c,leads_cstm.debt_bala nce_7_c,leads_cstm.debt_balance_8_c,leads_cstm.deb t_balance_9_c,leads_cstm.debt_balance_10_c,leads_c stm.home_phone_bill_c,leads_cstm.mobile_phone_bill _c,leads_cstm.electric_c,leads_cstm.water_sewer_c, leads_cstm.cable_tv_c,leads_cstm.other_utility_c,l eads_cstm.car_insurance_c,leads_cstm.public_transi t_c,leads_cstm.car_maintenence_c,leads_cstm.other_ transport_c,leads_cstm.tuition_c,leads_cstm.books_ c,leads_cstm.school_supplies_c,leads_cstm.other_ed ucation_c,leads_cstm.bus_fares_tolls_c,leads_cstm. medical_insurance_c,leads_cstm.doctor_c,leads_cstm .dentist_c,leads_cstm.co_pays_c,leads_cstm.medicat ion_c,leads_cstm.disability_insurance_c,leads_cstm .life_insurance_c,leads_cstm.other_medical_c,leads _cstm.total_utilities_c,leads_cstm.snacks_c,leads_ cstm.meals_c,leads_cstm.beverage_c,leads_cstm.ciga rettes_c,leads_cstm.newspapers_c,leads_cstm.lotter y_tickets_c,leads_cstm.alcohol_c,leads_cstm.books_ mags_c,leads_cstm.movies_c,leads_cstm.sports_c,lea ds_cstm.entertainment_c,leads_cstm.school_lunches_ c,leads_cstm.parking_c,leads_cstm.mtg_balance_1_c, leads_cstm.child_allowance_c,leads_cstm.dry_cleani ng_c,leads_cstm.laundromat_c,leads_cstm.animal_car e_c,leads_cstm.hair_care_c,leads_cstm.other_incide ntals_c,leads_cstm.grocery_store_c,leads_cstm.eati ng_out_c,leads_cstm.food_other_c,leads_cstm.tutori ng_c,leads_cstm.day_care_c,leads_cstm.after_school _programs_c,leads_cstm.child_support_c,leads_cstm. other_child_care_c,leads_cstm.garnishment_total_c, leads_cstm.loan_term_c,leads_cstm.name_on_card_c,l eads_cstm.card_number_c,leads_cstm.cvv_code_c,lead s_cstm.expiration_date_c,leads_cstm.name_on_check_ c,leads_cstm.routing_number_c,leads_cstm.bank_acco unt_number_c,leads_cstm.bank_name_c,leads_cstm.wag e_garnishment_1_c,leads_cstm.wage_garnishment_2_c, leads_cstm.wage_garnishment_3_c,leads_cstm.ganishm ent_amount_1_c,leads_cstm.garnishment_amount_2_c,l eads_cstm.garnishment_amount_3_c,leads_cstm.arrear s_amt_2_c,leads_cstm.arrears_amt_1_c,leads_cstm.pa yoff_amt_1_c,leads_cstm.fuel_c,leads_cstm.other_ex pense_3_c,leads_cstm.other_expense_c,leads_cstm.ot her_expense_2_c,leads_cstm.mtg_balance_2_c,leads_c stm.other_amount_1_c,leads_cstm.principal_bal_2_c, leads_cstm.other_amount_2_c,leads_cstm.other_amoun t_3_c,leads_cstm.loan_term_2_c,leads_cstm.loan_ter m_3_c,leads_cstm.net_after_garnishments_c,leads_cs tm.net_inc_total_c,leads_cstm.gross_inc_total_c,le ads_cstm.payoff_amt_2_c,leads_cstm.client_status_c ,leads_cstm.drivers_license_c,leads_cstm.service_a greement_c,leads_cstm.hud_settlement_c,leads_cstm. mortgage_statement_c,leads_cstm.pay_stubs_c,leads_ cstm.tax_bill_c,leads_cstm.insurance_bill_c,leads_ cstm.loan_note_c,leads_cstm.bank_statements_c,lead s_cstm.hardship_letter_c,leads_cstm.fee_payment_c, leads_cstm.information_release_c,leads_cstm.signup _fee_c,leads_cstm.mtg_balance_3_c,leads_cstm.net_i ncome_3_c,leads_cstm.debt_11_c,leads_cstm.debt_12_ c,leads_cstm.debt_13_c,leads_cstm.debt_14_c,leads_ cstm.debt_15_c,leads_cstm.debt_type_11_c,leads_cst m.debt_type_12_c,leads_cstm.debt_type_13_c,leads_c stm.debt_type_14_c,leads_cstm.debt_type_15_c,leads _cstm.debt_payment_11_c,leads_cstm.debt_payment_12 _c,leads_cstm.debt_payment_13_c,leads_cstm.debt_pa yment_14_c,leads_cstm.debt_payment_15_c,leads_cstm .debt_bal_13_c,leads_cstm.debt_balance_12_c,leads_ cstm.debt_bal_11_c,leads_cstm.debt_balance_14_c,le ads_cstm.debt_balance_15_c,leads_cstm.employer_add ress_1_postalcode_c,leads_cstm.employer_address_1_ country_c,leads_cstm.employer_address_1_c,leads_cs tm.employer_address_2_city_c,leads_cstm.employer_a ddress_2_state_c,leads_cstm.employer_address_2_pos talcode_c,leads_cstm.employer_address_2_country_c, leads_cstm.employer_address_2_c,leads_cstm.employe r_address_3_city_c,leads_cstm.employer_address_3_s tate_c,leads_cstm.employer_address_3_postalcode_c, leads_cstm.employer_address_3_country_c,leads_cstm .employer_address_3_c,leads_cstm.total_education_c ,leads_cstm.total_child_care_c,leads_cstm.total_fo od_c,leads_cstm.total_incidentals_c,leads_cstm.tot al_other_c,leads_cstm.total_liabilities_c,leads_cs tm.total_expenses_c,leads_cstm.total_expenses_liab ilities_c, CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name,leads.first_name, leads.last_name,leads.salutation,leads.status,acco unts.name acc_name_from_accounts,accounts.assigned_user_id acc_name_from_accounts_owner, 'Accounts' acc_name_from_accounts_mod, 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 accounts accounts ON accounts.id= leads.account_id AND accounts.deleted=0 AND accounts.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 name ASC

[vantagejuan]

that's the string that came up after inserting the php you said to input. i had to delete a few spaces between commas to get it to fit the character limit for posts, but didn't delete any actual content. i thought i knew my login and pass credentials to phpmyadmin, but can't login for some reason. is there anyway to find these credentials?

[andopes]

If you copy this query and run into phpMyAdmin does it return any error message?

[vantagejuan]

i can't access phpmyadmin right now because my login and password credentials fail. what do you mean by "run into phpmyadmin"?