Jump to content

SQL Manager bug Prestashop 1.6.1.20


PatriceJV

Recommended Posts

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 by PatriceVigier
misspelling (see edit history)
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.

 

 

 

 

Link to comment
Share on other sites

  • 4 months later...
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?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...