Dear community,

I upgraded Sheetnode to the beta4 version and tried to enter the TCPDF path in the PHPExcel module settings. The PHPExcel path which I entered in the beta3 version is found, but when I try to save the settings page, I get a blank page and the changes are not made.
It seems that the rest of the module is working fine.

Does anyone else have this problem and found a solution to it?

Thank you in advance for your help.

Regards,
rapport

Comments

rapport’s picture

This is the error message from the Apache error log when I click on the submit button on page admin/config/content/sheetnode/phpexcel, with both entered paths, PHPExcel and TCPDF:

[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP Fatal error:  Undefined class constant 'PDF_RENDERER_TCPDF' in /Data/pubtest/statistik_2012/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.module on line 269, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP Stack trace:, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   1. {main}() /Data/pubtest/statistik_2012/index.php:0, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   2. menu_execute_active_handler() /Data/pubtest/statistik_2012/index.php:21, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   3. call_user_func_array() /Data/pubtest/statistik_2012/includes/menu.inc:517, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   4. drupal_get_form() /Data/pubtest/statistik_2012/includes/menu.inc:517, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   5. drupal_build_form() /Data/pubtest/statistik_2012/includes/form.inc:131, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   6. drupal_process_form() /Data/pubtest/statistik_2012/includes/form.inc:374, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   7. drupal_validate_form() /Data/pubtest/statistik_2012/includes/form.inc:846, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   8. _form_validate() /Data/pubtest/statistik_2012/includes/form.inc:1134, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP   9. form_execute_handlers() /Data/pubtest/statistik_2012/includes/form.inc:1404, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel
[Sat Dec 15 12:48:49 2012] [error] [client 192.168.99.10] PHP  10. _sheetnode_phpexcel_settings_validate() /Data/pubtest/statistik_2012/includes/form.inc:1464, referer: http://pubtest.petermann.private/statistik_2012/admin/config/content/sheetnode/phpexcel

Thanks in advance for your help.
Regards,
rapport

wmdickson’s picture

More or less same problem here. Server Error whenever I submit values for those two fields. I like the idea of sheetnode, but it is unusable (for me) in this state.

wmdickson’s picture

More info. As an attempted workaround, since the ckeditor path works fine, I set it to the PHPExcel path, then copied that row in the database to a new row called (I was guessing here) sheetnode_phpexcel_library_path, and did the same for tcpdf. Then changed ckeditor back to its correct value.

Then load up the config page for the phpexcel and tcpdf path. No dice. The boxes are still blank there.

EDIT: I see now that tcpdf is probably called "sheetnode_phpexcel_pdf_renderer_path". Doesn't help.

LAST EDIT: I uninstalled (which was a bit ugly but managed to clean everything up), installed the dev version, and that seems to be fine.

nothinghere’s picture

I have same problem.

This problem :

Fatal error: Class 'PHPExcel_Settings' not found in /xyz/xyz/public_html/projets/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.module on line 267

If I uninstall, I think I lost all my data ? I can't do that ...

infojunkie’s picture

Version: 7.x-1.0-beta4 » 7.x-1.x-dev
Issue summary: View changes

Fixed in the latest dev as per #1067254: PHP Excel path.

infojunkie’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.