Hello,
Step 1 : CREATE TABLE `test` (`id` VARCHAR(50) not null, `txt` VARCHAR(50) not null , PRIMARY KEY (`id`), INDEX (`id`)); INSERT INTO `test` (`id`, `txt`) VALUES ('1', 'test "test" test');
Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save.
<phpmyadmin> SELECT `id`,`txt` FROM `test` WHERE 1 AND `id` LIKE "1" LIMIT 0, 30 MySQL said: You have an error in your SQL syntax near '"1" LIMIT 0, 30' at line 1 </phpmyadmin>
No problem if you key is an int. Yuk.
Regards,
Alain.
P.S : php 4.0.5, phpmyadmin cvs, mysql 3.23.39
Alain Brissaud a écrit :
Hello,
Step 1 : CREATE TABLE `test` (`id` VARCHAR(50) not null, `txt` VARCHAR(50) not null , PRIMARY KEY (`id`), INDEX (`id`)); INSERT INTO `test` (`id`, `txt`) VALUES ('1', 'test "test" test');
Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save.
Alain, I don't understand the step 2, please provide more detailed steps.
Marc
Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save.
Alain, I don't understand the step 2, please provide more detailed steps.
Marc
My pleasure : Select the "test" table in the left frame, click on the "select" link on the right frame then type 1 in the ID, then go. Then ... Click Edit (do nothing) then click save.
Btw, it's a display bug only 'cause if you change something, the change is done (but you get the warning).
Hope this helps,
Alain.
Alain Brissaud a écrit :
Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save.
Alain, I don't understand the step 2, please provide more detailed steps.
Marc
My pleasure : Select the "test" table in the left frame, click on the "select" link on the right frame then type 1 in the ID, then go. Then ... Click Edit (do nothing) then click save.
Btw, it's a display bug only 'cause if you change something, the change is done (but you get the warning).
Hope this helps,
Alain.
Ok now I can reproduce this bug. I will have a quick look at it this afternoon.
Marc
Marc Delisle a écrit :
Alain Brissaud a écrit :
Step 2 : Use phpmyadmin to Select id 1 (using tbl_select.php3), Click Edit (do nothing) then click save.
Alain, I don't understand the step 2, please provide more detailed steps.
Marc
My pleasure : Select the "test" table in the left frame, click on the "select" link on the right frame then type 1 in the ID, then go. Then ... Click Edit (do nothing) then click save.
Btw, it's a display bug only 'cause if you change something, the change is done (but you get the warning).
Hope this helps,
Alain.
Ok now I can reproduce this bug. I will have a quick look at it this afternoon.
Should be fixed in the cvs, please test.
Marc
-
Alain Brissaud -
Marc Delisle