[Phpmyadmin-devel] Refactoring db_search.php
Atul Pratap Singh
atulpratapsingh05 at gmail.com
Tue Jun 19 14:57:39 CEST 2012
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
> >>>> for any table.
> >>>> 4. Notice that a DELETE query is sent to sql.php. But no actual
> >>>> 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() method. None the less,
> it should be possible to at least show the error
Fixed the SQL results display while deleting in .
> without rewriting the
> whole functionality as that will require quite a lot of changes on the
> server side as far as I can see.
> : 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
Atul Pratap Singh
Senior Undergraduate Student
Institute Of Technology,
Banaras Hindu University, Varanasi,
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers