Error in My Account Settings

[henryjiva]

Hi All,

I am getting this error in the "My Account" section of every user.

Error running count query for User List: Query Failed: ( SELECT count(*) c FROM acl_roles INNER JOIN acl_roles_users ON (acl_roles.id=acl_roles_users.role_id AND acl_roles_users.user_id='351c028a-e067-ab6b-cbac-45cb7d51df79') where ( acl_roles_users.deleted=0 AND acl_roles.deleted=0) AND acl_roles.deleted=0 )::MySQL error 1033: Incorrect information in file: './sugarcrm/acl_roles.frm'

any help???

- HL

[pblag]

Hi!

It looks like you have removed or alter tables from sugar database.
Please check table list.
Also if you still need help you can contact me.

[henryjiva]

can you please tell me how can I check the tables in the database and what to look for.

"I am a newbie in programming and Linux administration"

- HL

[pblag]

Hi!

Important if you have valuable data in your SugaCRM database please do database back up using mysql command line if not you can try to do following
Please go to Admin/Repair/Repair Database/Execute SQL

if you still have problems please email me and i'll try to help you.

[pblag]

Also there can be access problem you can try to chmode sugarcrm directory with subfolders

[Piperin]

I have a error like

Error running count query for Account List: Query Failed SELECT count(*) c FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id= '937c6d6d-3154-b577-5673-4815c604cef0' AND meetings.parent_type='Accounts' AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held')) AND meetings.deleted=0 ) UNION ALL ( SELECT count(*) c FROM tasks LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= '937c6d6d-3154-b577-5673-4815c604cef0' AND tasks.parent_type='Accounts' AND tasks.deleted=0 AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 ) UNION ALL ( SELECT count(*) c FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id= '937c6d6d-3154-b577-5673-4815c604cef0' AND calls.parent_type='Accounts' AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 ) UNION ALL ( SELECT count(*) c FROM notes LEFT JOIN contacts contacts ON contacts.id= notes.contact_id AND contacts.deleted=0 AND contacts.deleted=0 where ( notes.parent_id= '937c6d6d-3154-b577-5673-4815c604cef0' AND notes.parent_type='Accounts' AND notes.deleted=0) AND notes.deleted=0 ) UNION ALL ( SELECT count(*) c FROM emails LEFT JOIN users jt0 ON jt0.id= emails.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 INNER JOIN emails_beans ON (emails.id=emails_beans.email_id AND emails_beans.bean_id= '937c6d6d-3154-b577-5673-4815c604cef0' AND bean_module='Accounts') where ( emails_beans.deleted=0 AND emails.deleted=0) AND emails.deleted=0 ) UNION ALL ( SELECT count(*) c FROM emails LEFT JOIN users jt0 ON jt0.id= emails.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 JOIN (select distinct email_id from emails_email_addr_rel eear join email_addr_bean_rel eabr on eabr.bean_id ='937c6d6d-3154-b577-5673-4815c604cef0' and eabr.bean_module = 'Accounts' and eabr.email_address_id = eear.email_address_id and eabr.deleted=0 where eear.deleted=0 and eear.email_id not in (select eb.email_id from emails_beans eb where eb.bean_module ='Accounts' and eb.bean_id = '937c6d6d-3154-b577-5673-4815c604cef0' and eb.deleted=0) ) derivedemails on derivedemails.email_id = emails.id where emails.deleted=0 )::MySQL error 1033:

any help? All folders of sugar have full permissions....

[eNick]

Basically, your database is corrupt.


Here's a link on how to fix it...

http://dev.mysql.com/doc/refman/5.0/en/repair.html

You're probably going to need to be fairly proficient in using the command line console to do this.