I got a very good news 🙂 I have managed myself to resolve the problem.Please ignore my earlier post which i thought it could be the cause of the problem, but clearly it was not.
Yes, you are correct. Error 1267 was related to MySQL. i have tracked down the error which is related to Table Collation for Advanced Folder listing as shown below;
1) myphp–>Database–>my own test database–>under the table list,go to bmcb5_advlisting_fields –> Operations–> Table Option–> Collation–> change it to php server connection collation.
2)myphp–>Database–>my own test database–>under the table list,go to bmcb5_advlisting_files –> Structure–> go to “Checked_Out_Time”–>change two setting here –>Default value to “Current_TimeStamp” and also Collation setting to php server connection collation.
Later i went to Sync File and all worked fine for me and i can see full list of files and Folders.I can say that was causing Collation issue to go with Dafault vaule for Checked out Time under the tables.
Many thanks for your support
Cheers
Prabhu