tabEmployee Profile

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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/d4265329-0414-4a8a-a9c9-2a37fd657f1c%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Fixed.


Please pull the latest update.

On Tue, Jun 25, 2013 at 4:29 PM, Rohit Waghchaure <ro…@indictranstech.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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/d4265329-0414-4a8a-a9c9-2a37fd657f1c%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.









Regards,
Akhilesh Darjee

www.erpnext.com



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAKuMqm0Lo47thSODZOrn1Z8ycm4cX594f3xo-2Rwo8x3sjcUnw%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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:
Fixed.

Please pull the latest update.


On Tue, Jun 25, 2013 at 4:29 PM, Rohit Waghchaure <ro...@indictranstech.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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/d4265329-0414-4a8a-a9c9-2a37fd657f1c%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.









Regards,
Akhilesh Darjee



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAKuMqm0Lo47thSODZOrn1Z8ycm4cX594f3xo-2Rwo8x3sjcUnw%40mail.gmail.com.


For more options, visit https://groups.google.com/groups/opt_out.





You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAFsi8V1Hf0nHy3VJo-fR2N%3D3DNxE9UPUWmW-spdywVKSUV0J1A%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Fixed it in master branch.

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:
Fixed.

Please pull the latest update.


On Tue, Jun 25, 2013 at 4:29 PM, Rohit Waghchaure <ro...@indictranstech.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.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/d4265329-0414-4a8a-a9c9-2a37fd657f1c%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 





Regards,
Akhilesh Darjee




You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAKuMqm0Lo47thSODZOrn1Z8ycm4cX594f3xo-2Rwo8x3sjcUnw%40mail.gmail.com.


For more options, visit https://groups.google.com/groups/opt_out.
 
 




You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAFsi8V1Hf0nHy3VJo-fR2N%3D3DNxE9UPUWmW-spdywVKSUV0J1A%40mail.gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 




You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/9D5B8FFA-EB7F-4595-A52D-CDC1FE19F620%40gmail.com.

For more options, visit https://groups.google.com/groups/opt_out.