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

[ronald munjoma]

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")

root@ronald ~/erpnext> 

[Anand Doshi]

Hi Ronald,

What command are you using to install erpnext?

-Anand.

--
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...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Ronald Munjoma]

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

-Anand.

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

[Anand Doshi]

Hi Ronald,

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

-Anand.

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

[ronald munjoma]

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

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

[Anand Doshi]

Hi Ronald,

MySQL ver 5+ is supported.

Thanks,

Anand.

[tart...@gmail.com]

Hello,
I have exactly the same error.
Please, How did you solve it ?
Thanks
Heidy

[ronald munjoma]

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

--

[tart...@gmail.com]

Hello Ronald,
thanks for your quick answer.

Merry Christmas and happy new year too

Heidy