Magento

I want to delete a database, but I keep on getting the following appearing:
#1217 - Cannot delete or update a parent row: a foreign key constraint fails
and the relevant files are ‘stuck!

is this a mysql or db issue?

I’d suggest to DROP DATABASE and then CREATE DATABASE if you do not have other than Magento’s tables in this database

I cant.  The database is being shared with other bits

In that case try running this before deleting tables:

and this after:

sorry to appear dim, but where do I run these from?

They are SQL commands.

Most hosts come with PhpMyAdmin (a web based database editor) which will allow you to input the commands and run them. Select your database, click on the SQL tab, enter the commands and click run.

Alternatively you can use something like SSH and the command line (PhpMyAdmin is much easier!).

this didnt work - still getting the error

With PhpMyAdmin you have to select all the tables and drop them all about 4 times until they all go.

You will get the error every time but the number of tables should decrease.

At least that’s what I found.

I have also run the after comment and got:
#1231 - Variable ‘foreign_key_checks’ can’t be set to the value of ‘0’

Moshe - 26 March 2008 08:50 AM

In that case try running this before deleting tables:

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

and this after:

SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS,0);

This worked for me but I also got the message when running the query after:-

Is that a bad thing?

I deleted so many magento db, if you select all tables and click on delete you receive that errors (but so many tables will be deleted), if you delete 1 table at once it works.
The tables that get errors are the first 4

Try to delete with “X” image x row and let me know

chiaraweb - 01 May 2008 01:30 AM

Try to delete with “X” image x row and let me know

the first 4 obviously not all

Thanks for your reply but I don’t get what you mean.

I have deleted all of the tables now (like Flowstack said in their post) it actually took a few times before they all went using phpMyAdmin.

What I am asking is now that all tables have been deleted, which I presume is because I ran the SQL query and not just because I tried deleting them several times, why doesn’t the 2nd query work and will this cause me any other problems in the future?

I’ve since then restored another database and cannot see a problem yet.