#1027 No edit without PK when using selection criteria

[al3]

Go to 'search' screen and select several fields to display BUT NOT the primary key. Do not display the PK.

Also, you MUST select some kind of criteria on the "query by example" fields.

You will get some records displayed. Edit one via the icon. Up comes the edit screen, so make some kind of a change. Then click "go". The edit will NOT take.

However, if you do NOT make a criteria (QBE) choice, everything works fine.

If you do all the above BUT also include the PK, everything is OK.

It only screws up when you don't choose the PK to dispaly AND you make a query-by-exemple selection.

Al

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

I cannot reproduce your problem with 2.10.1. Please attach here an export of your table's structure and tell me which fields you selected to display.

[al3]

Logged In: YES
user_id=1780994
Originator: YES

Here is the table structure. If I choose compay, first, last, notes, select where select <> space I get a bunch of records. I choose edit, make a change to notes (a text field) it will not 'take'. However if I do the above and add 'key' in my query it all works. It also works when I don't do a search but just display the file (30 recs at a time.)

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 29, 2007 at 10:55 PM
-- Server version: 5.0.24
-- PHP Version: 4.4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `colonial`
--

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

--
-- Table structure for table `rancho`
--

CREATE TABLE `rancho` (
`state` varchar(20) NOT NULL,
`company` varchar(100) NOT NULL,
`sic` varchar(20) NOT NULL,
`industry` varchar(100) NOT NULL,
`first` varchar(100) NOT NULL,
`last` varchar(100) NOT NULL,
`add1` varchar(100) NOT NULL,
`add2` varchar(100) NOT NULL,
`phone` varchar(20) NOT NULL,
`city` varchar(50) NOT NULL,
`zip` varchar(10) NOT NULL,
`zip4` varchar(4) NOT NULL,
`size` varchar(10) NOT NULL,
`select` varchar(10) NOT NULL,
`notes` text NOT NULL,
`call` date NOT NULL,
`sal` varchar(10) NOT NULL,
`key` int(11) NOT NULL auto_increment,
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=518 ;

[Jürgen Wind]

Logged In: YES
user_id=1383652
Originator: NO

Hmm,
works on http://pma.cihar.com/STABLE/index.php?db=test .

Since `key` is not involved and the character set is not utf8
the "where clause" can become quite long like:
UPDATE `test`.`rancho`
SET `state` = '5567'
WHERE CONVERT( `rancho`.`state` USING utf8 ) = '556'
AND CONVERT( `rancho`.`company` USING utf8 ) = '2'
AND CONVERT( `rancho`.`sic` USING utf8 ) = '3'
----8<----
LIMIT 1 ;

Maybe you ran into some "suhosin" request size limitations or somesuch (wild guess).

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Please try the latest snapshot from trunk (2.11-dev) on http://www.phpmyadmin.net/snapshot and report here.

[SourceForge Robot]

Logged In: YES
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).