Restoring Backup

Frappe Framework Bug
21
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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.
22
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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.
23

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

24
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


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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.
25
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


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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.
26

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


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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

27
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


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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.