Error Column with name "Extra" not found => SOL

[olivierf77]

subject: Error Column with name "Extra" not found on

<<< SOLUTION has been added at end of this msg >>>

First, and most important
All my gratitude and thanks for a wonderful package. As soon as I will be able to make it work, it will be great. It is obvious that you and your team has put a lot of work and time in it.

And many thanks for your quick and successful help

My context
- Win XP SP2 up to date
- D2007-win32
- zeos 6.2.2rc
- MySQL 5.1.23rc community
- mysql.dll latest version 5.1.33 in path as local server

- database exists and connection is ok
- tablename and accessed ok via MySQL browser/Admin

my problem
- When UNDER IDE (in design OR run mode)

1. component TZConnect to an existing database on a blank form
2 - property 'connect' set to 'true' => no problem
3. TZTable to an existing table
3. or TZQUERY with sql='SELECT fieldname FROM tablename".
with fieldname NOT equal to '*', but to an existing fieldname.
4. setting property 'active' to TRUE
==> displays under IDE from IDE:
Error: Column with name "Extra" not found

5. OR creating a "table connect" button to set this property to TRUE
6. Run (F9) under the IDE, to debug, and press "table connect" button
==> displays same error:
Error: Column with name "Extra" not found

7. BUT when lauching the compiled EXE from OUTSIDE IDE
=> No problem. Connection is active, and a more complete form will display all the records of the table.

8. Creating a field named "Extra" in the table does NOT suppress the error.

This error occurs in all tables of all my MySQL databases (including
your example).

I am quite baffled.
I hope that you can help me there since being able to link to data
from inside the IDE is very useful

The line where the message is created and displayed is easy to find, but the reason why the program is looking for the column "Extra", and only under IDE mode is much more complicated to understand.

Here is the traceback of the error, which I hope will help you.
the program itself is really minimal, with just your two components on a blank form, and a database standard connection parameters.

You can call me stupid if my mistake is obvious and you can correct it easily. I looked in your documentation before posting this msg, but could not find any information about this error. I hope you can find the mistake.
==============================================
THE SOLUTION
Thanks again for the quick tip offered by zeos support team:

My mistake:
I was using the latest libMySQL.dll from MySQL installation. This was what created the problem.


What I should have done:
I should have used the libMySQL50.dll provided by zeoslib
It can be found in the SVN library, at address

http://zeosdownloads.firmos.at/downloads/snapshots/

The programmer must download the latest library, in my case:
ZEOSLIB_TRUNK_REV361 of 2008-04-08.zip

In this zip file, find the relevant driver(s). In my case:
\lib\mysql\libmySQL50.dll

Install in executable path. In the iDE, for ZConnection, chose driver=MySQL50
=> Miracle ! => everything works perfectly under IDE design AND run mode, AND EXE file outside IDE.

two remarks:

1.
since libMySQL50.dll is installed, it is not in contradiction with the installation of the most recent libMySQL.dll in the same path. (Just tested)

2.
The versions displayed with a NOT working mode are:
ZConnection.ClientVersion => 5.1.23
ZConnection.ServerVersion => 5.1.23

The versions now displayed with a WORKING system are:
ZConnection.ClientVersion => 5.0.22
ZConnection.ServerVersion => 5.1.23

This might incur some restrictions about using specific 5.1 orders, but I don't believe so, at least until Zeos creates some MySQL orders specific to 5.1, directly accessible.

I suggest to the zeos team to include this (in certainly a shorter form) in the general FAQ, for crazy mistakes, for whoch the answer is not so obvious.

And, once again, many thanks to
- mdaems, for his quick help
- the whole zeos team, for their great creation.

[mdaems]

Are you sure the same dll is used in these scenario's? Use something like Filemon to make sure.
If you use the libmysql50.dll in our SVN repository or the bigger snapshot downloads you should be able to connect to mysql5.1 without trouble (I'm even using it for 6.0.4 alpha).

Mark

[olivierf77]

Dear mdaems (and Zeos team),

First, many thanks for such a quick answer.

The mysql.dll I used was the one from the Mysql download, not yours. I tried several dlls of differen date and sizes, with different results and errors occuring at different times.

I used one of your examples to display the versions used for client and server:
ZConnection.ClientVersion => 5.1.23
ZConnection.ServerVersion => 5.1.23
These are indeed the version used for sure at least in the run mode, either inside IDE or outside with the EXE.

I positioned the DLL in the BPL directory.

This DLL uses the most recent dll provided by MySQL.
However, I now realize that the most important is to use the DLL provided by ZEOS, since it is this piece of software which really communicates at binary level with zeoslib, and the communication of zeoslib/mysql.dll with the MySQL server is at a much higher level.

I will make several tries this evening with your own dll, positioned and named as required.

I will of course let you know the final result.

Once again, thank you for your quick answer

Olivier, Paris, France.

PS. What is the address of the SVN for a correct and adapted mysql(50).dll? I did find the following:
http://zeosdownloads.firmos.at/downloads/snapshots/
but it does not show clearly where is the mysql.dll. Is it included in the files to be downloaded?
I don't think so, but I may be wrong.

[wahono]

First time I use ZeosLib, I got this problem too. IMHO, you should rename libmysql.dll to libmysql51.dll. Maybe you have more than one MySQL Server with different version

wahono

[mdaems]

Just committed a couple of patches to testing branch that address this problem. (Rev. 373 - 374) Will be merged to trunk in a week. I hope some people use and test it before that date.

libmysql 5.1 also passes the test suite now the same way 5.0 does.

Mark

[ozi_lion]

Hello all i've had this error and tried to soleve it many times and finally after i installed the new version of zeosdbo 6.6.3 now everything is ok and my application is runing like new car thanks to all zeos developer team. İ suggest to everyone who encounter this error just update your zeos lib to ZEOSDBO-6.6.3-stable

[mdaems]

Inbelievable... The draft for 6.6.3-stable is just available for review by some other team members for only 6 hours and they found it...
Some disclosure : we're finishing 6.6.3-stable now. Adding changelogs, updating version information in packages, ... Please be patient for a few more days. (I renamed the files now including the word 'DRAFT-')

Before somebody starts asking : if you want to try and see what we've packaged already, download from http://zeosdownloads/downloads/snapshots/

BUT : at your own risk and it's NOT THE 6.6.3-STABLE RELEASE YET.

Mark