[Phpmyadmin-devel] Refactoring db_search.php

[Atul Pratap Singh]

On Tue, Jun 19, 2012 at 4:47 PM, Rouslan Placella <rouslan at placella.com>wrote:

> On 19/06/12 12:10, Marc Delisle 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)
> >
> > sql.php is not even called in an Ajax way.
>
> sql.php is being called via the evil .load()[0] method. None the less,
> it should be possible to at least show the error

Fixed the SQL results display while deleting in [0].

[0]
https://github.com/zixtor/phpmyadmin/commit/4ccf9b29b217d4dadadc496d4427695f490be7ac

> without rewriting the
> whole functionality as that will require quite a lot of changes on the
> server side as far as I can see.
>
> Bye,
> Rouslan
>
> [0]: http://api.jquery.com/load/
>
>
> ------------------------------------------------------------------------------
> 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/8d9a253d/attachment.html>