[Phpmyadmin-devel] Refactoring db_search.php

[Atul Pratap Singh]

On Tue, Jun 19, 2012 at 4:40 PM, Marc Delisle <marc at infomarc.info> wrote:

> Le 2012-06-19 06:50, Rouslan Placella a écrit :
> > On 19/06/12 11:47, Marc Delisle wrote:
> >> Le 2012-06-19 05:59, Atul Pratap Singh a écrit :
> >>> Hi Marc,
> >>> While taking a look at the Db-search functionality I noticed a bug.
> >>> Steps:
> >>> 1. Open db-search tab for a database.
> >>> 2. Make a search by entering a keyword and selecting all tables.
> >>> 3. From the 'browse' and 'delete' links in search results, select
> 'delete'
> >>> for any table.
> >>> 4. Notice that a DELETE query is sent to sql.php. But no actual
> deletion
> >>> happens.
> >>>
> >>> Regards
> >>
> >> Hi Atul,
> >> with current upstream master or your current repository, I cannot
> >> reproduce this bug.
> >>
> >> Please show us a short, sample export to reproduce the bug.
> >>
> >
> > Try searching for "pen" in sakila.actor
>
> Indeed, on the results page, trying to delete the one match in table
> "address" gives this on the first GET to sql.php, as seen with Firebug:
>
> #1451 - Cannot delete or update a parent row: a foreign key constraint
> fails (`sakila`.`customer`, CONSTRAINT `fk_customer_address` FOREIGN KEY
> (`address_id`) REFERENCES `address` (`address_id`) ON UPDATE CASCADE)
>
> Marc,
Deletion doesn't happen in a table with no foreign constraints also, like
sakila.'country'. Also I didn't see any error message after the GET request.

> sql.php is not even called in an Ajax way.
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>



-- 
Atul Pratap Singh
Senior Undergraduate Student
Institute Of Technology,
Banaras Hindu University, Varanasi,
India.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20120619/9fe085fa/attachment.html>