problem when removing a CCK field

I still have the problem, i corrected it by using this kind of query for deleting :

DELETE c FROM {content_complete} c INNER JOIN {node} n ON c.nid = n.nid WHERE n.type = '%s'

(Removed USING and put the name of deleting table before the FROM statement)

I don't think that using DELETE FROM work with INNER JOIN, taken from your link :

 You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT  in a multiple-table DELETE. The table_references clause lists the tables involved in the join. Its syntax is described in Section 12.2.8.1, “JOIN  Syntax”.

For the first multiple-table syntax, only matching rows from the tables listed before the FROM clause are deleted. For the second multiple-table syntax, only matching rows from the tables listed in the FROM clause (before the USING clause) are deleted. The effect is that you can delete rows from many tables at the same time and have additional tables that are used only for searching:

DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;

Or:

DELETE FROM t1, t2 USING t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;

These statements use all three tables when searching for rows to delete, but delete matching rows only from tables t1 and t2.

using 6.x-1.4 and encountered the bug

proper single-table SQL syntax should be:

DELETE FROM {content_complete} WHERE nid IN (SELECT n.nid FROM {node} n WHERE n.type = '%s')