_mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists")

Dear All,

I am installing erpnext on Ubuntu 12.04 LTS and getting the _mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists") error, see full trace below.

I would like to test and evaluate erpnext this weekend and your assistance will be greatly appreciated

Thanks and Regards
Ronald Munjoma


Installing ERPNext
--------------------------------------------------------------------------------
MySQL Root user's Password:
.
ERPNext Database Name: next
Created user next
Created database next
Granted privileges to user next and database next
Starting database import...
Imported from database lib/webnotes/../conf/Framework.sql
Installing app...
core | doctype | bulk_email
core | doctype | comment
core | doctype | communication
core | doctype | control_panel
core | doctype | custom_field
core | doctype | custom_script
core | doctype | customize_form
core | doctype | customize_form_field
core | doctype | default_home_page
core | doctype | defaultvalue
Traceback (most recent call last):
File "install_erpnext.py", line 348, in <module>
install()
File "install_erpnext.py", line 17, in install
install_erpnext(install_path)
File "install_erpnext.py", line 180, in install_erpnext
setup_db(install_path, root_password, db_name)
File "install_erpnext.py", line 244, in setup_db
inst.import_from_db(db_name, verbose=1)
File "lib/webnotes/install_lib/install.py", line 71, in import_from_db
self.install_app()
File "lib/webnotes/install_lib/install.py", line 80, in install_app
sync_for("lib", force=True, sync_everything=True)
File "lib/webnotes/model/sync.py", line 21, in sync_for
folder), force, sync_everything)
File "lib/webnotes/model/sync.py", line 44, in walk_and_sync
if import_file(module_name, doctype, name, force):
File "lib/webnotes/modules/import_file.py", line 25, in import_file
ret = import_file_by_path(path, force)
File "lib/webnotes/modules/import_file.py", line 46, in import_file_by_path
import_doclist(doclist)
File "lib/webnotes/modules/import_file.py", line 96, in import_doclist
new_bean.insert()
File "lib/webnotes/model/bean.py", line 285, in insert
return self.save()
File "lib/webnotes/model/bean.py", line 317, in save
self.run_method(&#39;on_update&#39;)</div><div>  File &quot;lib/webnotes/model/bean.py&quot;, line 226, in run_method</div><div>    getattr(self.controller, method)()</div><div>  File &quot;lib/core/doctype/doctype/doctype.py&quot;, line 73, in on_update</div>
updatedb(self.doc.name)
File "lib/webnotes/model/db_schema.py", line 407, in updatedb
tab.sync()
File "lib/webnotes/model/db_schema.py", line 170, in sync
self.create()
File "lib/webnotes/model/db_schema.py", line 91, in create
CHARACTER SET=utf8""" % (self.name, add_text))

File "lib/webnotes/db.py", line 111, in sql

raise e
_mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists")
ro…@ronald ~/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.

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

What command are you using to install erpnext?

-Anand.

On 20-Sep-2013, at 12:34 PM, ronald munjoma <si...@gmail.com> wrote:

Dear All,

I am installing erpnext on Ubuntu 12.04 LTS and getting the _mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists") error, see full trace below.

I would like to test and evaluate erpnext this weekend and your assistance will be greatly appreciated

Thanks and Regards
Ronald Munjoma


Installing ERPNext
--------------------------------------------------------------------------------
MySQL Root user's Password: 
.
ERPNext Database Name: next
Created user next
Created database next
Granted privileges to user next and database next
Starting database import...
Imported from database lib/webnotes/../conf/Framework.sql
Installing app...
core | doctype | bulk_email
core | doctype | comment
core | doctype | communication
core | doctype | control_panel
core | doctype | custom_field
core | doctype | custom_script
core | doctype | customize_form
core | doctype | customize_form_field
core | doctype | default_home_page
core | doctype | defaultvalue
Traceback (most recent call last):
  File "install_erpnext.py", line 348, in <module>
    install()
  File "install_erpnext.py", line 17, in install
    install_erpnext(install_path)
  File "install_erpnext.py", line 180, in install_erpnext
    setup_db(install_path, root_password, db_name)
  File "install_erpnext.py", line 244, in setup_db
    inst.import_from_db(db_name, verbose=1)
  File "lib/webnotes/install_lib/install.py", line 71, in import_from_db
    self.install_app()
  File "lib/webnotes/install_lib/install.py", line 80, in install_app
    sync_for("lib", force=True, sync_everything=True)
  File "lib/webnotes/model/sync.py", line 21, in sync_for
    folder), force, sync_everything)
  File "lib/webnotes/model/sync.py", line 44, in walk_and_sync
    if import_file(module_name, doctype, name, force):
  File "lib/webnotes/modules/import_file.py", line 25, in import_file
    ret = import_file_by_path(path, force)
  File "lib/webnotes/modules/import_file.py", line 46, in import_file_by_path
    import_doclist(doclist)
  File "lib/webnotes/modules/import_file.py", line 96, in import_doclist
    new_bean.insert()
  File "lib/webnotes/model/bean.py", line 285, in insert
    return self.save()
  File "lib/webnotes/model/bean.py", line 317, in save

    self.run_method(‘on_update’)

  File “lib/webnotes/model/bean.py”, line 226, in run_method
    getattr(self.controller, method)()
  File “lib/core/doctype/doctype/doctype.py”, line 73, in on_update

    updatedb(self.doc.name)
  File "lib/webnotes/model/db_schema.py", line 407, in updatedb
    tab.sync()
  File "lib/webnotes/model/db_schema.py", line 170, in sync
    self.create()
  File "lib/webnotes/model/db_schema.py", line 91, in create
    CHARACTER SET=utf8""" % (self.name, add_text))

  File “lib/webnotes/db.py”, line 111, in sql

    raise e
_mysql_exceptions.OperationalError: (1050, “Table ‘tabdocfield’ already exists”)
ro…@ronald ~/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.

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

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

On Friday, September 20, 2013 9:11:31 AM UTC+2, Anand Doshi wrote:
Hi Ronald,

What command are you using to install erpnext?
  1. python install_erpnext.py
 following steps outlined in this guide: https://github.com/webnotes/erpnext/wiki/How-to-Install-ERPNext

Thanks and Regards
Ronald Munjoma

-Anand.

On 20-Sep-2013, at 12:34 PM, ronald munjoma <si...@gmail.com> wrote:

Dear All,

I am installing erpnext on Ubuntu 12.04 LTS and getting the _mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists") error, see full trace below.

I would like to test and evaluate erpnext this weekend and your assistance will be greatly appreciated

Thanks and Regards
Ronald Munjoma


Installing ERPNext
--------------------------------------------------------------------------------
MySQL Root user's Password: 
.
ERPNext Database Name: next
Created user next
Created database next
Granted privileges to user next and database next
Starting database import...
Imported from database lib/webnotes/../conf/Framework.sql
Installing app...
core | doctype | bulk_email
core | doctype | comment
core | doctype | communication
core | doctype | control_panel
core | doctype | custom_field
core | doctype | custom_script
core | doctype | customize_form
core | doctype | customize_form_field
core | doctype | default_home_page
core | doctype | defaultvalue
Traceback (most recent call last):
  File "install_erpnext.py", line 348, in <module>
    install()
  File "install_erpnext.py", line 17, in install
    install_erpnext(install_path)
  File "install_erpnext.py", line 180, in install_erpnext
    setup_db(install_path, root_password, db_name)
  File "install_erpnext.py", line 244, in setup_db
    inst.import_from_db(db_name, verbose=1)
  File "lib/webnotes/install_lib/install.py", line 71, in import_from_db
    self.install_app()
  File "lib/webnotes/install_lib/install.py", line 80, in install_app
    sync_for("lib", force=True, sync_everything=True)
  File "lib/webnotes/model/sync.py", line 21, in sync_for
    folder), force, sync_everything)
  File "lib/webnotes/model/sync.py", line 44, in walk_and_sync
    if import_file(module_name, doctype, name, force):
  File "lib/webnotes/modules/import_file.py", line 25, in import_file
    ret = import_file_by_path(path, force)
  File "lib/webnotes/modules/import_file.py", line 46, in import_file_by_path
    import_doclist(doclist)
  File "lib/webnotes/modules/import_file.py", line 96, in import_doclist
    new_bean.insert()
  File "lib/webnotes/model/bean.py", line 285, in insert
    return self.save()
  File "lib/webnotes/model/bean.py", line 317, in save

    self.run_method(‘on_update’)

  File “lib/webnotes/model/bean.py”, line 226, in run_method
    getattr(self.controller, method)()
  File “lib/core/doctype/doctype/doctype.py”, line 73, in on_update

    updatedb(self.doc.name)
  File "lib/webnotes/model/db_schema.py", line 407, in updatedb
    tab.sync()
  File "lib/webnotes/model/db_schema.py", line 170, in sync
    self.create()
  File "lib/webnotes/model/db_schema.py", line 91, in create
    CHARACTER SET=utf8""" % (self.name, add_text))

  File “lib/webnotes/db.py”, line 111, in sql

    raise e
_mysql_exceptions.OperationalError: (1050, “Table ‘tabdocfield’ already exists”)
ro…@ronald ~/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.

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

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

I am not able to replicate this issue. Can you try installing again, after dropping the database "next"?

-Anand.

On 20-Sep-2013, at 12:59 PM, Ronald Munjoma <si...@gmail.com> wrote:

Hi Anand,

On Friday, September 20, 2013 9:11:31 AM UTC+2, Anand Doshi wrote:
Hi Ronald,

What command are you using to install erpnext?
  1. python install_erpnext.py
 following steps outlined in this guide: https://github.com/webnotes/erpnext/wiki/How-to-Install-ERPNext

Thanks and Regards
Ronald Munjoma

-Anand.

On 20-Sep-2013, at 12:34 PM, ronald munjoma <si...@gmail.com> wrote:

Dear All,

I am installing erpnext on Ubuntu 12.04 LTS and getting the _mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists") error, see full trace below.

I would like to test and evaluate erpnext this weekend and your assistance will be greatly appreciated

Thanks and Regards
Ronald Munjoma


Installing ERPNext
--------------------------------------------------------------------------------
MySQL Root user's Password: 
.
ERPNext Database Name: next
Created user next
Created database next
Granted privileges to user next and database next
Starting database import...
Imported from database lib/webnotes/../conf/Framework.sql
Installing app...
core | doctype | bulk_email
core | doctype | comment
core | doctype | communication
core | doctype | control_panel
core | doctype | custom_field
core | doctype | custom_script
core | doctype | customize_form
core | doctype | customize_form_field
core | doctype | default_home_page
core | doctype | defaultvalue
Traceback (most recent call last):
  File "install_erpnext.py", line 348, in <module>
    install()
  File "install_erpnext.py", line 17, in install
    install_erpnext(install_path)
  File "install_erpnext.py", line 180, in install_erpnext
    setup_db(install_path, root_password, db_name)
  File "install_erpnext.py", line 244, in setup_db
    inst.import_from_db(db_name, verbose=1)
  File "lib/webnotes/install_lib/install.py", line 71, in import_from_db
    self.install_app()
  File "lib/webnotes/install_lib/install.py", line 80, in install_app
    sync_for("lib", force=True, sync_everything=True)
  File "lib/webnotes/model/sync.py", line 21, in sync_for
    folder), force, sync_everything)
  File "lib/webnotes/model/sync.py", line 44, in walk_and_sync
    if import_file(module_name, doctype, name, force):
  File "lib/webnotes/modules/import_file.py", line 25, in import_file
    ret = import_file_by_path(path, force)
  File "lib/webnotes/modules/import_file.py", line 46, in import_file_by_path
    import_doclist(doclist)
  File "lib/webnotes/modules/import_file.py", line 96, in import_doclist
    new_bean.insert()
  File "lib/webnotes/model/bean.py", line 285, in insert
    return self.save()
  File "lib/webnotes/model/bean.py", line 317, in save

    self.run_method(‘on_update’)

  File “lib/webnotes/model/bean.py”, line 226, in run_method
    getattr(self.controller, method)()
  File “lib/core/doctype/doctype/doctype.py”, line 73, in on_update

    updatedb(self.doc.name)
  File "lib/webnotes/model/db_schema.py", line 407, in updatedb
    tab.sync()
  File "lib/webnotes/model/db_schema.py", line 170, in sync
    self.create()
  File "lib/webnotes/model/db_schema.py", line 91, in create
    CHARACTER SET=utf8""" % (self.name, add_text))

  File “lib/webnotes/db.py”, line 111, in sql

    raise e
_mysql_exceptions.OperationalError: (1050, “Table ‘tabdocfield’ already exists”)
ro…@ronald ~/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.

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

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

Hi Anand,

I have tried dropping the database and creating a new one with no luck.

I have also tried deleting everything and starting from scratch with no lucky.

Which mySQL version is supported?

Thanks and regards

Ronald Munjoma
28 N Mandela Avenue, Harare
+263775625283

On Sep 21, 2013 10:18 AM, "Anand Doshi" <an...@iwebnotes.com> wrote:
Hi Ronald,

I am not able to replicate this issue. Can you try installing again, after dropping the database "next"?

-Anand.

On 20-Sep-2013, at 12:59 PM, Ronald Munjoma <si...@gmail.com> wrote:

Hi Anand,

On Friday, September 20, 2013 9:11:31 AM UTC+2, Anand Doshi wrote:
Hi Ronald,

What command are you using to install erpnext?
  1. python install_erpnext.py

Thanks and Regards
Ronald Munjoma

-Anand.

On 20-Sep-2013, at 12:34 PM, ronald munjoma <si...@gmail.com> wrote:

Dear All,

I am installing erpnext on Ubuntu 12.04 LTS and getting the _mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists") error, see full trace below.

I would like to test and evaluate erpnext this weekend and your assistance will be greatly appreciated

Thanks and Regards
Ronald Munjoma


Installing ERPNext
--------------------------------------------------------------------------------
MySQL Root user's Password:
.
ERPNext Database Name: next
Created user next
Created database next
Granted privileges to user next and database next
Starting database import...
Imported from database lib/webnotes/../conf/Framework.sql
Installing app...
core | doctype | bulk_email
core | doctype | comment
core | doctype | communication
core | doctype | control_panel
core | doctype | custom_field
core | doctype | custom_script
core | doctype | customize_form
core | doctype | customize_form_field
core | doctype | default_home_page
core | doctype | defaultvalue
Traceback (most recent call last):
File "install_erpnext.py", line 348, in <module>
install()
File "install_erpnext.py", line 17, in install
install_erpnext(install_path)
File "install_erpnext.py", line 180, in install_erpnext
setup_db(install_path, root_password, db_name)
File "install_erpnext.py", line 244, in setup_db
inst.import_from_db(db_name, verbose=1)
File "lib/webnotes/install_lib/install.py", line 71, in import_from_db
self.install_app()
File "lib/webnotes/install_lib/install.py", line 80, in install_app
sync_for("lib", force=True, sync_everything=True)
File "lib/webnotes/model/sync.py", line 21, in sync_for
folder), force, sync_everything)
File "lib/webnotes/model/sync.py", line 44, in walk_and_sync
if import_file(module_name, doctype, name, force):
File "lib/webnotes/modules/import_file.py", line 25, in import_file
ret = import_file_by_path(path, force)
File "lib/webnotes/modules/import_file.py", line 46, in import_file_by_path
import_doclist(doclist)
File "lib/webnotes/modules/import_file.py", line 96, in import_doclist
new_bean.insert()
File "lib/webnotes/model/bean.py", line 285, in insert
return self.save()
File "lib/webnotes/model/bean.py", line 317, in save
self.run_method(&#39;on_update&#39;)</div><div>  File &quot;lib/webnotes/model/bean.py&quot;, line 226, in run_method</div><div>    getattr(self.controller, method)()</div><div>  File &quot;lib/core/doctype/doctype/<u></u>doctype.py&quot;, line 73, in on_update</div>
updatedb(self.doc.name)
File "lib/webnotes/model/db_schema.py", line 407, in updatedb
tab.sync()
File "lib/webnotes/model/db_schema.py", line 170, in sync
self.create()
File "lib/webnotes/model/db_schema.py", line 91, in create
CHARACTER SET=utf8""" % (self.name, add_text))

File "lib/webnotes/db.py", line 111, in sql

raise e
_mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists")
ro…@ronald ~/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.

    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+un…@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 a topic in the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/ozs9um6xiR0/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+un…@googlegroups.com.

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



Note:

 

If you are posting an issue,

  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.

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

MySQL ver 5+ is supported.

Thanks,
Anand.

On 22-Sep-2013, at 9:39 PM, ronald munjoma <si...@gmail.com> wrote:

Hi Anand,

I have tried dropping the database and creating a new one with no luck.

I have also tried deleting everything and starting from scratch with no lucky.

Which mySQL version is supported?

Thanks and regards

Ronald Munjoma
28 N Mandela Avenue, Harare
+263775625283

On Sep 21, 2013 10:18 AM, "Anand Doshi" <an...@iwebnotes.com> wrote:
Hi Ronald,

I am not able to replicate this issue. Can you try installing again, after dropping the database "next"?

-Anand.

On 20-Sep-2013, at 12:59 PM, Ronald Munjoma <si...@gmail.com> wrote:

Hi Anand,

On Friday, September 20, 2013 9:11:31 AM UTC+2, Anand Doshi wrote:
Hi Ronald,

What command are you using to install erpnext?
  1. python install_erpnext.py
 following steps outlined in this guide: https://github.com/webnotes/erpnext/wiki/How-to-Install-ERPNext

Thanks and Regards
Ronald Munjoma

-Anand.

On 20-Sep-2013, at 12:34 PM, ronald munjoma <si...@gmail.com> wrote:

Dear All,

I am installing erpnext on Ubuntu 12.04 LTS and getting the _mysql_exceptions.OperationalError: (1050, "Table 'tabdocfield' already exists") error, see full trace below.

I would like to test and evaluate erpnext this weekend and your assistance will be greatly appreciated

Thanks and Regards
Ronald Munjoma


Installing ERPNext
--------------------------------------------------------------------------------
MySQL Root user's Password: 
.
ERPNext Database Name: next
Created user next
Created database next
Granted privileges to user next and database next
Starting database import...
Imported from database lib/webnotes/../conf/Framework.sql
Installing app...
core | doctype | bulk_email
core | doctype | comment
core | doctype | communication
core | doctype | control_panel
core | doctype | custom_field
core | doctype | custom_script
core | doctype | customize_form
core | doctype | customize_form_field
core | doctype | default_home_page
core | doctype | defaultvalue
Traceback (most recent call last):
  File "install_erpnext.py", line 348, in <module>
    install()
  File "install_erpnext.py", line 17, in install
    install_erpnext(install_path)
  File "install_erpnext.py", line 180, in install_erpnext
    setup_db(install_path, root_password, db_name)
  File "install_erpnext.py", line 244, in setup_db
    inst.import_from_db(db_name, verbose=1)
  File "lib/webnotes/install_lib/install.py", line 71, in import_from_db
    self.install_app()
  File "lib/webnotes/install_lib/install.py", line 80, in install_app
    sync_for("lib", force=True, sync_everything=True)
  File "lib/webnotes/model/sync.py", line 21, in sync_for
    folder), force, sync_everything)
  File "lib/webnotes/model/sync.py", line 44, in walk_and_sync
    if import_file(module_name, doctype, name, force):
  File "lib/webnotes/modules/import_file.py", line 25, in import_file
    ret = import_file_by_path(path, force)
  File "lib/webnotes/modules/import_file.py", line 46, in import_file_by_path
    import_doclist(doclist)
  File "lib/webnotes/modules/import_file.py", line 96, in import_doclist
    new_bean.insert()
  File "lib/webnotes/model/bean.py", line 285, in insert
    return self.save()
  File "lib/webnotes/model/bean.py", line 317, in save

    self.run_method(‘on_update’)

  File “lib/webnotes/model/bean.py”, line 226, in run_method
    getattr(self.controller, method)()
  File “lib/core/doctype/doctype/doctype.py”, line 73, in on_update

    updatedb(self.doc.name)
  File "lib/webnotes/model/db_schema.py", line 407, in updatedb
    tab.sync()
  File "lib/webnotes/model/db_schema.py", line 170, in sync
    self.create()
  File "lib/webnotes/model/db_schema.py", line 91, in create
    CHARACTER SET=utf8""" % (self.name, add_text))

  File “lib/webnotes/db.py”, line 111, in sql

    raise e
_mysql_exceptions.OperationalError: (1050, “Table ‘tabdocfield’ already exists”)
ro…@ronald ~/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.

    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+un…@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 a topic in the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/ozs9um6xiR0/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+un…@googlegroups.com.

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




Note:

 

If you are posting an issue,

  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.

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

    For more options, visit https://groups.google.com/groups/opt_out.
Hello,
I have exactly the same error.
Please, How did you solve it ?
Thanks
Heidy



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.

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

Hi Heidy,

I failed to resolve the error, was forced to use the virtual image to test erpnext. (Note, I managed to install on a different machine, Ubuntu server, the desktop version failed)

I will try again next year.

Merry Christmas and Happy New Year!

Thanks and Regards
Ronald Munjoma

On 23 Dec 2013 15:15, <ta...@gmail.com> wrote:
Hello,
I have exactly the same error.
Please, How did you solve it ?
Thanks
Heidy



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 a topic in the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/ozs9um6xiR0/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+un…@googlegroups.com.

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



Note:

 

If you are posting an issue,

  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.

    For more options, visit https://groups.google.com/groups/opt_out.
Hello Ronald,
thanks for your quick answer.

Merry Christmas and happy new year too

Heidy



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.

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