[Tikiwiki-devel] Memory errors in tiki-sheets.php

[Oliver H. <ro...@re...>]

Hello,

anyone want to fix it? And maybe look for similar requests, where the whole userdatabase is read in or whole contents of other tables?


---snip---
On 29.08.2010 13:31, Oliver Hertel wrote:

> ok, i just found and installed xdebug. Hope I can find out something.

tiki-sheets.php: $users = $tikilib->list_users(0, -1, 'login_asc', '', false);

in the edit sheet block causes the memory error.



xdebug_start_trace("trace.log", 1); // ###############################

                $users = $tikilib->list_users(0, -1, 'login_asc', '', false);

xdebug_stop_trace(); // ##############################################################



output is (see the last line):




TRACE START [2010-08-29 12:15:04]
    0.1018    3928520       +0     -> TikiLib->list_users() /web/tikiwiki.org/tiki-sheets.php:59
    0.1020    3932432    +3912       -> include_once(/web/tikiwiki.org/lib/userprefs/userprefslib.php) /web/tikiwiki.org/lib/tikilib.php:2810
    0.1020    3932504      +72         -> basename() /web/tikiwiki.org/lib/userprefs/userprefslib.php:9
    0.1020    3932576      +72         -> strpos() /web/tikiwiki.org/lib/userprefs/userprefslib.php:9
    0.1022    4071936  +139360         -> TikiLib->__construct() /web/tikiwiki.org/lib/userprefs/userprefslib.php:114
    0.1022    4072208     +272           -> time() /web/tikiwiki.org/lib/tikilib.php:46
    0.1022    4074008    +1800       -> strpos() /web/tikiwiki.org/lib/tikilib.php:2839
    0.1022    4074136     +128       -> TikiDb_Bridge->convertSortMode() /web/tikiwiki.org/lib/tikilib.php:2863
    0.1022    4074272     +136         -> TikiDb::get() /web/tikiwiki.org/lib/core/lib/TikiDb/Bridge.php:94
    0.1023    4074272       +0         -> TikiDb->convertSortMode() /web/tikiwiki.org/lib/core/lib/TikiDb/Bridge.php:94
    0.1023    4074680     +408           -> str_replace() /web/tikiwiki.org/lib/core/lib/TikiDb.php:182
    0.1023    4074880     +200           -> preg_replace() /web/tikiwiki.org/lib/core/lib/TikiDb.php:183
    0.1023    4075152     +272           -> explode() /web/tikiwiki.org/lib/core/lib/TikiDb.php:189
    0.1023    4075960     +808           -> strrpos() /web/tikiwiki.org/lib/core/lib/TikiDb.php:193
    0.1024    4076088     +128           -> substr() /web/tikiwiki.org/lib/core/lib/TikiDb.php:194
    0.1024    4076488     +400           -> preg_replace() /web/tikiwiki.org/lib/core/lib/TikiDb.php:202
    0.1024    4076688     +200           -> preg_replace() /web/tikiwiki.org/lib/core/lib/TikiDb.php:203
    0.1024    4076832     +144           -> str_replace() /web/tikiwiki.org/lib/core/lib/TikiDb.php:205
    0.1024    4077184     +352           -> implode() /web/tikiwiki.org/lib/core/lib/TikiDb.php:209
    0.1025    4077888     +704       -> TikiDb_Bridge->fetchAll() /web/tikiwiki.org/lib/tikilib.php:2879
    0.1025    4078024     +136         -> TikiDb::get() /web/tikiwiki.org/lib/core/lib/TikiDb/Bridge.php:34
    0.1025    4078024       +0         -> TikiDb_Pdo->fetchAll() /web/tikiwiki.org/lib/core/lib/TikiDb/Bridge.php:34
    0.1025    4078544     +520           -> TikiDb_Pdo->_query() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:104
    0.1025    4079192     +648             -> intval() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:53
    0.1025    4079192       +0             -> intval() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:54
    0.1026    4079408     +216             -> TikiDb->convertQueryTablePrefixes() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:59
    0.1026    4079824     +416               -> is_null() /web/tikiwiki.org/lib/core/lib/TikiDb.php:162
    0.1026    4079824       +0             -> TikiDb->startTimer() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:66
    0.1026    4079824       +0               -> microtime() /web/tikiwiki.org/lib/core/lib/TikiDb.php:35
    0.1026    4079824       +0               -> explode() /web/tikiwiki.org/lib/core/lib/TikiDb.php:35
    0.1027    4080096     +272             -> PDO->prepare() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:69
    0.1027    4080792     +696             -> is_array() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:71
    0.1027    4080792       +0             -> PDOStatement->execute() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:75
    0.5751    4083712    +2920             -> TikiDb->stopTimer() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:81
    0.5752    4084112     +400               -> microtime() /web/tikiwiki.org/lib/core/lib/TikiDb.php:42
    0.5752    4084256     +144               -> explode() /web/tikiwiki.org/lib/core/lib/TikiDb.php:42
    0.5752    4085152     +896             -> TikiDb->setErrorMessage() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:93
    0.5752    4085152       +0             -> PDOStatement->columnCount() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:94
    0.5752    4085152       +0             -> PDOStatement->fetchAll() /web/tikiwiki.org/lib/core/lib/TikiDb/Pdo.php:95
    0.6279   47243520
TRACE END   [2010-08-29 12:15:04]


We should fix all those fetchAll calls.

Oliver