Databases
StackOverflow2013
Postsdbo
POPython MySQL wrong architecture error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPython MySQL wrong architecture error
    primarykey
    data
    text
    <p>I've been at this for some time and read many sites on the subject. suspect I have junk lying about causing this problem. But where?</p> <p>This is the error when I import MySQLdb in python:</p> <pre><code>&gt;&gt;&gt; import MySQLdb /Library/Python/2.6/site-packages/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /Library/Python/2.6/site-packages/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg/_mysql.pyc, but /Users/phoebebr/Downloads/MySQL-python-1.2.3c1 is being added to sys.path Traceback (most recent call last): File "&lt;stdin&gt;", line 1, in &lt;module&gt; File "MySQLdb/__init__.py", line 19, in &lt;module&gt; import _mysql File "build/bdist.macosx-10.6-universal/egg/_mysql.py", line 7, in &lt;module&gt; File "build/bdist.macosx-10.6-universal/egg/_mysql.py", line 6, in __bootstrap__ ImportError: dlopen(/Users/phoebebr/.python-eggs/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg-tmp/_mysql.so, 2): no suitable image found. Did find: /Users/phoebebr/.python-eggs/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg-tmp/_mysql.so: mach-o, but wrong architecture </code></pre> <p>I'm trying for 64 bit so checked here:</p> <pre><code>file $(which python) /usr/bin/python: Mach-O universal binary with 3 architectures /usr/bin/python (for architecture x86_64): Mach-O 64-bit executable x86_64 /usr/bin/python (for architecture i386): Mach-O executable i386 /usr/bin/python (for architecture ppc7400): Mach-O executable ppc file $(which mysql) /usr/local/mysql/bin/mysql: Mach-O 64-bit executable x86_64 </code></pre> <p>Have set my default version of python to 2.6</p> <pre><code>python Python 2.6.1 (r261:67515, Feb 11 2010, 00:51:29) [GCC 4.2.1 (Apple Inc. build 5646)] on darwin </code></pre> <p>Tried deleting build directory and python setup.py clean Renamed Python/2.5/site-packages so it could not try and pick that up.</p> <h1>UPDATE</h1> <p>Deleted everything and followed the instructions here: <a href="https://stackoverflow.com/questions/1904039/django-mysql-on-mac-os-10-6-2-snow-leopard">Django + MySQL on Mac OS 10.6.2 Snow Leopard</a> installing using macports. </p> <p>But basically still get the same error</p> <pre><code>Traceback (most recent call last): File "&lt;stdin&gt;", line 1, in &lt;module&gt; File "/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/MySQLdb/__init__.py", line 19, in &lt;module&gt; import _mysql ImportError: dlopen(/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/_mysql.so, 2): no suitable image found. Did find: /opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/_mysql.so: mach-o, but wrong architecture &gt;&gt;&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USPhoebeB
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPython MySQL wrong architecture error
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPython MySQL wrong architecture error
      1. USPhoebeB
      1. VTBountyStart
    3. VO
      singulars
      1. POPython MySQL wrong architecture error
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYour **library** (`_mysql.so` in `/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/_mysql.so`) is the wrong architecture (very likely 32-bit). You're almost there. :)
      singulars
      1. POPython MySQL wrong architecture error
      1. USvladr
    2. COSadly, trying to rebuild from source code caused an error The-Black-Book-2:MySQL-python-1.2.3 phoebebr$ ARCHFLAGS='-arch x86_64' python setup.py build sh: mysql_config: command not found Uninstalled all the macports install and doing a reinstall from scratch again in the hope that all the versions match up this time.
      singulars
      1. POPython MySQL wrong architecture error
      1. USPhoebeB
    3. COOK uninstalled all macports installs, removed everything on my hard disk related to mysql. Installed mysql from package on mysql site, downloaded python-mysql and built it using the same instructions I used originally, only this time it worked. Have no idea what was different this time, but it is working... Thanks to jdinuncio and belvoir - you were both right but had to pick one so chose the first person who responded! Hope this is ok.
      singulars
      1. POPython MySQL wrong architecture error
      1. USPhoebeB
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload