cache cause problems ?

[kalmencrm]

Hi ,

I suspect is the cache problem ,
and have a few questions ...

1. is sugarcrm store cache in db ?
2. how do i clear my cache (the one that in repair functions... do not solve what
I am facing ,
i.e. in particular ... I have clicked the sort column for account list and it caused malform of
sql and no record displayed and now WORST , it can not REVERT back to the
original , i wander where sugarcrm stored this kind of cache , I say it is a cache because
when i log in another user , without clicking the sort , it works correctly ...

I just need to find out where are those folder that is cache or tmp in folder and in tables
SO THAT IT CAN BE SAFELY REMOVE so that when i login as the problem user and go to
the account page , it will display the account list like before i click the sort column "account name"...

May be CLICKING SORT COLUMN IS A TIME BOMB , never try ...
ok , just joking...

Thanks and appreciate any help.

[julian.davis]

I'm in the same boat but this time with the Bugtracker. Loging in as two users user one gets the following sql that errors:

SELECT  bugs.id   , bugs_cstm.*, bugs.type , bugs.bug_number , bugs.name , bugs.status  , jt0.name release_name , jt0.created_by release_name_owner  , 'Releases' release_name_mod, bugs.found_in_release  , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod, bugs.assigned_user_id , bugs.system_id  FROM bugs   LEFT JOIN bugs_cstm ON bugs.id = bugs_cstm.id_c   LEFT JOIN  releases jt0 ON
jt0.id= bugs.found_in_release AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= bugs.assigned_user_id AND jt1.deleted=0
 AND jt1.deleted=0 where bugs.deleted=0 ORDER BY fixed_in_release_name DESC

but user 2 gets the following that does not error:

SELECT  bugs.id   , bugs_cstm.*, bugs.type , bugs.bug_number , bugs.name , bugs.status  , jt0.name release_name , jt0.created_by release_name_owner  , 'Releases' release_name_mod, bugs.found_in_release  , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod, bugs.assigned_user_id , bugs.system_id  FROM bugs   LEFT JOIN bugs_cstm ON bugs.id = bugs_cstm.id_c   LEFT JOIN  releases jt0 ON
jt0.id= bugs.found_in_release AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON
jt1.id= bugs.assigned_user_id AND jt1.deleted=0
 AND jt1.deleted=0 where bugs.deleted=0

The order by is the issue but cannot find where to clear it for this user.

Anyone got any ideas?????