Urgent!! - Major problem in Activities

[KACP]

I have an error message within the Activities console of Sugar after trying to import Contacts to Accounts. No Activities are now shown.

Error filling in additional detail fields: Query Failed:SELECT name , assigned_user_id parent_name_owner from accounts where id = '#BO6 4U6&\'::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''#BO6 4U6&\'' at line 1

CE 5.2.0i
The version of MySQL is 5.1.22.
PHP 5.2.5
Apache 1.339

Any ideas how to fix?

[eggsurplus]

I'd recommend going into the database and either removing the offending account id or change the account id. Somehow it doesn't have a standard guid for the id. My guess is that there isn't much tied to the account so data loss should be minimal. To update to a standard guid format:

update accounts
set id = uuid()
where id = '#BO6 4U6&\\';

[KACP]

Thanks for the suggestion but it came back with: 0 row(s) affected, and didn't solve problem. Any other suggestions?

[eggsurplus]

The where clause I have may be wrong but the same idea should work if you can find another way to identify and fix the data directly in the db.