Unable view the data in listview of accounts module

[santhoshemmadi]

Hi,

I am unable to view the data which gets populated in the list view of accounts module. I have tried the quick repair and rebuild option using admin->repair but i was unable to view the data in list view. I am able to view the data in list view of other modules.. Is there any file missing or anything is to be done so that the data gets populated in List View of Accounts module and also let me know the file which displays the list view data of Accounts module. Any solution to this problem

I am attaching the screen shot of what i get when i click the companies(accounts module).

WIndows 2003 server
Sugar CRM-5.2.0k
MYsql : 5.0.51
PHP :5.2
IIS 6.0

With Regards,
Santhosh

[salesagility]

Rather obvious question BUT ... did you clear all the searches by clicking Clear?

And ... what changes have you made to the application?

[santhoshemmadi]

Hi,

I have already cleared the search by clicking the clear button and I have just created a field Company Account Manager and Country and added those fields to the list view of accounts using Studio and saved and deployed it.
That's all i have done.

With Regards,
Santhosh

[salesagility]

Have a look in sugar.log and see if there are any errors being logged

[santhoshemmadi]

Hi,

I have found this error in the log file

11/18/09 09:34:52 [1312][d047320a-fd4f-06a3-6fd3-4ad2f501dcf5][FATAL] 000

Where red color represents my user id. Can you help me regarding this.

With Regards,
Santhosh

[heta]

hello santosh,

print list view query. go to include/ListView/ListViewData.php, search for $main_query, print $main_query just before it has been executed. run the same query in database directly, you might get some idea from there.

Hope that helps.

[santhoshemmadi]

Hi,

The problem intially started when i deleted the subpanels folder in the include directory, so that subpanels doesnt appear in my detail view layout. I then immediately pasted the subpanel folder into include directory but the list view didnt work then,I have deleted my entire sugar crm and then restored it and then i clicked the accounts module then I was able to see list view along with the data but when i go to studio and then add a field to search layout or the list view layout of the accounts module then the list view is shown without data getting populated. What would be the cause of the behaviour.

With Regards,
Santhosh

[nagarajkonaguthi@gmail.com]

hello santosh,

print list view query. go to include/ListView/ListViewData.php, search for $main_query, print $main_query just before it has been executed. run the same query in database directly, you might get some idea from there.

Hope that helps.

Hi Heta,

I am some issue in displaying the external data in one of the custom module.

Problem definition:

I need to connect to the external database through sugarcrm and need to fetch the data and show it in the sugar custom module.

I have used the logic_hook to make the connection to the external database and i am able to connect to the database. My problem is, i am not able to display all the data from the external table in my custom moudule.

My code [Logic_hook]:

I used "process_record" event
=============logic hook.php==========================
$hook_array['process_record'][] = Array(1, 'MyModule', 'custom/modules/mymodule/mymodule.php',Users_class', 'Users_method');

===============mymodule.php======================
if ($event != 'process_record') return;

$con = @mysql_connect('hostname'','root','');
@mysql_select_db('mydb',$con);

$qu .= "select * from tbl_name ";

$ct = mysql_query($qu, $con);

while($row = mysql_fetch_array($ct)) {
$bean->first_name = $row[1];
$bean->last_name = $row[2];
$bean->street_address = $row[3];
$bean->city = $row[5];
$bean->phone_number = $row[4];
$bean->zip = $row[6];
$bean->email_address = $row[7];
}
first_name. last_name are my custom fields.

Please help me out in displaying the records from the external table,. am i on the right track?

Thanks in advance,

--Nagaraj
================ends here===================

[mangesh1757]

Hi Heta,

If i modify the said file as describe by adding echo $main_query; or even say print($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 recording to the mysql error 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!!