all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
daily:ok
hourly:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
hourly:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
all:ok
# mysql -root -p erpnext
Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
ro…@erp:/home/c0mputerking# mysql -root -p erpnext
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1011
Server version: 5.1.63-0+squeeze1 (Debian)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> select timestamp, method, error from __SchedulerLog order by timestamp desc limit 5\G;
*************************** 1. row ***************************
timestamp: 2012-09-05 12:09:01
method: flush
error: Traceback (innermost last):
File “/var/www/erpnext/erpnext/startup/schedule_handlers.py”, line 59, in run_fn
fn()
File “lib/py/webnotes/utils/email_lib/bulk.py”, line 112, in flush
as_dict=1):
File “lib/py/webnotes/db.py”, line 153, in sql
raise e
ProgrammingError: (1146, “Table ‘erpnext.tabBulk Email’ doesn’t exist”)
*************************** 2. row ***************************
timestamp: 2012-07-17 23:57:03
method: manage_recurring_invoices
error: Traceback (innermost last):
File “/var/www/erpnext/erpnext/startup/schedule_handlers.py”, line 35, in execute_all
manage_recurring_invoices()
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 499, in manage_recurring_invoices
send_notification(new_rv)
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 598, in send_notification
sendmail(new_rv.doc.notification_email_address.split(", "), subject=subject, msg = msg)
File “lib/py/webnotes/utils/email_lib/init.py”, line 92, in sendmail
email.send(send_now)
File “lib/py/webnotes/utils/email_lib/send.py”, line 217, in send
self.validate()
File “lib/py/webnotes/utils/email_lib/send.py”, line 160, in validate
webnotes.msgprint(“%s is not a valid email id” % e, raise_exception = 1)
File “lib/py/webnotes/init.py”, line 101, in msgprint
raise ValidationError, msg
ValidationError: Administrator is not a valid email id
*************************** 3. row ***************************
timestamp: 2012-07-17 23:54:03
method: manage_recurring_invoices
error: Traceback (innermost last):
File “/var/www/erpnext/erpnext/startup/schedule_handlers.py”, line 35, in execute_all
manage_recurring_invoices()
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 499, in manage_recurring_invoices
send_notification(new_rv)
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 598, in send_notification
sendmail(new_rv.doc.notification_email_address.split(", "), subject=subject, msg = msg)
File “lib/py/webnotes/utils/email_lib/init.py”, line 92, in sendmail
email.send(send_now)
File “lib/py/webnotes/utils/email_lib/send.py”, line 217, in send
self.validate()
File “lib/py/webnotes/utils/email_lib/send.py”, line 160, in validate
webnotes.msgprint(“%s is not a valid email id” % e, raise_exception = 1)
File “lib/py/webnotes/init.py”, line 101, in msgprint
raise ValidationError, msg
ValidationError: Administrator is not a valid email id
*************************** 4. row ***************************
timestamp: 2012-07-17 23:51:02
method: manage_recurring_invoices
error: Traceback (innermost last):
File “/var/www/erpnext/erpnext/startup/schedule_handlers.py”, line 35, in execute_all
manage_recurring_invoices()
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 499, in manage_recurring_invoices
send_notification(new_rv)
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 598, in send_notification
sendmail(new_rv.doc.notification_email_address.split(", "), subject=subject, msg = msg)
File “lib/py/webnotes/utils/email_lib/init.py”, line 92, in sendmail
email.send(send_now)
File “lib/py/webnotes/utils/email_lib/send.py”, line 217, in send
self.validate()
File “lib/py/webnotes/utils/email_lib/send.py”, line 160, in validate
webnotes.msgprint(“%s is not a valid email id” % e, raise_exception = 1)
File “lib/py/webnotes/init.py”, line 101, in msgprint
raise ValidationError, msg
ValidationError: Administrator is not a valid email id
*************************** 5. row ***************************
timestamp: 2012-07-17 23:48:03
method: manage_recurring_invoices
error: Traceback (innermost last):
File “/var/www/erpnext/erpnext/startup/schedule_handlers.py”, line 35, in execute_all
manage_recurring_invoices()
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 499, in manage_recurring_invoices
send_notification(new_rv)
File “/var/www/erpnext/erpnext/accounts/doctype/gl_control/gl_control.py”, line 598, in send_notification
sendmail(new_rv.doc.notification_email_address.split(", "), subject=subject, msg = msg)
File “lib/py/webnotes/utils/email_lib/init.py”, line 92, in sendmail
email.send(send_now)
File “lib/py/webnotes/utils/email_lib/send.py”, line 217, in send
self.validate()
File “lib/py/webnotes/utils/email_lib/send.py”, line 160, in validate
webnotes.msgprint(“%s is not a valid email id” % e, raise_exception = 1)
File “lib/py/webnotes/init.py”, line 101, in msgprint
raise ValidationError, msg
ValidationError: Administrator is not a valid email id
5 rows in set (0.01 sec)
Hmmm not a valid email pretty sure i filled my email in everywhere i could find is this the problem?
On Tue, Oct 2, 2012 at 9:28 PM, Anand Doshi
<an…@iwebnotes.com> wrote:
Hi Ryan,
Please paste the last 50 lines of /var/log/erpnext-sch.log as a reply.
Also, if possible, run this query in your database:
use <database name>
select timestamp, method, error from __SchedulerLog order by timestamp desc limit 5\G;
We will work on an error reporting system to help you raise your issues with sufficient background.
Thanks,
Anand.
I have this
# crontab -l
*/3 * * * * cd /var/www/erpnext && python lib/wnf.py --run_scheduler >> /var/log/erpnext-sch.log 2>&1
On Wed, Sep 5, 2012 at 10:29 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Ryan,
Have you started the scheduler?
Please check Anand's post on this in the developer forum.
https://groups.google.com/forum/?fromgroups=#!topic/erpnext-developer-forum/D0LMV25QAvo
If yes, please check your log and report any error you see on the developer forums!
best,
Rushabh
On Thu, Sep 6, 2012 at 12:12 AM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
I have been gone from here for awhile, and while away i was expecting some autogenerated email invoices however they still do not seem to be working for me. Really need to get this sorted it is probably the most important feature of erpnext for me.
I did an update of erpnext today so should have the lastest files and what not
On Mon, Jul 23, 2012 at 11:32 PM, Nabin Hait
<na…@iwebnotes.com> wrote:
Hi Ryan,
Pull the latest update from erpnext master branch for getting email id from profile for administrator.
Also there is an update to validate notification email address.
Regards,
Nabin Hait
On Tue, Jul 24, 2012 at 10:19 AM, Nabin Hait
<na…@iwebnotes.com> wrote:
Hi Ryan,
“Update” button visibility issue has not yet been solved, will update you once it solved.
“Next Date” is the date on which recurring invoice will be created and calculated based on “Recurring Type” and “Repeat on the Day of Month”.
Regards,
Nabin Hait
On Tue, Jul 24, 2012 at 4:55 AM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
Ok I have added an email to the Admin account now but have not had a chance to add another test recurring invoice
However the update button is still not always appearing when the recurring information is added
Also i have entered a from date and a to date for a yearly invoice, but the next date is the posting date not the to date and not even the due date.
On Sun, Jul 22, 2012 at 11:42 PM, Anand Doshi
<an...@iwebnotes.com> wrote:
Hi Ryan,
In your case, the error arose because the user Administrator does not have a valid email address.
To solve your error, go to Document > Search > Profile > Administrator
Here, in the field Email, change its value to a valid email address.
Please note that Administrator account should only be used for development/maintenance related activities. We recommend that you create another user, assign all roles to it and use that user to create entries.
Thanks,
Anand.
On Monday 23 July 2012 at 10:18 AM, Nabin Hait wrote:
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px">
<span>Hi Ryan,<br><br>Pull the latest update from master branch. Now it will notify system managers if there is any error while creating recurring invoice. There might be some error while creating recurring invoice.<br>
If there is any error, you can check those error in __SchedulerLog table.
Regards,
Nabin Hait
On Sun, Jul 22, 2012 at 11:17 AM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
Ok all that is good and well but my reoccuring invoices are not being sent! they should also appear under sales invoices right?
On Fri, Jul 20, 2012 at 9:18 PM, Anand Doshi
<an...@iwebnotes.com> wrote:
Hi Ryan,
We will look into the update button issue.
Regarding end date, it acts as a deadline, when the recurring invoices creation stop for good, for that invoice. Suppose you have a customer under contract till 20 June 2014. By specifying this as the end date, you make sure that further recurring invoices are not created.
End Date is optional. If you don't specify end date, it won't cause a problem.
Thanks,
Anand.
On Saturday 21 July 2012 at 4:37 AM, Ryan vAN GINNEKEN wrote:
Also what is the point of the end date i have the to and from dates filled in but do not really understand why i need an end date? so i left it blank could this be my problem?
PS there is some wierd behaviour with the update button not a appearing after i add the reoccuring invoice infos
On Fri, Jul 20, 2012 at 5:03 PM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
I still cannot get recurring invoices working i have created a monthly invoice and made posting date and due date for 2 months ago. I get no email notification of my invoice even after i manually run the cron command
cd /var/www/erpnext && python lib/wnf.py --run_scheduler >> /var/log/erpnext-sch.log 2>&1
also i have added this using crontab -e as suggested in the install instructions.
*/3 * * * * cd /var/www/erpnext && python lib/wnf.py --run_scheduler >> /var/log/erpnext-sch.log 2>&1
On Tue, Jul 17, 2012 at 2:00 PM, Ryan vAN GINNEKEN
<ry...@gmail.com> wrote:
Oh i found the cron setup in the new install instruction while upgrading to the new apache config
On Tue, Jul 17, 2012 at 1:36 PM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
No I do not believe I have setup a cron job, also i do not remember seeing any instructions regarding this in the new Manual :) or anywhere else for that matter. I know this is a relatively new feature and you folks pretty much tweaked it to my liking which i really appreciate, and understand if the DOCs are not up to date. Plus i may have just missed reading the bit about cron somewhere could you point me to the DOC or give me instructions how to setup a cron job here?
On Tue, Jul 17, 2012 at 12:09 AM, Anand Doshi
<an...@iwebnotes.com> wrote:
Hi Ryan,
Did you setup a cron job of scheduler for your system?
thanks,
Anand.
On Tue, Jul 17, 2012 at 11:37 AM, Nabin Hait
<na…@iwebnotes.com> wrote:
Hi Ryan,
For testing you can create a back dated monthly recurring invoice (posting date 1 month ago). I will test at my end also.
Regards,
Nabin Hait
On Tue, Jul 17, 2012 at 4:25 AM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
Hello again I have created some monthly invoices, but they do not seem to be working, i get no notification about them and cannot find any RECINV in the system. There doesn't seem to be an easy way i can test them maybe making a daily option for testing so i do not have to wait a month to see if things are working.
Any log or some debugging tool i can uses to see if these invoices are working correctly.
On Sun, Jun 17, 2012 at 11:22 AM, Nabin Hait
<na…@iwebnotes.com> wrote:
Hi,
Yearly recurring invoice feature has been added in erpnext. Please pull the updates from repository using
lib/wnf.py --update origin master
Regards,
Nabin Hait
On Wed, Jun 13, 2012 at 12:51 AM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
Hello and not to be pushy but how are yearly invoices coming, also how do we know when stuff is added to erpnext when we should update that sort of thing.
On Fri, Jun 8, 2012 at 12:20 AM, Nabin Hait
<na...@iwebnotes.com> wrote:
If I manage my time, it can be today only :)
In the worst case you can expect it by the next weekend (15/06/12)
On Fri, Jun 8, 2012 at 11:43 AM, Ryan vAN GINNEKEN
<ry...@gmail.com> wrote:
Any ETA on this?
On Jun 8, 2012 12:10 AM, "Nabin Hait" <
na...@iwebnotes.com> wrote:
Currently the system only handles monthly recurring. We will add “Yearly” option as soon as possible.
On Fri, Jun 8, 2012 at 11:19 AM, Ryan vAN GINNEKEN
<ry…@gmail.com> wrote:
alot of my business is based on reoccurring invoices some monthly which ERPNext seems able to do however i do alot of yearly invoice too can/will erpnext be able to handle these?
</blockquote><div>
<br>
</div>
</div></blockquote></div><br>
</blockquote>
<div>
<br>
</div>
</div></blockquote></div><br>
or anywhere else for that matter. I know this is a relatively new feature and you folks pretty much tweaked it to my liking which i really appreciate, and understand if the DOCs are not up to date. Plus i may have just missed reading the bit about cron somewhere could you point me to the DOC or give me instructions how to setup a cron job here?