StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Looks like you are using a <code>MacPorts</code> Python installation on MacOS X. If you use <code>MacPorts</code> properly to upgrade, you should not run into problems like that. First, make sure your installation is up-to-date:</p> <pre><code>$ sudo port selfupdate $ sudo port outdated # lists outdated ports $ sudo port -u upgrade outdated # upgrade outdated ports and remove old versions </code></pre> <p>Then, if you still have problems, make sure you don't have a file permission problem somewhere. It should look something like this:</p> <pre><code>$ ls -l /opt/local/lib/mysql5/mysql total 93824 -rw-r--r-- 2 root admin 1824 Nov 22 16:10 libdbug.a -rw-r--r-- 2 root admin 161176 Nov 22 16:10 libheap.a -rw-r--r-- 2 root admin 900552 Nov 22 16:10 libmyisam.a -rw-r--r-- 2 root admin 136472 Nov 22 16:10 libmyisammrg.a -rwxr-xr-x 2 root admin 2871400 Nov 22 16:10 libmysqlclient.16.dylib* -rw-r--r-- 2 root admin 3224032 Nov 22 16:10 libmysqlclient.a lrwxr-xr-x 1 root admin 23 Nov 22 16:10 libmysqlclient.dylib@ -> libmysqlclient.16.dylib -rwxr-xr-x 2 root admin 1028 Nov 22 16:10 libmysqlclient.la* -rwxr-xr-x 2 root admin 2891208 Nov 22 16:10 libmysqlclient_r.16.dylib* -rw-r--r-- 2 root admin 3248504 Nov 22 16:10 libmysqlclient_r.a lrwxr-xr-x 1 root admin 25 Nov 22 16:10 libmysqlclient_r.dylib@ -> libmysqlclient_r.16.dylib -rwxr-xr-x 2 root admin 1040 Nov 22 16:10 libmysqlclient_r.la* -rw-r--r-- 2 root admin 25939344 Nov 22 16:10 libmysqld.a -rw-r--r-- 2 root admin 2643984 Nov 22 16:10 libmystrings.a -rw-r--r-- 2 root admin 667720 Nov 22 16:10 libmysys.a -rwxr-xr-x 2 root admin 2039856 Nov 22 16:10 libndbclient.3.dylib* -rw-r--r-- 2 root admin 3221192 Nov 22 16:10 libndbclient.a lrwxr-xr-x 1 root admin 20 Nov 22 16:10 libndbclient.dylib@ -> libndbclient.3.dylib -rwxr-xr-x 2 root admin 976 Nov 22 16:10 libndbclient.la* -rw-r--r-- 2 root admin 29568 Nov 22 16:10 libvio.a drwxr-xr-x 2 root admin 612 Nov 22 16:10 plugin/ </code></pre> <p>Also make sure you don't have an architecture mismatch:</p> <pre><code>$ cd /opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/ $ file _mysql.so _mysql.so: Mach-O universal binary with 2 architectures _mysql.so (for architecture x86_64): Mach-O 64-bit bundle x86_64 _mysql.so (for architecture i386): Mach-O bundle i386 $ otool -L _mysql.so # this shows which MySQL client lib the Python DB adapter is dynamically linked to _mysql.so: /opt/local/lib/mysql5/mysql/libmysqlclient_r.16.dylib (compatibility version 17.0.0, current version 17.0.0) /opt/local/lib/libz.1.dylib (compatibility version 1.0.0, current version 1.2.5) /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 125.2.0) /opt/local/lib/libssl.0.9.8.dylib (compatibility version 0.9.8, current version 0.9.8) /opt/local/lib/libcrypto.0.9.8.dylib (compatibility version 0.9.8, current version 0.9.8) $ cd /opt/local/lib/mysql5/mysql/ $ file libmysqlclient_r.16.dylib libmysqlclient_r.16.dylib: Mach-O universal binary with 2 architectures libmysqlclient_r.16.dylib (for architecture i386): Mach-O dynamically linked shared library i386 libmysqlclient_r.16.dylib (for architecture x86_64): Mach-O 64-bit dynamically linked shared library x86_64 </code></pre> <p>And, of course, make sure you are really using the <code>MacPorts</code> Python:</p> <pre><code>$ /opt/local/bin/python2.6 -V Python 2.6.6 $ /opt/local/bin/python2.6 -c 'import MySQLdb; print(MySQLdb._mysql.__file__)' /opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated from sets import ImmutableSet /opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/_mysql.so </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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