[Prabhu]

@Michael,

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

[Prabhu]

@Michael,

I may have found the reason why I am getting Error 1267 on SyncFile.I was doing various test to find out the cause of the error , it turns out that “Max Subfolder Level” option to be maximum value upto 255.

I went to Joomla–>Components–>Advance Lisiting–>Listing Manager–> chose one of own test listing –> bottom of the page ,check the field “Max SubFolder Level”.

I can not change option more than 255 for subfolder. could you please let me know how change max subfolder level maximum default value.

Where earlier case I could not load more than 300MB ( files and folder) but under;

Test 1: my new test I can Sync File more than 960MB without any sub folder at all and I can see them under Joomla website.

Test 2 : I have added 300MB( files and folders) to the existing test 1 which is 960MB Files only. now sync file works (very slow ) but I can see both 300MB and 960MB files & folders all in one Joomla page.

So I suspect that Max SubFolder Level could be the reason why its causing error for 1267

Please let me know

many thanks

With regards

Prabhu

[Prabhu]

@michaelgilkes

thanks for coming back to me on this post.

I have checked under C:wamp64logsphp_error.log and i dont see any related to error-1267.however please find the below shown log on from the php_error log file; sorry i dont see option to attach my log file instead of pasting on to the post.

***Log***

[24-Apr-2017 15:55:54 UTC] PHP Notice: Undefined variable: form_id in C:wamp64wwwcomponentscom_advlistinghelpersPaginatedListingTable.Class.php on line 154

[24-Apr-2017 15:55:54 UTC] PHP Stack trace:

[24-Apr-2017 15:55:54 UTC] PHP 1. {main}() C:wamp64wwwindex.php:0

[24-Apr-2017 15:55:54 UTC] PHP 2. JApplicationCms->execute() C:wamp64wwwindex.php:49

[24-Apr-2017 15:55:54 UTC] PHP 3. JApplicationSite->doExecute() C:wamp64wwwlibrariescmsapplicationcms.php:261

[24-Apr-2017 15:55:54 UTC] PHP 4. JApplicationSite->dispatch() C:wamp64wwwlibrariescmsapplicationsite.php:230

[24-Apr-2017 15:55:54 UTC] PHP 5. JComponentHelper::renderComponent() C:wamp64wwwlibrariescmsapplicationsite.php:191

[24-Apr-2017 15:55:54 UTC] PHP 6. JComponentHelper::executeComponent() C:wamp64wwwlibrariescmscomponenthelper.php:380

[24-Apr-2017 15:55:54 UTC] PHP 7. require_once() C:wamp64wwwlibrariescmscomponenthelper.php:405

[24-Apr-2017 15:55:54 UTC] PHP 8. JControllerLegacy->execute() C:wamp64wwwcomponentscom_advlistingadvlisting.php:38

[24-Apr-2017 15:55:54 UTC] PHP 9. JControllerLegacy->display() C:wamp64wwwlibrarieslegacycontrollerlegacy.php:702

[24-Apr-2017 15:55:54 UTC] PHP 10. AdvListingViewSingle->display() C:wamp64wwwlibrarieslegacycontrollerlegacy.php:664

[24-Apr-2017 15:55:54 UTC] PHP 11. AdvListingViewSingle->setupObjectsFor() C:wamp64wwwcomponentscom_advlistingviewssingleview.html.php:70

[24-Apr-2017 15:55:54 UTC] PHP 12. Listing->processListing() C:wamp64wwwcomponentscom_advlistingviewssingleview.html.php:127

[24-Apr-2017 15:55:54 UTC] PHP 13. ListingTable->renderHTML() C:wamp64wwwcomponentscom_advlistinghelpersListing.Class.php:165

[24-Apr-2017 15:55:54 UTC] PHP 14. PaginatedListingTable->buildTable() C:wamp64wwwcomponentscom_advlistinghelpersListingTable.Class.php:44

***log***

Please let me know

thanks

– Prabhu

[Prabhu]

Hello Michael,

recently i have bought your “Advanced Folder listing” and i am using Joomla 3.6.5 and Wamp server 3.0.6 – 64bit version.

I have created a folder(C:wamp64wwwtest) with lot of files(includes pdf,doc,xls,txt and jpg) and folder (almost 300MB), later on Joomla–> Components–> Advanced Lisiting–> File Manager –>SyncFile works fine.i can see the files and folders on Joomla website perfect.

later i wanted to add more file and folder to the existing same folder location.once i added the additional files and folders(almost 700MB) then i went to Joomla–>Components–> File Manager–> SyncFile gives me error “an error has occurred: 1267 , return to the control Panel”.

could you please let me know how to fix the issue ? i have to add more files and folder to the same location now and then.

thanks

Prabhu

[Author]

Posts