ERPNext setup on virtual enviroment

Hello All,
   I have installed the ERPNext setup on virtual environment without using site packages.

   It got installed without any error. but when i try to open it in browser it shown mysql import error so i have installed mysql using "easy_install MySQL-python"

Now it shows following errors.

Traceback (most recent call last):
  File "/home/erpnext/erpnext/lib/webnotes/middlewares.py", line 12, in __call__
    return super(StaticDataMiddleware, self).__call__(environ, start_response)
  File "/home/indictrans/virt_env/virt1/lib/python2.7/site-packages/Werkzeug-0.9.4-py2.7.egg/werkzeug/wsgi.py", line 579, in __call__
    return self.app(environ, start_response)
  File "/home/indictrans/virt_env/virt1/lib/python2.7/site-packages/Werkzeug-0.9.4-py2.7.egg/werkzeug/local.py", line 224, in application
    return ClosingIterator(app(environ, start_response), self.cleanup)
  File "/home/indictrans/virt_env/virt1/lib/python2.7/site-packages/Werkzeug-0.9.4-py2.7.egg/werkzeug/wrappers.py", line 285, in application
    return f(*args[:-2] + (request,))(*args[-2:])
  File "/home/erpnext/erpnext/lib/webnotes/app.py", line 50, in application
    webnotes.http_request = webnotes.auth.HTTPRequest()
  File "/home/erpnext/erpnext/lib/webnotes/auth.py", line 42, in __init__
    if webnotes.conn.get_global("__session_status")=='stop':
  File "/home/erpnext/erpnext/lib/webnotes/db.py", line 415, in get_global
    return self.get_default(key, user)
  File "/home/erpnext/erpnext/lib/webnotes/db.py", line 429, in get_default
    d = webnotes.defaults.get_defaults(parent).get(key)
  File "/home/erpnext/erpnext/lib/webnotes/defaults.py", line 29, in get_defaults
    userd = get_defaults_for(user)
  File "/home/erpnext/erpnext/lib/webnotes/defaults.py", line 113, in get_defaults_for
    where parent = %s order by creation""", parent, as_dict=1)
  File "/home/erpnext/erpnext/lib/webnotes/db.py", line 97, in sql
    self._cursor.execute(query, values)
  File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 187, in execute
    query = query % tuple([db.literal(item) for item in args])
TypeError: not all arguments converted during string formatting

I have googled but not found any proper solution.

Please suggest.

Thanks and Regards,
Gangadhar kadam



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.

On Wed, Jan 15, 2014 at 3:58 PM, gangadhar kadam em...@gmail.com wrote:

Hello All,
I have installed the ERPNext setup on virtual environment without using
site packages.

It got installed without any error. but when i try to open it in browser
it shown mysql import error so i have installed mysql using “easy_install
MySQL-python”

In the virtualenv, run

pip install mysql-python==1.2.4

Mysql python has a hard dependency on distribute==0.6.8 and if you
have a later version of distribute, installing the 0.6.8 causes
infinite recursion. So, incase you hit this issue, downgrade
distribute to 0.6.8 in the virtualenv.

Now it shows following errors.

Traceback (most recent call last):
File “/home/erpnext/erpnext/lib/webnotes/middlewares.py”, line 12, in
call
return super(StaticDataMiddleware, self).call(environ,
start_response)
File
“/home/indictrans/virt_env/virt1/lib/python2.7/site-packages/Werkzeug-0.9.4-py2.7.egg/werkzeug/wsgi.py”,
line 579, in call
return self.app(environ, start_response)
File
“/home/indictrans/virt_env/virt1/lib/python2.7/site-packages/Werkzeug-0.9.4-py2.7.egg/werkzeug/local.py”,
line 224, in application
return ClosingIterator(app(environ, start_response), self.cleanup)
File
“/home/indictrans/virt_env/virt1/lib/python2.7/site-packages/Werkzeug-0.9.4-py2.7.egg/werkzeug/wrappers.py”,
line 285, in application
return f(*args[:-2] + (request,))(*args[-2:])
File “/home/erpnext/erpnext/lib/webnotes/app.py”, line 50, in application
webnotes.http_request = webnotes.auth.HTTPRequest()
File “/home/erpnext/erpnext/lib/webnotes/auth.py”, line 42, in init
if webnotes.conn.get_global(“__session_status”)==‘stop’:
File “/home/erpnext/erpnext/lib/webnotes/db.py”, line 415, in get_global
return self.get_default(key, user)
File “/home/erpnext/erpnext/lib/webnotes/db.py”, line 429, in get_default
d = webnotes.defaults.get_defaults(parent).get(key)
File “/home/erpnext/erpnext/lib/webnotes/defaults.py”, line 29, in
get_defaults
userd = get_defaults_for(user)
File “/home/erpnext/erpnext/lib/webnotes/defaults.py”, line 113, in
get_defaults_for
where parent = %s order by creation"“”, parent, as_dict=1)
File “/home/erpnext/erpnext/lib/webnotes/db.py”, line 97, in sql
self._cursor.execute(query, values)
File “build/bdist.linux-x86_64/egg/MySQLdb/cursors.py”, line 187, in
execute
query = query % tuple([db.literal(item) for item in args])
TypeError: not all arguments converted during string formatting

I have googled but not found any proper solution.

Please suggest.

Thanks and Regards,
Gangadhar kadam


Pratik
erpnext