#13 Error when editing an entry from a subset

Hi,

I get an error if I:
- select a subset of rows with the 'select' option, or
by a given query
- edit a single entry
- save it

Phpmyadmin wants to return to the subset of rows and
gives this error:

Warning: Supplied argument is not a valid MySQL result
resource
in /home/projects/phpmyadmin/phpmyadmin.openeye.nl/sql.
php3 on line 72

Database openeye - table CommInfo
Error
SQL-query:

SELECT Id,Value from CommInfo where 1 and Value like
MySQL said: You have an error in your SQL syntax
near '' at line 1
Back

This is not a valid query indeed...

Thanks,
Stijn.

[Loïc Chapeaux]

Logged In: YES
user_id=144058

Hi Stijn!

Would you please try the latest version from the CVS and
tell us whether you face the bug or not?

Regards,
Loc

[Anonymous]

Logged In: YES
user_id=55395

Dear all,

I guess I have to tell you the problem still exists (cvs
checkout may 31). Some more details, so you can try it
yourselves (or tell me what I'm doing wrong...):

1) Create a test database

CREATE TABLE frop (
id tinyint(4) NOT NULL auto_increment,
test varchar(50) NOT NULL,
PRIMARY KEY (id)
);

2) Fill it with bogus data

INSERT INTO frop VALUES ( '1', 'test3');
INSERT INTO frop VALUES ( '2', 'lalala');
INSERT INTO frop VALUES ( '3', 'again');
INSERT INTO frop VALUES ( '4', 'test4');

3) Click on 'select' and for the query by example,
type "test%" for the 'test' column

4) The result should be (of course) 2 rows for the data
above

5) Edit a row, e.g. to change 'test4' into 'test5'

6) Click save

7) I get this result back

Warning: Supplied argument is not a valid MySQL result
resource in /home/projects/phpmyadmin/phpmyadmin-cvs-
20010531/sql.php3 on line 77

Database test - table frop
Error
SQL-query:

SELECT id,test from frop where 1 and test like
MySQL said: You have an error in your SQL syntax near '' at
line 1
Back

Hope this helps!

Regards,
Stijn

[Marc Delisle]

Logged In: YES
user_id=210714

fixed in both cvs