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".
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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".
Logged In: YES
user_id=210714
Originator: YES
Fixed using $_SESSION. Might be backported.
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;
Logged In: YES
user_id=210714
Originator: YES
Yes, that's the reason, I'll complete the fix tomorrow to handle this case.
Logged In: YES
user_id=210714
Originator: YES
Should be OK now.