range check error

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

oguzy
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 22.03.2010, 10:53

range check error

Postby oguzy » 23.03.2010, 08:59

I tried Zeos ZEOSDBO-6.6.6-stable with Delphi 7. Compiled the dbg and installed the components. I was able to connect to the local mysql database but when i entered a query i got "Range check error"

My mysql version is: 5.1.36 and i am using wamp at my system.
I installed the libmysql.dll from this address: http://delphi.about.com/gi/o.htm?zi=1/X ... /0010.php3

I tried DBGrid to see the entries at the table.

Will be happy if there is any solution.

mparak
Senior Boarder
Senior Boarder
Posts: 81
Joined: 12.09.2005, 06:51
Location: Durban South Africa
Contact:

Postby mparak » 15.02.2012, 13:21

How many fields are you selecting. ?

M
Mohammed Parak
CAD RETAIL
Durban South Africa
http://www.cad.co.za

Werner3112
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 25.05.2012, 11:42

Having the same issue

Postby Werner3112 » 25.05.2012, 11:44

Is there a limit on the number of columns/fields.

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 25.05.2012, 12:46

Werner3112,

normaly not. But actually we support only 32KB/row in \testing or \trunk and 64kb/row in \testing-egonhugeist. Which means there is no column limitation but a memory limitation..

Michael
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 11.12.2017, 13:35

Hello!
I had the same problem. There is a table in mysql where the number of columns is greater than 128, the same error occurs. How to solve it?

marsupilami
Gold Boarder
Gold Boarder
Posts: 673
Joined: 17.01.2011, 14:17

Re: range check error

Postby marsupilami » 11.12.2017, 14:51

Hello shiva4,

which verson of Zeos did you use?

With best regards,

Jan

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 12.12.2017, 07:37

Hi!
I would like to clarify. I have a table with 386 columns and this is not the limit that can be. on this amount I have an error

the version I'm using ZEOSDBO-7.1.4-stable

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 12.12.2017, 07:45

when there were 176 fields it worked

marsupilami
Gold Boarder
Gold Boarder
Posts: 673
Joined: 17.01.2011, 14:17

Re: range check error

Postby marsupilami » 12.12.2017, 09:28

Could you please try the current Zeos 7.2 from SVN?

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 12.12.2017, 15:07

Well I'll try and write about the result later

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 13.12.2017, 08:06

As it turned out, I had version 6.6.5-stable. I work with delphi5 and as I understand the version above 6.6.5 it is not supported. In any case, the delphi5 directory does not exist and it is impossible to install from another directory

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 13.12.2017, 08:41

The error appears from the ZPlainMySqlDriver module in function TZMySQL5PlainDriver.GetFieldData

Going further I found

in the module zplainMySql5 I found

MYSQL_ROW = array [00 .. $ ff] of PChar;

This is the restriction in connection with which this error arises.


I do not know if it's enough to change the code in this place and recompile the components if possible

shiva4
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 11.12.2017, 13:31

Re: range check error

Postby shiva4 » 13.12.2017, 09:06

Looked in the source files of version 7.2.0 this restriction remains.

file ZPlainMySqlConstants.pas

string

MYSQL_ROW = array [00 .. $ ff] of PAnsiChar;

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: range check error

Postby EgonHugeist » 09.02.2018, 21:23

fixed. R4171 \tesing-7.2.

Thanks for the report
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “MySQL”

Who is online

Users browsing this forum: No registered users and 0 guests