On 19/06/12 12:22, Atul Pratap Singh wrote:
On Tue, Jun 19, 2012 at 4:40 PM, Marc Delislemarc@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:
- Open db-search tab for a database.
- Make a search by entering a keyword and selecting all tables.
- 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'.
sakila.country is linked to sakila.city. Clearly you can't have cities that don't belong to a country.
Try searching for "11" in sakila.film_actor, there will be about 300 results, all of them can be deleted successfully.
Also I didn't see any error message after the GET request.
Look at the server response in your firebug console.
sql.php is not even called in an Ajax way.