Advanced listing and error 1267 on sync files

[fedeviv]

Dear staff,

i have been using Advanced folder listing and i had not encountered this issue before: when i try to sync the files inside a certain folder, i get ERROR 1267.

The files are mostly pdfs and the names contained a lot of special characters that i have taken out and renamed. I do not understand why the problem persists.

Could you tell me what ERROR 1267 stands for?

Thank you very much,

Federica Vivarelli

[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

[Michael Gilkes]

@Prabhu. Thanks for posting. I think Error 1267 relates to some kind of MySQL error. I am not sure what triggers it. Are you getting any errors in your php logs?

[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]

@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

[Michael Gilkes]

@Prabhu. Max Subfolder Level has nothing to do with the Sync files. It only relates to how deep the go when displaying the subfolders on the webpage. So, it is unrelated.

The errors you displayed earlier in your php error logs don’t related to Sync files either. The relate to displaying the listing as a paginated table. I will have to investigate that further, but it too does not relate to Sync files.

I am not sure I am understanding what is happening. Your 2 tests both completed without the error 1267 coming up. So, how often do you get this error and under what circumstance? Also, you should clear out your php logs, and then the next time you get the error, check your logs to see what PHP posted.

Could you verify what version of Advanced Folder Listing you have installed? Also your PHP version and MySQL version? Thanks.

[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

[Author]

Posts