[ad_1]
Replies: 3
Our history group’s table of hundreds of gravestones in TablePress derives from a spreadsheet. There’s now a few more graves (!) to be added to the spreadsheet, saved as CSV, but TablePress crashes on import, with an “undefinded function” error in StringHelper.php L473. I’ll add the full details below.
I was sure this would be my spreadsheet mistake, so to check I tried to import the old CSV spreadsheet from a year ago. Same error. Then a different XLS spreadsheet. Same error. Then XSLX. Same
One thing that has changed is of course TablePress – now on version 2.0.3, whereas a year ago my import was with a version 1.n.m.
Sehr geehrter Herr Bäthge .. zu Hilfe bitte!
Here are those full details:
WordPress version 6.1.1
Active theme: Twenty Seventeen pvhg (version 1.4)
Current plugin: TablePress (version 2.0.2)
PHP version 8.0.19
Error Details
=============
An error of type E_ERROR was caused in line 473 of the file /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Shared/StringHelper.php. Error message: Uncaught Error: Call to undefined function TablePress\PhpOffice\PhpSpreadsheet\Shared\mb_convert_case() in /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Shared/StringHelper.php:473
Stack trace:
#0 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Spreadsheet.php(1049): TablePress\PhpOffice\PhpSpreadsheet\Shared\StringHelper::strToUpper()
#1 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Worksheet/Validations.php(92): TablePress\PhpOffice\PhpSpreadsheet\Spreadsheet->getDefinedName()
#2 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Worksheet/Worksheet.php(2758): TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Validations::definedNameToCoordinate()
#3 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Worksheet/Worksheet.php(1492): TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setSelectedCells()
#4 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Cell/Cell.php(606): TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->getStyle()
#5 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Reader/Csv.php(408): TablePress\PhpOffice\PhpSpreadsheet\Cell\Cell->getStyle()
#6 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Reader/Csv.php(354): TablePress\PhpOffice\PhpSpreadsheet\Reader\Csv->loadStringOrFile()
#7 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Reader/Csv.php(268): TablePress\PhpOffice\PhpSpreadsheet\Reader\Csv->loadIntoExisting()
#8 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/libraries/vendor/PhpOffice/PhpSpreadsheet/Reader/BaseReader.php(166): TablePress\PhpOffice\PhpSpreadsheet\Reader\Csv->loadSpreadsheetFromFile()
#9 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/classes/class-import-phpspreadsheet.php(176): TablePress\PhpOffice\PhpSpreadsheet\Reader\BaseReader->load()
#10 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/classes/class-import-phpspreadsheet.php(61): TablePress_Import_PHPSpreadsheet->_import_phpspreadsheet()
#11 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/classes/class-import.php(578): TablePress_Import_PHPSpreadsheet->import_table()
#12 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/classes/class-import.php(469): TablePress_Import->_load_table_from_file_phpspreadsheet()
#13 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/classes/class-import.php(95): TablePress_Import->_import_files()
#14 /var/home/packingt/pvhg.uk/wordpress/wp-content/plugins/tablepress/controllers/controller-admin.php(992): TablePress_Import->run()
#15 /var/home/packingt/pvhg.uk/wordpress/wp-includes/class-wp-hook.php(308): TablePress_Admin_Controller->handle_post_action_import()
#16 /var/home/packingt/pvhg.uk/wordpress/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#17 /var/home/packingt/pvhg.uk/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action()
#18 /var/home/packingt/pvhg.uk/wordpress/wp-admin/admin-post.php(85): do_action()
#19 {main}
thrownNo hurry – but thanks in advance from Robert