[patch_done] Lazarus/FPC x64, fpc 2.6.1, win64 MySQL 64Bit

wylton · Post by **wylton** » 17.02.2012, 14:36

project *** raised exception class 'EZSQLException' with message:
SQL error: You have an error in your SQL syntax; check the manuel that cooresponds to your mysql server version for the right syntax to use near 'LIKE '%'' at line 1.

in file 'D:\lazarus64\components\zeoslib\src\ZDbcMysqlUtiles.pas' at line 470.

Post by **EgonHugeist** » 17.02.2012, 23:21

Can you tell me more details about this problem? I Can't run the testsuites for fpc/dbc-layers for lazarus. So please tell me detailed your Config-details..

Best regards

EgonHugeist

wylton · Post by **wylton** » 18.02.2012, 15:27

unit Unit1;

{$mode objfpc}{$H+}

interface

uses
Classes, SysUtils, FileUtil, ZConnection, ZDataset, Forms, Controls, Graphics,
Dialogs, StdCtrls;

type

{ TForm1 }

TForm1 = class(TForm)
Button1: TButton;
ZConnection1: TZConnection;
ZQuery1: TZQuery;
procedure Button1Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ private declarations }
public
{ public declarations }
end;

var
Form1: TForm1;

implementation

{$R *.lfm}

{ TForm1 }

procedure TForm1.Button1Click(Sender: TObject);
begin
with ZQuery1 do
begin
Connection:=ZConnection1;
active:=false;
sql.Clear;
sql.Text:='select * from empresa';
open;
end;

end;

procedure TForm1.FormCreate(Sender: TObject);
begin
with ZConnection1 do
begin
ZConnection1.HostName:='localhost';
ZConnection1.User:='zeoslib';
ZConnection1.Password:='lazarus';
ZConnection1.Port:=3306;
ZConnection1.Database:='lazarus';
ZConnection1.Protocol:='mysql-5';
ZConnection1.Connect;
//ZConnection1.Connected:=true;

end;

end;

end.

wylton · Post by **wylton** » 18.02.2012, 15:28

picture2

wylton · Post by **wylton** » 18.02.2012, 15:30

picture3

wylton · Post by **wylton** » 18.02.2012, 15:33

with lazarus win32, this do fine..

wylton · Post by **wylton** » 18.02.2012, 15:36

picture4

ism · Post by **ism** » 18.02.2012, 18:32

Give example mysql database dump with example lazarus project in archive

Post by **EgonHugeist** » 18.02.2012, 19:41

wylton,
I'll try my best to help you. Can you also tell me which ClientCodePage do you use? Have you updated your Zeos-Rev.? If the thread-Rev. is right then you use my private expermintal one you have to know. And actually i'm hardly working on it. There are nearly dayly Rev-upgrades. I think it's a compatibility problem of the new FPC 2.6.

ism, are you fpc2.6 user?

Best regards

wylton · Post by **wylton** » 18.02.2012, 20:20

this is only problem of X64 fpc 2.6.. I have tested on X32 fpc 2.6.0, work fine. I haven't use any ClientCodePage in Zconnection and ZQuery.
my windows is windows 7 in chinese.
I have trid with rev943 and rev1008(?).
sorry my ingles....

wylton · Post by **wylton** » 18.02.2012, 20:28

ism wrote:Give example mysql database dump with example lazarus project in archive

que es lo que necesitas? backup mysql database con Lazarus?
en windows o Linux? para backup, puedes utilizar process de Lazarus.

Post by **EgonHugeist** » 18.02.2012, 20:48

Your english does'nt matter... Which branch have you downloaded? trunk or testing or testing-egonhugeist? If the last one then refresh your SVN... and tell me if the erreors happens again..

ism · Post by **ism** » 18.02.2012, 20:54

EgonHugeist wrote: ism, are you fpc2.6 user?

No , but I can easily install it , I am interested in the reliable work of zeosdbo (i use it in my projects) and can test it

Post by **EgonHugeist** » 18.02.2012, 21:08

ism,

which compiler is your prefered one? I need some test-developers for my private testing-branch. Some detailed bug-reports are helpfull or additional thougth...

Are you fpc or delphi user?

wylton · Post by **wylton** » 18.02.2012, 22:40

now I update to zeoslib - Revision 1017: /branches/testing..
problem is same.