500 server error with custom importer when upgraded to php 5.6

**mc12345678** · 15 Mar 2016, 04:48 AM

Excel/reader.php

**hp09** · 15 Mar 2016, 05:53 AM

Originally Posted by mc12345678

Excel/reader.php

Sorry. Here it is.

**mc12345678** · 15 Mar 2016, 01:09 PM

Originally Posted by mc12345678

Okay, then there is a way to reference the information associated without actually typing it in and becoming more of a security risk. Have a few things to add to the files included/required to minimize the potential of the files being called/used by something outside of ZC. Will be a bit before can post it, but with regards to the Excel/reader.php file it may also reference other files that didn't make it to your new install. Look for include(, include_once(, require(, or require_once( type statements.

Originally Posted by hp09

Thanks for your help.
I checked for other require or include files, but didn't find anything else.

Originally Posted by hp09

Sorry. Here it is.

So, took a quick look through the file. Although stated above that there were no other require/include related files, I have found that Excel/reader.php has the following:

Code:

require_once 'oleread.inc';

So, did that file get transferred and what is its contents?
I also found a few other places that needed to have global variables applied in the original revision. Will post that revised version later. Also found a minor change for Excel/reader.php for it to support PHP 7.0 and maintain compatibility with PHP 5.3+. There may also be an issue with the encoding supported on your host as in Excel/reader.php there is a line: $this->setUTFEncoder('iconv'); that is choosing to use iconv for conversation instead of mb (mb_convert_encoding related function). I'm not specifically familiar with either, but it is a choice that is coded into the program and the option(s) do relate to supported server options.

**hp09** · 23 Mar 2016, 05:40 PM

Thanks again for all your help. Sorry that I've been offline for a few days. We've been moving and it took longer than expected. The file oleread.inc is on the server in the Excel directory with the reader.php file. It's attached.

**hp09** · 23 Mar 2016, 06:20 PM

My problem is still the error:
"File type is not recognized! Please try again with a valid excel file."
Line 213 in icindex.php

Using a .xls file attached.