Menu

#2394 (ok 2.11) Edit next row

2.10.0.2
fixed
None
1
2013-06-11
2007-03-15
No

Does not work. The next primary key is not passed to tbl_change.php.

Discussion

  • Marc Delisle

    Marc Delisle - 2007-03-15

    Logged In: YES
    user_id=210714
    Originator: YES

    In tbl_replace.php, doing
    $url_params['primary_key'][] = PMA_getUniqueCondition($res, count($row), $meta, $row);
    has no effect since at the end of tbl_replace.php, tbl_change.php is called with a "require".

     
  • Marc Delisle

    Marc Delisle - 2007-03-25
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-03-25

    Logged In: YES
    user_id=210714
    Originator: YES

    Fixed using $_SESSION. Might be backported.

     
  • Marc Delisle

    Marc Delisle - 2007-03-25
    • summary: Edit next row --> (ok 2.11) Edit next row
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Jürgen Wind

    Jürgen Wind - 2007-03-25

    Logged In: YES
    user_id=1383652
    Originator: NO

    hmmm, after edit, save and edit next on
    http://pma.cihar.com/trunk-config/sql.php?db=TEST&table=jwk
    i get:
    Error

    SQL query:

    SELECT *
    FROM `TEST`.`jwk`
    WHERE ; /* <--- empty statement */

    MySQL said:
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

    maybe because there is no primary index defined?:

    CREATE TABLE `jwk` (
    `cl_from` int(8) unsigned NOT NULL default '0',
    `cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
    `cl_sortkey` varchar(86) character set latin1 collate latin1_bin NOT NULL default '',
    `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
    KEY `cl_sortkey` (`cl_to`,`cl_sortkey`),
    KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

     
  • Marc Delisle

    Marc Delisle - 2007-03-25
    • priority: 1 --> 4
    • summary: (ok 2.11) Edit next row --> Edit next row
    • status: open-fixed --> open-accepted
     
  • Marc Delisle

    Marc Delisle - 2007-03-25

    Logged In: YES
    user_id=210714
    Originator: YES

    Yes, that's the reason, I'll complete the fix tomorrow to handle this case.

     
  • Marc Delisle

    Marc Delisle - 2007-03-26

    Logged In: YES
    user_id=210714
    Originator: YES

    Should be OK now.

     
  • Marc Delisle

    Marc Delisle - 2007-03-26
    • summary: Edit next row --> (ok 2.11) Edit next row
    • priority: 4 --> 1
    • status: open-accepted --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-08-21
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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