Restoring Backup

pdvyas · December 11, 2013, 6:32am

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--

Pratik
erpnext

system · December 12, 2013, 5:24am

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.

where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

adityaduggal · June 16, 2014, 5:45am

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

rmehta · June 16, 2014, 7:05am

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:
hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/07B4644F-6505-4EB7-B815-2A1228334443%40gmail.com.

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

adityaduggal · June 16, 2014, 11:31am

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:
hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

rmehta · June 17, 2014, 7:15am

Aditya,

You have to start the Python virtual env:

cd frappe-bench

. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE
frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:
Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:
hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/E9BA9BAE-8114-4041-9533-968442CA6EC0%40gmail.com.

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

adityaduggal · July 2, 2014, 11:19am

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>
load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn
return fn(*args, **new_kwargs)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install
admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db
create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user
raise Exception("Database %s already exists" % (db_name,))
Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE
frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:
Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:
hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

anand · July 2, 2014, 1:01pm

If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAAQzbF3DwphEe7aDhkhCMbBqFcMQp0ErLmSOtBs6Pdc%2BUQ7FwA%40mail.gmail.com.

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

adityaduggal · July 2, 2014, 1:17pm

Hi Anand,

Thanks for the tip. But now I guess I am stuck with another error as below:

(env)ad...@addy:~/frappe-bench/sites$ frappe --restore DB_NAME /home/Downloads/XXX_database.sql --force

MySQL root password:

Created user DB_NAME

Created database DB_NAME

Granted privileges to user DB_NAME and database DB_NAME

Starting database import...

sh: 1: cannot open /home/Downloads/XXX_database.sql: No such file

Imported from database /home/Downloads/XXX_database.sql

Traceback (most recent call last):

File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 308, in _install

install_app("frappe", verbose=verbose, set_as_patched=not source_sql)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 87, in install_app

frappe.clear_cache()

File "/home/addy/frappe-bench/apps/frappe/frappe/__init__.py", line 284, in clear_cache

frappe.sessions.clear_cache()

File "/home/addy/frappe-bench/apps/frappe/frappe/sessions.py", line 55, in clear_cache

for sess in frappe.db.sql("""select user, sid from tabSessions""", as_dict=1):

File "/home/addy/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql

self._cursor.execute(query)

File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute

self.errorhandler(self, exc, value)

File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler

raise errorclass, errorvalue

_mysql_exceptions.ProgrammingError: (1146, "Table 'rigpl.tabSessions' doesn't exist")

On Wednesday, July 2, 2014 6:31:44 PM UTC+5:30, Anand Doshi wrote:

If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5b5d70e4-4ec8-4180-a4ca-653d0033c703%40googlegroups.com.

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

adityaduggal · July 2, 2014, 1:32pm

Hi Anand,

Please disregard the previous post, it turns out that I was not using the correct path (new to Linux and its paths)

But after the import of database I guess I am stuck with the Apps and I am getting an error for the rigpl_erpnext apps hook.

The error console is here: http://pastebin.com/JFr24LVv

Let me know how could I resolve this error.

I guess this error would also answer one of my queries that how could I setup a system on Develop branch to do the testing and then push the commits to the production branch.

On Wednesday, July 2, 2014 6:48:00 PM UTC+5:30, Aditya Duggal wrote:

Hi Anand,

Thanks for the tip. But now I guess I am stuck with another error as below:

(env)ad...@addy:~/frappe-bench/sites$ frappe --restore DB_NAME /home/Downloads/XXX_database.sql --force
MySQL root password:
Created user DB_NAME
Created database DB_NAME
Granted privileges to user DB_NAME and database DB_NAME
Starting database import...
sh: 1: cannot open /home/Downloads/XXX_database.sql: No such file
Imported from database /home/Downloads/XXX_database.sql
Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>
load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn
return fn(*args, **new_kwargs)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 308, in _install
install_app("frappe", verbose=verbose, set_as_patched=not source_sql)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 87, in install_app
frappe.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/__init__.py", line 284, in clear_cache
frappe.sessions.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/sessions.py", line 55, in clear_cache
for sess in frappe.db.sql("""select user, sid from tabSessions""", as_dict=1):
File "/home/addy/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
self._cursor.execute(query)
File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'rigpl.tabSessions' doesn't exist")

On Wednesday, July 2, 2014 6:31:44 PM UTC+5:30, Anand Doshi wrote:
If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ab8fc319-499e-4edf-8c4f-60a6938d6163%40googlegroups.com.

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

anand · July 2, 2014, 1:59pm

You need to have your custom apps also installed on your setup.

I recommend that you clone a fresh bench, but before restore/install, copy the standard_apps.json file from your production setup. Then run the install command and later restore your database.

-Anand.

On Wed, Jul 2, 2014 at 7:02 PM, Aditya Duggal <ad…@gmail.com> wrote:

Hi Anand,

Please disregard the previous post, it turns out that I was not using the correct path (new to Linux and its paths)

But after the import of database I guess I am stuck with the Apps and I am getting an error for the rigpl_erpnext apps hook.

The error console is here: http://pastebin.com/JFr24LVv

Let me know how could I resolve this error.

I guess this error would also answer one of my queries that how could I setup a system on Develop branch to do the testing and then push the commits to the production branch.

On Wednesday, July 2, 2014 6:48:00 PM UTC+5:30, Aditya Duggal wrote:
Hi Anand,

Thanks for the tip. But now I guess I am stuck with another error as below:

(env)ad…@addy:~/frappe-bench/sites$ frappe --restore DB_NAME /home/Downloads/XXX_database.sql --force

MySQL root password:
Created user DB_NAME
Created database DB_NAME
Granted privileges to user DB_NAME and database DB_NAME
Starting database import...
sh: 1: cannot open /home/Downloads/XXX_database.sql: No such file

Imported from database /home/Downloads/XXX_database.sql
Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 308, in _install
install_app("frappe", verbose=verbose, set_as_patched=not source_sql)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 87, in install_app

frappe.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/__init__.py", line 284, in clear_cache
frappe.sessions.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/sessions.py", line 55, in clear_cache

for sess in frappe.db.sql("""select user, sid from tabSessions""", as_dict=1):
File "/home/addy/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql

self._cursor.execute(query)
File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)

File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'rigpl.tabSessions' doesn't exist")

On Wednesday, July 2, 2014 6:31:44 PM UTC+5:30, Anand Doshi wrote:
If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ab8fc319-499e-4edf-8c4f-60a6938d6163%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAAQzbF3sis6Fzya5gX2H5KN2m9Vuh-%2BJ%2B_pDWLkOj4ddqpECAw%40mail.gmail.com.

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

adityaduggal · July 2, 2014, 2:24pm

Hi Anand,

I lost you in your explanation. I have checked my production server and there indeed is a standard_apps.json file under frappe-bench folder but when I checked on the contents then there is no mention of the custom apps in this json file.

Can you please elaborate as to how I could accomplish this feat.

On Wednesday, July 2, 2014 7:29:24 PM UTC+5:30, Anand Doshi wrote:

You need to have your custom apps also installed on your setup.

I recommend that you clone a fresh bench, but before restore/install, copy the standard_apps.json file from your production setup. Then run the install command and later restore your database.

-Anand.

On Wed, Jul 2, 2014 at 7:02 PM, Aditya Duggal <ad…@gmail.com> wrote:

Hi Anand,

Please disregard the previous post, it turns out that I was not using the correct path (new to Linux and its paths)

But after the import of database I guess I am stuck with the Apps and I am getting an error for the rigpl_erpnext apps hook.

The error console is here: http://pastebin.com/JFr24LVv

Let me know how could I resolve this error.

I guess this error would also answer one of my queries that how could I setup a system on Develop branch to do the testing and then push the commits to the production branch.

On Wednesday, July 2, 2014 6:48:00 PM UTC+5:30, Aditya Duggal wrote:
Hi Anand,

Thanks for the tip. But now I guess I am stuck with another error as below:

(env)ad…@addy:~/frappe-bench/sites$ frappe --restore DB_NAME /home/Downloads/XXX_database.sql --force

MySQL root password:
Created user DB_NAME
Created database DB_NAME
Granted privileges to user DB_NAME and database DB_NAME
Starting database import...
sh: 1: cannot open /home/Downloads/XXX_database.sql: No such file

Imported from database /home/Downloads/XXX_database.sql
Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 308, in _install
install_app("frappe", verbose=verbose, set_as_patched=not source_sql)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 87, in install_app

frappe.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/__init__.py", line 284, in clear_cache
frappe.sessions.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/sessions.py", line 55, in clear_cache

for sess in frappe.db.sql("""select user, sid from tabSessions""", as_dict=1):
File "/home/addy/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql

self._cursor.execute(query)
File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)

File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'rigpl.tabSessions' doesn't exist")

On Wednesday, July 2, 2014 6:31:44 PM UTC+5:30, Anand Doshi wrote:
If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ab8fc319-499e-4edf-8c4f-60a6938d6163%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/77b95933-5af7-4bfd-bd30-9fd2574d2ace%40googlegroups.com.

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

rmehta · July 3, 2014, 5:17am

Aditya, you will have to install custom apps via:

frappe --install_app yourapp

On 02-Jul-2014, at 7:54 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi Anand,

I lost you in your explanation. I have checked my production server and there indeed is a standard_apps.json file under frappe-bench folder but when I checked on the contents then there is no mention of the custom apps in this json file.

Can you please elaborate as to how I could accomplish this feat.

On Wednesday, July 2, 2014 7:29:24 PM UTC+5:30, Anand Doshi wrote:
You need to have your custom apps also installed on your setup.

I recommend that you clone a fresh bench, but before restore/install, copy the standard_apps.json file from your production setup. Then run the install command and later restore your database.

-Anand.

On Wed, Jul 2, 2014 at 7:02 PM, Aditya Duggal <ad…@gmail.com> wrote:

Hi Anand,

Please disregard the previous post, it turns out that I was not using the correct path (new to Linux and its paths)

But after the import of database I guess I am stuck with the Apps and I am getting an error for the rigpl_erpnext apps hook.

The error console is here: http://pastebin.com/JFr24LVv

Let me know how could I resolve this error.

I guess this error would also answer one of my queries that how could I setup a system on Develop branch to do the testing and then push the commits to the production branch.

On Wednesday, July 2, 2014 6:48:00 PM UTC+5:30, Aditya Duggal wrote:
Hi Anand,

Thanks for the tip. But now I guess I am stuck with another error as below:

(env)ad…@addy:~/frappe-bench/sites$ frappe --restore DB_NAME /home/Downloads/XXX_database.sql --force

MySQL root password:
Created user DB_NAME
Created database DB_NAME
Granted privileges to user DB_NAME and database DB_NAME
Starting database import...
sh: 1: cannot open /home/Downloads/XXX_database.sql: No such file

Imported from database /home/Downloads/XXX_database.sql
Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 308, in _install
install_app("frappe", verbose=verbose, set_as_patched=not source_sql)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 87, in install_app

frappe.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/__init__.py", line 284, in clear_cache
frappe.sessions.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/sessions.py", line 55, in clear_cache

for sess in frappe.db.sql("""select user, sid from tabSessions""", as_dict=1):
File "/home/addy/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql

self._cursor.execute(query)
File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)

File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'rigpl.tabSessions' doesn't exist")

On Wednesday, July 2, 2014 6:31:44 PM UTC+5:30, Anand Doshi wrote:
If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ab8fc319-499e-4edf-8c4f-60a6938d6163%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/77b95933-5af7-4bfd-bd30-9fd2574d2ace%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/7A7C22D9-36A2-449D-BEC0-A0B4FE231B3A%40gmail.com.

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

adityaduggal · July 4, 2014, 5:34am

HI Anand,

The standard_apps.json in my production system is the same as the one in my test machine. the path which I am referring to is:

/frappe-bench/standard_apps.json

The content of this file in my production server only reflect to the 3 standard apps of erpnext and not to the custom app of rigpl.

I have also tried to edit the standard_apps.json file in my test environment to point to the rigpl_erpnext app and then run the install command but then I am getting this error:

Traceback (most recent call last):

File "./scripts/virtualenv.py", line 2365, in <module>

main()

File "./scripts/virtualenv.py", line 829, in main

after_install(options, home_dir)

File "./scripts/virtualenv.py", line 2341, in after_install

subprocess.check_output('/'.join([home_dir, 'bin', 'pip install honcho']), shell=True)

File "/usr/lib/python2.7/subprocess.py", line 573, in check_output

raise CalledProcessError(retcode, cmd, output=output)

subprocess.CalledProcessError: Command '/frappe-bench/env/bin/pip install honcho' returned non-zero exit status 1

On Wednesday, July 2, 2014 7:29:24 PM UTC+5:30, Anand Doshi wrote:

You need to have your custom apps also installed on your setup.

I recommend that you clone a fresh bench, but before restore/install, copy the standard_apps.json file from your production setup. Then run the install command and later restore your database.

-Anand.

On Wed, Jul 2, 2014 at 7:02 PM, Aditya Duggal <ad…@gmail.com> wrote:

Hi Anand,

Please disregard the previous post, it turns out that I was not using the correct path (new to Linux and its paths)

But after the import of database I guess I am stuck with the Apps and I am getting an error for the rigpl_erpnext apps hook.

The error console is here: http://pastebin.com/JFr24LVv

Let me know how could I resolve this error.

I guess this error would also answer one of my queries that how could I setup a system on Develop branch to do the testing and then push the commits to the production branch.

On Wednesday, July 2, 2014 6:48:00 PM UTC+5:30, Aditya Duggal wrote:
Hi Anand,

Thanks for the tip. But now I guess I am stuck with another error as below:

(env)ad…@addy:~/frappe-bench/sites$ frappe --restore DB_NAME /home/Downloads/XXX_database.sql --force

MySQL root password:
Created user DB_NAME
Created database DB_NAME
Granted privileges to user DB_NAME and database DB_NAME
Starting database import...
sh: 1: cannot open /home/Downloads/XXX_database.sql: No such file

Imported from database /home/Downloads/XXX_database.sql
Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main
return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run
out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore
_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 308, in _install
install_app("frappe", verbose=verbose, set_as_patched=not source_sql)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 87, in install_app

frappe.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/__init__.py", line 284, in clear_cache
frappe.sessions.clear_cache()
File "/home/addy/frappe-bench/apps/frappe/frappe/sessions.py", line 55, in clear_cache

for sess in frappe.db.sql("""select user, sid from tabSessions""", as_dict=1):
File "/home/addy/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql

self._cursor.execute(query)
File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)

File "/home/addy/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1146, "Table 'rigpl.tabSessions' doesn't exist")

On Wednesday, July 2, 2014 6:31:44 PM UTC+5:30, Anand Doshi wrote:
If you are doing this in a VM or somewhere other than your production server, use --force at the end of the command and it should be safe. Also, once the database is restored, you should get a message "Scheduler is disabled". Make sure that this message appears, else email pulling will start on this test setup.

-Anand.

On Wed, Jul 2, 2014 at 4:49 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am getting this error:

Traceback (most recent call last):
File "/home/addy/frappe-bench/env/bin/frappe", line 9, in <module>

load_entry_point('frappe==4.1.0', 'console_scripts', 'frappe')()

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 53, in main

return run(fn, parsed_args)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 81, in run

out = globals().get(fn)(*args.get(fn), **args)
File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn

return fn(*args, **new_kwargs)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 375, in restore

_install(db_name, source_sql=source_sql, quiet=quiet, force=force)

File "/home/addy/frappe-bench/apps/frappe/frappe/cli.py", line 306, in _install

admin_password = admin_password, verbose=verbose, force=force, site_config=site_config, reinstall=reinstall)

File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 30, in install_db

create_database_and_user(force, verbose)
File "/home/addy/frappe-bench/apps/frappe/frappe/installer.py", line 47, in create_database_and_user

raise Exception("Database %s already exists" % (db_name,))

Exception: Database rigpl already exists

No matter what name of the database I choose, I am getting the same error. Could you please let me know what is it that I am missing.

On Tuesday, June 17, 2014 12:46:21 PM UTC+5:30, rushabh wrote:

Aditya,

You have to start the Python virtual env:

cd frappe-bench
. env/bin/activate

On 16-Jun-2014, at 5:01 pm, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I am getting a frappe command not found after I did the below things:

:~/frappe-bench/sites$ frappe --restore DBNAME SQLFILE

frappe: command not found

What am I missing?

On Monday, June 16, 2014 12:35:53 PM UTC+5:30, rushabh wrote:

Thanks Aditya for pointing out. Fixed instructions:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On 16-Jun-2014, at 11:15 am, Aditya Duggal <ad…@gmail.com> wrote:

Hi,

I am trying to restore a backup on v4 but I guess the old method does not work.

Can someone please let me know the correct way to restore an old backup on v4.

I am using the wiki page here: https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

On Thursday, December 12, 2013 10:54:07 AM UTC+5:30, Mahesh wrote:

hi, when I say

./lib/wnf.py --restore erpnext path/to/sqlfile --force

it is saying no such file.
where as I checked with dir , the file is very much there...

what am I missing.

Sorry for putting a very silly question here.....

Regards,
Mahesh

On Wed, Dec 11, 2013 at 12:02 PM, Pratik Vyas <pd...@gmail.com> wrote:

Hi Mahesh,

Can you run update again, latest version should be able to patch your instance without any exceptions.

--
Pratik
erpnext

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/aeddb58c-a507-4d08-8673-cb069e31257b%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8f43f0a9-bdd5-45c2-96f5-65885a2d883a%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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+unsubscr…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/8c2d6ad2-ca18-418f-be23-384e7baa5ce8%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ab8fc319-499e-4edf-8c4f-60a6938d6163%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/80521933-560d-4893-868e-8297577f99a7%40googlegroups.com.

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

pdvyas · July 4, 2014, 8:40am

On Fri, Jul 4, 2014 at 11:04 AM, Aditya Duggal ad...@gmail.com wrote:

HI Anand,

The standard_apps.json in my production system is the same as the one in my
test machine. the path which I am referring to is:

/frappe-bench/standard_apps.json

The content of this file in my production server only reflect to the 3
standard apps of erpnext and not to the custom app of rigpl.

I have also tried to edit the standard_apps.json file in my test environment
to point to the rigpl_erpnext app and then run the install command but then
I am getting this error:

Traceback (most recent call last):
File “./scripts/virtualenv.py”, line 2365, in
main()
File “./scripts/virtualenv.py”, line 829, in main
after_install(options, home_dir)
File “./scripts/virtualenv.py”, line 2341, in after_install
subprocess.check_output(‘/’.join([home_dir, ‘bin’, ‘pip install
honcho’]), shell=True)
File “/usr/lib/python2.7/subprocess.py”, line 573, in check_output
raise CalledProcessError(retcode, cmd, output=output)
subprocess.CalledProcessError: Command ‘/frappe-bench/env/bin/pip install
honcho’ returned non-zero exit status 1

Hi Aditya,

We’ll be improving our bench system to make this easy. Will get back
to you soon about that.

You can try the following,

cd apps
git clone github.com/org/app1
pip install -e app1
git clone github.com/org/app2
pip install -e app2
cd ../sites
../env/bin/frappe --restore db_dump_file db_name sitename
../env/bin/frappe --use sitename
cd ..
./env/bin/honcho start

–
Pratik
erpnext

adityaduggal · July 4, 2014, 12:34pm

Hi Pratik,

Thanks for the help, I guess I am almost there.

I have been able to restore the database but I guess the website is not working on my system. When I login to 0.0.0.0:8000, I am getting a traceback "Keyerror" which is enclosed something to do with templates of website.

The link to pastebin is here http://pastebin.com/BPDHyVX8

Let me know what have I missed.

On Wednesday, November 27, 2013 3:08:27 PM UTC+5:30, Mahesh wrote:

Hello,

I have current older version of erpnext hosted on erpnext server.

I have desired to restore backup on my local machine, and hence I have downloaded the virtual machine and have successfully imported latest erpnext ova file.

I have also executed restoring the backup using the following

cd ~/erpnext
wget https://link/to/backup --no-check-certificate #
downloads database dump from erpnext.com

gunzip path/to/backup # unzip the database dump
./lib/wnf.py --restore path/to/backup --force
./lib/wnf.py --update origin master --reload_gunicorn
Now I go to host browser and type

http://localhost:8000/

and I only see a fresh new install of ERPNEXT, ( and I do not see the restored version from backup )

even tried following in the VM shell..

db_name = "erpnext" in conf.py

which returned nothing.

Requesting to receive help in order to see a local version of my ERPNEXT with restored backup

Thanks in advance.
Regards,
Mahesh

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ac6227ad-77cf-4a9f-838c-3624ed65bc43%40googlegroups.com.

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

adityaduggal · July 5, 2014, 10:37am

Hi Pratik,

Have you had the chance to check on the problem?

On Friday, July 4, 2014 6:04:15 PM UTC+5:30, Aditya Duggal wrote:

Hi Pratik,

Thanks for the help, I guess I am almost there.

I have been able to restore the database but I guess the website is not working on my system. When I login to 0.0.0.0:8000, I am getting a traceback "Keyerror" which is enclosed something to do with templates of website.

The link to pastebin is here http://pastebin.com/BPDHyVX8

Let me know what have I missed.

On Wednesday, November 27, 2013 3:08:27 PM UTC+5:30, Mahesh wrote:
Hello,

I have current older version of erpnext hosted on erpnext server.

I have desired to restore backup on my local machine, and hence I have downloaded the virtual machine and have successfully imported latest erpnext ova file.

I have also executed restoring the backup using the following

cd ~/erpnext
wget https://link/to/backup --no-check-certificate #
downloads database dump from erpnext.com

gunzip path/to/backup # unzip the database dump
./lib/wnf.py --restore path/to/backup --force
./lib/wnf.py --update origin master --reload_gunicorn
Now I go to host browser and type

http://localhost:8000/

and I only see a fresh new install of ERPNEXT, ( and I do not see the restored version from backup )

even tried following in the VM shell..

db_name = "erpnext" in conf.py

which returned nothing.

Requesting to receive help in order to see a local version of my ERPNEXT with restored backup

Thanks in advance.
Regards,
Mahesh

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/0367f382-3921-4903-9fd3-18ab6f52cf19%40googlegroups.com.

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

pdvyas · July 6, 2014, 4:31am

Hi Aditya,

Doesn't seem like a deployment issue. Raise on on frappe/frappe

On Jul 4, 2014 6:04 PM, "Aditya Duggal" <ad...@gmail.com> wrote:

Hi Pratik,

Thanks for the help, I guess I am almost there.

I have been able to restore the database but I guess the website is not working on my system. When I login to 0.0.0.0:8000, I am getting a traceback "Keyerror" which is enclosed something to do with templates of website.

The link to pastebin is here http://pastebin.com/BPDHyVX8

Let me know what have I missed.

On Wednesday, November 27, 2013 3:08:27 PM UTC+5:30, Mahesh wrote:

Hello,

I have current older version of erpnext hosted on erpnext server.

I have desired to restore backup on my local machine, and hence I have downloaded the virtual machine and have successfully imported latest erpnext ova file.

I have also executed restoring the backup using the following

cd ~/erpnext
wget https://link/to/backup --no-check-certificate #

downloads database dump from erpnext.com

gunzip path/to/backup # unzip the database dump
./lib/wnf.py --restore path/to/backup --force
./lib/wnf.py --update origin master --reload_gunicorn
Now I go to host browser and type

http://localhost:8000/

and I only see a fresh new install of ERPNEXT, ( and I do not see the restored version from backup )

even tried following in the VM shell..

db_name = "erpnext" in conf.py

which returned nothing.

Requesting to receive help in order to see a local version of my ERPNEXT with restored backup

Thanks in advance.
Regards,
Mahesh

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ac6227ad-77cf-4a9f-838c-3624ed65bc43%40googlegroups.com.

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

adityaduggal · July 7, 2014, 7:06am

Hi Pratik,

Just raised an issue of frappe https://github.com/frappe/frappe/issues/676

Kindly let me know what else is needed from my end.

On Sunday, July 6, 2014 10:01:51 AM UTC+5:30, Pratik Vyas wrote:

Hi Aditya,

Doesn't seem like a deployment issue. Raise on on frappe/frappe

On Jul 4, 2014 6:04 PM, "Aditya Duggal" <ad...@gmail.com> wrote:

Hi Pratik,

Thanks for the help, I guess I am almost there.

I have been able to restore the database but I guess the website is not working on my system. When I login to 0.0.0.0:8000, I am getting a traceback "Keyerror" which is enclosed something to do with templates of website.

The link to pastebin is here http://pastebin.com/BPDHyVX8

Let me know what have I missed.

On Wednesday, November 27, 2013 3:08:27 PM UTC+5:30, Mahesh wrote:

Hello,

I have current older version of erpnext hosted on erpnext server.

I have desired to restore backup on my local machine, and hence I have downloaded the virtual machine and have successfully imported latest erpnext ova file.

I have also executed restoring the backup using the following

cd ~/erpnext
wget https://link/to/backup --no-check-certificate #

downloads database dump from erpnext.com

gunzip path/to/backup # unzip the database dump
./lib/wnf.py --restore path/to/backup --force
./lib/wnf.py --update origin master --reload_gunicorn
Now I go to host browser and type

http://localhost:8000/

and I only see a fresh new install of ERPNEXT, ( and I do not see the restored version from backup )

even tried following in the VM shell..

db_name = "erpnext" in conf.py

which returned nothing.

Requesting to receive help in order to see a local version of my ERPNEXT with restored backup

Thanks in advance.
Regards,
Mahesh

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ac6227ad-77cf-4a9f-838c-3624ed65bc43%40googlegroups.com.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/f09b590b-95b1-437f-8af9-e09ad3185792%40googlegroups.com.

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