Is There a way to restore database data from version 2 to version 3?

Hi;


I have tried to upgrade from version 2 (my last update was on september 2012) and it fails with lot of errors, then finally I tried to install a fresh installation of version 3 yesterday and it was successfull, but I need to restore my old data from version 2 is it possible or I have to do that manually table by table ?

Thanks.



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/18u0jyIx1vkJ.

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

 

 

Hi HF,

Make sure you have a copy of your database backed up. 

Try this out:
lib/wnf.py --install NEW_DB_NAME PATH_TO_BACKUP_SQL

change db_name in conf.py

Run
lib/wnf.py --patch_sync

You will need to change Administrator password as it gets reset to admin

Sent from my phone

On 20-Apr-2013, at 3:57 PM, HF <gm...@gmail.com> wrote:

Hi;

I have tried to upgrade from version 2 (my last update was on september 2012) and it fails with lot of errors, then finally I tried to install a fresh installation of version 3 yesterday and it was successfull, but I need to restore my old data from version 2 is it possible or I have to do that manually table by table ?

Thanks.



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/18u0jyIx1vkJ.

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

 

 



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

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

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

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

 

 

Hi Anand;


It gives me a lot of errors when I run patch_sync.

Is there any other way?

Thanks.



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/krMYwMQab1IJ.

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

 

 

HF,

What are the errors?

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 21-Apr-2013, at 12:44 AM, HF <gm...@gmail.com> wrote:

Hi Anand;

It gives me a lot of errors when I run patch_sync.

Is there any other way?

Thanks.



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/krMYwMQab1IJ.

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

 

 




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

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

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

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

 

 

Hi Rushabh;


I got these errors :

ro…@erpnext:/var/www/erp/erpnext# lib/wnf.py --patch_sync
u’— query explain —'
Executing patches.october_2012.fix_wrong_vouchers in erpnextdb33
Success
Executing patches.october_2012.remove_old_customer_contact_address in erpnextdb33
Success
Executing patches.october_2012.company_fiscal_year_docstatus_patch in erpnextdb33
Success
Executing patches.october_2012.update_account_property in erpnextdb33
Traceback (innermost last):
  File “/var/www/erp/erpnext/lib/webnotes/modules/patch_handler.py”, line 74, in execute_patch
    webnotes.get_method(patchmodule + “.execute”)()
  File “app/patches/october_2012/update_account_property.py”, line 14, in execute
    where lft > %(lft)s and rgt < %(rgt)s""", acc, debug=1)
  File “/var/www/erp/erpnext/lib/webnotes/db.py”, line 120, in sql
    raise e
 ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘update tabAccount set debit_or_credit = ‘Debit’, \n\t\t\tis_pl_account = ‘No’, compa’ at line 1”)

patches.october_2012.update_account_property: failed: STOPPED

Thanks.



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/M8_k70RaSqoJ.

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

 

 

Hi HF,

Please run update again. We have fixed the issue.

Thanks,
Anand.

On 22-Apr-2013, at 2:14 PM, HF <gm...@gmail.com> wrote:

Hi Rushabh;

I got these errors :

ro...@erpnext:/var/www/erp/erpnext# lib/wnf.py --patch_sync
u'--- query explain ---'
Executing patches.october_2012.fix_wrong_vouchers in erpnextdb33
Success
Executing patches.october_2012.remove_old_customer_contact_address in erpnextdb33
Success
Executing patches.october_2012.company_fiscal_year_docstatus_patch in erpnextdb33
Success
Executing patches.october_2012.update_account_property in erpnextdb33
Traceback (innermost last):
  File "/var/www/erp/erpnext/lib/webnotes/modules/patch_handler.py", line 74, in execute_patch
    webnotes.get_method(patchmodule + ".execute")()
  File "app/patches/october_2012/update_account_property.py", line 14, in execute
    where lft > %(lft)s and rgt < %(rgt)s""", acc, debug=1)
  File "/var/www/erp/erpnext/lib/webnotes/db.py", line 120, in sql
    raise e
 ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update tabAccount set debit_or_credit = 'Debit', \n\t\t\tis_pl_account = 'No', compa' at line 1")

patches.october_2012.update_account_property: failed: STOPPED

Thanks.



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/M8_k70RaSqoJ.

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

 

 




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

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

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

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

 

 

Hi Anand;


Which command to update ?




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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/icO7WTQb2BsJ.

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

 

 

Hi Anand;


OK I made the update,

It works now and have my old data in version 3.

Thank you so much.

HF



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

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

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

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/-5bUIfpO8mQJ.

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