PS 1.6.x and 1.7.x on PHP 7.1 Fatal error: operator not supported in DbQuery.php

[itmag.pro]

 If use PHP 7.1 for PrestaShop 1.6.x only (in 1.7.x this fixed) we have get this fatal error:

[16-Dec-2016 01:15:47 Europe/Kiev] PHP Fatal error:  Uncaught Error: [] operator not supported for strings in /var/www/classes/db/DbQuery.php:96

need change:

protected $query = array(
    'type'   => 'SELECT',
    'select' => array(),
    'from'   => '',
    'join'   => array(),
    'where'  => array(),
    'group'  => array(),
    'having' => array(),
    'order'  => array(),
    'limit'  => array('offset' => 0, 'limit' => 0),
);

to

protected $query = array(
    'type'   => 'SELECT',
    'select' => array(),
    'from'   => array(),
    'join'   => array(),
    'where'  => array(),
    'group'  => array(),
    'having' => array(),
    'order'  => array(),
    'limit'  => array('offset' => 0, 'limit' => 0),
);

Edited December 16, 2016 by www.remoteshaman.com (see edit history)

[itmag.pro]

PrestaShop has not been made compatible with PHP 7.1. You will come across this problem even more.

 

PHP 7 provide best performance than PHP 5. PrestaShop must be adopt for/under PHP 7!!!

 

After fix DbQuery.php my PrestaShop 1.6.1.10 (backend and frontend) worked fine on PHP 7.1 - no php errors in php-errors.log no server errors and other errors I not find.

Edited December 16, 2016 by www.remoteshaman.com (see edit history)

[duredo]

PHP 7 provide best performance than PHP 5. PrestaShop must be adopt for/under PHP 7!!!

 

After fix DbQuery.php my PrestaShop 1.6.1.10 (backend and frontend) worked fine on PHP 7.1 - no php errors in php-errors.log no server errors and other errors I not find.

hi, can you attach your DbQuery.php here? I need to try it

[itmag.pro]

hi, can you attach your DbQuery.php here? I need to try it

 

Get from github:

https://github.com/PrestaShop/PrestaShop/pull/7232

https://github.com/PrestaShop/PrestaShop/blob/1.6.1.x/classes/db/DbQuery.php

[nikolaosp]

 

 If use PHP 7.1 for PrestaShop 1.6.x only (in 1.7.x this fixed) we have get this fatal error:

[16-Dec-2016 01:15:47 Europe/Kiev] PHP Fatal error:  Uncaught Error: [] operator not supported for strings in /var/www/classes/db/DbQuery.php:96

need change:

protected $query = array(
    'type'   => 'SELECT',
    'select' => array(),
    'from'   => '',
    'join'   => array(),
    'where'  => array(),
    'group'  => array(),
    'having' => array(),
    'order'  => array(),
    'limit'  => array('offset' => 0, 'limit' => 0),
);

to

protected $query = array(
    'type'   => 'SELECT',
    'select' => array(),
    'from'   => array(),
    'join'   => array(),
    'where'  => array(),
    'group'  => array(),
    'having' => array(),
    'order'  => array(),
    'limit'  => array('offset' => 0, 'limit' => 0),
);

Your solution worked for me as well.  Did not have this problem with php 7.0.7 though

 

Thanks anyway

[duredo]

Get from github:

https://github.com/PrestaShop/PrestaShop/pull/7232

https://github.com/PrestaShop/PrestaShop/blob/1.6.1.x/classes/db/DbQuery.php

great, my live site running PHP 7.1 now, will update if there is any errors

 

=== Update ===

I found error, there is no content on my dashboard statistics

Edited December 17, 2016 by duredo.com (see edit history)

[bellini13]

I would stick with PHP 7.0.13 (or the latest of the 7.0) branch for now.

 

There are likely other changes required to fully support PHP 7.1.  Ideally you should create forge tickets for those issues, or contribute to Prestashops github as you find and fix issues

[TiaNex Shopping]

i upgrade my server to php 7.0.18 and mysql 5.7 

it's much faster than before,it's will take about 1700ms to load the product page,

now only 500ms

[Claudiocool]

Am 17.12.2016 um 5:37 AM schrieb duredo.com:

great, my live site running PHP 7.1 now, will update if there is any errors

 

=== Update ===

I found error, there is no content on my dashboard statistics

Did you or anyone else find any solution for the Dashboard?

[fettah]

thank you it works very well
 

[plutten22]

Hi.

There is no content on my dashboard statistics when i change to PHP 7.1

Did you or anyone else find any solution for the Dashboard? 

[bellini13]

9 minutes ago, plutten22 said:

Hi.

There is no content on my dashboard statistics when i change to PHP 7.1

Did you or anyone else find any solution for the Dashboard? 

What is your exact version of Prestashop?  Perhaps you should not use PHP 7.1, and should revert to a supported PHP version

[plutten22]

Hi.

My version is 1.6.1.10  My provider is changing from php 5.6 to 7.1 .

Any sulotion.

[bellini13]

PS v1.6.1.10 does not support PHP 7.1

Your options?

1. Upgrade to the latest version of PS v1.6
2. Downgrade your PHP version to PHP 5.6 or possibly 7.0
3. Apply patches to Prestashop to support PHP 7.1

[plutten22]

Ok i understand.

I have made a lot of chages to the prestashop standard theme so i dont want to upgrade bc the changes will be lost.

I can not downgrade to PHP 5.6 bc my supplyer will not have it after 27 december.

How can i apply patches to Prestashop to support PHP 7.1

Regards

[bellini13]

That might depend on your skill level with coding.  Generally I go through the release notes and change logs for Prestashop, identify the individual changes that were made so that PS v1.6 would support PHP 7.1, and then manually apply those changes to your core files. 

If you are not a proficient coder, then you might need to look into hiring a developer

[El Patron]

best to move to hosting that is not dropping php 5.6.

[bellini13]

5.6 loses support from PHP this month.  PHP 7.0 does as well

so really you should be looking to properly maintain your store and keep it up to date

being afraid to upgrade because of customizations you made is unfortunately not a good answer.  And will instead leave you open to security issues

[plutten22]

Ok. Thanks for the answers.

I will upgrade my site.

Regards

[plutten22]

Hi.

I have now upgraded my site to 1.6.1.23 but it dos not work with php 7.1

Backoffice work but frontoffice dos not.

I attache a picture.

Regards

[bellini13]

perhaps you have a custom theme or module that does not support it.  enabled debug mode and see if that provides a helpful error

[plutten22]

Ok. I will look at this. Thanks.

[El Patron]

upgrade to 1.7 and you can use php 7.2.  It cannot get much worse lol

[dandumit]

also in Product.php

line 5151

$sql_values = '';

has to be changed to 

$sql_values = array();

[jorgeduarte]

On 12/16/2016 at 1:31 AM, www.remoteshaman.com said:

 

Get from github:

https://github.com/PrestaShop/PrestaShop/pull/7232

https://github.com/PrestaShop/PrestaShop/blob/1.6.1.x/classes/db/DbQuery.php

thank you!

[Ajay Kumar]

@www.remoteshaman.com  Thank you very much. its working for me also

Edited August 23, 2019 by Ajay Kumar (see edit history)

[lagoacity]

Hello,

I needed a help, I have a problem with the site where overnight the images of the site were all in error. We talked to the person who handled the accommodation and made the change to php because there had been an error and would have to change the php but then I got the images "no images".

If I enter BackOffice in a product the images are there, but on the site they do not appear.

How can I solve this situation?

Prestashop version 1.6.1.7

PHP version: 7.1.32

https://www.winespiritus.com/

Through the link you can see the images of products that are not giving

I look forward to a brief reply.

Best regards,

André Correia!