View Issue Details

IDProjectCategoryView StatusLast Update
0020424mantisbtcsvpublic2017-01-23 14:53
Reportercproensa Assigned Tocproensa  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.3.0 
Target Version1.3.1Fixed in Version1.3.1 
Summary0020424: Export to CSV and Excel fails with large issue count
Description

When exporting a large number of issues, both CSV and excel export processes may fail due to memory limits.

In my system with default settings, for example, CSV fails at around 15k issues

TagsNo tags attached.

Relationships

related to 0020423 assignedcproensa review SQL queries with IN clauses that can break db query limits 
related to 0022234 closedcproensa Exporting more than 20000 issues, downloaded CSV file has zero bytes 

Activities

vboctor

vboctor

2015-12-26 19:39

manager   ~0052181

PR: https://github.com/mantisbt/mantisbt/pull/698

cproensa

cproensa

2016-07-30 13:47

developer   ~0053731

PR: https://github.com/mantisbt/mantisbt/pull/832
This is 698 cleaned after changing master branch

Related Changesets

MantisBT: master-1.3.x e4d257fb

2016-08-04 19:53

vboctor


Details Diff
Merge remote-tracking branch 'origin/pr/832' into master-1.3.x Affected Issues
0020424
mod - core/constant_inc.php Diff File
mod - core/filter_api.php Diff File
mod - csv_export.php Diff File
mod - excel_xml_export.php Diff File

MantisBT: master 404468dd

2016-08-04 19:54

vboctor


Details Diff
Merge remote-tracking branch 'origin/pr/832' Affected Issues
0020424
mod - core/constant_inc.php Diff File
mod - core/filter_api.php Diff File
mod - csv_export.php Diff File
mod - excel_xml_export.php Diff File

MantisBT: master-1.3.x 84f43e0f

2016-08-11 08:28

cproensa

Committer: dregad


Details Diff
Fix error for excel export page

Fix an error introduced by commit f233869f, that makes
excel_xml_export.php throw an error when exporting issues.

Issue 0020424

Signed-off-by: Damien Regad <dregad@mantisbt.org>
Affected Issues
0020424
mod - excel_xml_export.php Diff File

MantisBT: master-1.3.x b08cafe9

2016-08-15 15:22

cproensa

Committer: dregad


Details Diff
Remove undeclared variables from excel, csv export

The undeclared variables were introduced by error after rebasing PR from
Issue 0020424
Affected Issues
0020424
mod - csv_export.php Diff File
mod - excel_xml_export.php Diff File

MantisBT: master-1.3.x 4d160125

2016-08-19 17:02

cproensa

Committer: dregad


Details Diff
Fix querying zero projects

Fix the new api functions, to support the case when a user doesn't have
any accessible project. In this case the filter query can't be built, so
fix returning empty values.

Affected functions were introduced in relation to Issues 0020424, 0021072.
Affected Issues
0020424, 0021072
mod - core/database_api.php Diff File
mod - core/filter_api.php Diff File
mod - core/history_api.php Diff File