Limit exports

Estrella9 2010-04-19 19:23:59 UTC #1

Where to verify the statement that is generated to export the logs of the monitoring system (tracker), and since PHP file to configure the export limits, since I only exports 400 records when I have 6,000.

Leithoff_Klaus 2010-04-20 07:21:27 UTC #2

You may be able to configure this:
Admin-> site Configuration -> How many entries should non-admins be able to
export (empty = no limit, no = no export):

11:23:59 -0800 (PST)

Where to verify the statement that is generated to export the logs of the
monitoring system (tracker), and since PHP file to configure the export
limits, since I only exports 400 records when I have 6,000.

–
View this message in context:
http://n3.nabble.com/LIMIT-EXPORTS-tp730551p730551.html
Sent from the egroupware-developers mailing list archive at Nabble.com.

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

–
Stylite GmbH
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden

fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de

Geschäftsführer: Andre Keller, Gudrun Müller, Ralf Becker
Handelsregister Kaiserslautern HRB 30575
USt-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

Estrella9 2010-04-20 15:31:25 UTC #3

By going to the site configuration, this one is empty = no limit, so I can not even export my 6.500 records.

Ralf_Becker_Stylite 2010-04-20 15:51:28 UTC #4

It only means you are not running agains a programmed limit of EGroupware.

You should check your Apache error_log, maybe you get aborted because of
php.ini memory_limit or max_execusion_time …

Ralf

By going to the site configuration, this one is empty = no limit, so I can
not even export my 6.500 records.

–
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

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Estrella9 2010-04-20 19:28:13 UTC #5

Which contains the php.ini, about what I say is
Log_errors_max_len = 1024 …
memory_limit = 24M
max_execution_time = 30

in fact already and exported from the database without problem, but that no records serve me for my report, I should have to convert dates, linking tables etc. Can you help me?

Ralf_Becker_Stylite 2010-04-21 07:21:52 UTC #6

Your memory_limit and max_excution_time is very low for huge exports.
Have a look in your Apache error_log, you will find there the reason for
the abort of the export.

Anyway there are a lot resources about SQL. To convert a timestamp
column you can use: FROM_UNIXTIME(column)

Ralf

Which contains the php.ini, about what I say is
Log_errors_max_len = 1024 …
memory_limit = 24M
max_execution_time = 30

in fact already and exported from the database without problem, but that no
records serve me for my report, I should have to convert dates, linking
tables etc. Can you 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

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Estrella9 2010-04-21 16:56:20 UTC #7

I leave a few lines dew code found in error_log, there if I can help, thanks

Thu Apr 15 13:54:04 2010] [error] [client 127.0.0.1] sqlfs_stream_wrapper::stream_open(links://default/apps/tracker/6494/export.csv,w,4) NO stream, returning false!, referer: http://localhost/egroupware/etemplate/process_exec.php?menuaction=tracker.tracker_ui.edit
[Thu Apr 15 13:54:04 2010] [error] [client 127.0.0.1] PHP Warning: copy(links://default/apps/tracker/6494/export.csv) [function.copy]: failed to open stream: “links_stream_wrapper::stream_open” call failed in /var/www/html/egroupware/phpgwapi/inc/class.egw_link.inc.php on line 785, referer: http://localhost/egroupware/etemplate/process_exec.php?menuaction=tracker.tracker_ui.edit

		if (($Ok = copy($file['tmp_name'],$fname = egw_vfs::concat($entry_dir,$file['name'])) &&
			($stat = links_stream_wrapper::url_stat($fname,0))) && $comment)
		{
			egw_vfs::proppatch(parse_url($fname,PHP_URL_PATH),array(array('name'=>'comment','val'=>$comment)));	// set comment
		}
	}
	else
	{
		error_log(__METHOD__."($app,$id,$file,$comment) Can't mkdir $entry_dir!");
	}
	return $Ok ? -$stat['ino'] : false;
}

/**

Ralf_Becker_Stylite 2010-04-21 17:57:14 UTC #8

The error is from not being able to write to a file attached to a
tracker item. This has nothing to do with an export stopping …

Are you sure error-reporting is switched on on your installation?

Run tail -f /var/log/http/error_log (or whatever path error_log is on
your install), while trying an export. If you get a white screen AND
nothing is in the tail, you probably have error_reporting switched off!

Ralf

I leave a few lines dew code found in error_log, there if I can help, thanks

Thu Apr 15 13:54:04 2010] [error] [client 127.0.0.1]
sqlfs_stream_wrapper::stream_open(links://default/apps/tracker/6494/export.csv,w,4)
NO stream, returning false!, referer:
http://localhost/egroupware/etemplate/process_exec.php?menuaction=tracker.tracker_ui.edit
[Thu Apr 15 13:54:04 2010] [error] [client 127.0.0.1] PHP Warning:
copy(links://default/apps/tracker/6494/export.csv) [ function.copy
function.copy ]: failed to open stream:
"links_stream_wrapper::stream_open" call failed in
/var/www/html/egroupware/phpgwapi/inc/class.egw_link.inc.php on line 785,
referer:
http://localhost/egroupware/etemplate/process_exec.php?menuaction=tracker.tracker_ui.edit

–
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

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Estrella9 2010-04-21 20:14:48 UTC #9

If other errors appear when I run tail-f, but at the time that the export will not make me any error log appears in error_log.

or also change

Memory_limit = 60M
Max_execution_time = 300