title: python 'module' object has no attribute 'compile'
body: <pre><code>[root@proxy-001 scripts]# python
  Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22)
  [GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
  Type "help", "copyright", "credits" or "license" for more information.
     &gt;&gt;&gt; import MySQLdb
     &gt;&gt;&gt; from MySQLdb import cursors
      Traceback (most recent call last):
        File "&lt;stdin&gt;", line 1, in &lt;module&gt;
        File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 16, in &lt;module&gt;
          insert_values= re.compile(restr)
      AttributeError: 'module' object has no attribute 'compile'
  </code></pre>
  
  <p>any ideas?</p>
  
  <p>Same error:</p>
  
  <pre><code>[root@proxy-001 scripts]# python
  Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22)
  [GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
  Type "help", "copyright", "credits" or "license" for more information.
  &gt;&gt;&gt; import re
  &gt;&gt;&gt; import MySQLdb
  &gt;&gt;&gt; import MySQLdb.cursors
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
    File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 16, in &lt;module&gt;
      insert_values= re.compile(restr)
  AttributeError: 'module' object has no attribute 'compile'
  </code></pre>
  
  <p>edited: /usr/lib64/python2.6/site-packages/MySQLdb/cursors.py
  added: </p>
  
  <pre><code>print re
  print dir(re)
  insert_values= re.compile(restr)
  
  
  [root@proxy-001 scripts]# python
  Python 2.6.6 (r266:84292, Dec  7 2011, 20:48:22)
  [GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
  Type "help", "copyright", "credits" or "license" for more information.
  &gt;&gt;&gt; import re
  &gt;&gt;&gt; import MySQLdb
  &gt;&gt;&gt; import MySQLdb.cursors
  &lt;module 're' from 're.pyc'&gt;
  ['__builtins__', '__doc__', '__file__', '__name__', '__package__', 'main', 'modify_url', 'sys']
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
    File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 18, in &lt;module&gt;
      insert_values= re.compile(restr)
  AttributeError: 'module' object has no attribute 'compile'
  &gt;&gt;&gt;
  </code></pre>