How to resolve 'No module named 'cPickle'' exception in virtualenv

Question

I'm trying to run a program which connects to all databases(mysql,sqlite) and fetch data from it .

Python version - 3.6.8

Since the code is too long ,i'm showing only particular snippets.

def show_columns_mysql(cursor,tbname):
    cursor.execute("""show columns from %s"""%(tbname))
    rs=cursor.fetchall()
    colname=[]
    for i in rs:
        colname.append(i[0])
    return colname

There is no problem or issue if i exexute the program in normal python environment . When i try to execute this in virtual environment ,it shows me No module named 'cPickle' .

I have tried all the solutions but none solved my problem .

What was the problem ?

Possible duplicate of [Can't find module cPickle using Python 3.5 and Anaconda](https://stackoverflow.com/questions/49579282/cant-find-module-cpickle-using-python-3-5-and-anaconda) — R4444, Aug 06 '19 at 05:49
no i'm not using it .some people suggested to use six package .so when i checked using pip show six , it is installed — Gomathimeena Subburayan, Aug 06 '19 at 05:51

score 2 · Accepted Answer · answered Aug 06 '19 at 05:51

2

There is no cPickle in Python 3. Just import pickle. pickle will automatically use the C accelerator.

answered Aug 06 '19 at 05:51

Sushant Nair

83
7

Im not at all using pickle anywhere . Then where i need to use **import pickle** ??? – Gomathimeena Subburayan Aug 06 '19 at 05:53
1

If you are not using the ```pickle``` anywhere, you can remove the line where you imported it. – dipesh Aug 06 '19 at 05:56
@DipeshPaudel I'm not using the import pickle statement anywhere in my program with respect to knowledge and it still throws the exception . – Gomathimeena Subburayan Aug 06 '19 at 05:58
what line number throws the exception? what's on that line? – Skaperen Aug 06 '19 at 05:59
1

might be possibilities that your external files are might be using it check the error to which file error was created it will help in debug – Sushant Nair Aug 06 '19 at 05:59

score -1 · Answer 2 · answered Aug 06 '19 at 05:52

-1

Install pickle. Then do:

import pickle as cPickle

answered Aug 06 '19 at 05:52

R4444

2,016
2
19
30

when i try to install pickle : Collecting pickle ERROR: Could not find a version that satisfies the requirement pickle (from versions: none) ERROR: No matching distribution found for pickle – Gomathimeena Subburayan Aug 06 '19 at 05:55

How to resolve 'No module named 'cPickle'' exception in virtualenv

2 Answers2