7 Aug
2001
7 Aug
'01
8:44 p.m.
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
7 Aug
7 Aug
10:33 p.m.
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
8 Aug
8 Aug
1:13 a.m.
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
7:34 p.m.
Alain Brissaud a écrit :
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
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
11:03 p.m.
Marc Delisle a écrit :
Alain Brissaud a écrit :
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
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
8440
days inactive
8441
days old
5 comments
2 participants
participants (2)
-
Alain Brissaud -
Marc Delisle