sugar5.0b , all account records disappear!

[kalmencrm]

Hi ,


I am using sugarcrm 5.0b , and i have 2 users , one is admin and one is demo1

when i login using admin and view my account list , there are around 600 ++ records and when
after I click the sorting column , at the account list , 'Account Name" ... then ALL RECORDS disappear ,
i try to use basic search , advance search no luck ... don't know what happened to all my
records , i chk using some mysql tool and see whether the table accounrts records is ok , all records
is there ... but no matter what I click , search at account list , it just won't come out ...

just not too sure whether any sessions and any search is cached and cause problems...

BUT when i use another user to login , the demo1 , the account list still can see the records...
but i dare not try to click the sorting...

is anyone of you know what went wrong , pls help , thanks.

[kuske]

Set your log level in log4php.properties to debug and checke sugarcrm.log for any errors.

log4php.appender.A2=LoggerAppenderRollingFile
log4php.appender.A2.MaxFileSize=10MB
log4php.appender.A2.MaxBackupIndex=5
log4php.appender.A2.layout=LoggerLayoutTTCC
log4php.appender.A2.layout.ContextPrinting="true"
log4php.appender.A2.layout.DateFormat="%c"
log4php.appender.A2.File=./sugarcrm.log

log4php.rootLogger=fatal, A2
//log4php.rootLogger=error, A2
//log4php.rootLogger=warn, A2
//log4php.rootLogger=info, A2
log4php.rootLogger=debug, A2

[kalmencrm]

Hi , look into the log file ...found this

SELECT contacts.id , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) as name, contacts.first_name , contacts.last_name ,
contacts.salutation , accounts.name account_name, jtl0.account_id account_id, contacts.title , contacts.phone_work
, jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod,
contacts.assigned_user_id

FROM contacts
LEFT JOIN accounts_contacts jtl0 ON contacts.id=jtl0.contact_id AND jtl0.deleted=0
LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN users jt1 ON jt1.id= contacts.assigned_user_id
AND jt1.deleted=0
AND jt1.deleted=0
where contacts.deleted=0
ORDER BY contacts.last_name ASC
ORDER BY contacts.last_name ASC Start: 0 count: 21

PLEASE CHECK ABOVE bold and underline , and seems that when i click sort column
it form the sql ORDER BY contacts.last_name ASC TWICE and then expect to see limit 0,21 but
see Start: 0 count: 21 , is this bug from sugarcrm ?

Thanks.