ZeosLib MySql

[xinyiman]

ZeosLib I installed the 6.6.6 stable version. I installed MySql 5.1.41-3ubuntu12.1 and try to connect the zconnection connects, but when I try to turn me zquery returns

Unknown MySQL data type!

Why?

[stonefull]

You need to install Lazarus 0.9.29.

[xinyiman]

Where is it? I found only up to 0.9.28

[Leledumbo]

See Daily Snapshots in the left pane?

[xinyiman]

I've never gone on! I used it now for the first time. What should I download over the third item (Lazarus source zip)? Even the first entry (Lazarus fixes source zip)? And the fpc sources?

[Leledumbo]

If you just want to upgrade your lazarus, download the lazarus source only and compile yourself. You don't need the fixes one since that only fixes errors in previous stable version, the true one both fix the errors and add new features (and new errors as well)

[xinyiman]

Ok thanks a lot

[xinyiman]

I installed the 0.9.29 package from both sources. Deb but the error remains. Any other suggestions?

[IndianaJones]

I tested with the zeoslib6.6.6 and ubuntu 10.04 and create a simple application. it works, what is your step to get this error. Anyway on the command line execute the following command to get the mysql server version.

mysql -u root -p -e status | grep 'Server version'

To test with the simple application, try with this.
1) Drag an ZConnection1 to the form, ZQuery1, Datasource1.
2) Change protocol, database name, user and password variables on the ZConnection1
3) Enter the following sql statement into the ZQuery1's SQL proporties.
4) Change Dataset property of the Datasource1 to ZQuery1.
5) Activate the ZConnection1 and Zquery1, connection and active to true.
6) To see the result DBGrid1 is enough.
Thats all, you can test with it.
Thanks.

[xinyiman]

Server version:      5.1.41-3ubuntu12.1 (Ubuntu)

But you hava 0.9.28 Lazarus version?

[IndianaJones]

Xinyiman, I use the Lazarus 0.9.29 svn version, leave the Daily snapshot way,
use the svn installation method. Here is the procedure.

1) Install the svn client application with apt-get install.
2) svn co http://svn.freepascal.org/svn/lazarus/trunk lazarus, execute this command in your homepage.
3) In the lazarus directory, which is stated after the trunk, execute make clean all.
4) After compilation of the lazarus, just start the lazarus.
Try with this method and install the latest svn revision and test it with the zeoslib.
If you have any question feel free to ask.
Thanks.

[xinyiman]

It does not work with svn version 0.9.29! I do not know where to turn! Fie! Help me please

[IndianaJones]

First of all, are you sure you are using the latest svn which is 25884. Secondly Are you using the daily snapshots or svn method?
Thirdly, ZeosLib package installation is fine?
And the last thing is try the following example to test the mysql example.
My simple example working with the following mysql server version number.
Server version:      5.1.39-ndb-7.0.9-1ubuntu7 (Ubuntu)

Briefly, explain this question to narrow the problem area.
Thanks.

[xinyiman]

So I installed the version from SVN just like you told me! The ZeosLib I have downloaded and installed today from the official site of the project. The only thing I can try is to change the version of mysql. Where can I find one that you have it?

[IndianaJones]

I dont think the problem might be the version number, Are you installed the Zeoslib lazarus package without error?
Thanks.