Hello, I have select ‘All Employee (Active)’ in sms center to retrieve employee details but it give me an following error
line 51, in
create_receiver_list
rec = sql(“select t1.employee_name, t2.cell_number from tabEmployee t1, tabEmployee Profile t2 where t2.employee = t1.name
and t1.status = ‘Active’ and t1.docstatus != 2 and
ifnull(t2.cell_number,‘’)!=‘’ %s” % where_clause)
File “…/lib/webnotes/db.py”, line 130, in sql
raise e
ProgrammingError: (1146, “Table ‘church.tabEmployee Profile’ doesn’t
exist”)
So please tell me how can i retrieve employee details.
Thanks and regards Rohit
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Hello, I have select 'All Employee (Active)' in sms center to retrieve employee details but it give me an following error
line 51, in
create_receiver_list
rec = sql("select t1.employee_name, t2.cell_number from
`tabEmployee` t1, `tabEmployee Profile` t2 where t2.employee = t1.name
and t1.status = 'Active' and t1.docstatus != 2 and
ifnull(t2.cell_number,'')!='' %s" % where_clause)
File "../lib/webnotes/db.py", line 130, in sql
raise e
ProgrammingError: (1146, "Table 'church.tabEmployee Profile' doesn't
exist")
So please tell me how can i retrieve employee details.
Thanks and regards Rohit
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Hello, I have select 'All Employee (Active)' in sms center to retrieve employee details but it give me an following error
line 51, in
create_receiver_list
rec = sql("select t1.employee_name, t2.cell_number from tabEmployee t1, tabEmployee Profile t2 where t2.employee = t1.name
and t1.status = 'Active' and t1.docstatus != 2 and
ifnull(t2.cell_number,'')!='' %s" % where_clause)
File "…/lib/webnotes/db.py", line 130, in sql
raise e
ProgrammingError: (1146, "Table 'church.tabEmployee Profile' doesn't
exist")
So please tell me how can i retrieve employee details.
Thanks and regards Rohit
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
P.S. As you are actively doing customization on erpnext, we expect, this type of bugs should be fixed by yourself and be contributed back to community.
On 26-Jun-2013, at 5:58 PM, Rohit Waghchaure wrote:
Hello Akhilesh,
'All Sales Partner Contact' also not working please check it also
Thanks and Regards
Rohit
On Tue, Jun 25, 2013 at 6:04 PM, Akhilesh Darjee <ak...@erpnext.com> wrote:
Hello, I have select 'All Employee (Active)' in sms center to retrieve employee details but it give me an following error
line 51, in
create_receiver_list
rec = sql(“select t1.employee_name, t2.cell_number from tabEmployee t1, tabEmployee Profile t2 where t2.employee = t1.name
and t1.status = ‘Active’ and t1.docstatus != 2 and
ifnull(t2.cell_number,‘’)!=‘’ %s” % where_clause)
File “…/lib/webnotes/db.py”, line 130, in sql
raise e
ProgrammingError: (1146, “Table ‘church.tabEmployee Profile’ doesn’t
exist”)
So please tell me how can i retrieve employee details.
Thanks and regards Rohit
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.