Problems with PHP7.2

[kevin201]

It's such a shame that this project seems to have been abandoned. It's such a great package!

I've just been through an exercise to update an old instance (2014) to work with PHP7.2, which, I think, would only require some tweaks in the composer.lock file to work again straight out of the box. (before I was getting white screens or "Warning: count(): Parameter must be an array or an object that implements Countable" errors)

I've even managed to cobble together a function in the PhpReportType.php file to enable dynamic dropdown headers from my SQL data.

I haven't found anywhere other than here where the author might be watching, (the old support forum seems to be defunct) so I thought I'd post this here in case.

[hellifiknow]

I have been able to update it to work with PHP 7.2, so I may be able to help. What version of Twig and Flight are you using?

[kevin201]

I'm not at work at the moment, but if I recall correctly the main problem was solved by relaxing the requirements in the lock file. I couldn't get Twig 2 to play, but a later version of 1.x worked ok. Any more info on what tweaks you made would be interesting.

[kevin201]

Twig: const VERSION = '1.24.1-DEV'; Flight: 1.2.20

[apropos]

@kevin201 can you please post composer files that work with php 7.2?

[hellifiknow]

@kevin201 Try upgrading the version of Flight you are using to 1.3.7 and upgrade the version of Twig you are using to 1.37.1.

[apropos]

I keep getting the following error. PHP Fatal error: Cannot declare class Flight, because the name is already in use in /var/www/xxxx/vendor/mikecao/flight/flight/Flight.php on line 53

[hellifiknow]

@apropos What version of Flight are you using?

[apropos]

I figured out the problem with class declaration. Removing Flight from autoload solved it.

@hellifiknow the one you suggested, 1.3.7 and Twig 1.37.1 "require": { "twig/twig": "1.37.1", "swiftmailer/swiftmailer": "5.", "mikecao/flight": "1.3.7", "jdorn/sql-formatter": "dev-master", "jdorn/file-system-cache": "dev-master", "phpoffice/phpexcel": "dev-develop", "adodb/adodb-php": "dev-master", "lespoilus/spyc": "dev-master", "google/apiclient": "1.0.@beta" },

[apropos]

@hellifiknow thanks for the help. Now the problem I'm having is following.

500 Internal Server Error Trying to get property 'report' of non-object (8)

#0 /var/www/html/xxx/data_reports/lib/PhpReports/PhpReports.php(189): flight\Engine->handleError(8, 'Trying to get p...', '/var/www/html/w...', 189, Array) #1 /var/www/html/xxx/data_reports/index.php(82): PhpReports::displayReport('daily_gross_rep...', 'html') #2 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(169): {closure}('html') #3 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(145): flight\core\Dispatcher::callFunction(Object(Closure), Array) #4 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/Engine.php(340): flight\core\Dispatcher::execute(Object(Closure), Array) #5 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(198): flight\Engine->_start() #6 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(144): flight\core\Dispatcher::invokeMethod(Array, Array) #7 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(49): flight\core\Dispatcher::execute(Array, Array) #8 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/Engine.php(92): flight\core\Dispatcher->run('start', Array) #9 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(198): flight\Engine->__call('start', Array) #10 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/Flight.php(77): flight\core\Dispatcher::invokeMethod(Array, Array) #11 /var/www/html/xxx/data_reports/index.php(102): Flight::__callStatic('start', Array) #12 {main}

[hellifiknow]

Try clearing out the cache directory. Possibly it was cached before you updated and the cache has an old version.

[apropos]

i remove the whole vendor directory and do composer update --no-dev each time.

[hellifiknow]

There is a directory that gets created named 'cache' at the same level as the vendor directory. Just run sudo rm -r cache to clear it out.

[apropos]

@hellifiknow I've reinstalled php-reports and that seems to have fixed the issues. Thanks so much for the help!

[hellifiknow]

@apropos Cool! Glad I could help.

[eotin]

@hellifiknow thanks for the help. Now the problem I'm having is following.

500 Internal Server Error Trying to get property 'report' of non-object (8)

#0 /var/www/html/xxx/data_reports/lib/PhpReports/PhpReports.php(189): flight\Engine->handleError(8, 'Trying to get p...', '/var/www/html/w...', 189, Array) #1 /var/www/html/xxx/data_reports/index.php(82): PhpReports::displayReport('daily_gross_rep...', 'html') #2 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(169): {closure}('html') #3 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(145): flight\core\Dispatcher::callFunction(Object(Closure), Array) #4 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/Engine.php(340): flight\core\Dispatcher::execute(Object(Closure), Array) #5 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(198): flight\Engine->_start() #6 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(144): flight\core\Dispatcher::invokeMethod(Array, Array) #7 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(49): flight\core\Dispatcher::execute(Array, Array) #8 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/Engine.php(92): flight\core\Dispatcher->run('start', Array) #9 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/core/Dispatcher.php(198): flight\Engine->__call('start', Array) #10 /var/www/html/xxx/data_reports/vendor/mikecao/flight/flight/Flight.php(77): flight\core\Dispatcher::invokeMethod(Array, Array) #11 /var/www/html/xxx/data_reports/index.php(102): Flight::__callStatic('start', Array) #12 {main}

Hi, I'm having the same issue but can't fix it. Could you please provide me some help, maybe by providing you composer file ? Thanks a lot

[apropos]

Hi, I'm having the same issue but can't fix it. Could you please provide me some help, maybe by providing you composer file ? Thanks a lot

I resolved the issue by reinstalling php-reports and here's the current composer.json { "name": "jdorn/php-reports", "description": "A PHP framework for displaying reports from any data source, including SQL and MongoDB", "homepage": "http://jdorn.github.com/php-reports/", "keywords": ["reports", "mongodb", "sql", "reporting", "csv", "database"], "license": "LGPL-3.0+", "authors": [ { "name": "Jeremy Dorn", "email": "[email protected]" } ], "require": { "php": ">=5.3", "ext-pdo": "", "twig/twig": "1.37.1", "swiftmailer/swiftmailer": "5.", "mikecao/flight": "1.3.7", "jdorn/sql-formatter": "dev-master", "jdorn/file-system-cache": "dev-master", "phpoffice/phpexcel": "dev-develop", "adodb/adodb-php": "dev-master", "lespoilus/spyc": "dev-master", "google/apiclient": "1.0.*@beta" }, "autoload": { "files": [ "lib/adodb/pivottable.inc.php" ], "classmap": [ "vendor/jdorn/file-system-cache/" ] }, "minimum-stability": "dev" }

[russell-hutson-jp]

twig 1.44.7 works for me on PHP 7.4.3