On Tue, Jun 19, 2012 at 4:47 PM, Rouslan Placella <rouslan@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@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.