Hi,
it’s a known problem: mysql has a fixed nesting level for subqueries.
Unfortunately the level varies a lot and I have no idea how to query it
from mysql itself.
What you can do is, change the level in your code:
phpgwapi/inc/class.sqlfs_stream_wrapper.inc.php around line 1037 in Trunk:
// MySQL 5.0 has a nesting limit for subqueries
// --> we replace the so far cumulated subqueries with their result
// no idea about the other DBMS, but this does NOT hurt …
// setting the value to 7, after reports on the user list, thought MySQL
5.0.51 with MyISAM engine works up to 10
if ($n > 1 && !(($n-1) % 7) && !($query =
self::$pdo->query($query)->fetchColumn()))
Ralf
lancelot25 schrieb:
I’ve been working since a few months and today I found a problem with the
filemanager.
I have seven levels of folders, for instance
home/PEPE/Informacion_tecnica/Desarrollo de Software/Analisis y
Diseño/Diseño/Diagramas de Clase
In the last level (Diagramas de clase), I can not upload files and it shows
the error:
Database error
Invalid SQL: SELECT * FROM egw_config WHERE config_app=‘filemanager’:
MySQL server has gone away
Click here to resume your eGroupWare Session.
However, the rest of folders I can upload files.
Somebody can help me???
–
Ralf Becker
Director Software Development
Stylite GmbH
[open style of IT]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de
www.stylite.de
www.egroupware.org
Geschäftsführer Andre Keller,
Gudrun Müller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
