PHPSpreadsheet undefined function mb_strlen

Question

I got phpspreadsheet installed but am getting an error:

PHP Fatal error: Call to undefined function PhpOffice\PhpSpreadsheet\Shared\mb_strlen() in /opt/apache/htdocs/mysite/tools/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/StringHelper.php on line 469

Here is the code used to call phpspreadsheet:

require '../vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

From what I found it means the plugin mbstring isnt working/installed but my PHP says it is installed:

# php -m
[PHP Modules]
Core
ctype
curl
date
dom
ereg
fileinfo
filter
gd
hash
iconv
intl
json
libxml
mbstring
mhash
mysql
mysqli
openssl
pcre
PDO
pdo_mysql
Phar
Reflection
session
SimpleXML
SPL
sqlite3
standard
xml
xmlreader
xmlwriter
zip
zlib

[Zend Modules]

Any idea if something else is missing or how I can fix this?

Did you check this question? https://stackoverflow.com/questions/6419102/fatal-error-call-to-undefined-function-mb-strlen — Michael Heidelberg, Feb 01 '19 at 16:37
I did, and mbstring is installed in the correct php on my system. — Jason M, Feb 01 '19 at 16:48

score 1 · Answer 1 · answered Feb 01 '19 at 16:38

1

CLI configuration is separate from web configuration. Depending on your environment you have to change the php.ini file that is being used when PHP is accessed via whatever web server you use.

In order to check what is the location of the php.ini file in use, you can run phpinfo() from your web app (not CLI). The phpinfo() output will have information of php.ini file location.

answered Feb 01 '19 at 16:38

matiit

7,969
5
41
65

I verified my phpinfo() is showing the same ini file and has this in its configure command: '--enable-mbstring=shared' ' – Jason M Feb 01 '19 at 16:46
does it list mbstring module enabled? Have you restarted webserver after changing php.ini? – matiit Feb 01 '19 at 16:51
It says it is enabled per the phpinfo and php -m. Also, it was already there before I started trying to use it. I even tried a fresh install but got the 'nothing to do' since its already there. I have restarted apache just in case but did not help. – Jason M Feb 01 '19 at 16:56

score 0 · Answer 2 · answered Feb 01 '19 at 17:07

So everything points to it being installed and working, but it was still giving the error. I even verified the mbstring.so actually exists where it should be and is in the php.ini and not commented.

I tried to install it but got 'nothing to do' since its already there.

What I did to fix this is uninstall mbstring then install it again from opencsw (where I install all my php packages from).

After doing that and restarting apache again, it is no longer giving me the error.

PHPSpreadsheet undefined function mb_strlen

2 Answers2