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

2014-01-14, 11:21
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:


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

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


above the line


(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:


and you should also overwrite the file




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

Yvonne Milne.