Help save net neutrality! Learn more.
Close

#165 Can't change table row

3.2.2
closed-fixed
MySQL (69)
5
2011-08-01
2011-06-29
Anonymous
No

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).

Discussion

  • Jakub Vrána

    Jakub Vrána - 2011-06-29

    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.

     
  • Jakub Vrána

    Jakub Vrána - 2011-06-29
    • status: open --> pending
     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-06-29

    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 has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2011-06-29
    • status: pending --> open
     
  • Jakub Vrána

    Jakub Vrána - 2011-06-29

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

     
  • Jakub Vrána

    Jakub Vrána - 2011-06-29
    • status: open --> open-accepted
     
  • Jakub Vrána

    Jakub Vrána - 2011-06-29

    Thank you for the report, I've fixed it in Git. You can download the "Current development version" from http://www.adminer.org/#download

     
  • Jakub Vrána

    Jakub Vrána - 2011-06-29
    • status: open-accepted --> open-fixed
     
  • Nobody/Anonymous

    Dík moc

     
  • Jakub Vrána

    Jakub Vrána - 2011-08-01
    • status: open-fixed --> closed-fixed
     

Log in to post a comment.