Prestashop: Undefined "checkedForm" error on valid queries in SQL Manager

[matks]

Describe the bug
I have an error message "undefined checkedForm" when I try to export order sql query to sql manager. The SQL queries used to be considered valid in previous versions of PrestaShop.

To Reproduce
Steps to reproduce the behavior:

1. Go to Orders > Orders or Orders > Credit slip or Catalog > Products or Catalog > Categories
2. Click on Export to sql manager
3. Click on Save
4. See error

The root cause is the same than in https://github.com/PrestaShop/PrestaShop/issues/10316

[marionf]

I can't reproduce it on develop branch

[Nittarab]

I have the same error in PS 1.7.4.4... I try to execute the query directly in the DB and it work...

[kpodemski]

Same error for me on every 1.7 with migrated page. This page seems to be completely broken...

[marionf]

@kpodemski

I can't reproduce with 1.7.6.0

[kpodemski]

@marionf

i'll try to do some debugging to see why error appears on some environments

[marionf]

Thank you very much @kpodemski

[noindie]

same error

[jonasburneika]

I have it on 1.7.5.1 my sql code: https://www.codepile.net/pile/K9GbMrvx

[sebastien-auve]

Is there any update? I have the same problem on 1.7.5.1 like @jonasburneika.
I can't join tables...

[matks]

It seems we cannot reproduce this issue 100% times so specific conditions are required to observe the buggy behavior 🤔

[sebastien-auve]

Everytime I want to join tables or make a query on mulitple tables I have this error.
So I did some basic SQL queries on PrestaShop and my processing by Excel and VBA.

[robrothkopf]

On the back end (e.g. phpMyAdmin), you know the query works because you've tested it, ya? But that identical query gives this error when trying to save on PrestaShop's SQL Manager?

WORKAROUND:
Create a view via phpMyAdmin, and then in PrestaShop's SQL Manager, select the data from the view instead of the query.

e.g.
If your query was:
select * from MYTABLE

create a view from that query as follows:

create view v_MyViewName as 
select * from MYTABLE

Now in PrestaShop's SQL Manager, your sql query will be:
select * from v_MyViewName

No more error and you get the same results!

Obviously, this was an overly-simplified sample query, but try it .. it did the trick for me!