Ticket modified by Tracking System at 2010/12/17 18:02
Tracking System: Bugs
Category: MyDMS
Version: Version 1.6 (unsupported)
Status: Closed
Resolution: None
Completed: 0%
Priority: 5 - medium
Created By: rory hodgson
Assigned to: not assigned
Summary: #2587 - Error on 17th subfolder created/added/read from mydms folder table
It would appear there is a mySQL limit set that causes the mySQL output to fail at the 17th loop through the phpgw_mydms_Folders table.
apache 2.2.14
MySQL 5.0.90-community
egw 1.6.003
Behaviour:
I have a folder tree with 1400+ folders.
When I try to copy a mydms folder with more that 17 sub-folders egroupware hangs
If there are less than 17 subfolders all folders are copied ok
The 17th folder created or added causes this problem
I also get an loadxml error when the folder tree frame tries to load the same problematic folders with 17 subfolders
This is nothing to do with special chracters used in the database
After many hours of tests I have identified this as an sql limit that is set somewhere in egroupware or possibly with the SQL server itself. I found this on a forum by Ralf:
"it’s a known problem: mysql has a fixed nesting level for subqueries"
http://www.egroupware.org/forum#nabble-td689004
I made the said change in the file /home/pbi/public_html/egroupware/phpgwapi/inc/class.sqlfs_stream_wrapper.inc.php but it does not seem to have made any difference.
This makes me think that the setting needs to be reset at the SQL level instead but I am quite out of my depth here.
Could someone please try to emulate this and possibly point me in the direction of the code I need to edit to remove this limit?
Many thanks in advance
Rory Hodgson
Comment by Tracking System at 2010/12/17 18:02:
This Tracker item was closed automatically by the system. It was previously set to a Pending status, and the original submitter did not respond within 14 days.
Comment by Ralf Becker at 2010/12/03 17:48:
Dear EGroupware user,
thanks for reporting bugs back to egroupware.org.
With the new release of EGroupware 1.8.001 we also fixed many bugs. So we kindly ask you to recheck your bug reports against the new version.
If you do not respond within the next 14 days, we assume the bug no longer exist and your report will be closed automatically.
Thanks for your understanding
Ralf Becker
Stylite GmbH
linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2587&no_popup=1