Unable to delete contacts

[jcb23]

Windows XP and Vista
Sugar 5.0.0b
Apache 2.2.4
PHP: 5.2.3-1ubuntu6.3
MySQL Server: 5.0.45-1ubuntu3.3

I'm having trouble deleting contacts. When I click select all records and then hit delete i get this error message:
"Query Failed:SELECT contacts.*,email_addresses.email_address, accounts.name as account_name, users.user_name as assigned_user_name , contacts_cstm.* FROM contacts LEFT JOIN users ON contacts.assigned_user_id=users.id LEFT JOIN accounts_contacts ON contacts.id=accounts_contacts.contact_id LEFT JOIN accounts ON accounts_contacts.account_id=accounts.id LEFT JOIN email_addr_bean_rel on contacts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Contacts' and email_addr_bean_rel.primary_address=1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c where ( where contacts.deleted=0) AND ( accounts.deleted IS NULL OR accounts.deleted=0 ) AND contacts.deleted=0 AND (accounts_contacts.deleted IS NULL OR accounts_contacts.deleted=0) ::MySQL error 1064:"

When I click select this page and hit delete it just reloads the page of contacts without deleting any of them. I've installed the Enhanced Search module and the latest version of the Power Prospecting module I don't know if either of those caused the problem for some reason. Any suggestions?

[Markku]

Have you upgraded your system lately? I suggest you to run repair relationships on admin panel and see if it helps.

There seem to be several threads that concern "error 1064", please search the forum.

[kenshiro]

Hi,
it seems to have nothing to do with Enhanced Search, but you can try again after having uninstalled it, just to be sure.

[jcb23]

Have you upgraded your system lately? I suggest you to run repair relationships on admin panel and see if it helps.

There seem to be several threads that concern "error 1064", please search the forum.

I ran repair relationships and am still having the problem. And I actually did search the forum before posting this message, but none of the threads about error 1064 had to do with the problem I'm having. I believe my system has been upgraded lately as well.

[andopes]

Hi, jcb23


Run this query in phpMyAdmin
It will display more details about the error.

Cheers