Error 1030: Got error 134 from storage engine

[PhoenixD]

Hi,

So I'm not sure what the problem is, doing a delete statement that should work. I heard that it has to do with me having a MyISAM table where an InnoDB table would work.

Anyway, this is the statement:

DELETE t1
FROM rehabs t1, rehabs t2
WHERE t1.name = t2.name
AND t1.address1 = t2.address1
AND t1.address2 = t2.address2
AND t1.city = t2.city
AND t1.zip = t2.zip
AND t1.phone2 IS NULL 
AND t1.url2 IS NULL
AND t1.rehabID <> t2.rehabID

I'm using MySQL 5.0.45

The full error message:

MySQL said:
#1030 - Got error 134 from storage engine

If I remove

AND t1.phone2 IS NULL 
AND t1.url2 IS NULL

It will work, but I need those fields.

Any suggestions?