[adminer-tracker] [ adminer-Bugs and Features-3344307 ] Can't change table row

[SourceForge.net <no...@so...>]

Bugs and Features item #3344307, was opened at 2011-06-29 17:08
Message generated for change (Settings changed) made by jakubvrana
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3344307&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL
Group: 3.2.2
Status: Open
>Resolution: Accepted
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Jakub Vrána (jakubvrana)
Summary: Can't change table row

Initial Comment:
I have the table with this structure: 
id             int(11)	 
order           int(11)	 
name        varchar(127)	 
type        enum('check_success','check_fail','link','target')	 
value        varchar(1000)

and there is data rows like this in the table: 

INSERT INTO `test` (`id`, `order`, `name`, `type`, `value`) VALUES
(636,	1,	'',	'link',	'/index\\.php\\?go=addpage&catid=\\d+');

If I want to edit some value by doubleclick od table cell in Adminer, value is still the same (not edited).

----------------------------------------------------------------------

>Comment By: Jakub Vrána (jakubvrana)
Date: 2011-06-29 17:30

Message:
I accept the bug in Adminer (there should be \\\\ instead of \\) but I
suggest you to add a PRIMARY KEY (id).

----------------------------------------------------------------------

Comment By: https://www.google.com/accounts ()
Date: 2011-06-29 17:25

Message:
Pardon, až teraz som si všimol, že sem ľudia kľudne píšu aj česky
(skoro slovensky) :-) Tu je tabuľka:

CREATE TABLE IF NOT EXISTS `test` (
  `id` int(11) NOT NULL,
  `order` int(11) NOT NULL,
  `name` varchar(127) collate utf8_czech_ci NOT NULL,
  `type` enum('check_success','check_fail','link','target') collate
utf8_czech_ci NOT NULL default 'target',
  `value` varchar(1000) collate utf8_czech_ci NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

Editácia vyvolá tento SQL príkaz:

UPDATE `test` SET `value` = '+/index\\.php\\?go=addpage&catid=\\d+' WHERE 
`id` = '636' COLLATE utf8_bin 
AND `order` = '1' COLLATE utf8_bin 
AND `name` = '' COLLATE utf8_bin 
AND `type` = 'link' COLLATE utf8_bin 
AND `value` LIKE '/index\\.php\\?go=addpage&catid=\\d+' COLLATE utf8_bin 
LIMIT 1;

Ak však výraz upravím na nasledujúci, tak operácia funguje:

UPDATE `test` SET `value` = '+/index\\.php\\?go=addpage&catid=\\d+' WHERE 
`id` = '636' COLLATE utf8_bin 
AND `order` = '1' COLLATE utf8_bin 
AND `name` = '' COLLATE utf8_bin 
AND `type` = 'link' COLLATE utf8_bin
LIMIT 1;

----------------------------------------------------------------------

Comment By: Jakub Vrána (jakubvrana)
Date: 2011-06-29 17:10

Message:
Please send the SQL statement to create the table. Maybe the PRIMARY KEY is
missing (but Adminer should work even without it) or there is some other
problem.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3344307&group_id=264133