Menu

#3559 (ok 3.5.1) Query error after search

3.5.0
fixed
1
2013-06-11
2012-04-11
No

1. Go to http://demo.phpmyadmin.net/master-config/
2. Click "test" database and click table name "editor" for view
3. Click "Search" tab
4. Write some exist value in the search field ("65454") and press "Go" button
5. Click field data area, write new field value in the tehtarea and try commit this change.
6. See SQL error:

----------------------------------
SQL query: Edit Edit

UPDATE `test`.`editor` SET `fieldname the comment` = '65454yy' WHERE `editor`.`fieldname` =65454 LIMIT 1

MySQL said: Documentation
#1054 - Unknown column 'fieldname
the comment' in 'field list'
----------------------------------

--
-- Table structure for table `editor`
--

CREATE TABLE IF NOT EXISTS `editor` (
`fieldname` int(5) NOT NULL COMMENT 'the comment'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `editor`
--

INSERT INTO `editor` (`fieldname`) VALUES
(678944),
(65454);

Discussion

  • Madhura Jayaratne

    • assigned_to: nobody --> madhuracj
     
  • Madhura Jayaratne

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Madhura Jayaratne

    • priority: 5 --> 1
    • summary: Query error after search --> (ok 3.5.1) Query error after search
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2012-05-07
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed