Linux 64bit (Ubuntu 12.10 and above) - MySQL field type/width errors

The following only applies to Lianja on Linux 64 bit (Ubuntu 12.10 and above).

If, on connecting to a MySQL database, character fields are listed as type 'memo' or numeric fields have a field width of -1, please carry out the following steps.

1. Please check whether you have the packages libqt4-sql-odbc and libqt4-sql-mysql. These install the files:

/usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlodbc.so
/usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so

If not, please install using your preferred method, e.g.

Code:

---

sudo apt-get install libqt4-sql-odbc libqt4-sql-mysql

---

2. Copy libqsqlodbc.so and libqsqlmysql.so into /opt/lianja/lib/plugins/sqldrivers/ overwriting the existing ones installed by Lianja. (Or delete the Lianja ones and create symbol links to the /usr/lib... ones.)

3. Add /usr/lib/x86_64-linux-gnu/ to your LD_LIBRARY_PATH, either for your login, or just in the /opt/lianja/bin/lianja script, adding the line

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/lib/x86_64-linux-gnu/

above the line

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${LIANJADIR}lib/

(or combine the two, as long as the /usr/lib/... one comes first)

4. Check whether you have the libjpeg62 package installed. If you do, you will have the link:

/usr/lib/x86_64-linux-gnu/libjpeg.so.62

and you should also overwrite the file

/opt/lianja/lib/plugins/imageformats/libqjpeg.so

with

/usr/lib/x86_64-linux-gnu/qt4/plugins/imageformats/libqjpeg.so

5. Retry your MySQL connection and check the field types/sizes.


Yvonne Milne.