SQL Manager bug Prestashop 1.6.1.20

[PatriceJV]

Hello,

I want to enter a sql query in the back-office - advanced parameters  - SQL Manager but impossible to save I have the error.

Undefined "checkedFrom" error

My query is good, I did verified it in phpmyadmin.

If I put the query directly in the table and then use it in the backoffice, it works.

Do you know if there is a bug? and, if yes, what is the cure?

Code is

select xx_product.id_product,
       reference,
       name,
       is_virtual,
       data_field_1_1,
       data_field_1_2,
       data_field_1_3,
       data_virtual_1_1,
       id_lang,
       description,
       description_short,
       meta_keywords,
       meta_description,
       meta_title
from xx_product
inner join xx_product_lang on xx_product.id_product = xx_product_lang.id_product

Thank you

Edited August 18, 2018 by PatriceVigier
misspelling (see edit history)

[Knowband Plugins]

Hi,

Kindly share the PS version. If using PS1.6, Then try to use the following patch.

http://forge.prestashop.com/browse/PSCSX-4734

[PatriceJV]

54 minutes ago, Knowband Plugins said:

Hi,

Kindly share the PS version. If using PS1.6, Then try to use the following patch.

http://forge.prestashop.com/browse/PSCSX-4734

Hello,

Thank you for your answer, however this do not fix the problem, this change has already been integrated in 1.6.1.20

Sincerely

[Knowband Plugins]

Ok

For the workaround, I have removed this check from the file. 

Upload the attached file in classes folder & check again. (Kindly take the backup of the original file)

I hope it will help

 

RequestSql.php

[PatriceJV]

On 8/20/2018 at 10:57 AM, Knowband Plugins said:

Ok

For the workaround, I have removed this check from the file. 

Upload the attached file in classes folder & check again. (Kindly take the backup of the original file)

I hope it will help

 

RequestSql.php

Man........ this is working. Thank you very much for your help.

[Guest]

Never ever change core files directly! It prevents Prestashop from updating and you might have a hard time figuring out what is going on because you are no longer using the original files.

Knowband plugins, you should have known better! Provide an override next time, please!

[Knowband Plugins]

23 hours ago, PrestaRalph said:

Never ever change core files directly! It prevents Prestashop from updating and you might have a hard time figuring out what is going on because you are no longer using the original files.

Knowband plugins, you should have known better! Provide an override next time, please!

1

 

I think, you haven't read my comment properly.  I have already mentioned that its a workaround.

Anyway, I have done my part & If you think you can provide the better solution then simply do the same.

 

 

 

 

[JosefNerb]

On 8/20/2018 at 10:57 AM, Knowband Plugins said:

Ok

For the workaround, I have removed this check from the file. 

Upload the attached file in classes folder & check again. (Kindly take the backup of the original file)

I hope it will help

 

RequestSql.php

Thanks a lot. Does anyone know whether this workaround is already part of 1.6.1.23?