Update from 3 to 4 error

Frappe Framework Bug
1
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/b338e1b1-3be4-488a-8607-a320667793e7%40googlegroups.com.

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

On Wed, Jun 11, 2014 at 5:38 PM, Faisal Reza fa...@gmail.com wrote:

Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the
erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version

git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached
ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev
libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto+±dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain
erp.mycompanyname.com

error log :
erpnext 4 upgrade from v3 error - Pastebin.com

appreciate for any helo, thanks in advance

–
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/b338e1b1-3be4-488a-8607-a320667793e7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Edit site_config.json and either remove backup_path or change public
to private in it’s value.

–
Pratik
erpnext

3
The trace shows the exception is about the backups directory, which is public - it should not be.



On 11-Jun-2014, at 5:38 pm, Faisal Reza <fa...@gmail.com> wrote:

Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/b338e1b1-3be4-488a-8607-a320667793e7%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/F0D55196-20DC-4D55-AAAE-5BFE520EAC17%40gmail.com.

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

what should do to fix that? any explaination for the steps?

thanks

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/525f421d-582c-4317-a20f-47e5e2421070%40googlegroups.com.

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

i already changed in
/home/erpnext/frappe-bench/sites/erpnext/site_config.json

either remove backup and change public to private
after that i run again ./scripts/install.sh migrate_3_to_3 /home/erpnext/erpnext

ro...@erp:/home/erpnext/frappe-bench# ./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/
New python executable in env/bin/python2.7
Not overwriting existing python script env/bin/python (you must use env/bin/python2.7)
Installing setuptools, pip...done.
site erpnext already exists

what should i do?

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/5dac3a33-2647-4a73-a187-5d1951fff58c%40googlegroups.com.

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

On Wed, Jun 25, 2014 at 12:00 PM, Faisal Reza fa...@gmail.com wrote:

hi pratik

i already changed in
/home/erpnext/frappe-bench/sites/erpnext/site_config.json

either remove backup and change public to private
after that i run again ./scripts/install.sh migrate_3_to_3
/home/erpnext/erpnext

ro…@erp:/home/erpnext/frappe-bench# ./scripts/install.sh migrate_3_to_4
/home/erpnext/erpnext/
New python executable in env/bin/python2.7
Not overwriting existing python script env/bin/python (you must use
env/bin/python2.7)
Installing setuptools, pip…done.
site erpnext already exists

what should i do?

From the sites directory, run
../env/bin/frappe --latest erpnext

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:

Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the
erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version

git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git
memcached ntp vim screen htop mariadb-server mariadb-common
libmariadbclient-dev libxslt1.1 libxslt1-dev redis-server libssl-dev
libcrypto+±dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain
erp.mycompanyname.com

error log :
erpnext 4 upgrade from v3 error - Pastebin.com

appreciate for any helo, thanks in advance

–
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/5dac3a33-2647-4a73-a187-5d1951fff58c%40googlegroups.com.

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

–
Pratik
erpnext

7
Hi,
I am trying  to upgrade from Erpnext3 to 4 also, using same scripts.
Here is the log:
http://pastebin.com/ZtKCEWtv

Appreciate for any help,
regards,
Ferenc

On Wednesday, June 11, 2014 2:08:38 PM UTC+2, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/4ec83fae-e1cc-4217-92e2-23ede09170e5%40googlegroups.com.

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

Hi Fernec, will push a fix today.

On Jul 5, 2014 9:18 AM, "Ferenc" <fe...@gmail.com> wrote:
Hi,
I am trying to upgrade from Erpnext3 to 4 also, using same scripts.
Here is the log:
http://pastebin.com/ZtKCEWtv

Appreciate for any help,
regards,
Ferenc

On Wednesday, June 11, 2014 2:08:38 PM UTC+2, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version

git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/4ec83fae-e1cc-4217-92e2-23ede09170e5%40googlegroups.com.

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

9
Hi Pratik,

the error still continues, 
this is what i'm doing

1. Delete frappe-bench folder
#rm -rf /home/erpnext/frappe-bench

2. i try to repeat again from the start
#git clone https://github.com/frappe/frappe-bench

3. enter the directory and run migration script
#cd frappe-bench
#./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext

and here comes the new error
Traceback (most recent call last):
  File "scripts/3to4.py", line 32, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 23, in migrate
    add_to_installed_apps('frappe', rebuild_sitemap=False)
TypeError: add_to_installed_apps() got an unexpected keyword argument 'rebuild_site
map'

complete log is in the http://pastebin.com/4etPCNRq

4. as you mentioned, i also try running ../env/bin/frappe --latest erpnext
# cd sites
# ../env/bin/frappe --latest erpnext

here comes the error :

  File "/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 202, in msgprint
    _raise_exception()
  File "/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 186, in _raise_exception
    raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field User ID in row 10
er...@erp:~/frappe-bench/sites$ 

complete log on http://pastebin.com/SQXuAmj3

is there any steps i missed? what should i do to make this migration 3 to 4 sucessful?

really appreciate for your help

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/6e18d767-c50d-4252-aebd-7985d5eabe2d%40googlegroups.com.

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

https://github.com/frappe/frappe-bench/commit/7effa5bcb09bb4ef36324f041d3a90d77bceccaf
should fix Fernec’s and Faisal’s issue

On Sun, Jul 6, 2014 at 8:09 PM, Faisal Reza fa...@gmail.com wrote:

Hi Pratik,

the error still continues,
this is what i’m doing

  1. Delete frappe-bench folder
    #rm -rf /home/erpnext/frappe-bench

  2. i try to repeat again from the start
    git clone https://github.com/frappe/frappe-bench

  3. enter the directory and run migration script
    #cd frappe-bench
    #./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext

and here comes the new error
Traceback (most recent call last):
File “scripts/3to4.py”, line 32, in
migrate(args.site)
File “scripts/3to4.py”, line 23, in migrate
add_to_installed_apps(‘frappe’, rebuild_sitemap=False)
TypeError: add_to_installed_apps() got an unexpected keyword argument
‘rebuild_site
map’

complete log is in the migrate_3_to_4 error_#2 - Pastebin.com

  1. as you mentioned, i also try running …/env/bin/frappe --latest erpnext

cd sites

…/env/bin/frappe --latest erpnext

here comes the error :

File “/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/init.py”,
line 202, in msgprint
_raise_exception()
File “/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/init.py”,
line 186, in _raise_exception
raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field
User ID in row 10
er…@erp:~/frappe-bench/sites$

complete log on env/bin/frappe --latest erpnext - Pastebin.com

is there any steps i missed? what should i do to make this migration 3 to 4
sucessful?

really appreciate for your help

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:

Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the
erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version

git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git
memcached ntp vim screen htop mariadb-server mariadb-common
libmariadbclient-dev libxslt1.1 libxslt1-dev redis-server libssl-dev
libcrypto+±dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain
erp.mycompanyname.com

error log :
erpnext 4 upgrade from v3 error - Pastebin.com

appreciate for any helo, thanks in advance

–
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/6e18d767-c50d-4252-aebd-7985d5eabe2d%40googlegroups.com.

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

–
Pratik
erpnext

11
Hi,
We are still trying to migrate Erpnext3 to 4...If there is some alternative way, pls let me know. Some additional written instructions would be highly appreciated concerning huge amount of data in the Erpnext3 database.
Regards,
Ferenc

On Sunday, July 6, 2014 4:39:29 PM UTC+2, Faisal Reza wrote:
Hi Pratik,

the error still continues, 
this is what i'm doing

1. Delete frappe-bench folder
#rm -rf /home/erpnext/frappe-bench

2. i try to repeat again from the start

3. enter the directory and run migration script
#cd frappe-bench
#./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext

and here comes the new error
Traceback (most recent call last):
  File "scripts/3to4.py", line 32, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 23, in migrate
    add_to_installed_apps('frappe', rebuild_sitemap=False)
TypeError: add_to_installed_apps() got an unexpected keyword argument 'rebuild_site
map'

complete log is in the http://pastebin.com/4etPCNRq

4. as you mentioned, i also try running ../env/bin/frappe --latest erpnext
# cd sites
# ../env/bin/frappe --latest erpnext

here comes the error :

  File "/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 202, in msgprint
    _raise_exception()
  File "/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 186, in _raise_exception
    raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field User ID in row 10
er...@erp:~/frappe-bench/sites$ 


is there any steps i missed? what should i do to make this migration 3 to 4 sucessful?

really appreciate for your help

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/2c5dbbcf-8e9d-4007-ab26-1fa7663f9f2a%40googlegroups.com.

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

On Tue, Jul 8, 2014 at 2:14 AM, Ferenc fe...@gmail.com wrote:

Hi,
We are still trying to migrate Erpnext3 to 4…If there is some alternative
way, pls let me know. Some additional written instructions would be highly
appreciated concerning huge amount of data in the Erpnext3 database.
Regards,
Ferenc

Hi Fernec,

The steps you followed are correct. The error was due to an API change
in frappe and we’ve fixed it in the migration script. Can you try
migrating again after updating (./scripts/update.sh) ?

On Sunday, July 6, 2014 4:39:29 PM UTC+2, Faisal Reza wrote:

Hi Pratik,

the error still continues,
this is what i’m doing

  1. Delete frappe-bench folder
    #rm -rf /home/erpnext/frappe-bench

  2. i try to repeat again from the start
    git clone https://github.com/frappe/frappe-bench

  3. enter the directory and run migration script
    #cd frappe-bench
    #./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext

and here comes the new error
Traceback (most recent call last):
File “scripts/3to4.py”, line 32, in
migrate(args.site)
File “scripts/3to4.py”, line 23, in migrate
add_to_installed_apps(‘frappe’, rebuild_sitemap=False)
TypeError: add_to_installed_apps() got an unexpected keyword argument
‘rebuild_site
map’

complete log is in the migrate_3_to_4 error_#2 - Pastebin.com

  1. as you mentioned, i also try running …/env/bin/frappe --latest erpnext

cd sites

…/env/bin/frappe --latest erpnext

here comes the error :

File
“/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line
202, in msgprint
_raise_exception()
File
“/home/erpnext/erpnext/frappe-bench/apps/frappe/frappe/init.py”, line
186, in _raise_exception
raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for
field User ID in row 10
er…@erp:~/frappe-bench/sites$

complete log on env/bin/frappe --latest erpnext - Pastebin.com

is there any steps i missed? what should i do to make this migration 3 to
4 sucessful?

really appreciate for your help

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:

Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the
erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version

git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git
memcached ntp vim screen htop mariadb-server mariadb-common
libmariadbclient-dev libxslt1.1 libxslt1-dev redis-server libssl-dev
libcrypto+±dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain
erp.mycompanyname.com

error log :
erpnext 4 upgrade from v3 error - Pastebin.com

appreciate for any helo, thanks in advance

–
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/2c5dbbcf-8e9d-4007-ab26-1fa7663f9f2a%40googlegroups.com.

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

Thanks,

Pratik
erpnext

13
still see the error 

    validate_fields_for_doctype(self.doc_type)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 186, in validate_fields_for_doctype
    validate_fields(frappe.get_meta(doctype).get("fields"))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 246, in validate_fields
    check_link_table_options(d)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 212, in check_link_table_options
    frappe.throw(_("Options must be a valid DocType for field {0} in row {1}").format(d.label, d.idx))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 206, in throw
    msgprint(msg, raise_exception=exc)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 203, in msgprint
    _raise_exception()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 187, in _raise_exception
    raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field User ID in row 10
er...@erp:~/frappe-bench$

any other suggestions?

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/3454a960-6e2e-4ce2-a826-6ffd371833bb%40googlegroups.com.

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

can you reply?

---------- Forwarded message ----------
From: Faisal Reza fa...@gmail.com
Date: Tue, Jul 8, 2014 at 5:31 PM
Subject: [erpnext-dev] Re: Update from 3 to 4 error
To: er...@googlegroups.com

still see the error

validate_fields_for_doctype(self.doc_type)

File “/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”,
line 186, in validate_fields_for_doctype
validate_fields(frappe.get_meta(doctype).get(“fields”))
File “/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”,
line 246, in validate_fields
check_link_table_options(d)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”,
line 212, in check_link_table_options
frappe.throw(_(“Options must be a valid DocType for field {0} in
row {1}”).format(d.label, d.idx))
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”,
line 206, in throw
msgprint(msg, raise_exception=exc)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”,
line 203, in msgprint
_raise_exception()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/init.py”,
line 187, in _raise_exception
raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for
field User ID in row 10
er…@erp:~/frappe-bench$

any other suggestions?

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:

Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version

git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto+±dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
erpnext 4 upgrade from v3 error - Pastebin.com

appreciate for any helo, thanks in advance

–
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/3454a960-6e2e-4ce2-a826-6ffd371833bb%40googlegroups.com.

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

–
Pratik
erpnext

15
Did you change any fields doctype Employee?

(seems an issue with the User ID field)


@rushabh_mehta

On 08-Jul-2014, at 5:31 pm, Faisal Reza <fa...@gmail.com> wrote:

still see the error 

    validate_fields_for_doctype(self.doc_type)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 186, in validate_fields_for_doctype
    validate_fields(frappe.get_meta(doctype).get("fields"))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 246, in validate_fields
    check_link_table_options(d)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 212, in check_link_table_options
    frappe.throw(_("Options must be a valid DocType for field {0} in row {1}").format(d.label, d.idx))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 206, in throw
    msgprint(msg, raise_exception=exc)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 203, in msgprint
    _raise_exception()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 187, in _raise_exception
    raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field User ID in row 10
er...@erp:~/frappe-bench$

any other suggestions?

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/3454a960-6e2e-4ce2-a826-6ffd371833bb%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/169CBBAF-85CD-489C-9608-F191EE77FC10%40gmail.com.

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

is there any follow-up concerning upgrading and data transfer from erpnext3 to 4.

Thank you,
Ferenc

On Wednesday, July 9, 2014 7:31:27 AM UTC+2, rushabh wrote:
Did you change any fields doctype Employee?

(seems an issue with the User ID field)


@rushabh_mehta

On 08-Jul-2014, at 5:31 pm, Faisal Reza <fa...@gmail.com> wrote:

still see the error 

    validate_fields_for_doctype(self.doc_type)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 186, in validate_fields_for_doctype
    validate_fields(frappe.get_meta(doctype).get("fields"))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 246, in validate_fields
    check_link_table_options(d)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 212, in check_link_table_options
    frappe.throw(_("Options must be a valid DocType for field {0} in row {1}").format(d.label, d.idx))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 206, in throw
    msgprint(msg, raise_exception=exc)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 203, in msgprint
    _raise_exception()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 187, in _raise_exception
    raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field User ID in row 10
er...@erp:~/frappe-bench$

any other suggestions?

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/3454a960-6e2e-4ce2-a826-6ffd371833bb%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/4918cb97-b59f-4cdc-b34d-c9e17f61c29b%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
17
3-to-4 script should work - we have migrated more than 300 accounts using the script.


On 15-Jul-2014, at 3:28 pm, Ferenc <fe...@gmail.com> wrote:

Hi,

is there any follow-up concerning upgrading and data transfer from erpnext3 to 4.

Thank you,
Ferenc

On Wednesday, July 9, 2014 7:31:27 AM UTC+2, rushabh wrote:
Did you change any fields doctype Employee?

(seems an issue with the User ID field)


@rushabh_mehta

On 08-Jul-2014, at 5:31 pm, Faisal Reza <fa...@gmail.com> wrote:

still see the error 

    validate_fields_for_doctype(self.doc_type)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 186, in validate_fields_for_doctype
    validate_fields(frappe.get_meta(doctype).get("fields"))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 246, in validate_fields
    check_link_table_options(d)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 212, in check_link_table_options
    frappe.throw(_("Options must be a valid DocType for field {0} in row {1}").format(d.label, d.idx))
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 206, in throw
    msgprint(msg, raise_exception=exc)
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 203, in msgprint
    _raise_exception()
  File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 187, in _raise_exception
    raise raise_exception, msg
frappe.exceptions.ValidationError: Options must be a valid DocType for field User ID in row 10
er...@erp:~/frappe-bench$

any other suggestions?

On Wednesday, June 11, 2014 7:08:38 PM UTC+7, Faisal Reza wrote:
Hi
trying to upgrade from v3 (VM) to v4 using update scripts
the scripts end with error and the username from v3 cannot login to the erpnext

this is what i do

./lib/wnf.py --pull origin master
./lib/wnf.py --latest
sudo pip install semantic-version
 
git clone https://github.com/frappe/frappe-bench
cd frappe-bench/

sudo apt-get install python-dev build-essential python-mysqldb git memcached ntp vim screen htop mariadb-server mariadb-common libmariadbclient-dev  libxslt1.1 libxslt1-dev redis-server libssl-dev libcrypto++-dev postfix

./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext/

when postfix dialog appear, i choose Local only with domain erp.mycompanyname.com

error log :
http://pastebin.com/6miJqwzD

appreciate for any helo, thanks in advance

–

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/3454a960-6e2e-4ce2-a826-6ffd371833bb%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/4918cb97-b59f-4cdc-b34d-c9e17f61c29b%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/B93F452B-BE37-4A74-BF31-F9BED99622EA%40gmail.com.

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

I've got the error during upgrading.
[ro...@ip-172-31-0-5 frappe-bench]# ./scripts/install.sh migrate_3_to_4 /home/erpnext/erpnext
New python executable in env/bin/python2.7
Also creating executable in env/bin/python
Installing setuptools, pip...done.
remote: Reusing existing pack: 56374, done.
remote: Counting objects: 93, done.
remote: Compressing objects: 100% (93/93), done.
remote: Total 56467 (delta 40), reused 0 (delta 0)
Receiving objects: 100% (56467/56467), 22.38 MiB | 4.03 MiB/s, done.
Resolving deltas: 100% (39646/39646), done.
remote: Reusing existing pack: 114207, done.
remote: Counting objects: 92, done.
remote: Compressing objects: 100% (91/91), done.
remote: Total 114299 (delta 54), reused 2 (delta 1)
Receiving objects: 100% (114299/114299), 35.93 MiB | 5.58 MiB/s, done.
Resolving deltas: 100% (81397/81397), done.
remote: Reusing existing pack: 904, done.
remote: Total 904 (delta 0), reused 0 (delta 0)
Receiving objects: 100% (904/904), 260.24 KiB | 129 KiB/s, done.
Resolving deltas: 100% (622/622), done.
Wrote sites/assets/js/frappe-web.min.js - 63k
Wrote sites/assets/js/shopping-cart-web.min.js - 1k
Wrote sites/assets/js/erpnext.min.js - 12k
Wrote sites/assets/css/frappe.css - 211k
Wrote sites/assets/css/frappe-web.css - 162k
Wrote sites/assets/css/shopping-cart-web.css - 0k
Wrote sites/assets/js/editor.min.js - 26k
Wrote sites/assets/css/erpnext.css - 0k
Wrote sites/assets/js/frappe.min.js - 608k
Wrote sites/assets/js/erpnext-web.min.js - 0k
Wrote sites/assets/js/slickgrid.min.js - 102k
Wrote sites/assets/js/canvasResize.min.js - 22k
Executing execute:frappe.db.sql("""update `tabPatch Log` set patch=replace(patch, '.4_0.', '.v4_0.')""") #2014-05-12 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc('core', 'doctype', 'doctype', force=True) #2014-01-24 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc('core', 'doctype', 'docfield', force=True) #2014-03-01 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc('core', 'doctype', 'docperm') #2014-06-04 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc('core', 'doctype', 'page') #2013-13-26 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc('core', 'doctype', 'report') #2014-06-03 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc('core', 'doctype', 'version') #2014-02-21 in erpnext (hpharmerp)
Traceback (most recent call last):
  File "scripts/3to4.py", line 32, in <module>
    migrate(args.site)
  File "scripts/3to4.py", line 26, in migrate
    latest()
  File "/var/www/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn
    return fn(*args, **new_kwargs)
  File "/var/www/frappe-bench/apps/frappe/frappe/cli.py", line 417, in latest
    frappe.modules.patch_handler.run_all()
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all
    if not run_single(patchmodule = patch):
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 50, in run_single
    return execute_patch(patchmodule, method, methodargs)
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 64, in execute_patch
    exec patchmodule.split("execute:")[1] in globals()
  File "<string>", line 1, in <module>
  File "/var/www/frappe-bench/apps/frappe/frappe/__init__.py", line 364, in reload_doc
    return frappe.modules.reload_doc(module, dt, dn, force=force)
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/__init__.py", line 35, in reload_doc
    return import_files(module, dt, dn, force=force)
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 17, in import_files
    return import_file(module, dt, dn, force=force)
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 22, in import_file
    ret = import_file_by_path(path, force)
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 50, in import_file_by_path
    import_doc(doc, force=force)
  File "/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py", line 111, in import_doc
    doc.insert()
  File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line 147, in insert
    self.run_post_save_methods()
  File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line 419, in run_post_save_methods
    self.run_method("on_update")
  File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line 392, in run_method
    return Document.hook(fn)(self, *args, **kwargs)
  File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line 468, in composer
    return composed(self, method, *args, **kwargs)
  File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line 451, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "/var/www/frappe-bench/apps/frappe/frappe/model/document.py", line 386, in <lambda>
    fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
  File "/var/www/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py", line 86, in on_update
    updatedb(self.name)
  File "/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 390, in updatedb
    tab.sync()
  File "/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 170, in sync
    self.create()
  File "/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py", line 90, in create
    CHARACTER SET=utf8""" % (self.name, add_text))
  File "/var/www/frappe-bench/apps/frappe/frappe/database.py", line 118, in sql
    self._cursor.execute(query)
  File "/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.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 '(6),\n\t\t\tmodified datetime(6),\n\t\t\tmodified_by varchar(255),\n\t\t\towner varchar(255)' at line 3")

May I ask how to make it possible to upgrade? Thanks so much.

Thanks,
Kenneth 

–

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/79e4e3e9-a1a6-46a4-a5b2-a8ffbfad0b75%40googlegroups.com.

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

On Sat, Jul 19, 2014 at 4:10 PM, ‘Kenneth K’ via ERPNext Developer
Forum er...@googlegroups.com wrote:

Hi Pratik,

I’ve got the error during upgrading.

[ro…@ip-172-31-0-5 frappe-bench]# ./scripts/install.sh migrate_3_to_4
/home/erpnext/erpnext

New python executable in env/bin/python2.7
Also creating executable in env/bin/python
Installing setuptools, pip…done.
remote: Reusing existing pack: 56374, done.
remote: Counting objects: 93, done.
remote: Compressing objects: 100% (93/93), done.
remote: Total 56467 (delta 40), reused 0 (delta 0)
Receiving objects: 100% (56467/56467), 22.38 MiB | 4.03 MiB/s, done.
Resolving deltas: 100% (39646/39646), done.
remote: Reusing existing pack: 114207, done.
remote: Counting objects: 92, done.
remote: Compressing objects: 100% (91/91), done.
remote: Total 114299 (delta 54), reused 2 (delta 1)
Receiving objects: 100% (114299/114299), 35.93 MiB | 5.58 MiB/s, done.
Resolving deltas: 100% (81397/81397), done.
remote: Reusing existing pack: 904, done.
remote: Total 904 (delta 0), reused 0 (delta 0)
Receiving objects: 100% (904/904), 260.24 KiB | 129 KiB/s, done.
Resolving deltas: 100% (622/622), done.
Wrote sites/assets/js/frappe-web.min.js - 63k
Wrote sites/assets/js/shopping-cart-web.min.js - 1k
Wrote sites/assets/js/erpnext.min.js - 12k
Wrote sites/assets/css/frappe.css - 211k
Wrote sites/assets/css/frappe-web.css - 162k
Wrote sites/assets/css/shopping-cart-web.css - 0k
Wrote sites/assets/js/editor.min.js - 26k
Wrote sites/assets/css/erpnext.css - 0k
Wrote sites/assets/js/frappe.min.js - 608k
Wrote sites/assets/js/erpnext-web.min.js - 0k
Wrote sites/assets/js/slickgrid.min.js - 102k
Wrote sites/assets/js/canvasResize.min.js - 22k
Executing execute:frappe.db.sql(“”“update tabPatch Log set
patch=replace(patch, ‘.4_0.’, ‘.v4_0.’)”“”) #2014-05-12 in erpnext
(hpharmerp)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘doctype’,
force=True) #2014-01-24 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docfield’,
force=True) #2014-03-01 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docperm’)
#2014-06-04 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘page’) #2013-13-26
in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘report’)
#2014-06-03 in erpnext (hpharmerp)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘version’)
#2014-02-21 in erpnext (hpharmerp)

Traceback (most recent call last):
File “scripts/3to4.py”, line 32, in
migrate(args.site)
File “scripts/3to4.py”, line 26, in migrate
latest()
File “/var/www/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in
new_fn
return fn(*args, **new_kwargs)
File “/var/www/frappe-bench/apps/frappe/frappe/cli.py”, line 417, in
latest
frappe.modules.patch_handler.run_all()
File
“/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line
25, in run_all
if not run_single(patchmodule = patch):
File
“/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line
50, in run_single
return execute_patch(patchmodule, method, methodargs)
File
“/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line
64, in execute_patch
exec patchmodule.split(“execute:”)[1] in globals()
File “”, line 1, in
File “/var/www/frappe-bench/apps/frappe/frappe/init.py”, line 364,
in reload_doc
return frappe.modules.reload_doc(module, dt, dn, force=force)
File “/var/www/frappe-bench/apps/frappe/frappe/modules/init.py”,
line 35, in reload_doc
return import_files(module, dt, dn, force=force)
File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 17, in import_files
return import_file(module, dt, dn, force=force)
File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 22, in import_file
ret = import_file_by_path(path, force)
File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 50, in import_file_by_path
import_doc(doc, force=force)
File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,
line 111, in import_doc
doc.insert()
File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line
147, in insert
self.run_post_save_methods()
File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line
419, in run_post_save_methods
self.run_method(“on_update”)
File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line
392, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line
468, in composer
return composed(self, method, *args, **kwargs)
File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line
451, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line
386, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args,
**kwargs)
File
“/var/www/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”,
line 86, in on_update
updatedb(self.name)
File “/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line
390, in updatedb
tab.sync()
File “/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line
170, in sync
self.create()
File “/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line
90, in create
CHARACTER SET=utf8"“” % (self.name, add_text))
File “/var/www/frappe-bench/apps/frappe/frappe/database.py”, line 118,
in sql
self._cursor.execute(query)
File
“/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”,
line 205, in execute
self.errorhandler(self, exc, value)
File
“/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”,
line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.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 ‘(6),\n\t\t\tmodified
datetime(6),\n\t\t\tmodified_by varchar(255),\n\t\t\towner varchar(255)’ at
line 3”)

May I ask how to make it possible to upgrade? Thanks so much.

Thanks,
Kenneth

–
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/79e4e3e9-a1a6-46a4-a5b2-a8ffbfad0b75%40googlegroups.com.

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

Hi Kenneth,

Have you upgraded to MariaDB 5.5?

Thanks,

Pratik
erpnext

20

Yes, already upgraded to MariaDB 5.5.


Regards,
Kenneth

Pratik Vyas於 2014年7月19日星期六UTC+8下午6時53分26秒寫道：
On Sat, Jul 19, 2014 at 4:10 PM, ‘Kenneth K’ via ERPNext Developer

Forum <erpnext-dev…@googlegroups.com> wrote:

> Hi Pratik,

>

> I’ve got the error during upgrading.

>>

>> [ro…@ip-172-31-0-5 frappe-bench]# ./scripts/install.sh migrate_3_to_4

>> /home/erpnext/erpnext

>>

>> New python executable in env/bin/python2.7

>> Also creating executable in env/bin/python

>> Installing setuptools, pip…done.

>> remote: Reusing existing pack: 56374, done.

>> remote: Counting objects: 93, done.

>> remote: Compressing objects: 100% (93/93), done.

>> remote: Total 56467 (delta 40), reused 0 (delta 0)

>> Receiving objects: 100% (56467/56467), 22.38 MiB | 4.03 MiB/s, done.

>> Resolving deltas: 100% (39646/39646), done.

>> remote: Reusing existing pack: 114207, done.

>> remote: Counting objects: 92, done.

>> remote: Compressing objects: 100% (91/91), done.

>> remote: Total 114299 (delta 54), reused 2 (delta 1)

>> Receiving objects: 100% (114299/114299), 35.93 MiB | 5.58 MiB/s, done.

>> Resolving deltas: 100% (81397/81397), done.

>> remote: Reusing existing pack: 904, done.

>> remote: Total 904 (delta 0), reused 0 (delta 0)

>> Receiving objects: 100% (904/904), 260.24 KiB | 129 KiB/s, done.

>> Resolving deltas: 100% (622/622), done.

>> Wrote sites/assets/js/frappe-web.min.js - 63k

>> Wrote sites/assets/js/shopping-cart-web.min.js - 1k

>> Wrote sites/assets/js/erpnext.min.js - 12k

>> Wrote sites/assets/css/frappe.css - 211k

>> Wrote sites/assets/css/frappe-web.css - 162k

>> Wrote sites/assets/css/shopping-cart-web.css - 0k

>> Wrote sites/assets/js/editor.min.js - 26k

>> Wrote sites/assets/css/erpnext.css - 0k

>> Wrote sites/assets/js/frappe.min.js - 608k

>> Wrote sites/assets/js/erpnext-web.min.js - 0k

>> Wrote sites/assets/js/slickgrid.min.js - 102k

>> Wrote sites/assets/js/canvasResize.min.js - 22k

>> Executing execute:frappe.db.sql(“”“update tabPatch Log set

>> patch=replace(patch, ‘.4_0.’, ‘.v4_0.’)”“”) #2014-05-12 in erpnext

>> (hpharmerp)

>> Success

>> Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘doctype’,

>> force=True) #2014-01-24 in erpnext (hpharmerp)

>> Success

>> Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docfield’,

>> force=True) #2014-03-01 in erpnext (hpharmerp)

>> Success

>> Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docperm’)

>> #2014-06-04 in erpnext (hpharmerp)

>> Success

>> Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘page’) #2013-13-26

>> in erpnext (hpharmerp)

>> Success

>> Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘report’)

>> #2014-06-03 in erpnext (hpharmerp)

>> Success

>> Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘version’)

>> #2014-02-21 in erpnext (hpharmerp)

>>

>> Traceback (most recent call last):

>>   File “scripts/3to4.py”, line 32, in <module>

>>     migrate(args.site)

>>   File “scripts/3to4.py”, line 26, in migrate

>>     latest()

>>   File “/var/www/frappe-bench/apps/frappe/frappe/cli.py”, line 67, in

>> new_fn

>>     return fn(*args, **new_kwargs)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/cli.py”, line 417, in

>> latest

>>     frappe.modules.patch_handler.run_all()

>>   File

>> “/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line

>> 25, in run_all

>>     if not run_single(patchmodule = patch):

>>   File

>> “/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line

>> 50, in run_single

>>     return execute_patch(patchmodule, method, methodargs)

>>   File

>> “/var/www/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line

>> 64, in execute_patch

>>     exec patchmodule.split(“execute:”)[1] in globals()

>>   File “<string>”, line 1, in <module>

>>   File “/var/www/frappe-bench/apps/frappe/frappe/init.py”, line 364,

>> in reload_doc

>>     return frappe.modules.reload_doc(module, dt, dn, force=force)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/modules/init.py”,

>> line 35, in reload_doc

>>     return import_files(module, dt, dn, force=force)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,

>> line 17, in import_files

>>     return import_file(module, dt, dn, force=force)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,

>> line 22, in import_file

>>     ret = import_file_by_path(path, force)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,

>> line 50, in import_file_by_path

>>     import_doc(doc, force=force)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/modules/import_file.py”,

>> line 111, in import_doc

>>     doc.insert()

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line

>> 147, in insert

>>     self.run_post_save_methods()

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line

>> 419, in run_post_save_methods

>>     self.run_method(“on_update”)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line

>> 392, in run_method

>>     return Document.hook(fn)(self, *args, **kwargs)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line

>> 468, in composer

>>     return composed(self, method, *args, **kwargs)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line

>> 451, in runner

>>     add_to_return_value(self, fn(self, *args, **kwargs))

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/document.py”, line

>> 386, in <lambda>

>>     fn = lambda self, *args, **kwargs: getattr(self, method)(*args,

>> **kwargs)

>>   File

>> “/var/www/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”,

>> line 86, in on_update

>>     updatedb(self.name)

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line

>> 390, in updatedb

>>     tab.sync()

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line

>> 170, in sync

>>     self.create()

>>   File “/var/www/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line

>> 90, in create

>>     CHARACTER SET=utf8"“” % (self.name, add_text))

>>   File “/var/www/frappe-bench/apps/frappe/frappe/database.py”, line 118,

>> in sql

>>     self._cursor.execute(query)

>>   File

>> “/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/cursors.py”,

>> line 205, in execute

>>     self.errorhandler(self, exc, value)

>>   File

>> “/var/www/frappe-bench/env/lib/python2.7/site-packages/MySQLdb/connections.py”,

>> line 36, in defaulterrorhandler

>>     raise errorclass, errorvalue

>> mysql_exceptions.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 '(6),\n\t\t\tmodified

>> datetime(6),\n\t\t\tmodifiedby varchar(255),\n\t\t\towner varchar(255)’ at

>> line 3")

>

>

> May I ask how to make it possible to upgrade? Thanks so much.

>

> Thanks,

> Kenneth

>

> –

> 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/79e4e3e9-a1a6-46a4-a5b2-a8ffbfad0b75%40googlegroups.com.

>

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



Hi Kenneth,



Have you upgraded to MariaDB 5.5?





Thanks,

–

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

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/0896cacd-12a4-4c31-8976-8c897efebb11%40googlegroups.com.

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