The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Blank server error page when exporting to Excel - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Modules / Other (https://forums.formtools.org/forumdisplay.php?fid=8)
+--- Forum: Modules (https://forums.formtools.org/forumdisplay.php?fid=16)
+--- Thread: Blank server error page when exporting to Excel (/showthread.php?tid=1140)



Blank server error page when exporting to Excel - jak - Mar 23rd, 2011

Hi all,

I can't generate an Excel spreadsheet. When I attempt it, I get a blank page after the page initially hangs. What I get is a server connection error similar to when you try to access a site that isn't there. My client is freaking out. A real hothead. Need a fix fast.

Please, if there is anyone that can help it would be much appreciated. Can't seem to find the issue in the forum.

Thanks in advance.


RE: Blank server error page when exporting to Excel - jak - Mar 24th, 2011

Sorry, the export script didn't receive all the required fields and cannot proceed.

Anybody ever get the above error?

Thanks.


RE: Blank server error page when exporting to Excel - michatmaster7 - Aug 5th, 2011

I haven't gotten that error. However, I did get the blank page.

I was about to make backups (via export to Excel) of all my submission data, so that I could upgrade my core to 2.1.0. So I have about a dozen or so active forms. Of all of them, this only happens with one of the forms. In fact, it happens that I cannot generate table views of the submission data, either.

I found that if I select only 10 lines of my initial data, it will generate without a problem. But when I want to export all 2500 or so lines of data, it just hangs on a blank page. I am kind of freaking out over this, too. Did you ever find a solution?

To clarify: when clicking on Generate, a new window opens at the following URL and just sits there, blank. But only on my form with over 2400 submissions:
Code:
http://www.domain.com/formtools/modules/export_manager/export.php



RE: Blank server error page when exporting to Excel - michatmaster7 - Aug 5th, 2011

I just realized that with the Export Manager I can show the option to use a CSV file instead of XLS (I'm a little slow). So I used the CSV option to export all 2500 or so records and I get the following error message:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1550172 bytes) in /home/{domain}/public_html/formtools/global/code/general.php on line 198

Is this a limit that cannot be lifted? Do I need to export records in smaller batches, no matter what?


RE: Blank server error page when exporting to Excel - Ben - Aug 7th, 2011

Hi michatmaster,

You *can* lift the limit, yes. The Export Manager is very CPU intensive - it does a great deal of work to generate the entire contents of a View / form, so memory can become an issue.

If you have access to the server's php.ini file, try updating the memory_limit directive to something higher than it is now. If you don't have access, perhaps ask your hosting provider on how you can do a customization for your site / folder. Some hosts have the server configured to let you define your own php.ini file in a folder that overrides specific settings like that one. Other hosts let you do that, but only by including the php.ini file in a cgi-bin folder. Other (for security reasons) don't let you do that at all.

If all else fails, you may have to resort to exporting the entire content in pieces (e.g. creating Views that show date ranges, or by specific content).

Good luck!

- Ben


RE: Blank server error page when exporting to Excel - JLA - Feb 20th, 2012

(Mar 24th, 2011, 10:10 AM)jak Wrote: Sorry, the export script didn't receive all the required fields and cannot proceed.

Anybody ever get the above error?

Thanks.

I know this is an older thread, but we just had this happen to one of our installations. The problem fixed itself when I changed the global/config.php file thusly:

$g_root_url = "http://domain.org/formtools";

to

$g_root_url = "http://www.domain.org/formtools";

We had recently standardized our use of "www" but not updated the formtools url. For some reason that did the trick. Hope that is helpful.