sheet graph engine fatal error (timeout) - abstract.gridbased.php on line 444
- Status
- Closed
- Subject
- sheet graph engine fatal error (timeout) - abstract.gridbased.php on line 444
- Version
- 12.x Regression
- Category
- Regression
- Feature
- Spreadsheet
- Resolution status
- New
- Submitted by
- Xavier de Pedro
- Lastmod by
- Xavier de Pedro
- Rating
- Description
That used to work in 6.x at least.
I created a simple sheetfoo 1 bar 2 yeah 3 toto 4
And wanted to create a simple scatter plot. I did select the required options, in this urland got this error message:
Copy to clipboard( ! ) Fatal error: Maximum execution time of 90 seconds exceeded in /var/www/12.x/lib/graph-engine/abstract.gridbased.php on line 444 Call Stack # Time Memory Function Location 1 0.0015 307504 {main}( ) ../tiki-graph_sheet.php:0 2 0.1446 13397672 Graphic->draw( ) ../tiki-graph_sheet.php:160 3 0.1447 13407536 GridBasedGraphic->_drawContent( ) ../core.php:305 4 0.1449 13420336 GridBasedGraphic->_drawScales( ) ../abstract.gridbased.php:51 5 0.1450 13422144 LinearGridScale->getSize( ) ../abstract.gridbased.php:91 6 0.1450 13423168 LinearGridScale->_calculateSkip( ) ../abstract.gridbased.php:435
I've reproduced it in show.t.o
u: admin
p: 12345- Go to http://xavi-9794-4890.show.tikiwiki.org/tiki-graph_sheet.php?sheetId=1
- and choose multiline
- Then add the basic params, as in the screenshot, and click at "show":
- Error message:
Copy to clipboardFatal error: Maximum execution time of 30 seconds exceeded in /var/www/xavi-9794-4890/lib/graph-engine/abstract.gridbased.php on line 444
- Workaround
I can't seem to fix this but the problem is that you are trying to draw a graph line from string data, i think.
If you add another column of numbers, and use the 2 numeric columns to draw the graphs with it works ok.
Can't seem to find a better fix in the code - the problem line tries to execute:
while( $size > $space * ++$skip )
without checking if the values are numeric or checking if it ever returns - bad (but very old) code
UPDATE: You are right Jonny. My confusion. Changing chart type to bar chart, or adding a new numeric column for the scatter plot fixed my issue.
Thanks!- Importance
- 5
- Easy to solve?
- 1 difficult
- Priority
- 5
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 4890
- Created
- Thursday 07 November, 2013 17:40:23 UTC
by Xavier de Pedro - LastModif
- Monday 18 November, 2013 14:51:06 UTC