phpMyAdmin / Bugs / #1832 (in 2.7.0) Chance you have found bug in the SQL parser

Carlos Pérez - 2005-10-22

Logged In: YES
user_id=1204910

I did another query from the upper part of the query window
(not a batch file) and got this message back:
------------------------------------------------------------------------------------------------------------------------------------
SQL query:

INSERT INTO VARIABLES SET TesisNumero = '1',
TesisFecha = '2004-07-12',
TesisAutor = 'Edgar Alayn, Greicy Bonaldy, Deyvis Febres,
Belkis Valera',
TesisTitulo = 'MANUAL DE NORMAS Y PROCEDIMIENTOS EN LA
UNIDAD DE ADMINISTRACIN DE CONTRATOS DE LA EMPRESA ALAR
ALARMA, C.A.',
TesisDetalles = 'Normalizacin del Procedimiento de
Facturacin del Departamento de Administracin de la Empresa
Impotec, C.A. Autores: Alcega Rene, Aray Rubn,
Menndez Paula, Silva Jutmila, (2003)',
TesisTeoria = 'Teora Clsica Teora de la
Normalizacin Manuales',
TesisTutor = 'Yajaira La Cruz de Prez'

MySQL said:
-----------------------------------------------------------------------------------------------------------------------------------
As you can see, on the last line there is no MASQL said.

Also notice that the accented characters are correctly written.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-10-22

Logged In: YES
user_id=1204910

One more thing.

I tried to update the table using the batch mode and could
not get the accented characters to be saved correctly.

I always got back strange characters instead of the accented
characters.

I tried using the batch file mode set to ( ascii, latin1,
latin2, latin5 & latin 7) all this settings and never worked.

The only way to update correctly the table is via the upper
part of the sql window.

Bellow is a sample of what I get back when I tried the bacth
mode and after the correct output from the upper part of the
window.
BEGIN BATCH MODE RESPONSE USING utf8
---------------------------------------------------------------------------------------------
SQL query:
INSERT INTO Tesis SET TesisNumero = '1', TesisFecha =
'2004-07-12', TesisAutor = 'Edgar Alay�n, Greicy Bonaldy,
Deyvis Febres, Belkis Valera', TesisTitulo = 'MANUAL DE
NORMAS Y PROCEDIMIENTOS EN LA UNIDAD DE ADMINISTRACI�N DE
CONTRATOS DE LA EMPRESA ALAR ALARMA, C.A.', TesisDetalles =
'Normalizaci�n del Procedimiento de Facturaci�n del
Departamento de Administraci�n de la Empresa Impotec, C.A.
Autores: Alcega Rene, Aray Rub�n, Men�ndez Paula, Silva
Jutmila, (2003)', TesisTeoria = 'Teor�a Cl�sica
Teor�a de la Normalizaci�n
Manuales', TesisTutor = 'Yajaira La Cruz de P�rez'; #
Affected rows:1 INSERT INTO Tesis SET TesisNumero = '2',
TesisFecha = '2004-07-12', TesisAutor = 'Harry J. Anderson
Hern�ndez, Eva A. Chirino Valido, Jos� A. Rinc�n Araque',
TesisTitulo = 'DISE�O DEL MANUAL DE NORMAS Y PROCEDIMIENTOS
PARA EL PROCESO DE RECLAMO DE FIDEICOMISO, CAJA DE AHORRO Y
AHORRO HABITACIONAL DE LA UNIDAD DE SERVICIOS SEGMENTADOS
DEL BANCO MERCANTIL', TesisDetalles = 'Elaboraci�n de un
Manual de Normas y Procedimientos para el proceso de
Atenci�n Telef�nica del Centro de Atenci�n Mercantil,
Caracas, seg�n las Normas ISO 9002. etc, etc, etc.
----------------------------------------------------------------------------------------
END BATCH MODE RESPONSE USING utf8

BEGIN BATCH MODE RESPONSE USING UPPER PART OF THE SQL WINDOW
---------------------------------------------------------------------------------------------
SQL query:
INSERT INTO Tesis
SET TesisNumero = '1',
TesisFecha = '2004-07-12',
TesisAutor = 'Edgar Alayn, Greicy Bonaldy, Deyvis Febres,
Belkis Valera',
TesisTitulo = 'MANUAL DE NORMAS Y PROCEDIMIENTOS EN LA
UNIDAD DE ADMINISTRACIN DE CONTRATOS DE LA EMPRESA ALAR
ALARMA, C.A.',
TesisDetalles = 'Normalizacin del Procedimiento de
Facturacin del Departamento de Administracin de la Empresa
Impotec, C.A. Autores: Alcega Rene, Aray Rubn, Menndez
Paula, Silva Jutmila, (2003)',
TesisTeoria = 'Teora Clsica Teora de la
Normalizacin Manuales',
TesisTutor = 'Yajaira La Cruz de Prez';# Affected rows:1
etc, etc, etc.
----------------------------------------------------------------------------------------
END BATCH MODE RESPONSE USING USING UPPER PART OF THE SQL
WINDOW.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-10-25

Logged In: YES
user_id=1204910

Today I had another problem with the same situation.
I tried the following query:
----------------------------------------------------------------------------------------------
INSERT INTO `Variables` VALUES ( 'N', 'Frame',
'EneIndexF05.php', 'Desc.En-08',
'',
' It''s main function is to coordinate the Transmission
Vice Presidency operations in reference to financial, human
resources and administrative procedures, to constitute a
base for key decision making in the different processes of
the business. Assess, consolidate and propose financial
information to the Transmission Vice Presidency, Operational
Units and Corporate Finances in accordance with Generally
Accepted Accounting Procedures and the Company corporative
Norms.
 Finances and Support also provides to the
Transmission Vice Presidency with on time and efficient
services in reference to Human Resources, Cash,
Acquisitions, Warehouse and Sales to Third Party companies.',
'2004-11-01 00:00:00', '2005-10-24 00:00:00' );
----------------------------------------------------------------------------------------------
and got this answer back
Server: My Personal Web Server - Database: Energia -
Table: Variables "Variables a usar en todo el
Sistema/Aplicacin"
Error
SQL query:
INSERT INTO `Variables`
VALUES (
'N', 'Frame', 'EneIndexF05.php', 'Desc.En-08', '',
' It''s main function is to coordinate the
Transmission Vice Presidency operations in reference to
financial, human resources and administrative procedures, to
constitute a base for key decision making in the different
processes of the business. Assess, consolidate and propose
financial information to the Transmission Vice Presidency,
Operational Units and Corporate Finances in accordance with
Generally Accepted Accounting Procedures and the Company
corporative Norms. Finances and Support
also provides to the Transmission Vice Presidency with on
time and efficient services in reference to Human Resources,
Cash, Acquisitions, Warehouse and Sales to Third Party
companies.', '2004-11-01 00:00:00', '2005-10-24 00:00:00'
)
MySQL said:
----------------------------------------------------------------------------------------------
The problem is that My sql error should have stated that the
key already existed in the table due that that was the
condition.
Instead there is NO Mysql response as it does normally.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-03

assigned_to: nobody --> lem9
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-03

assigned_to: lem9 --> nobody
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-03

Logged In: YES
user_id=210714

Development note: accented characters are not detected
correctly when expressed in UTF-8.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sebastian Mendel - 2005-11-07

Logged In: YES
user_id=326580

im sorry, but can someone give me a hint? i can not
reproduce any of the erros mentioned here, i always get
correctly MySQL errors back.

tested with MySQL 4.0.24; 4.1.7; 4.1.15; 5.0.15;

can someone cut down this problem to the core? a little dump
with a little SQL, what should happen and what is happen?

can this problem be a misconfiguration?

Carlos Prez: can you please provide your collations (from
PMA start page or/and server variables)

btw. it would be nice if the sqlparser error output also
holds the collations (server, client, connection, db?, table?)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-07

Logged In: YES
user_id=210714

Sebastian,
I cannot reproduce this bug under my test systems either,
but Mr. Perez gets the bug anyway.

If you take the encoded message and feed it to
scripts/decode_bug.php, you'll see on which string the
parser chokes.
Then in sqlparser.lib.php, in the "Checks for something
inside quotation marks", there is a loop that is supposed to
find the closing quote. It finds it without problem on my
systems. The data between positions 349 and 996 is found.

I don't know what sets $GLOBALS['PMA_strpos'] but maybe on
Mr. Perez system, it's different than on ours.

I don't know if it's related, but
string.lib.php/PMA_STR_isAccented() is not UTF-8 compatible,
I think.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-07

First - SQL input area

01Sql.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-07

Sql query screen Answer

02Sql.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-07

PhpMyAdmin Settings

01Config.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

PhpInfo details

PhpInfo.xls

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

PhpMyAdmin configuration file

config.inc.php

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

Logged In: YES
user_id=1204910

In response to lem9 and cybot_tm.
First in response to lem9 comment as of 2005-11-03
Development note: accented characters are not detected
correctly when expressed in UTF-8.
The error occurs (not always) no matter if it is from a file
or the sql window. When issued the update forma window I
have attached 2 images of the problem. The images are 01Sql
and 02Sql.

Second. in response to cybot_tm I have attached an image
with the PhpMyAdmin start page (01Config.png), an Excel file
with the PhpInfo (PhpInfo.xls), my PhpMyAdmin config file
(config.inc.php) and my php.ini file.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sebastian Mendel - 2005-11-08

Logged In: YES
user_id=326580

can you plaese try to upgrade your mysql client lib, (usally
in windows/system32/libmysql.dll) with the one from your php
folder?

and just to be safe, did you tried any other mysql
connection collation than latin1_spanish_ci? f.e
utf8_spanish_ci?

and last can you please attach the output of
print_r($GLOBALS), best inserted somewhere in
footer.inc.php? (but remove sensitive information!)

thanks for your patiance!

lem9: you dont know _what_ sets $GLOBALS['PMA_strpos']? or
you dont know what is it set to?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-08

Logged In: YES
user_id=210714

Sebastian,
when I wrote my message, I did not know where it was set but
now I know :) I guess that in his case, it contains
'mb_strpos' and there is a problem with it on PHP 4.4.0/WinNT.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

Globals for PhpMyAdmin

PhpMyAdminGlobals.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

Logged In: YES
user_id=1204910

For cybot_tm;

ONE: I have attached a file PhpMyAdminGlobals.php with the
globals variables as you requested.

TWO: There is NO libmysql.dll in NONE of the directories
within the PHP installation, so I can't do what you requested.

THREE: I haven't tried any other collation, I can try BUT, I
have this very same installation in my laptop, and also the
same definition under Linux FEDORA CORE 3 (open source) and
also under Linux FEDORA REDHAT (licensed) installed under
different servers (HP and IBM) in the company in which I
work and in them I don't have this problem.
The main difference is the versions installed which are:
(PhpMyAdmin 2.6.3-pl1, mysql version 4.0.20a-nt in windows
in the installations WITHOUT problems)
(PhpMyAdmin 2.6.4-pl3, mysql version 4.1.13a-nt in windows
in the installation WITH problems).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sebastian Mendel - 2005-11-08

Logged In: YES
user_id=326580

and do your installation without problems also use MySQL
3.23.x client lib?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

Logged In: YES
user_id=1204910

TO cybot_tm in response to Date: 2005-11-08 13:02

I really don't understand this question
and do your installation without problems also use MySQL
3.23.x client lib?
I use mysql as a server not as a client so I don't know
where or what to look for.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-08

Logged In: YES
user_id=210714

Mr Perez: in your phpinfo.xls you attached here, you can see
in the "mysql" section "Client API version 3.23.49".

You use MySQL as a server, but the web server is a client
for the MySQL server, and uses this library, which is quite
old and could explain your problems.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-08

Logged In: YES
user_id=1204910

TO lem9 in response to Date: 2005-11-08 16:39
Yes in my other window installation it's the same mysql version.

This install, the one with the machine with problems is
MySql version
4.1.13, it's an auto install downloaded from the MySql web
page it's name is mysql-4.1.13a-win32.zip and if any of the
libraries is old it's nothing I can do to fix it, THIS IS A
SETUP, AUTOINSTALL program in which I can't select nothing
special about libraries or dll or any other stuff.

Furthermore, I DOUBT that the problem is a MySql problem due
to the fact that if I do any or all of the queries involved
in this problem at the command line, I get always the
correct response from mysql.
MORE: I have other tables which are to big, and I have to
update them via CLI, I have done the updates, I have
commited erros like duplicating the same query and I allways
get back some kind of answer that corresponds to the error I
did so I allways know what to do.

MORE the error (SINCE MY FIRST INPUT) is not an error
detected by mysql but an error programed INTO PhpMyAdmin so
you should look into the code to see what is going on and
not trying to blame my installation or the versions f mysql
installed.

MORE I have a few morre errors that I have with THIS version
of PhpMyAdmin which I haven't sent because this one is still
open.

MORE: this kind of problem did not happende with the version
before this one, I had the very same installation, and THE
PROBLEMS BEGAN WITH THIS VERSION of PhpMyAdmin.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sebastian Mendel - 2005-11-09

Logged In: YES
user_id=326580

We dont try to blame your installation for the errors you
get, but we can not reproduce your problem - i tested with
MySQL 4.0 4.1 and 5.0 with latest phpMyAdmin on Windows XP
and PHP 5.0.4 - so we try to find whats special on your
installation what makes this error occur in phpMyAdmin.

The client lib is the library (under Windows a .dll) which
is used by PHP to connect to the MySQL server, this file is
not installed by MySQL it comes with PHP - but PHP 4.4.0
does not have this version you reported so it seems that you
have an old version of this lib on your system.

btw. did you took a look into the source of the outputed
html when the 'mysql said error' is empty? possible
something prevents just from displaying.

Thanks for your patiance.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Pérez - 2005-11-09

Logged In: YES
user_id=1204910

Which (specifically) is the .dll I should look for to see
it's date and verify.
You have never told me it's name.

At this moment I'm online with 4 installations (2 windows
XP, 2 Linux RedHat Licensed)so I can do a lot of search.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2005-11-09

Logged In: YES
user_id=210714

Mr Perez, you wrote:
"The main difference is the versions installed which are:
(PhpMyAdmin 2.6.3-pl1, mysql version 4.0.20a-nt in windows
in the installations WITHOUT problems)
(PhpMyAdmin 2.6.4-pl3, mysql version 4.1.13a-nt in windows
in the installation WITH problems)."

So, how can you say:
"MORE: this kind of problem did not happen with the version
before this one, I had the very same installation, and THE
PROBLEMS BEGAN WITH THIS VERSION of PhpMyAdmin."

Based on what you are telling us, you changed the MySQL
version AND the phpMyAdmin version.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(in 2.7.0) Chance you have found bug in the SQL parser

A software tool to bring MySQL to the Web

Group

Searches

Help

#1832 (in 2.7.0) Chance you have found bug in the SQL parser

Discussion